A dataset containing US county-level data on COVID-19, collected by the New York Times.

nytcovcounty

Format

A tibble with 2,502,832 rows and 6 columns

date

Date in YYYY-MM-DD format (date)

county

County name (character)

state

State name (character)

fips

County FIPS code (character)

cases

Cumulative N reported cases

deaths

Cumulative N reported deaths

Source

The New York Times https://github.com/nytimes/covid-19-data For details on the methods and limitations see https://github.com/nytimes/covid-19-data. For county data, note in particular:

  • New York: All cases for the five boroughs of New York City (New York, Kings, Queens, Bronx and Richmond counties) are assigned to a single area called New York City. There is a large jump in the number of deaths on April 6th due to switching from data from New York City to data from New York state for deaths. For all New York state counties, starting on April 8th we are reporting deaths by place of fatality instead of residence of individual.

  • Kansas City, Mo: Four counties (Cass, Clay, Jackson and Platte) overlap the municipality of Kansas City, Mo. The cases and deaths that we show for these four counties are only for the portions exclusive of Kansas City. Cases and deaths for Kansas City are reported as their own line.

  • Alameda County, Calif: Counts for Alameda County include cases and deaths from Berkeley and the Grand Princess cruise ship.

  • Douglas County, Neb. Counts for Douglas County include cases brought to the state from the Diamond Princess cruise ship.

  • Chicago: All cases and deaths for Chicago are reported as part of Cook County.

  • Guam: Counts for Guam include cases reported from the USS Theodore Roosevelt.

Details

Table: Data summary

Namenytcovcounty
Number of rows2502832
Number of columns6
_______________________
Column type frequency:
Date1
character3
numeric2
________________________
Group variablesNone

Variable type: Date

skim_variablen_missingcomplete_rateminmaxmediann_unique
date012020-01-212022-05-132021-04-23844

Variable type: character

skim_variablen_missingcomplete_rateminmaxemptyn_uniquewhitespace
county01.00335019320
state01.004240560
fips236780.9955032200

Variable type: numeric

skim_variablen_missingcomplete_ratemeansdp0p25p50p75p100hist
cases01.0010033.8047525.220382177358842908425▇▁▁▁▁
deaths576050.98161.61820.33063310140267▇▁▁▁▁