COVID-19, JHU CSSE Dataset
@owid.john_hopkins_university
@owid.john_hopkins_university
CREATE TABLE owid_john_hopkins_university (
"country" VARCHAR,
"date" TIMESTAMP,
"daily_new_confirmed_cases_of_covid_19" UINTEGER,
"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,
"daily_new_confirmed_cases_due_to_covid_19_rolling_7_da_8307be16" FLOAT,
"daily_new_confirmed_deaths_due_to_covid_19_rolling_7_d_06a906b2" 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,
"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,
"weekly_cases" UINTEGER,
"weekly_deaths" UINTEGER,
"weekly_case_growth_pct" FLOAT,
"weekly_death_growth_pct" FLOAT,
"biweekly_cases" UINTEGER,
"biweekly_deaths" UINTEGER,
"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.