ACS 5 Year Data By Community Area
City of Chicago
@usgov.city_of_chicago_acs_5_year_data_by_community_area
City of Chicago
@usgov.city_of_chicago_acs_5_year_data_by_community_area
CREATE TABLE table_1 (
"acs_year" BIGINT,
"community_area" VARCHAR,
"under_25_000" BIGINT,
"n__25_000_to_49_999" BIGINT,
"n__50_000_to_74_999" BIGINT,
"n__75_000_to_125_000" BIGINT,
"n__125_000" BIGINT,
"male_0_to_17" BIGINT,
"male_18_to_24" BIGINT,
"male_25_to_34" BIGINT,
"male_35_to_49" BIGINT,
"male_50_to_64" BIGINT,
"male_65" BIGINT,
"female_0_to_17" BIGINT,
"female_18_to_24" BIGINT,
"female_25_to_34" BIGINT,
"female_35_to_49" BIGINT,
"female_50_to_64" BIGINT,
"female_65" BIGINT,
"total_population" BIGINT,
"white" BIGINT,
"black_or_african_american" BIGINT,
"american_indian_or_alaska_native" BIGINT,
"asian" BIGINT,
"native_hawaiian_or_pacific_islander" BIGINT,
"other_race" BIGINT,
"multiracial" BIGINT,
"white_not_hispanic_or_latino" BIGINT,
"hispanic_or_latino" BIGINT,
"record_id" VARCHAR
);
Anyone who has the link will be able to view this.