State and County COVID-19 Cases

State and country observations from the Covid Tracking Project

covidtracking.com-covid19-3.1.51. Modified 2020-07-08T04:54:16

Resources | Packages | Documentation| Contacts| Data Dictionary

Resources

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

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

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 Data in Vanilla Pandas

import pandas as pd


states_df =  pd.read_csv('http://library.metatab.org/covidtracking.com-covid19-3.1.51/data/states.csv')

Accessing Package in Metapack

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

# Create Dataframes
states_df = pkg.resource('states').dataframe()