How full are ICUs for a given metropolitan area?

How full is the ICU overall in terms of staffed adult beds on a given week in a given metropolitan area? You need the CBSA id to run this query, you can figure it out here. Enter the CBSA id 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.

Custom SQL query (hide)

select  cbsatitle, hospital_name, hospital_subtype,  collection_week,   zip, cbsaxfips.fips_code,   ccn, (0.0+staffed_adult_icu_bed_occupancy_7_day_avg)/total_staffed_adult_icu_beds_7_day_avg as icu_occupancy_fraction, (0.0+staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg)/total_staffed_adult_icu_beds_7_day_avg as covid_icu_fraction, total_staffed_adult_icu_beds_7_day_avg, staffed_adult_icu_bed_occupancy_7_day_avg, staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg from   hosp_capacity left join cbsaxfips on hosp_capacity.fips_code = cbsaxfips.fips_code where  not total_staffed_adult_icu_beds_7_day_avg = '' and total_staffed_adult_icu_beds_7_day_avg > 0 and collection_week = '2021/09/17' and covid_icu_fraction > 0 and cbsaxfips.cbsacode = :cbsacode order by covid_icu_fraction desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Query took 197.669ms