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

897.34 kB
38,336 rows
56 columns

CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "zip_code" VARCHAR,
  "n__1000_assignment_police" DOUBLE  -- $1000 Assignment - Police,
  "n__1000_assignment_other_public_safety" DOUBLE  -- $1000 Assignment - Other Public Safety,
  "n__1000_assignment_infrastructure_services" DOUBLE  -- $1000 Assignment - Infrastructure Services,
  "n__1000_assignment_public_health" DOUBLE  -- $1000 Assignment - Public Health,
  "n__1000_assignment_community" DOUBLE  -- $1000 Assignment - Community,
  "n__1000_assignment_streets_and_sanitation" DOUBLE  -- $1000 Assignment - Streets And Sanitation,
  "n__1000_assignment_city_development" DOUBLE  -- $1000 Assignment - City Development,
  "n__1000_assignment_libraries" DOUBLE  -- $1000 Assignment - Libraries,
  "n__1000_assignment_regulatory" DOUBLE  -- $1000 Assignment - Regulatory,
  "n__1000_assignment_cultural_affairs_and_special_events" DOUBLE  -- $1000 Assignment - Cultural Affairs And Special Events,
  "rank_police" DOUBLE  -- Rank - Police,
  "rank_other_public_safety" DOUBLE  -- Rank - Other Public Safety,
  "rank_infrastructure" DOUBLE  -- Rank - Infrastructure,
  "rank_public_health" DOUBLE  -- Rank - Public Health,
  "rank_community" DOUBLE  -- Rank - Community,
  "rank_streets_and_sanitation" DOUBLE  -- Rank - Streets And Sanitation,
  "rank_city_development" DOUBLE  -- Rank - City Development,
  "rank_libraries" DOUBLE  -- Rank - Libraries,
  "rank_regulatory" DOUBLE  -- Rank - Regulatory,
  "rank_cultural_affairs_and_special_events" DOUBLE  -- Rank - Cultural Affairs And Special Events,
  "additional_resources_police" BOOLEAN  -- Additional Resources - Police,
  "additional_resources_other_public_safety" BOOLEAN  -- Additional Resources - Other Public Safety,
  "additional_resources_infrastructure_services" BOOLEAN  -- Additional Resources - Infrastructure Services,
  "additional_resources_public_health" BOOLEAN  -- Additional Resources - Public Health,
  "additional_resources_community" BOOLEAN  -- Additional Resources - Community,
  "additional_resources_streets_and_sanitation" BOOLEAN  -- Additional Resources - Streets And Sanitation,
  "additional_resources_city_development" BOOLEAN  -- Additional Resources - City Development,
  "additional_resources_libraries" BOOLEAN  -- Additional Resources - Libraries,
  "additional_resources_regulatory" BOOLEAN  -- Additional Resources - Regulatory,
  "additional_resources_cultural_affairs_and_special_events" BOOLEAN  -- Additional Resources - Cultural Affairs And Special Events,
  "additional_resources_type" BOOLEAN  -- Additional Resources - Type,
  "additional_resources_source_reallocate_existing_funding" BOOLEAN  -- Additional Resources Source - Reallocate Existing Funding,
  "additional_resources_source_increase_revenue" BOOLEAN  -- Additional Resources Source - Increase Revenue,
  "additional_resources_source_other" BOOLEAN  -- Additional Resources Source - Other,
  "reallocate_from_police" BOOLEAN  -- Reallocate From - Police,
  "reallocate_from_other_public_safety" BOOLEAN  -- Reallocate From - Other Public Safety,
  "reallocate_from_infrastructure_services" BOOLEAN  -- Reallocate From - Infrastructure Services,
  "reallocate_from_public_health" BOOLEAN  -- Reallocate From - Public Health,
  "reallocate_from_community" BOOLEAN  -- Reallocate From - Community,
  "reallocate_from_streets_and_sanitation" BOOLEAN  -- Reallocate From - Streets And Sanitation,
  "reallocate_from_city_development" BOOLEAN  -- Reallocate From - City Development,
  "reallocate_from_libraries" BOOLEAN  -- Reallocate From - Libraries,
  "reallocate_from_regulatory" BOOLEAN  -- Reallocate From - Regulatory,
  "reallocate_from_cultural_affairs_and_special_events" BOOLEAN  -- Reallocate From - Cultural Affairs And Special Events,
  "reallocate_from_none" BOOLEAN  -- Reallocate From - None,
  "increase_revenue_increase_sales_tax" BOOLEAN  -- Increase Revenue - Increase Sales Tax,
  "increase_revenue_property_tax" BOOLEAN  -- Increase Revenue - Property Tax,
  "increase_revenue_garbage_fee" BOOLEAN  -- Increase Revenue - Garbage Fee,
  "increase_revenue_expand_sales_tax" BOOLEAN  -- Increase Revenue - Expand Sales Tax,
  "increase_revenue_fuel_tax" BOOLEAN  -- Increase Revenue - Fuel Tax,
  "increase_revenue_none" BOOLEAN  -- Increase Revenue - None,
  "increase_revenue_other" BOOLEAN  -- Increase Revenue - Other,
  "open_ended_response" BOOLEAN,
  "counter_column" BIGINT
);