Use files, branches, or tags for mod dependencies →

Plugins Docs Home

turbot/covid19

0Controls

0Variables

covid19_boosters_by_continent covid19_cases_deaths_per_million_by_continent covid19_distribution_of_new_cases_by_continent covid19_fully_vaccinated_per_hundred_by_continent covid19_global_new_cases covid19_global_new_deaths covid19_global_total_cases covid19_global_total_deaths covid19_icu_vs_hospital_patients covid19_tests_vs_cases_over_time covid19_vaccination_progress_over_time covid19_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_data
group by
  date
order by
  date;

Dashboards

The query is used in the dashboards:

COVID-19 Dashboard