Show current simplified COVID hospitalization in a state

This query finds outputs a simplified view of hospital bed and icu availabilty and occupancy for a given state for the current week. Enter the state's two digit postal code below and hit 'Run SQL'.

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   state,   hospital_name,   hospital_subtype, collection_week,   address,   city,   state,   zip,  ccn,   fips_code as county_fips,   all_adult_hospital_inpatient_beds_7_day_avg as adult_inpatient_beds,   inpatient_beds_used_7_day_avg as inpatient_beds_used,   total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg as covid_all,   total_adult_patients_hospitalized_confirmed_covid_7_day_avg as confirmed_covid,   total_icu_beds_7_day_avg as tot_icu_beds,   total_staffed_adult_icu_beds_7_day_avg as staffed_icu_beds,   staffed_adult_icu_bed_occupancy_7_day_avg as icu_occupancy,   staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg as all_covid_icu,   staffed_icu_adult_patients_confirmed_covid_7_day_avg as confirmed_covid_icu from   hosp_capacity where   collection_week = '2021/09/17' and state = :state order by covid_all desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Query took 1.242ms