About this Dataset

COVID-19, JHU CSSE Dataset

This is the data repository for the 2019 Novel Coronavirus Visual Dashboard operated by the Johns Hopkins University Center for Systems Science and Engineering (JHU CSSE). Also, Supported by ESRI Living Atlas Team and the Johns Hopkins University Applied Physics Lab (JHU APL).

For the historic of changes and modifications to the data, refer to https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data. For more details, refer to https://github.com/CSSEGISandData/COVID-19/tree/master.

Tables

COVID-19, JHU CSSE Dataset

@owid.john_hopkins_university.owid_john_hopkins_university

16.2 MB
253,130 rows
34 columns

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 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,
  "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_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_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,
  "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,
  "weekly_cases" UINTEGER,
  "weekly_deaths" UINTEGER,
  "weekly_case_growth_pct" FLOAT  -- Weekly Case Growth, Pct,
  "weekly_death_growth_pct" FLOAT  -- Weekly Death Growth, Pct,
  "biweekly_cases" UINTEGER,
  "biweekly_deaths" UINTEGER,
  "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
);