cityofchicago/chicago-population-counts-85cm-7uqa
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 year ago
Indexed 4 hours ago

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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofchicago/chicago-population-counts-85cm-7uqa\".\"chicago_population_counts\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • chicago_population_counts
     
     
     
     
     
Upstream Metadata