Ohio COVID-19 Key Metrics On Testing
From March 2020 through August 2022
@kaggle.ryanlingo_ohio_covid_19_key_metrics_on_testing
From March 2020 through August 2022
@kaggle.ryanlingo_ohio_covid_19_key_metrics_on_testing
The COVID-19 diagnostic testing data, including total daily tests performed and daily percentage of positive tests, as reported to the Ohio Department of Health (ODH). This data includes laboratory testing from hospitals, private labs and the ODH lab.
source: https://data.ohio.gov/wps/portal/gov/data/view/covid-nineteen-key-metrics-on-testing
CREATE TABLE testingdetails (
"date" TIMESTAMP,
"confirmatory_lab_percent_positive_daily" DOUBLE -- Confirmatory Lab Percent Positive (Daily),
"confirmatory_lab_total_positive_daily" BIGINT -- Confirmatory Lab Total Positive (Daily),
"confirmatory_lab_total_tested_daily" BIGINT -- Confirmatory Lab Total Tested (Daily),
"confirmatory_lab_7_day_percent_positive" DOUBLE,
"presumptive_lab_percent_positive_daily" DOUBLE -- Presumptive Lab Percent Positive (Daily),
"presumptive_lab_total_positive_daily" DOUBLE -- Presumptive Lab Total Positive (Daily),
"presumptive_lab_total_tested_daily" DOUBLE -- Presumptive Lab Total Tested (Daily),
"presumptive_lab_7_day_percent_positive" DOUBLE,
"confirmatory_and_presumptive_lab_total_positive_daily" DOUBLE -- Confirmatory And Presumptive Lab Total Positive (Daily),
"confirmatory_and_presumptive_lab_total_tested_daily" DOUBLE -- Confirmatory And Presumptive Lab Total Tested (Daily),
"confirmatory_and_presumptive_lab_percent_positive_daily" DOUBLE -- Confirmatory And Presumptive Lab Percent Positive (Daily),
"confirmatory_and_presumptive_lab_7_day_percent_positive" DOUBLE
);Anyone who has the link will be able to view this.