turbot/covid19

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

Dashboards

The query is used in the dashboards: