Show overall COVID hospitalization by state

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, inpatient_beds_used_covid as tot_covid_beds, inpatient_beds_used_covid_coverage as tot_covid_beds_coverage, (inpatient_beds) as total_beds, (inpatient_beds_coverage) as total_beds_coverage, 100*(inpatient_beds_used_covid)/(inpatient_beds) as percent_covid from hospitals_state where state = :state and date > '2020/10/01' order by date desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Queries took 17.421ms