Child hospitalization over time at a single hospital

Reported variables for pediatric hospitalizations at a particular hospital. Enter the hospitals's CCN number 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 ccn = :ccn order by collection_week desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Queries took 358.688ms