covid19census

Overview

The package covid19census provides functions to extract COVID-19 cases, deaths, hospitalizations and test of U.S. and Italy at the county and regional level, respectively, and then combines them with other population metrics (age, sex, prevalence of chronic conditions, income indexes, access to health services and many others).

Note that the package has not been made by and is not part of the covid19.census.gov website.

Installation

Download the package in a local folder and then run the following code.

devtools::install_local("path_to_package")

Alternatively, you can install it directly from github.

library(devtools)

devtools::install_github("c1au6i0/covid19census")

Usage

A dataset that includes COVID-19 data and all the other demographic variables can be obtained executing getus_all (get-U.S-all) to get U.S data, or getit_all (get-Italy-all) to get Italy data.

library(covid19census)

# to retrieve u.s data you can use 
# the new york times or john hopkins university repository f
all_us <- getus_all(repo = "jhu")

# to retrieve italy data
all_it <- getit_all()

Details on the other functions and the datasets can be found in the vignette of the package vignette("v_covid19census").

U.S. Datasets and Sources

Data regarding COVID-19 number of cases and deaths (at the county level) can be obtained from the New York Time or the Johns Hopkins University, whereas number of tests and hospitalizations from the the Covid Tracking Project.

The other datsets were obtained from the Homeland Infrastructure Foundation, the Census, Mapping Medicare Disparities, and activity indexes calculated by Victor Couture, Jonathan Dingel, Allison Green, Jessie Handbury, and Kevin Williams based on smartphone movement data provided by PlaceIQ. Emissions of pm2.5 in micro g/m3 (2016) were reported by and #’ aggregate by

This is a list of U.S. datasets that can be accessed directly or in a dataframe containing also COVID-19 metrics:

• us_acm_househ: several metric regarding household composition, including poverty, education, ancestry (2018).
• us_age_sex: age and sex distribution (2018).
• us_fl65: percentage of fee-for-service (FFS) Medicare enrollees that had an annual flu vaccination (2019)
• us_hospbeds: total hospital beds in each county (2019).
• us_netinc: median househould income (2018).
• us_mmd: data of 2019 regarding the prevalence found in medicare beneficiaries of
  • many medical and chronic conditions (Alzheimer, chronic kidney, obesity, depression, obstructive pulmonary, disease, arthritis, diabetes, osteoporosis, asthma, atrial fibrillation, ischemic hearth, myocardial infarction, hypertension).
  • several type of cancer.
  • emergency, medical admissions and annual visits.
  • pneumoccocal vaccine.
  • tobacco use.
• us_pm2.5: Emissions of pm2.5 in micro g/m3
• us_race: estimated races in population (2018).

Note that info for some counties are missing in some datasets. For example, hospbeds contains info on 2545 counties, fl65 has 3224 counties, whereas datasets from the Census have 3220.

Italy: Datasets and Sources

Data regarding COVID-19 deaths, confirmed cases, test and hospitalizations are extracted from the Protezione Civile repository

Demographic metrics and other stats regarding medical conditions and vaccinations were obtained from the ISTAT, Ministero della Salute. Data regarding pm2.5 were collected by Istituto Superiore per la Protezione Ambientale

This is a list of Italy datasets that can be accessed directly or in a dataframe containing also COVID-19 metrics:

• it_bweight: Body mass index in regions of Italy, in the general population.
• it_cancer: Number of cancer patients in each region by type.
• it_chronic: Number of people suffering of chronic conditions by region and type.
• it_dem: Number of people by region, sex, age.
• it_firstaid: Number of people using first aid or medical guard (3 months).
• it_fl: Influenza vaccination coverage in Italy for 2009-2019 season for general population and aged 65 and more.
• it_fl_2019: Influenza vaccination coverage in Italy for 2018-2019 season for general population and 65 and more.
• it_hospbed: Inpatient hospital beds per 1000 people.
• it_house: household crowding index from 2014 to 2018 in each region.
• it_netinc: median net annual households income (including imputed rents, in euros).
• it_pm2.5: emission of particulate 2.5 in tons per region.
• it_regions: Area in square meters of each region. Used to calculate density per region.
• it_smoking: Number of people aged 14 years and over that self-referred as smoker, non smoker, or past smoker by region.

Raw Data and other Scripts

Raw data and the code used to import it can be found in the data-raw folder.

Terms of Use

Refer to the License for details on the terms of use and copyrights.