COVID-2019 - ECDC (2020)
@owid.ecdc
@owid.ecdc
CREATE TABLE owid_ecdc (
"year" INTEGER,
"country" VARCHAR,
"daily_new_confirmed_cases_of_covid_19" INTEGER,
"daily_new_confirmed_deaths_due_to_covid_19" INTEGER,
"total_confirmed_cases_of_covid_19" UINTEGER,
"total_confirmed_deaths_due_to_covid_19" UINTEGER,
"daily_new_confirmed_cases_of_covid_19_per_million_people" FLOAT,
"daily_new_confirmed_deaths_due_to_covid_19_per_million_people" FLOAT,
"total_confirmed_cases_of_covid_19_per_million_people" FLOAT,
"total_confirmed_deaths_due_to_covid_19_per_million_people" FLOAT,
"days_since_the_total_confirmed_cases_of_covid_19_reached_100" INTEGER,
"days_since_the_total_confirmed_deaths_of_covid_19_reached_5" INTEGER,
"days_since_the_total_confirmed_cases_of_covid_19_per_m_62ff899d" INTEGER,
"days_since_the_total_confirmed_deaths_of_covid_19_per__9cd4b472" INTEGER,
"days_since_30_daily_new_confirmed_cases_recorded" INTEGER,
"days_since_50_daily_new_confirmed_cases_recorded" INTEGER,
"days_since_10_daily_new_confirmed_deaths_recorded" INTEGER,
"days_since_5_daily_new_confirmed_deaths_recorded" INTEGER,
"days_since_3_daily_new_confirmed_deaths_recorded" INTEGER,
"days_since_daily_new_confirmed_cases_of_covid_19_rolli_b51fbe22" INTEGER,
"days_since_daily_new_confirmed_deaths_due_to_covid_19__a874cef2" INTEGER,
"days_since_daily_new_confirmed_cases_of_covid_19_per_m_7888423c" INTEGER,
"days_since_daily_new_confirmed_deaths_due_to_covid_19__255bbd3e" INTEGER,
"days_since_daily_new_confirmed_deaths_due_to_covid_19__58c3e323" INTEGER,
"daily_new_confirmed_cases_of_covid_19_rolling_3_day_av_96e4956b" FLOAT,
"daily_new_confirmed_cases_due_to_covid_19_rolling_7_da_8307be16" FLOAT,
"daily_new_confirmed_deaths_due_to_covid_19_rolling_3_d_2525c2a2" FLOAT,
"daily_new_confirmed_deaths_due_to_covid_19_rolling_7_d_06a906b2" FLOAT,
"daily_new_confirmed_cases_of_covid_19_per_million_peop_66cbcf60" FLOAT,
"daily_new_confirmed_deaths_due_to_covid_19_per_million_b5c834d9" FLOAT,
"daily_new_confirmed_cases_of_covid_19_per_million_peop_222355d4" FLOAT,
"daily_new_confirmed_deaths_due_to_covid_19_per_million_c0d604fd" FLOAT,
"case_fatality_rate_of_covid_19_pct" FLOAT,
"case_fatality_rate_of_covid_19_pct_only_observations_w_54618d16" FLOAT,
"case_fatality_rate_of_covid_19_pct_short_term" FLOAT,
"days_since_the_total_confirmed_cases_of_covid_19_reach_f1f07c54" INTEGER,
"has_population_gte_5m_and_had_gte_100_cases_gte_21_day_c0b4f511" INTEGER,
"doubling_days_of_total_confirmed_cases_3_day_period" FLOAT,
"doubling_days_of_total_confirmed_cases_7_day_period" FLOAT,
"doubling_days_of_total_confirmed_deaths_3_day_period" FLOAT,
"doubling_days_of_total_confirmed_deaths_7_day_period" FLOAT,
"weekly_cases" INTEGER,
"weekly_deaths" INTEGER,
"weekly_case_growth_pct" FLOAT,
"weekly_death_growth_pct" FLOAT,
"biweekly_cases" INTEGER,
"biweekly_deaths" INTEGER,
"biweekly_case_growth_pct" FLOAT,
"biweekly_death_growth_pct" FLOAT,
"weekly_cases_per_million_people" FLOAT,
"weekly_deaths_per_million_people" FLOAT,
"biweekly_cases_per_million_people" FLOAT,
"biweekly_deaths_per_million_people" FLOAT
);
Anyone who has the link will be able to view this.