covid19nytimes

The covid19nytimes package harvests the data made freely available by the New York Times. See https://www.nytimes.com/article/coronavirus-county-data-us.html for more.

Installation

You can install the released version of covid19nytimes from CRAN with:

install.packages("covid19nytimes")

Or the latest development version from github

devtools::install_github("covid19R/covid19nytimes")

Data

The package has the data from states and counties. The package comes with static data that was downloaded at the time of the last package update.

library(covid19nytimes)

head(covid19nytimes_states_demo) %>% knitr::kable()
date location location_type location_code location_code_type data_type value
2020-04-12 Alabama state 01 fips_code cases_total 3583
2020-04-12 Alabama state 01 fips_code deaths_total 93
2020-04-12 Alaska state 02 fips_code cases_total 270
2020-04-12 Alaska state 02 fips_code deaths_total 6
2020-04-12 American Samoa state 60 fips_code cases_total 0
2020-04-12 American Samoa state 60 fips_code deaths_total 0 
head(covid19nytimes_counties_demo) %>% knitr::kable()
date location location_type location_code location_code_type data_type value
2020-04-12 Abbeville,South Carolina county_state 45001 fips_code cases_total 9
2020-04-12 Abbeville,South Carolina county_state 45001 fips_code deaths_total 0
2020-04-12 Acadia,Louisiana county_state 22001 fips_code cases_total 99
2020-04-12 Acadia,Louisiana county_state 22001 fips_code deaths_total 5
2020-04-12 Accomack,Virginia county_state 51001 fips_code cases_total 15
2020-04-12 Accomack,Virginia county_state 51001 fips_code deaths_total 0

Getting the Most Up to Date Data

To get the most updated data, run the following functions

covid19nytimes_states <- refresh_covid19nytimes_states()

covid19nytimes_counties <- refresh_covid19nytimes_counties()

Columns

The data follows the covid19R standard for tidy Covid-19 data. The data columns are as follows:

  • date - The date in YYYY-MM-DD form
  • location - The name of the location as provided by the data source. The counties dataset provides county and state. They are combined and separated by a ,, and can be split by tidyr::separate(), if you wish.
  • location_type - The type of location using the covid19R controlled vocabulary. Nested locations are indicated by multiple location types being combined with a `_
  • location_code - A standardized location code using a national or international standard. In this case, FIPS state or county codes. See https://en.wikipedia.org/wiki/Federal_Information_Processing_Standard_state_code and https://en.wikipedia.org/wiki/FIPS_county_code for more
  • location_code_type The type of standardized location code being used according to the covid19R controlled vocabulary. Here we use fips_code
  • data_type - the type of data in that given row. Includes total_cases and total_deaths, cumulative measures of both.
  • value - number of cases of each data type

Sample visualization

library(dplyr)
#> 
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#> 
#>     filter, lag
#> The following objects are masked from 'package:base':
#> 
#>     intersect, setdiff, setequal, union
library(ggplot2)

covid19nytimes_states %>%
  filter(location %in% c("Washington", "New York", "Massachusetts", "Michigan", "Illinois")) %>%
  filter(data_type == "deaths_total") %>%
  ggplot(aes(x = date, y = value, color = location)) +
  geom_line() +
  theme_minimal(base_size=14) +
  scale_y_continuous()