nchs_sas: Provisional COVID-19 Death Counts by Sex, Age, and State
In kjhealy/covdata: COVID-19 Data

nchs_sas

R Documentation

Provisional COVID-19 Death Counts by Sex, Age, and State

Description

Deaths involving coronavirus disease (COVID-19), pneumonia, and influenza reported to NCHS by sex and age group and state.

Usage

nchs_sas

Format

A tibble with 115,668 rows and 15 variables:

data_as_of: date Date of data release
start_date: date First date of data period
end_date: date Last date of data period
group: character Unit of time observation: whether data in this row are measured By month, By total, or By year
year: integer Year of observation
month: integer Month of observation
state: character Jurisdiction of occurrence. One of: United States total, a US State, District of Columbia, and New York City, separate from New York state.
sex: character Sex
age_group: character Age group
covid_19_deaths: integer Deaths involving COVID-19 (ICD-code U07.1)
total_deaths: integer Deaths from all causes of death
pneumonia_deaths: integer Pneumonia Deaths (ICD-10 codes J12.0-J18.9)
pneumonia_and_covid_19_deaths: integer Deaths with Pneumonia and COVID-19 (ICD-10 codes J12.0-J18.9 and U07.1)
influenza_deaths: integer Influenza Deaths (ICD-10 codes J09-J11)
pneumonia_influenza_or_covid_19_deaths: integer Deaths with Pneumonia, Influenza, or COVID-19 (ICD-10 codes U07.1 or J09-J18.9)

Details

Table: Data summary


Name	nchs_sas
Number of rows	115668
Number of columns	15
_______________________
Column type frequency:
Date	1
character	6
numeric	8
________________________
Group variables	None

Variable type: Date

skim_variable	n_missing	complete_rate	min	max	median	n_unique
data_as_of	0	1	2023-01-18	2023-01-18	2023-01-18	1

Variable type: character

skim_variable	n_missing	complete_rate	min	max	empty	n_unique	whitespace
start_date	0	1	10	10	0	37	0
end_date	0	1	10	10	0	37	0
group	0	1	7	8	0	3	0
state	0	1	4	20	0	54	0
sex	0	1	4	9	0	3	0
age_group	0	1	8	17	0	17	0

Variable type: numeric

skim_variable	n_missing	complete_rate	mean	sd	p0	p25	p50	p75	p100	hist
year	2754	0.98	2021.10	0.91	2020	2020	2021	2022	2023	▇▇▁▇▁
month	13770	0.88	6.35	3.52	1	3	6	9	12	▇▅▅▅▇
covid_19_deaths	31823	0.72	351.76	6263.51	0	0	10	60	1094723	▇▁▁▁▁
total_deaths	17146	0.85	2812.18	52269.95	0	41	148	648	10144808	▇▁▁▁▁
pneumonia_deaths	36293	0.69	349.71	6016.66	0	0	17	76	1030983	▇▁▁▁▁
pneumonia_and_covid_19_deaths	30476	0.74	174.88	3162.39	0	0	0	26	550128	▇▁▁▁▁
influenza_deaths	22407	0.81	4.94	103.26	0	0	0	0	18477	▇▁▁▁▁
pneumonia_influenza_or_covid_19_deaths	35678	0.69	535.21	9239.91	0	0	25	112	1591892	▇▁▁▁▁

Number of deaths reported in this table are the total number of deaths received and coded as of the date of analysis, and do not represent all deaths that occurred in that period. Data during this period are incomplete because of the lag in time between when the death occurred and when the death certificate is completed, submitted to NCHS and processed for reporting purposes. This delay can range from 1 week to 8 weeks or more. Missing values may indicate that a category has between 1 and 9 observed cases and have been suppressed in accordance with NHCS confidentiality standards. As of September 2, 2020, this data file includes the following age groups in addition to the age groups that are routinely included: 0-17, 18-29, 30-49, and 50-64. The new age groups are consistent with categories used across CDC COVID-19 surveillance pages. When analyzing the file, the user should make sure to select only the desired age groups. Summing across all age categories provided will result in double counting deaths from certain age groups. Similarly, the state variable includes the United States as a whole, and New York City counted separately from the rest of New York State. The temporal unit of observation also varies, with totals given by year, by month, and overall. It is necessary to first filter the data by desired time unit, region, and age group to ensure there is no double-counting in subsequent calculations.