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_weekly_admissions
Usage
powerpipe query covid19.query.covid19_weekly_admissions
SQL
select date, sum(weekly_icu_admissions) as "ICU Admissions", sum(weekly_hosp_admissions) as "Hospital Admissions"from covid_datagroup by dateorder by date;
Dashboards
The query is used in the dashboards: