Name: COVID-2019 - ECDC (2020)
Creator: Our World In Data
License: https://creativecommons.org/publicdomain/

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.4 MB
64,535 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 Cases Of Covid 19 Per Million People Reached 1,
  "days_since_the_total_confirmed_deaths_of_covid_19_per__9cd4b472" INTEGER  -- Days Since The Total Confirmed Deaths Of Covid 19 Per Million People Reached 0–1,
  "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 Cases Of Covid 19, Rolling 7 Day Average, Right Aligned, Reached 30,
  "days_since_daily_new_confirmed_deaths_due_to_covid_19__a874cef2" INTEGER  -- Days Since Daily New Confirmed Deaths Due To Covid 19, Rolling 7 Day Average, Right Aligned, Reached 5,
  "days_since_daily_new_confirmed_cases_of_covid_19_per_m_7888423c" INTEGER  -- Days Since Daily New Confirmed Cases Of Covid 19 Per Million People, Rolling 7 Day Average, Right Aligned, Reached 1,
  "days_since_daily_new_confirmed_deaths_due_to_covid_19__255bbd3e" INTEGER  -- Days Since Daily New Confirmed Deaths Due To Covid 19 Per Million People, Rolling 7 Day Average, Right Aligned, Reached 0–1,
  "days_since_daily_new_confirmed_deaths_due_to_covid_19__58c3e323" INTEGER  -- Days Since Daily New Confirmed Deaths Due To Covid 19 Per Million People, Rolling 7 Day Average, Right Aligned, Reached 0–01,
  "daily_new_confirmed_cases_of_covid_19_rolling_3_day_av_96e4956b" FLOAT  -- Daily New Confirmed Cases Of Covid 19, Rolling 3 Day Average, Right Aligned,
  "daily_new_confirmed_cases_due_to_covid_19_rolling_7_da_8307be16" FLOAT  -- Daily New Confirmed Cases Due To Covid 19, Rolling 7 Day Average, Right Aligned,
  "daily_new_confirmed_deaths_due_to_covid_19_rolling_3_d_2525c2a2" FLOAT  -- Daily New Confirmed Deaths Due To Covid 19, Rolling 3 Day Average, Right Aligned,
  "daily_new_confirmed_deaths_due_to_covid_19_rolling_7_d_06a906b2" FLOAT  -- Daily New Confirmed Deaths Due To Covid 19, Rolling 7 Day Average, Right Aligned,
  "daily_new_confirmed_cases_of_covid_19_per_million_peop_66cbcf60" FLOAT  -- Daily New Confirmed Cases Of Covid 19 Per Million People, Rolling 3 Day Average, Right Aligned,
  "daily_new_confirmed_deaths_due_to_covid_19_per_million_b5c834d9" FLOAT  -- Daily New Confirmed Deaths Due To Covid 19 Per Million People, Rolling 3 Day Average, Right Aligned,
  "daily_new_confirmed_cases_of_covid_19_per_million_peop_222355d4" FLOAT  -- Daily New Confirmed Cases Of Covid 19 Per Million People, Rolling 7 Day Average, Right Aligned,
  "daily_new_confirmed_deaths_due_to_covid_19_per_million_c0d604fd" FLOAT  -- Daily New Confirmed Deaths Due To Covid 19 Per Million People, Rolling 7 Day Average, Right Aligned,
  "case_fatality_rate_of_covid_19_pct" FLOAT  -- Case Fatality Rate Of Covid 19, Pct,
  "case_fatality_rate_of_covid_19_pct_only_observations_w_54618d16" FLOAT  -- Case Fatality Rate Of Covid 19, Pct, Only Observations With, Gte 100 Cases,
  "case_fatality_rate_of_covid_19_pct_short_term" FLOAT  -- Case Fatality Rate Of Covid 19, Pct, Short Term,
  "days_since_the_total_confirmed_cases_of_covid_19_reach_f1f07c54" INTEGER  -- Days Since The Total Confirmed Cases Of Covid 19 Reached 100, With Population, Gte, 5m,
  "has_population_gte_5m_and_had_gte_100_cases_gte_21_day_c0b4f511" INTEGER  -- Has Population, Gte, 5m And Had, Gte 100 Cases, Gte 21 Days Ago And Has Testing Data,
  "doubling_days_of_total_confirmed_cases_3_day_period" FLOAT  -- Doubling Days Of Total Confirmed Cases, 3 Day Period,
  "doubling_days_of_total_confirmed_cases_7_day_period" FLOAT  -- Doubling Days Of Total Confirmed Cases, 7 Day Period,
  "doubling_days_of_total_confirmed_deaths_3_day_period" FLOAT  -- Doubling Days Of Total Confirmed Deaths, 3 Day Period,
  "doubling_days_of_total_confirmed_deaths_7_day_period" FLOAT  -- Doubling Days Of Total Confirmed Deaths, 7 Day Period,
  "weekly_cases" INTEGER,
  "weekly_deaths" INTEGER,
  "weekly_case_growth_pct" FLOAT  -- Weekly Case Growth, Pct,
  "weekly_death_growth_pct" FLOAT  -- Weekly Death Growth, Pct,
  "biweekly_cases" INTEGER,
  "biweekly_deaths" INTEGER,
  "biweekly_case_growth_pct" FLOAT  -- Biweekly Case Growth, Pct,
  "biweekly_death_growth_pct" FLOAT  -- Biweekly Death Growth, Pct,
  "weekly_cases_per_million_people" FLOAT,
  "weekly_deaths_per_million_people" FLOAT,
  "biweekly_cases_per_million_people" FLOAT,
  "biweekly_deaths_per_million_people" FLOAT
);