About this Dataset

AH Monthly Provisional Counts Of Deaths For Select Causes Of Death By Sex, Age, And Race And Hispanic Origin

Provisional counts of deaths by the month the deaths occurred, by age group, sex, and race/ethnicity, for select underlying causes of death for 2020-2021. Final data are provided for 2019. The dataset also includes monthly provisional counts of death for COVID-19, coded to ICD-10 code U07.1 as an underlying or multiple cause of death.
Organization: U.S. Department of Health & Human Services
Last updated: 2020-11-10T16:17:16.931632
Tags: age, age-group, all-causes, alzheimer-disease, cancer, causes-of-death, cerebrovascular-disease, chronic-lower-respiratory-disease, coronavirus, covid-19, deaths, diabetes, diseases-of-heart, hispanic-origin, influenza, kidney-disease, monthly, mortality, natural-cause, nchs, nvss, pneumonia, provisional, race, respiratory-disease, septicemia, sex, united-states

Tables

Table 1

@usgov.hhs_gov_monthly_provisional_counts_of_deaths_by_age_gr_6a993eb3.table_1

123.78 kB
3,960 rows
24 columns

CREATE TABLE table_1 (
  "analysisdate" TIMESTAMP,
  "date_of_death_year" BIGINT,
  "date_of_death_month" BIGINT,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "jurisdiction_of_occurrence" VARCHAR,
  "sex" VARCHAR,
  "race_ethnicity" VARCHAR,
  "agegroup" VARCHAR,
  "allcause" BIGINT,
  "naturalcause" BIGINT,
  "septicemia_a40_a41" BIGINT  -- Septicemia (A40-A41),
  "malignant_neoplasms_c00_c97" BIGINT  -- Malignant Neoplasms (C00-C97),
  "diabetes_mellitus_e10_e14" BIGINT  -- Diabetes Mellitus (E10-E14),
  "alzheimer_disease_g30" BIGINT  -- Alzheimer Disease (G30),
  "influenza_and_pneumonia_j09_j18" BIGINT  -- Influenza And Pneumonia (J09-J18),
  "chronic_lower_respiratory_diseases_j40_j47" BIGINT  -- Chronic Lower Respiratory Diseases (J40-J47),
  "other_diseases_of_respiratory_system_j00_j06_j30_j39_j_72b5e9ca" BIGINT  -- Other Diseases Of Respiratory System (J00-J06,J30-J39,J67,J70-J98),
  "nephritis_nephrotic_syndrome_and_nephrosis_n00_n07_n17_0c76b42b" BIGINT  -- Nephritis, Nephrotic Syndrome And Nephrosis (N00-N07,N17-N19,N25-N27),
  "symptoms_signs_and_abnormal_clinical_and_laboratory_fi_cdf2c2f5" BIGINT  -- Symptoms, Signs And Abnormal Clinical And Laboratory Findings, Not Elsewhere Classified (R00-R99),
  "diseases_of_heart_i00_i09_i11_i13_i20_i51" BIGINT  -- Diseases Of Heart (I00-I09,I11,I13,I20-I51),
  "cerebrovascular_diseases_i60_i69" BIGINT  -- Cerebrovascular Diseases (I60-I69),
  "covid_19_u071_multiple_cause_of_death" BIGINT  -- COVID-19 (U071, Multiple Cause Of Death),
  "covid_19_u071_underlying_cause_of_death" BIGINT  -- COVID-19 (U071, Underlying Cause Of Death)
);