State and County COVID-19 Cases

State and country observations from the Covid Tracking Project

covidtracking.com-covid19-3.1.5. Modified 2020-04-04T02:21:20

Resources | Packages | Documentation| Contacts| Data Dictionary

Resources

  • states. Cumulative cases, deaths, hospitalizations, etc for US states
  • counties. Cumulative cases, deaths, hospitalizations, etc for US counties

Documentation

The COVID Tracking Project collects information from 50 US states, the District of Columbia, and 5 other US territories to provide the most comprehensive testing data we can collect for the novel coronavirus, SARS-CoV-2. They attempt to include positive and negative results, pending tests, and total people tested for each state or district currently reporting that data.

Contacts

Packages

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/covidtracking.com-covid19-3.1.5.zip')

# Create Dataframes

states_df = pkg.resource('states').dataframe()
counties_df = pkg.resource('counties').dataframe()

Data Dictionary

counties | states

counties

Column NameData TypeDescription
statestring
countystring
covid19sitestring
datasiteunknown
mainsitestring
twitterunknown
puistring

states

Column NameData TypeDescription
dateinteger
statestring
positiveinteger
negativeinteger
pendinginteger
hospitalizedcurrentlyinteger
hospitalizedcumulativeinteger
inicucurrentlyinteger
inicucumulativeinteger
onventilatorcurrentlyinteger
onventilatorcumulativeinteger
recoveredinteger
hashstring
datecheckeddatetime
deathinteger
hospitalizedinteger
totalinteger
totaltestresultsinteger
posneginteger
fipsinteger
deathincreaseinteger
hospitalizedincreaseinteger
negativeincreaseinteger
positiveincreaseinteger
totaltestresultsincreaseinteger

Packages

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/covidtracking.com-covid19-3.1.5.zip')

# Create Dataframes

states_df = pkg.resource('states').dataframe()
counties_df = pkg.resource('counties').dataframe()