Show percent of adult patients hospitalized with COVID who are in ICU by state

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

state

Edit SQL