How full are ICUs summed by metropolitan area in a given state?
How full is the ICU at all reporting hospitals overall in metropolitan areas with more than 10 ICU beds in a given state? Enter the metropolitan area's cbsacode below and hit 'Run SQL'. To see hospital level detail for this metro area, copy the cbsacode and paste it into this query
Note that this query leaves out hospitals averaging less than 4 ICU COVID beds weekly, or that don't report their weekly staffed bed count, so consider the results an estimate only. This query also ignores lines where this data is blank.
The fractions are 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.