Icon for Socrata external plugin
Open repository in Console
Updated 10 months ago
Indexed 2 hours ago

Budget Survey 2020

As part of the preparation process for the 2020 City of Chicago budget, the City conducted a public survey. The final results are shown in this dataset.

For the $1000 Assignment columns, negative values have been converted to blanks and totals above $1000 (after converting negatives to blanks) have been converted to $1000, with all of the component values adjusted accordingly, to retain their relative proportions. Totals below $1000 were not adjusted up because the survey specifically allowed for not allocating the full amount.

For more information on the 2020 budget, including the survey, please see

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofchicago/budget-survey-2020-drbg-ny73\".\"budget_survey_2020\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • budget_survey_2020
Upstream Metadata