Dataset: COVID-2019 - ECDC (2020)

About this Dataset

COVID-2019 - ECDC (2020)

Raw data on confirmed cases and deaths for all countries is sourced from the European Centre for Disease Prevention and Control (ECDC).

Our complete COVID-19 dataset is a collection of the COVID-19 data maintained by Our World in Data. It is updated daily and includes data on confirmed cases, deaths, and testing.

We have created a new description of all our data sources. You find it at our GitHub repository here. There you can download all of our data.

Tables

Ecdc

@owid.ecdc.owid_ecdc

5.15 MB
64535 rows
53 columns


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
);