Show percent of adult patients hospitalized with COVID who are in ICU 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 state, date, (100*(staffed_icu_adult_patients_confirmed_and_suspected_covid)/(total_adult_patients_hospitalized_confirmed_and_suspected_covid)) as percent_covid_hosp_adults_icu, (staffed_icu_adult_patients_confirmed_and_suspected_covid) as total_adult_covid_icu, (staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage) as total_adult_covid_icu_coverage, (total_adult_patients_hospitalized_confirmed_and_suspected_covid) as total_adult_covid_patients, (total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage) as total_adult_covid_patients_coverage from hospitals_state where state=:state order by date desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Queries took 16.87ms