Deaths involving coronavirus disease (COVID-19), pneumonia, and influenza reported to NCHS by sex and age group and state.
nchs_sasA tibble with 115,668 rows and 15 variables:
data_as_ofdate Date of data release
start_datedate First date of data period
end_datedate Last date of data period
groupcharacter Unit of time observation: whether data in this row are measured By month, By total, or By year
yearinteger Year of observation
monthinteger Month of observation
statecharacter Jurisdiction of occurrence. One of: United States total, a US State, District of Columbia, and New York City, separate from New York state.
sexcharacter Sex
age_groupcharacter Age group
covid_19_deathsinteger Deaths involving COVID-19 (ICD-code U07.1)
total_deathsinteger Deaths from all causes of death
pneumonia_deathsinteger Pneumonia Deaths (ICD-10 codes J12.0-J18.9)
pneumonia_and_covid_19_deathsinteger Deaths with Pneumonia and COVID-19 (ICD-10 codes J12.0-J18.9 and U07.1)
influenza_deathsinteger Influenza Deaths (ICD-10 codes J09-J11)
pneumonia_influenza_or_covid_19_deathsinteger Deaths with Pneumonia, Influenza, or COVID-19 (ICD-10 codes U07.1 or J09-J18.9)
National Center for Health Statistics https://data.cdc.gov/NCHS/Provisional-COVID-19-Death-Counts-by-Sex-Age-and-S/9bhg-hcku
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.