Child hospitalization, current vs prior week, by hospital

REnter the state's two digit postal abbrevation to see results. Note that numbers less than 4.0 are replaced with -999999 by HHS.

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_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum as total_pediatric_admits_current_week, b.total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum as total_pediatric_admits_prior_week, (0.0+a.total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum)/b.total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum  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.058ms