Budget Survey 2020 by US Government | Demographics and Population Studies

About this Dataset

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 https://www.chicago.gov/city/en/depts/obm/supp_info/budgetdocuments/2020_Budget.html.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:48.669231
Tags: 2020, budget, survey

Tables

Table 1

@usgov.city_of_chicago_budget_survey_2020.table_1

173.91 KB
7347 rows
55 columns


CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "zip_code" DOUBLE,
  "revenue_interest_garage_parking_tax" BOOLEAN,
  "revenue_interest_ridesharing_tax" BOOLEAN,
  "revenue_interest_alcohol_tax" BOOLEAN,
  "revenue_interest_tax_on_sports_theater_other_entertainment" BOOLEAN,
  "revenue_interest_cigarette_tax" BOOLEAN,
  "revenue_interest_hotel_tax" BOOLEAN,
  "revenue_interest_shopping_bag_tax" BOOLEAN,
  "revenue_interest_property_tax" BOOLEAN,
  "revenue_interest_sales_tax" BOOLEAN,
  "revenue_interest_permit_fees" BOOLEAN,
  "revenue_interest_license_fees" BOOLEAN,
  "revenue_interest_other" BOOLEAN,
  "expense_interest_police" BOOLEAN,
  "expense_interest_other_public_safety" BOOLEAN,
  "expense_interest_infrastructure" BOOLEAN,
  "expense_interest_community" BOOLEAN,
  "expense_interest_streets_and_sanitation" BOOLEAN,
  "expense_interest_city_development" BOOLEAN,
  "expense_interest_libraries" BOOLEAN,
  "expense_interest_regulatory" BOOLEAN,
  "expense_interest_cultural_affairs_and_special_events" BOOLEAN,
  "expense_interest_other" BOOLEAN,
  "spending_change_police" VARCHAR,
  "spending_change_other_public_safety" VARCHAR,
  "spending_change_infrastructure" VARCHAR,
  "spending_change_community" VARCHAR,
  "spending_change_streets_and_sanitation" VARCHAR,
  "spending_change_city_development" VARCHAR,
  "spending_change_libraries" VARCHAR,
  "spending_change_regulatory" VARCHAR,
  "spending_change_cultural_affairs_and_special_events" VARCHAR,
  "revenue_change_garage_parking_tax" VARCHAR,
  "revenue_change_ridesharing_tax" VARCHAR,
  "revenue_change_alcohol_tax" VARCHAR,
  "revenue_change_tax_on_sports_theater_other_entertainment" VARCHAR,
  "revenue_change_cigarette_tax" VARCHAR,
  "revenue_change_hotel_tax" VARCHAR,
  "revenue_change_shopping_bag_tax" VARCHAR,
  "revenue_change_property_tax" VARCHAR,
  "revenue_change_sales_tax" VARCHAR,
  "revenue_change_permit_fees" VARCHAR,
  "revenue_change_license_fees" VARCHAR,
  "n__1000_assignment_police" DOUBLE,
  "n__1000_assignment_other_public_safety" DOUBLE,
  "n__1000_assignment_infrastructure_services" 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,
  "n__1000_assignment_total" BIGINT,
  "counter_column" BIGINT
);