About this Dataset

Public Health Statistics - Selected Public Health Indicators By Chicago Community Area - Historical

Note: This dataset is historical only and there are not corresponding datasets for more recent time periods. For that more-recent information, please visit the Chicago Health Atlas at https://chicagohealthatlas.org.

This dataset contains a selection of 27 indicators of public health significance by Chicago community area, with the most updated information available. The indicators are rates, percents, or other measures related to natality, mortality, infectious disease, lead poisoning, and economic status. See the full description at https://data.cityofchicago.org/api/assets/2107948F-357D-4ED7-ACC2-2E9266BBFFA2.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:02.014235
Tags: historical

Tables

Table 1

@usgov.city_of_chicago_public_health_statistics_selected_publ_962060dd.table_1

34.35 kB
77 rows
29 columns

CREATE TABLE table_1 (
  "community_area" BIGINT,
  "community_area_name" VARCHAR,
  "birth_rate" DOUBLE,
  "general_fertility_rate" DOUBLE,
  "low_birth_weight" DOUBLE,
  "prenatal_care_beginning_in_first_trimester" DOUBLE,
  "preterm_births" DOUBLE,
  "teen_birth_rate" DOUBLE,
  "assault_homicide" DOUBLE  -- Assault (Homicide),
  "breast_cancer_in_females" DOUBLE,
  "cancer_all_sites" DOUBLE  -- Cancer (All Sites),
  "colorectal_cancer" DOUBLE,
  "diabetes_related" DOUBLE,
  "firearm_related" DOUBLE,
  "infant_mortality_rate" DOUBLE,
  "lung_cancer" DOUBLE,
  "prostate_cancer_in_males" DOUBLE,
  "stroke_cerebrovascular_disease" DOUBLE  -- Stroke (Cerebrovascular Disease),
  "childhood_blood_lead_level_screening" DOUBLE,
  "childhood_lead_poisoning" DOUBLE,
  "gonorrhea_in_females" DOUBLE,
  "gonorrhea_in_males" VARCHAR,
  "tuberculosis" DOUBLE,
  "below_poverty_level" DOUBLE,
  "crowded_housing" DOUBLE,
  "dependency" DOUBLE,
  "no_high_school_diploma" DOUBLE,
  "per_capita_income" BIGINT,
  "unemployment" DOUBLE
);