Chicago Population Counts
City of Chicago
@usgov.city_of_chicago_chicago_population_counts
City of Chicago
@usgov.city_of_chicago_chicago_population_counts
Population totals for groupings commonly used in other datasets. Not all values are available for all years. Note that because the "Citywide" rows roll up the values from the individual ZIP Codes and the "Age 0-4," "Age 5-11," "Age 12-17," "Age 5+," "Age 18+," and "Age 65+" columns overlap other age categories, as well as each other in some cases, care should be taken in summing values to avoid accidental double-counting. The "Age 5-11" and "Age 12-17" columns only include children who live in households. Data Sources: U.S. Census Bureau American Community Survey (ACS) 5-year estimates (ZIP Code) and 1-year estimates (Citywide). The U.S. Census Bureau did not release standard 1-year estimates from the 2020 ACS. In 2020 only, 5-year estimates were used for the Citywide estimates.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:32.296191
Tags: census, federal, link-to-article-present, population
CREATE TABLE table_1 (
"geography_type" VARCHAR,
"year" BIGINT,
"geography" VARCHAR,
"population_total" BIGINT -- Population - Total,
"population_age_0_17" BIGINT -- Population - Age 0-17,
"population_age_18_29" BIGINT -- Population - Age 18-29,
"population_age_30_39" BIGINT -- Population - Age 30-39,
"population_age_40_49" BIGINT -- Population - Age 40-49,
"population_age_50_59" BIGINT -- Population - Age 50-59,
"population_age_60_69" BIGINT -- Population - Age 60-69,
"population_age_70_79" BIGINT -- Population - Age 70-79,
"population_age_80" BIGINT -- Population - Age 80+,
"population_age_0_4" BIGINT -- Population - Age 0-4,
"population_age_5_11" DOUBLE -- Population - Age 5-11,
"population_age_12_17" DOUBLE -- Population - Age 12-17,
"population_age_5" BIGINT -- Population - Age 5+,
"population_age_18" BIGINT -- Population - Age 18+,
"population_age_65" BIGINT -- Population - Age 65+,
"population_female" BIGINT -- Population - Female,
"population_male" BIGINT -- Population - Male,
"population_latinx" BIGINT -- Population - Latinx,
"population_asian_non_latinx" DOUBLE -- Population - Asian Non-Latinx,
"population_black_non_latinx" DOUBLE -- Population - Black Non-Latinx,
"population_white_non_latinx" BIGINT -- Population - White Non-Latinx,
"population_other_race_non_latinx" DOUBLE -- Population - Other Race Non-Latinx,
"record_id" VARCHAR
);Anyone who has the link will be able to view this.