How full are hospital beds with COVID patients for a given state?

How full are hospital beds in terms of staffed adult beds on a given week? Enter the state's two digit postal code below and hit 'Run SQL'.

Note that this leaves out hospitals averaging less than 4 COVID inpatient beds weekly, which may be a large fraction of small hospitals. his query also ignores lines where this data is blank. Overall room rate is calculated as
room_fate = all_adult_hospital_inpatient_bed_occupied_7_day_avg /all_adult_hospital_inpatient_beds_7_day_avg
covid_room_rate = total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg /all_adult_hospital_inpatient_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 hospital_name,  hospital_subtype, collection_week,     city,   state,   zip,   fips_code, ccn, (0.0+total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg)/all_adult_hospital_inpatient_beds_7_day_avg as covid_room_rate, (0.0+all_adult_hospital_inpatient_bed_occupied_7_day_avg)/all_adult_hospital_inpatient_beds_7_day_avg as occupied_room_rate,all_adult_hospital_inpatient_beds_7_day_avg, all_adult_hospital_inpatient_bed_occupied_7_day_avg, total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg from   hosp_capacity where not all_adult_hospital_inpatient_beds_7_day_avg = '' and total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg > 0   and collection_week = '2022/03/04' and state like :state order by covid_room_rate desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Queries took 294.358ms