Regional COVID-19 hospital resource usage in Texas based on Department of State Health Services data. Powered by D3.js. Hosted on GitHub Pages.
https://covid-texas.csullender.com/
- Hospitalization and COVID-19 data from Texas DSHS
- Historic hospital occupancy rate as reported by NCHS in Health, United States, 2017.
Hospital data reported daily by the Texas Department of Health State Services are used for all metrics. The "Statewide Total" is manually calculated by aggregating values from all available trauma service areas (TSAs). This aggregation is incomplete for bed counts prior to May 29, 2020, because of fragmented reporting from TSA-F (Paris) and TSA-R (Galveston). All data is incomplete between July 23 to July 28 due to a transition in hospital reporting to comply with new federal requirements.
The unmodified daily data is available in data.csv. A cleaned version of the data removing inconsistencies that interfere with graph generation is available in docs/data.csv. Datapoints were manually excluded if they differed significantly from the preceding or following day and resulted in extreme graph values. These manual curations can be seen in the update script fetch.py.
The "average annual occupancy rate" shown on the Statewide Hospital Bed Usage chart is based on the annual Health, United States report by the National Center for Health Statistics (NCHS). Table 91 details the average annual occupancy rate in community hospitals for each state, with Texas reporting 60% occupancy in 2015. This number was further validated with the Acute Care Hospitals report from the Texas DSHS Center for Health Statistics, which reported 60.4% staffed bed occupancy in 2016.