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_cases_deaths_per_million_by_continent

Usage

powerpipe query covid19.query.covid19_cases_deaths_per_million_by_continent

SQL

select
  continent,
  sum(total_cases_per_million) as "Total Cases Per Million",
  sum(total_deaths_per_million) as "Total Deaths Per Million"
from
  covid_data
where
  continent != ''
group by
  continent
order by
  sum(total_cases_per_million),
  sum(total_deaths_per_million) desc;

Dashboards

The query is used in the dashboards:

COVID-19 Dashboard