About this Dataset

AH Monthly Provisional Counts Of Deaths By Age Group And HHS Region For Select Causes Of Death, 2019-2021

Provisional counts of deaths by the month the deaths occurred, by age group and HHS region, for select underlying causes of death for 2019-2020. 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:16:28.784747
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, hhs-region, influenza, kidney-disease, monthly, mortality, natural-cause, nchs, nvss, pneumonia, provisional, respiratory-disease, septicemia, united-states

Tables

Table 1

@usgov.hhs_gov_monthly_provisional_counts_of_deaths_by_age_gr_f5ea4520.table_1

144.02 kB
3,410 rows
36 columns

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