How full is the ICU overall in terms of staffed adult beds on a given week in a given state? Enter the state's two digit postal code below and hit 'Run SQL'.
Note that this query leaves out hospitals averaging less than 4 ICU COVID beds weekly, which may be a large fraction of small hospitals. This query also ignores lines where this data is blank. This is calculated as: icu_occupancy_fraction = staffed_adult_icu_bed_occupancy_7_day_avg /total_staffed_adult_icu_beds_7_day_avg How full is the ICU in terms of confirmed or suspected COVID patients? This is calculated as: covid_icu_fraction = staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg /total_staffed_adult_icu_beds_7_day_avg
This database can be queried directly using Structured Query Language (SQL) supported by SQLite. For more on that syntax, see here. Read more about datasette, the technology powering these interactive queries.