Skip to content

Latest commit

 

History

History
 
 

csse_covid_19_data

README.md

CSSE COVID-19 Dataset

Daily reports (csse_covid_19_daily_reports)

This folder contains daily case reports. All timestamps are in UTC (GMT+0).

File naming convention

MM-DD-YYYY.csv in UTC.

Field description

  • Province/State: China - province name; US/Canada/Australia/ - city name, state/province name; Others - name of the event (e.g., "Diamond Princess" cruise ship); other countries - blank.
  • Country/Region: country/region name conforming to WHO (will be updated).
  • Last Update: MM/DD/YYYY HH:mm (24 hour format, in UTC).
  • Confirmed: the number of confirmed cases. For Hubei Province: from Feb 13 (GMT +8), we report both clinically diagnosed and lab-confirmed cases. For lab-confirmed cases only (Before Feb 17), please refer to who_covid_19_situation_reports. For Italy, diagnosis standard might be changed since Feb 27 to "slow the growth of new case numbers." (Source)
  • Deaths: the number of deaths.
  • Recovered: the number of recovered cases.

Update frequency

  • Files after Feb 1 (UTC): once a day around 23:59 (UTC).
  • Files on and before Feb 1 (UTC): the last updated files before 23:59 (UTC). Sources: archived_data and dashboard.

Data sources

Refer to the mainpage.

Why create this new folder?

  1. Unifying all timestamps to UTC, including the file name and the "Last Update" field.
  2. Pushing only one file every day.
  3. All historic data is archived in archived_data.

Time series summary (csse_covid_19_time_series)

This folder contains daily time series summary tables, including confirmed, deaths and recovered. All data are from the daily case report.

Field descriptioin

  • Province/State: same as above.
  • Country/Region: same as above.
  • Lat and Long: a coordinates reference for the user.
  • Date fields: M/DD/YYYY (UTC), the same data as MM-DD-YYYY.csv file.

Update frequency

  • Once a day.

Data modification records

We are also monitoring the curve change. Any errors made by us will be corrected in the dataset. Any possible errors from the original data sources will be listed here as a reference.

  • NHC 2/14: Hubei Province deducted 108 prior deaths from the death toll due to double counting.
  • About DP 3/1: All cases of COVID-19 in repatriated US citizens from the Diamond Princess are grouped together, and their location is currently designated at the ship’s port location off the coast of Japan. These individuals have been assigned to various quarantine locations (in military bases and hospitals) around the US. This grouping is consistent with the CDC.

UID Lookup Table Logic

  1. All countries without dependencies (entries with only Admin0).
  • None cruise ship Admin0: UID = code3. (e.g., Afghanistan, UID = code3 = 4)
  • Cruise ships in Admin0: Diamond Princess UID = 9999, MS Zaandam UID = 8888.
  1. All countries with only state-level dependencies (entries with Admin0 and Admin1).
  • Demark, France, Netherlands: mother countries and their dependencies have different code3, therefore UID = code 3. (e.g., Faroe Islands, Denmark, UID = code3 = 234; Denmark UID = 208)
  • United Kingdom: the mother country and dependencies have different code3s, therefore UID = code 3. One exception: Channel Islands is using the same code3 as the mother country (826), and its artificial UID = 8261.
  • Australia: alphabetically ordered all states, and their UIDs are from 3601 to 3608. Australia itself is 36.
  • Canada: alphabetically ordered all provinces (including cruise ships and recovered entry), and their UIDs are from 12401 to 12415. Canada itself is 124.
  • China: alphabetically ordered all provinces, and their UIDs are from 15601 to 15631. China itself is 156. Hong Kong and Macau have their own code3.
  1. The US (most entries with Admin0, Admin1 and Admin2).
  • US by itself is 840 (UID = code3).
  • US dependencies, American Samoa, Guam, Northern Mariana Islands, Virgin Islands and Puerto Rico, UID = code3. Their FIPS codes are different from code3.
  • US states: UID = 840 (country code3) + 000XX (state FIPS code). Ranging from 8400001 to 84000056.
  • Out of [State], US: UID = 840 (country code3) + 800XX (state FIPS code). Ranging from 8408001 to 84080056.
  • Unassigned, US: UID = 840 (country code3) + 900XX (state FIPS code). Ranging from 8409001 to 84090056.
  • US counties: UID = 840 (country code3) + XXXXX (5-digit FIPS code).
  • Exception type 1, such as recovered and Kansas City, ranging from 8407001 to 8407999.
  • Exception type 2, only the New York City, which is replacing New York County and its FIPS code.
  • Exception type 3, Diamond Princess, US: 84088888; Grand Princess, US: 84099999.