Census Data - Selected Socioeconomic Indicators In Chicago, 2008 – 2012

City of Chicago

@usgov.city_of_chicago_census_selected_socioeconomic_indicato_69ec4893

Table List

1 table(12.04 KB)

Table 1

@usgov.city_of_chicago_census_selected_socioeconomic_indicato_69ec4893.table_1

12.04 KB
78 rows
9 columns

community_area_number Community Area Number	community_area_name COMMUNITY AREA NAME	percent_of_housing_crowded PERCENT OF HOUSING CROWDED	percent_households_below_poverty PERCENT HOUSEHOLDS BELOW POVERTY	percent_aged_16_unemployed PERCENT AGED 16+ UNEMPLOYED	percent_aged_25_without_high_school_diploma PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA	percent_aged_under_18_or_over_64 PERCENT AGED UNDER 18 OR OVER 64	per_capita_income PER CAPITA INCOME	hardship_index HARDSHIP INDEX
1	Rogers Park	7.7	23.6	8.7	18.2	27.5	23939	39
2	West Ridge	7.8	17.2	8.8	20.8	38.5	23040	46
3	Uptown	3.8	24	8.9	11.8	22.2	35787	20
4	Lincoln Square	3.4	10.9	8.2	13.4	25.5	37524	17
5	North Center	0.3	7.5	5.2	4.5	26.2	57123	6
6	Lake View	1.1	11.4	4.7	2.6	17	60058	5
7	Lincoln Park	0.8	12.3	5.1	3.6	21.5	71551	2
8	Near North Side	1.9	12.9	7	2.5	22.6	88669	1
9	Edison Park	1.1	3.3	6.5	7.4	35.3	40959	8
10	Norwood Park	2	5.4	9	11.5	39.5	32875	21


CREATE TABLE table_1 (
  "community_area_number" DOUBLE,
  "community_area_name" VARCHAR,
  "percent_of_housing_crowded" DOUBLE,
  "percent_households_below_poverty" DOUBLE,
  "percent_aged_16_unemployed" DOUBLE,
  "percent_aged_25_without_high_school_diploma" DOUBLE,
  "percent_aged_under_18_or_over_64" DOUBLE,
  "per_capita_income" BIGINT,
  "hardship_index" DOUBLE
);