Show prior day admission count by state

Note that not all hospitals answer this question. Refer to the corresponding _coverage variables for specifics.

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, previous_day_admission_adult_covid_confirmed + previous_day_admission_adult_covid_suspected as all_adult_admits, previous_day_admission_adult_covid_confirmed as adult_confirmed_admits, previous_day_admission_adult_covid_suspected as adult_suspected_admits, previous_day_admission_pediatric_covid_confirmed +  previous_day_admission_pediatric_covid_suspected as all_pediatric_admits, previous_day_admission_pediatric_covid_confirmed as pediatric_confirmed_admits, previous_day_admission_pediatric_covid_suspected as pediatric_suspected_admits 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 18.934ms