About this Dataset

Public Health - Suburban Cook County - Selected Causes Of Death

This data is compiled by the Cook County Department of Public Health using data from the Illinois Department of Public Health Vital Statistics. It includes the annual number of deaths, crude and age-adjusted death rates by selected causes of death. Further analysis is available by age group, race/ethnicity, gender and decedent's place of residence in suburban Cook County at the time of their death. Note: Counts suppressed for events between 1 and 4, Rates not calculated for events less than 20
Organization: Cook County of Illinois
Last updated: 2020-12-04T19:16:08.468261
Tags: age-adjusted-death-rate, age-adjusted-mortality-rate, causes-of-death, crude-death-rate, crude-mortality-rate, death, death-rate, fy2020, mortality, suburban-cook-county, suburban-cook-county-selected-causes-of-death, vital-statistics

Tables

Table 1

@usgov.cook_county_of_illinois_public_health_suburban_cook_co_ec8c0666.table_1

1.5 MB
47,700 rows
92 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "place" VARCHAR,
  "gender" VARCHAR,
  "race_ethnicity" VARCHAR,
  "age_group" VARCHAR,
  "total_deaths" DOUBLE,
  "all_cause_cdr" DOUBLE,
  "all_cause_aadr" DOUBLE,
  "cancer_deaths" DOUBLE,
  "cancer_cdr" DOUBLE,
  "cancer_aadr" DOUBLE,
  "colorectal_cancer_deaths" DOUBLE,
  "colorectal_cancer_deaths_cdr" DOUBLE,
  "colorectal_cancer_deaths_aadr" DOUBLE,
  "lung_cancer_deaths" DOUBLE,
  "lung_cancer_cdr" DOUBLE,
  "lung_cancer_aadr" DOUBLE,
  "breast_cancer_deaths" DOUBLE,
  "breast_cancer_cdr" DOUBLE,
  "breast_cancer_aadr" DOUBLE,
  "prostate_cancer_deaths" DOUBLE,
  "prostate_cancer_cdr" DOUBLE,
  "prostate_cancer_aadr" DOUBLE,
  "cervical_cancer_deaths" DOUBLE,
  "cervical_cancer_cdr" DOUBLE,
  "cervical_cancer_aadr" DOUBLE,
  "cvd_deaths" DOUBLE,
  "cvd_cdr" DOUBLE,
  "cvd_aadr" DOUBLE,
  "cerebrovascular_stroke_deaths" DOUBLE  -- Cerebrovascular (Stroke) Deaths,
  "cerebrovascular_stroke_cdr" DOUBLE  -- Cerebrovascular (Stroke) CDR,
  "cerebrovascular_stroke_aadr" DOUBLE  -- Cerebrovascular (Stroke) AADR,
  "heart_disease_deaths" DOUBLE,
  "heart_disease_cdr" DOUBLE,
  "heart_disease_aadr" DOUBLE,
  "hypertension_deaths" DOUBLE,
  "hypertension_cdr" DOUBLE,
  "hypertension_aadr" DOUBLE,
  "diabetes_deaths" DOUBLE,
  "diabetes_cdr" DOUBLE,
  "diabetes_aadr" DOUBLE,
  "clrd_deaths" DOUBLE,
  "clrd_cdr" DOUBLE,
  "clrd_aadr" DOUBLE,
  "alzheimer_s_deaths" DOUBLE,
  "alzheimer_s_cdr" DOUBLE,
  "alzheimer_s_aadr" DOUBLE,
  "asthma_deaths" DOUBLE,
  "asthma_cdr" DOUBLE,
  "asthma_aadr" DOUBLE,
  "chronic_liver_disease_deaths" DOUBLE,
  "chronic_liver_disease_cdr" DOUBLE,
  "chronic_liver_disease_aadr" DOUBLE,
  "nephritis_deaths" DOUBLE,
  "nephritis_deaths_cdr" DOUBLE,
  "nephritis_deaths_aadr" DOUBLE,
  "parkinson_s_deaths" DOUBLE,
  "parkinson_s_cdr" DOUBLE,
  "parkinson_s_aadr" DOUBLE,
  "drug_overdose_deaths" DOUBLE,
  "drug_overdose_cdr" DOUBLE,
  "drug_overdose_aadr" DOUBLE,
  "opioid_overdose_deaths" DOUBLE,
  "opioid_overdose_cdr" DOUBLE,
  "opioid_overdose_aadr" DOUBLE,
  "homicide_deaths" DOUBLE,
  "homicide_cdr" DOUBLE,
  "homicide_aadr" DOUBLE,
  "firearms_deaths" DOUBLE,
  "firearms_cdr" DOUBLE,
  "firearms_aadr" DOUBLE,
  "motor_vehicle_accidents_deaths" DOUBLE,
  "motor_vehicle_accidents_cdr" DOUBLE,
  "motor_vehicle_accidents_aadr" DOUBLE,
  "suicide_deaths" DOUBLE,
  "suicide_cdr" DOUBLE,
  "suicide_aadr" DOUBLE,
  "congenital_anomalies_deaths" DOUBLE,
  "congenital_anomalies_cdr" DOUBLE,
  "congenital_anomalies_aadr" DOUBLE,
  "perinatal_deaths" DOUBLE,
  "perinatal_cdr" DOUBLE,
  "perinatal_aadr" DOUBLE,
  "hiv_deaths" DOUBLE,
  "hiv_cdr" DOUBLE,
  "hiv_aadr" DOUBLE,
  "pneumonia_flu_deaths" DOUBLE,
  "pneumonia_flu_cdr" DOUBLE,
  "pneumonia_flu_aadr" DOUBLE,
  "septicemia_deaths" DOUBLE,
  "septicemia_cdr" DOUBLE,
  "septicemia_aadr" DOUBLE
);