COVID ICU room occupancy comparing current with prior week, for a state

Compare ICU rooms occupied by confirmed and suspected COVID patients between the current and prior week in a given state. Enter the state's uppercase two-digit postal code.

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  a.hospital_name, a.hospital_subtype, a.city,a.fips_code,a.total_staffed_adult_icu_beds_7_day_avg as staffed_icu_beds ,a.staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg as current_total_covid_icu, b.staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg as prior_total_covid_icu, (0.0+a.staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg)/b.staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg  as change from hosp_capacity a join hosp_capacity b on a.state = :state and b.state = a.state and a.ccn = b.ccn and a.collection_week = '2021/09/17' and b.collection_week = '2021/09/10' order by change desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Query took 0.992ms