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 recorded daily and released weekly 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, 2020, 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.

Texas COVID-19 vaccine distribution tracker based on Department of State Health Services data. Powered by D3.js. Hosted on GitHub Pages.

https://covid-texas.csullender.com/vaccine/

• Vaccination data from Texas DSHS
  • Archive of weekly Excel spreadsheets available here (was daily prior to December 1, 2022)
• Population data from U.S. Census Bureau and Texas Demographic Center

Vaccination data reported weekly by the Texas Department of Health State Services are used for all metrics. The number of vaccine doses administered, number of people vaccinated with one dose, number of people fully vaccinated, and number of people with booster doses are aggregated by the recipient's county of residence. Weekly allocations/shipments to each county were stopped on the week of May 3, 2021, due to there being a sufficient supply of vaccine. These metrics have been removed from the tracker (final update available here). Health care providers have 24 hours after a dose is administered to enter information into the Texas Immunization Registry (ImmTrac2). The daily data comes from vaccination records submitted by health care providers as of 11:59 PM the previous night. Population numbers are based on 2019 estimates from the U.S. Census Bureau and Texas Demographic Center.