covid19_boosters_by_continentcovid19_cases_deaths_per_million_by_continentcovid19_distribution_of_new_cases_by_continentcovid19_fully_vaccinated_per_hundred_by_continentcovid19_global_new_casescovid19_global_new_deathscovid19_global_total_casescovid19_global_total_deathscovid19_icu_vs_hospital_patientscovid19_tests_vs_cases_over_timecovid19_vaccination_progress_over_timecovid19_weekly_admissions
Query: covid19_icu_vs_hospital_patients
Usage
powerpipe query covid19.query.covid19_icu_vs_hospital_patients
SQL
select date, sum(icu_patients) as "ICU Patients", sum(hosp_patients) as "Hospital Patients"from covid_datagroup by dateorder by date;
Dashboards
The query is used in the dashboards: