COVID-19: Ultimate Data Set [CSV] (refreshed August 9, 2021)

This is the ultimate GLOBAL data set for COVID-19. It provides population, deaths, land area, ISO codes, confirmed cases, deaths, ICU beds, workers, workers that take public transit, new and cumulative cases/deaths/recovered, day numbers (to compare on set of outbreak or quarantine dates), and more ..at the county level!

Go to the bottom of the post for the download links!

I have been using John Hopkins (JH) data to track COVID-19 for quite awhile now. JH has done a great job collecting all this data. However, the ability to tie other data into it has been challenging and the schema has frequently changed. Again, I’m grateful for their work.

As you may know, I have been maintaining a consistent schema for a few months now and sharing that on my blog. However, I found myself manually combining and analyzing other data with JH’s data. So, this ultimate data set combines the hard work of John Hopkins with other useful data (e.g., population, land area, quarantine dates, outbreak dates, ICU beds, and more).

I have created an ultimate data set for COVID-19, that has the following:

• Global Confirmed Cases, Deaths, Recovered (John Hopkins)
  • Temporarily removing Canada recovered cases for another reason
  • Source: https://github.com/CSSEGISandData/COVID-19
• US Confirmed Cases, Deaths (John Hopkins)
  • Note: US Recovered is currently omitted from the JH data set
  • Source: https://github.com/CSSEGISandData/COVID-19
• ISO Alpha 2, Alpha 3, Numeric
  • Source: https://www.iso.org/obp/ui/#search
  • Source: https://en.wikipedia.org/wiki/ISO_3166-2:US
• Population (total and Urban), Deaths (non-COVID related), Median age, and Land area [provided for all reported Global regions and US counties (only population, deaths, land area), for super detailed analysis]; also allows for population density calculations
  • Global Source (population, median age, land area): https://www.worldometers.info/world-population/population-by-country/
  • Australia provinces source: https://www.ga.gov.au/scientific-topics/national-location-information/dimensions/area-of-australia-states-and-territories
  • Canada Province Source: https://en.wikipedia.org/wiki/Provinces_and_territories_of_Canada
  • China province source: https://en.wikipedia.org/wiki/Provinces_of_China#cite_note-7 and http://data.stats.gov.cn/english/easyquery.htm?cn=E0103
  • US Source for Population/Deaths (county level): https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/counties/totals/
  • US Source for land area (square miles): https://www.ers.usda.gov/data-products/rural-urban-commuting-area-codes/
• US Only (detailed to county level):
  • State Abbreviation
  • FIPS Code
  • Total Workers, Workers from home, Total Workers that take Public Transit (US Census Data)
    • Source: https://data.census.gov/cedsci/table?q=2018%20means%20of%20transportation&g=0100000US.050000&tid=ACSDT1Y2018.B08141&t=Transportation&y=2018&vintage=2018&hidePreview=true&tp=true
  • Population 60 and over, ICU Beds – county level detail (KHN)
    • Source: https://khn.org/news/as-coronavirus-spreads-widely-millions-of-older-americans-live-in-counties-with-no-icu-beds/#lookup (click on “Get the Data”)
  • Political affiliation (e.g., Republican, Democrat)
    • Source: https://github.com/tonmcg/US_County_Level_Election_Results_08-16/blob/master/2016_US_County_Level_Presidential_Results.csv
• Only available in the file that has dates on each row:
  • Day Numbers and Dates that events occurred [These lets you compare regions side by side. This is available for all levels (Country, Region, County)]
    • First 100, 500, 1000 cases
    • First 10, 50, 100 deaths
    • Quarantine dates
      • Source: https://time.com/5789631/coronavirus-covid-19-global-cases/
      • Source: https://www.nytimes.com/interactive/2020/us/coronavirus-stay-at-home-order.html
      • Source: https://en.wikipedia.org/wiki/National_responses_to_the_2019%E2%80%9320_coronavirus_pandemic
  • New Cases, New Deaths, New Recovered (from previous day)

I was considering adding the following:

• US state-level test data (positive, negative, total)

This file is in beta at the moment and may change. Please provide feedback.

Download here (refreshed with 8/9/2021 data):

Note: Starting in June 2020, the “series2” file will only include a trailing 3 months due to an error I was getting, likely due to the size of the file and my computer’s ability to process. All other files have all dates available. If you need those dates, let me know and I’ll add a separate file that you can concatenate.

Dates are exploded into rows (my preference): (This file has more info avail, like day numbers, dates that events occurred, new cases/deaths/recovered but is only limited to the trailing three months)

https://www.soothsawyer.com/wp-content/uploads/2020/03/john-hopkins-ryan-format-time-series2.csv (~210MB)

Download gzip version here (~12MB) <—– FASTER DOWNLOAD

Dates are individual columns instead of rows (this makes the file way smaller) and this file has ALL dates:

https://www.soothsawyer.com/wp-content/uploads/2020/03/john-hopkins-ryan-format-time-series1.csv (~3MB)