COVID-19, Confirmed Cases And Deaths
@owid.cases_deaths
@owid.cases_deaths
CREATE TABLE owid_cases_deaths (
"country" VARCHAR,
"date" TIMESTAMP,
"new_cases" UINTEGER,
"total_cases" UINTEGER,
"new_deaths" INTEGER,
"total_deaths" UINTEGER,
"weekly_cases" UINTEGER,
"weekly_deaths" UINTEGER,
"weekly_pct_growth_cases" FLOAT,
"weekly_pct_growth_deaths" FLOAT,
"biweekly_cases" UINTEGER,
"biweekly_deaths" UINTEGER,
"biweekly_pct_growth_cases" FLOAT,
"biweekly_pct_growth_deaths" FLOAT,
"new_cases_per_million" FLOAT,
"new_deaths_per_million" FLOAT,
"total_cases_per_million" FLOAT,
"total_deaths_per_million" FLOAT,
"weekly_cases_per_million" FLOAT,
"weekly_deaths_per_million" FLOAT,
"biweekly_cases_per_million" FLOAT,
"biweekly_deaths_per_million" FLOAT,
"total_deaths_per_100k" FLOAT,
"new_deaths_per_100k" FLOAT,
"new_cases_7_day_avg_right" FLOAT,
"new_deaths_7_day_avg_right" FLOAT,
"new_cases_per_million_7_day_avg_right" FLOAT,
"new_deaths_per_million_7_day_avg_right" FLOAT,
"new_deaths_per_100k_7_day_avg_right" FLOAT,
"cfr" FLOAT,
"cfr_100_cases" FLOAT,
"cfr_short_term" FLOAT,
"days_since_100_total_cases" INTEGER,
"days_since_5_total_deaths" INTEGER,
"days_since_1_total_cases_per_million" INTEGER,
"days_since_0_1_total_deaths_per_million" INTEGER,
"days_since_100_total_cases_and_5m_pop" INTEGER,
"total_deaths_last12m" INTEGER,
"total_deaths_per_100k_last12m" FLOAT,
"total_deaths_per_million_last12m" FLOAT
);
Anyone who has the link will be able to view this.