About this Dataset

Monthly Provisional Counts Of Deaths By Select Causes, 2020-2023

Effective September 27, 2023, this dataset will no longer be updated. Similar data are accessible from wonder.cdc.gov. Provisional counts of deaths by the month the death occurred and by select causes of death for 2020-2023.
Organization: U.S. Department of Health & Human Services
Last updated: 2021-03-16T19:53:16.340831
Tags: all-causes, alzheimer-disease, cancer, causes-of-death, cerebrovascular-disease, chronic-lower-respiratory-disease, coronavirus, covid-19, deaths, diabetes, diseases-of-heart, drug-overdose, homicide, influenza, kidney-disease, monthly, mortality, motor-vehicle-accidents, natural-cause, nchs, nvss, pneumonia, provisional, respiratory-disease, septicemia, suicide, unintentional-injuries, united-states

Tables

Table 1

@usgov.hhs_gov_monthly_counts_of_deaths_by_select_causes_2020_3feabe44.table_1

30.43 kB
45 rows
31 columns

CREATE TABLE table_1 (
  "data_as_of" TIMESTAMP,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "jurisdiction_of_occurrence" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "all_cause" BIGINT,
  "natural_cause" BIGINT,
  "septicemia" BIGINT,
  "malignant_neoplasms" BIGINT,
  "diabetes_mellitus" BIGINT,
  "alzheimer_disease" BIGINT,
  "influenza_and_pneumonia" BIGINT,
  "chronic_lower_respiratory_diseases" BIGINT,
  "other_diseases_of_respiratory_system" BIGINT,
  "nephritis_nephrotic_syndrome_and_nephrosis" BIGINT  -- Nephritis, Nephrotic Syndrome And Nephrosis,
  "symptoms_signs_and_abnormal_clinical_and_laboratory_fi_877043bc" BIGINT  -- Symptoms, Signs And Abnormal Clinical And Laboratory Findings, Not Elsewhere Classified,
  "diseases_of_heart" BIGINT,
  "cerebrovascular_diseases" BIGINT,
  "accidents_unintentional_injuries" DOUBLE  -- Accidents (Unintentional Injuries),
  "motor_vehicle_accidents" DOUBLE,
  "intentional_self_harm_suicide" DOUBLE  -- Intentional Self-Harm (Suicide),
  "assault_homicide" DOUBLE  -- Assault (Homicide),
  "drug_overdose" DOUBLE,
  "covid_19_multiple_cause_of_death" BIGINT  -- COVID-19 (Multiple Cause Of Death),
  "covid_19_underlying_cause_of_death" BIGINT  -- COVID-19 (Underlying Cause Of Death),
  "flag_accid" VARCHAR,
  "flag_mva" VARCHAR,
  "flag_suic" VARCHAR,
  "flag_homic" VARCHAR,
  "flag_drugod" VARCHAR
);