turbot/covid19

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_data
group by
date
order by
date;

Dashboards

The query is used in the dashboards: