Show pediatric COVID occupancy by state

Enter the state's two letter postal abbreviation in capital letters.

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, date, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid as pediatric_hospitalized, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage as pediatric_hospitalized_coverage from hospitals_state where date > '2020/10/01' and state = :state order by date desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Queries took 16.955ms