turbot/covid19

Query: covid19_tests_vs_cases_over_time

Usage

powerpipe query covid19.query.covid19_tests_vs_cases_over_time

SQL

select
date,
sum(new_tests) as "New Tests",
sum(new_cases) as "New Cases"
from
covid_data
group by
date
order by
date;

Dashboards

The query is used in the dashboards: