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

Compare total 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.all_adult_hospital_inpatient_beds_7_day_avg as adult_inpatient_beds ,a.total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg as current_covid_all, b.total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg as prior_covid_all, (0.0+a.total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg)/b.total_adult_patients_hospitalized_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 1.022ms