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
Selected variables from the most recent ACS Community Survey (Released 2023) aggregated by Community Area. Additional years will be added as they become available.
The underlying algorithm to create the dataset calculates the % of a census tract that falls within the boundaries of a given community area. Given that census tracts and community area boundaries are not aligned, these figures should be considered an estimate.
Total population in this dataset: 2,647,621
Total Chicago Population Per ACS 2023: 2,664,452
% Difference: -0.632%
There are different approaches in common use for displaying Hispanic or Latino population counts. In this dataset, following the approach taken by the Census Bureau, a person who identifies as Hispanic or Latino will also be counted in the race category with which they identify. However, again following the Census Bureau data, there is also a column for White Not Hispanic or Latino.
Code can be found here: https://github.com/Chicago/5-Year-ACS-Survey-Data
Community Area Shapefile:
Census Area Python Package Documentation:
https://census-area.readthedocs.io/en/latest/index.html
Organization: City of Chicago
Last updated: 2025-02-07T23:48:27.720757
Tags: census, community-area, federal, population
CREATE TABLE table_1 (
"acs_year" BIGINT,
"community_area" VARCHAR,
"under_25_000" BIGINT -- Under $25,000,
"n__25_000_to_49_999" BIGINT -- $25,000 To $49,999,
"n__50_000_to_74_999" BIGINT -- $50,000 To $74,999,
"n__75_000_to_125_000" BIGINT -- $75,000 To $125,000,
"n__125_000" BIGINT -- $125,000 +,
"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 -- Male 65+,
"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 -- Female 65 +,
"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.