Budget Survey 2021 by US Government | Demographics and Population Studies

About this Dataset

Budget Survey 2021

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

For the $1000 Assignment columns, negative and blank values have been converted to $0 if any question is this series was answered. If the total allocated was above or below $1000, all values have been adjusted proportionally to bring the total to $1000.

For more information on the 2021 budget, including the survey, please see https://chicago.gov/2021budget.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:58.106674
Tags: 2021, budget, survey

Tables

Table 1

@usgov.city_of_chicago_budget_survey_2021.table_1

876.31 KB
38336 rows
56 columns


CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "zip_code" VARCHAR,
  "n__1000_assignment_police" DOUBLE,
  "n__1000_assignment_other_public_safety" DOUBLE,
  "n__1000_assignment_infrastructure_services" DOUBLE,
  "n__1000_assignment_public_health" DOUBLE,
  "n__1000_assignment_community" DOUBLE,
  "n__1000_assignment_streets_and_sanitation" DOUBLE,
  "n__1000_assignment_city_development" DOUBLE,
  "n__1000_assignment_libraries" DOUBLE,
  "n__1000_assignment_regulatory" DOUBLE,
  "n__1000_assignment_cultural_affairs_and_special_events" DOUBLE,
  "rank_police" DOUBLE,
  "rank_other_public_safety" DOUBLE,
  "rank_infrastructure" DOUBLE,
  "rank_public_health" DOUBLE,
  "rank_community" DOUBLE,
  "rank_streets_and_sanitation" DOUBLE,
  "rank_city_development" DOUBLE,
  "rank_libraries" DOUBLE,
  "rank_regulatory" DOUBLE,
  "rank_cultural_affairs_and_special_events" DOUBLE,
  "additional_resources_police" BOOLEAN,
  "additional_resources_other_public_safety" BOOLEAN,
  "additional_resources_infrastructure_services" BOOLEAN,
  "additional_resources_public_health" BOOLEAN,
  "additional_resources_community" BOOLEAN,
  "additional_resources_streets_and_sanitation" BOOLEAN,
  "additional_resources_city_development" BOOLEAN,
  "additional_resources_libraries" BOOLEAN,
  "additional_resources_regulatory" BOOLEAN,
  "additional_resources_cultural_affairs_and_special_events" BOOLEAN,
  "additional_resources_type" BOOLEAN,
  "additional_resources_source_reallocate_existing_funding" BOOLEAN,
  "additional_resources_source_increase_revenue" BOOLEAN,
  "additional_resources_source_other" BOOLEAN,
  "reallocate_from_police" BOOLEAN,
  "reallocate_from_other_public_safety" BOOLEAN,
  "reallocate_from_infrastructure_services" BOOLEAN,
  "reallocate_from_public_health" BOOLEAN,
  "reallocate_from_community" BOOLEAN,
  "reallocate_from_streets_and_sanitation" BOOLEAN,
  "reallocate_from_city_development" BOOLEAN,
  "reallocate_from_libraries" BOOLEAN,
  "reallocate_from_regulatory" BOOLEAN,
  "reallocate_from_cultural_affairs_and_special_events" BOOLEAN,
  "reallocate_from_none" BOOLEAN,
  "increase_revenue_increase_sales_tax" BOOLEAN,
  "increase_revenue_property_tax" BOOLEAN,
  "increase_revenue_garbage_fee" BOOLEAN,
  "increase_revenue_expand_sales_tax" BOOLEAN,
  "increase_revenue_fuel_tax" BOOLEAN,
  "increase_revenue_none" BOOLEAN,
  "increase_revenue_other" BOOLEAN,
  "open_ended_response" BOOLEAN,
  "counter_column" BIGINT
);