Show pediatric COVID admits as fraction of total by state

Includes confirmed and suspected admissions. Oregon and Washington have a data error and are excluded.

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 date, total_adult_admits, total_ped_admits, 100.0*total_ped_admits / (total_ped_admits + total_adult_admits) as ped_prnct from (select date, sum(previous_day_admission_adult_covid_suspected) + sum(previous_day_admission_adult_covid_confirmed) as total_adult_admits,   sum(previous_day_admission_pediatric_covid_suspected) + sum(previous_day_admission_pediatric_covid_confirmed) as total_ped_admits from hospitals_state where date > '2020/10/01' and state = :state  group by date order by date desc);

Query parameters

Edit SQL

0 results

Powered by Datasette · Queries took 18.707ms