Child hospitalization by state

Reported variables for pediatric hospitalizations. Enter 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 rowid, collection_week, state, ccn, hospital_name, address, city, zip, hospital_subtype, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg, total_pediatric_patients_hospitalized_confirmed_covid_7_day_avg, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum, total_pediatric_patients_hospitalized_confirmed_covid_7_day_sum, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_coverage, total_pediatric_patients_hospitalized_confirmed_covid_7_day_coverage, previous_day_admission_pediatric_covid_confirmed_7_day_sum, previous_day_admission_pediatric_covid_suspected_7_day_sum, previous_day_admission_pediatric_covid_confirmed_7_day_coverage, previous_day_admission_pediatric_covid_suspected_7_day_coverage, is_corrected from hosp_capacity where state = :state and collection_week = '2021/09/17' order by total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Query took 0.99ms