About this Dataset

Public Health Statistics - Selected Underlying Causes Of Death In Chicago, 2006–2010 - 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 the cumulative number of deaths, average number of deaths annually, average annual crude and adjusted death rates with corresponding 95% confidence intervals, and average annual years of potential life lost per 100,000 residents aged 75 and younger due to selected causes of death, by Chicago community area, for the years 2006 – 2010. A ranking for each measure is also provided, with the highest value indicated with a ranking of 1. See the full description at: https://data.cityofchicago.org/api/views/6vw3-8p6f/files/CqPqfHSv8UUAoXCBjn4_tLqcQHhb36Ih4-meM-4zNzs?download=true&filename=P:\EPI\OEPHI\MATERIALS\REFERENCES\MORTALITY\Dataset_Description_06_10_PORTAL_ONLY.pdf
Organization: City of Chicago
Last updated: 2021-08-07T18:16:12.722829
Tags: historical

Tables

Table 1

@usgov.city_of_chicago_public_health_statistics_selected_unde_17bcd62b.table_1

67.07 KB
1404 rows
17 columns


CREATE TABLE table_1 (
  "cause_of_death" VARCHAR,
  "community_area" BIGINT,
  "community_area_name" VARCHAR,
  "cumulative_deaths_2006_2010" BIGINT,
  "cumulative_deaths_rank" DOUBLE,
  "average_annual_deaths_2006_2010" BIGINT,
  "average_crude_rate_2006_2010" DOUBLE,
  "average_crude_rate_lower_ci" DOUBLE,
  "average_crude_rate_upper_ci" DOUBLE,
  "crude_rate_rank" DOUBLE,
  "average_adjusted_rate_2006_2010" DOUBLE,
  "average_adjusted_rate_lower_ci" DOUBLE,
  "average_adjusted_rate_upper_ci" DOUBLE,
  "adjusted_rate_rank" DOUBLE,
  "average_annual_years_of_potential_life_lost_ypll_rate_2006_2010" BIGINT,
  "ypll_rate_rank" DOUBLE,
  "warning" VARCHAR
);