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

178.09 kB
7,347 rows
55 columns

CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "zip_code" DOUBLE,
  "revenue_interest_garage_parking_tax" BOOLEAN  -- Revenue Interest - Garage Parking Tax,
  "revenue_interest_ridesharing_tax" BOOLEAN  -- Revenue Interest - Ridesharing Tax,
  "revenue_interest_alcohol_tax" BOOLEAN  -- Revenue Interest - Alcohol Tax,
  "revenue_interest_tax_on_sports_theater_other_entertainment" BOOLEAN  -- Revenue Interest - Tax On Sports, Theater, Other Entertainment,
  "revenue_interest_cigarette_tax" BOOLEAN  -- Revenue Interest - Cigarette Tax,
  "revenue_interest_hotel_tax" BOOLEAN  -- Revenue Interest - Hotel Tax,
  "revenue_interest_shopping_bag_tax" BOOLEAN  -- Revenue Interest - Shopping Bag Tax,
  "revenue_interest_property_tax" BOOLEAN  -- Revenue Interest - Property Tax,
  "revenue_interest_sales_tax" BOOLEAN  -- Revenue Interest - Sales Tax,
  "revenue_interest_permit_fees" BOOLEAN  -- Revenue Interest - Permit Fees,
  "revenue_interest_license_fees" BOOLEAN  -- Revenue Interest - License Fees,
  "revenue_interest_other" BOOLEAN  -- Revenue Interest - Other,
  "expense_interest_police" BOOLEAN  -- Expense Interest - Police,
  "expense_interest_other_public_safety" BOOLEAN  -- Expense Interest - Other Public Safety,
  "expense_interest_infrastructure" BOOLEAN  -- Expense Interest - Infrastructure,
  "expense_interest_community" BOOLEAN  -- Expense Interest - Community,
  "expense_interest_streets_and_sanitation" BOOLEAN  -- Expense Interest - Streets And Sanitation,
  "expense_interest_city_development" BOOLEAN  -- Expense Interest - City Development,
  "expense_interest_libraries" BOOLEAN  -- Expense Interest - Libraries,
  "expense_interest_regulatory" BOOLEAN  -- Expense Interest - Regulatory,
  "expense_interest_cultural_affairs_and_special_events" BOOLEAN  -- Expense Interest - Cultural Affairs And Special Events,
  "expense_interest_other" BOOLEAN  -- Expense Interest - Other,
  "spending_change_police" VARCHAR  -- Spending Change - Police,
  "spending_change_other_public_safety" VARCHAR  -- Spending Change - Other Public Safety,
  "spending_change_infrastructure" VARCHAR  -- Spending Change - Infrastructure,
  "spending_change_community" VARCHAR  -- Spending Change - Community,
  "spending_change_streets_and_sanitation" VARCHAR  -- Spending Change - Streets And Sanitation,
  "spending_change_city_development" VARCHAR  -- Spending Change - City Development,
  "spending_change_libraries" VARCHAR  -- Spending Change - Libraries,
  "spending_change_regulatory" VARCHAR  -- Spending Change - Regulatory,
  "spending_change_cultural_affairs_and_special_events" VARCHAR  -- Spending Change - Cultural Affairs And Special Events,
  "revenue_change_garage_parking_tax" VARCHAR  -- Revenue Change - Garage Parking Tax,
  "revenue_change_ridesharing_tax" VARCHAR  -- Revenue Change - Ridesharing Tax,
  "revenue_change_alcohol_tax" VARCHAR  -- Revenue Change - Alcohol Tax,
  "revenue_change_tax_on_sports_theater_other_entertainment" VARCHAR  -- Revenue Change - Tax On Sports, Theater, Other Entertainment,
  "revenue_change_cigarette_tax" VARCHAR  -- Revenue Change - Cigarette Tax,
  "revenue_change_hotel_tax" VARCHAR  -- Revenue Change - Hotel Tax,
  "revenue_change_shopping_bag_tax" VARCHAR  -- Revenue Change - Shopping Bag Tax,
  "revenue_change_property_tax" VARCHAR  -- Revenue Change - Property Tax,
  "revenue_change_sales_tax" VARCHAR  -- Revenue Change - Sales Tax,
  "revenue_change_permit_fees" VARCHAR  -- Revenue Change - Permit Fees,
  "revenue_change_license_fees" VARCHAR  -- Revenue Change - License Fees,
  "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_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,
  "n__1000_assignment_total" BIGINT  -- $1000 Assignment - Total,
  "counter_column" BIGINT
);