Show simplified COVID hospitalization over time at one hospital

This query finds outputs a simplified view of hospital bed and icu availabilty and occupancy for a given hospital identifed by CMS provider id, aka CCN

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   ccn = :hospital_ccn order by collection_week desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Query took 57.001ms