Readme
Updated 20 days 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 https://www.chicago.gov/city/en/depts/obm/supp_info/budgetdocuments/2020_Budget.html.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Revenue Interest - Cigarette Tax | revenue_interest_cigarette_tax | revenue_interest_cigarette_tax | Checkbox | Whether the respondent reported interest in information on this topic. |
| Revenue Interest - Hotel Tax | revenue_interest_hotel_tax | revenue_interest_hotel_tax | Checkbox | Whether the respondent reported interest in information on this topic. |
| Revenue Interest - Shopping Bag Tax | revenue_interest_shopping_bag_tax | revenue_interest_shopping_bag_tax | Checkbox | Whether the respondent reported interest in information on this topic. |
| Expense Interest - Police | expense_interest_police | expense_interest_police | Checkbox | Whether the respondent reported interest in information on this topic. |
| Spending Change - Other Public Safety | spending_change_other_public_safety | spending_change_other_public_safety | Text | Answer for this area to the question: "Which areas of spending would you consider reducing, increasing or remaining the same in order to balance the City’s budget? " |
| Spending Change - Community | spending_change_community | spending_change_community | Text | Answer for this area to the question: "Which areas of spending would you consider reducing, increasing or remaining the same in order to balance the City’s budget? " |
| Spending Change - Streets and Sanitation | spending_change_streets_and_sanitation | spending_change_streets_and_sanitation | Text | Answer for this area to the question: "Which areas of spending would you consider reducing, increasing or remaining the same in order to balance the City’s budget? " |
| Spending Change - City Development | spending_change_city_development | spending_change_city_development | Text | Answer for this area to the question: "Which areas of spending would you consider reducing, increasing or remaining the same in order to balance the City’s budget? " |
| Spending Change - Libraries | spending_change_libraries | spending_change_libraries | Text | Answer for this area to the question: "Which areas of spending would you consider reducing, increasing or remaining the same in order to balance the City’s budget? " |
| Revenue Change - Garage Parking Tax | revenue_change_garage_parking_tax | revenue_change_garage_parking_tax | Text | Answer for this potential revenue source to the question: "Which revenues would you consider increasing or keeping the same in order to balance the City’s budget? " |
| Revenue Change - Ridesharing Tax | revenue_change_ridesharing_tax | revenue_change_ridesharing_tax | Text | Answer for this potential revenue source to the question: "Which revenues would you consider increasing or keeping the same in order to balance the City’s budget? " |
| Revenue Change - Tax on Sports, Theater, Other Entertainment | revenue_change_tax_on_sports_theater_other_entertainment | revenue_change_tax_on_sports_theater_other_entertainment | Text | Answer for this potential revenue source to the question: "Which revenues would you consider increasing or keeping the same in order to balance the City’s budget? " |
| Revenue Change - Sales Tax | revenue_change_sales_tax | revenue_change_sales_tax | Text | Answer for this potential revenue source to the question: "Which revenues would you consider increasing or keeping the same in order to balance the City’s budget? " |
| Revenue Change - Permit Fees | revenue_change_permit_fees | revenue_change_permit_fees | Text | Answer for this potential revenue source to the question: "Which revenues would you consider increasing or keeping the same in order to balance the City’s budget? " |
| ZIP Code | zip_code | zip_code | Text | The respondent's reported home ZIP Code. |
| $1000 Assignment - Cultural Affairs and Special Events | _1000_assignment_cultural_affairs_and_special_events | _1000_assignment_cultural_affairs_and_special_events | Number | Amount of a hypothetical $1000 allocated to this area. Negative values have been converted to blanks. Totals above $1000 have been adjusted proportionally to reduce the total to $1000. |
| Revenue Interest - Alcohol Tax | revenue_interest_alcohol_tax | revenue_interest_alcohol_tax | Checkbox | Whether the respondent reported interest in information on this topic. |
| Revenue Interest - Garage Parking Tax | revenue_interest_garage_parking_tax | revenue_interest_garage_parking_tax | Checkbox | Whether the respondent reported interest in information on this topic. |
| Revenue Interest - Property Tax | revenue_interest_property_tax | revenue_interest_property_tax | Checkbox | Whether the respondent reported interest in information on this topic. |
| Expense Interest - Streets and Sanitation | expense_interest_streets_and_sanitation | expense_interest_streets_and_sanitation | Checkbox | Whether the respondent reported interest in information on this topic. |
| Expense Interest - Other | expense_interest_other | expense_interest_other | Checkbox | Whether the respondent reported interest in information on this topic. |
| Spending Change - Police | spending_change_police | spending_change_police | Text | Answer for this area to the question: "Which areas of spending would you consider reducing, increasing or remaining the same in order to balance the City’s budget? " |
| Revenue Change - Cigarette Tax | revenue_change_cigarette_tax | revenue_change_cigarette_tax | Text | Answer for this potential revenue source to the question: "Which revenues would you consider increasing or keeping the same in order to balance the City’s budget? " |
| Expense Interest - Other Public Safety | expense_interest_other_public_safety | expense_interest_other_public_safety | Checkbox | Whether the respondent reported interest in information on this topic. |
| $1000 Assignment - Police | _1000_assignment_police | _1000_assignment_police | Number | Amount of a hypothetical $1000 allocated to this area. Negative values have been converted to blanks. Totals above $1000 have been adjusted proportionally to reduce the total to $1000. |
| Expense Interest - Community | expense_interest_community | expense_interest_community | Checkbox | Whether the respondent reported interest in information on this topic. |
| Revenue Interest - Other | revenue_interest_other | revenue_interest_other | Checkbox | Whether the respondent reported interest in information on this topic. |
| Revenue Change - License Fees | revenue_change_license_fees | revenue_change_license_fees | Text | Answer for this potential revenue source to the question: "Which revenues would you consider increasing or keeping the same in order to balance the City’s budget? " |
| Revenue Change - Property Tax | revenue_change_property_tax | revenue_change_property_tax | Text | Answer for this potential revenue source to the question: "Which revenues would you consider increasing or keeping the same in order to balance the City’s budget? " |
| Expense Interest - Libraries | expense_interest_libraries | expense_interest_libraries | Checkbox | Whether the respondent reported interest in information on this topic. |
| Revenue Interest - Sales Tax | revenue_interest_sales_tax | revenue_interest_sales_tax | Checkbox | Whether the respondent reported interest in information on this topic. |
| Revenue Interest - Permit Fees | revenue_interest_permit_fees | revenue_interest_permit_fees | Checkbox | Whether the respondent reported interest in information on this topic. |
| Spending Change - Infrastructure | spending_change_infrastructure | spending_change_infrastructure | Text | Answer for this area to the question: "Which areas of spending would you consider reducing, increasing or remaining the same in order to balance the City’s budget? " |
| Spending Change - Regulatory | spending_change_regulatory | spending_change_regulatory | Text | Answer for this area to the question: "Which areas of spending would you consider reducing, increasing or remaining the same in order to balance the City’s budget? " |
| Revenue Interest - Ridesharing Tax | revenue_interest_ridesharing_tax | revenue_interest_ridesharing_tax | Checkbox | Whether the respondent reported interest in information on this topic. |
| Revenue Interest - Tax on Sports, Theater, Other Entertainment | revenue_interest_tax_on_sports_theater_other_entertainment | revenue_interest_tax_on_sports_theater_other_entertainment | Checkbox | Whether the respondent reported interest in information on this topic. |
| Date | date | date | Calendar date | The date on which the respondent completed the survey. |
| Expense Interest - City Development | expense_interest_city_development | expense_interest_city_development | Checkbox | Whether the respondent reported interest in information on this topic. |
| $1000 Assignment - Community | _1000_assignment_community | _1000_assignment_community | Number | Amount of a hypothetical $1000 allocated to this area. Negative values have been converted to blanks. Totals above $1000 have been adjusted proportionally to reduce the total to $1000. |
| Expense Interest - Cultural Affairs and Special Events | expense_interest_cultural_affairs_and_special_events | expense_interest_cultural_affairs_and_special_events | Checkbox | Whether the respondent reported interest in information on this topic. |
| $1000 Assignment - Total | _1000_assignment_total | _1000_assignment_total | Number | Total of the previous columns, after accounting for the adjustments. |
| Counter Column | counter_column | counter_column | Number | This is an additional column, set to 1 for all records, to allow for certain types of charts and aggregations. |
| Spending Change - Cultural Affairs and Special Events | spending_change_cultural_affairs_and_special_events | spending_change_cultural_affairs_and_special_events | Text | Answer for this area to the question: "Which areas of spending would you consider reducing, increasing or remaining the same in order to balance the City’s budget? " |
| Expense Interest - Regulatory | expense_interest_regulatory | expense_interest_regulatory | Checkbox | Whether the respondent reported interest in information on this topic. |
| Expense Interest - Infrastructure | expense_interest_infrastructure | expense_interest_infrastructure | Checkbox | Whether the respondent reported interest in information on this topic. |
| Revenue Change - Hotel Tax | revenue_change_hotel_tax | revenue_change_hotel_tax | Text | Answer for this potential revenue source to the question: "Which revenues would you consider increasing or keeping the same in order to balance the City’s budget? " |
| Revenue Interest - License Fees | revenue_interest_license_fees | revenue_interest_license_fees | Checkbox | Whether the respondent reported interest in information on this topic. |
| Revenue Change - Alcohol Tax | revenue_change_alcohol_tax | revenue_change_alcohol_tax | Text | Answer for this potential revenue source to the question: "Which revenues would you consider increasing or keeping the same in order to balance the City’s budget? " |
| $1000 Assignment - Libraries | _1000_assignment_libraries | _1000_assignment_libraries | Number | Amount of a hypothetical $1000 allocated to this area. Negative values have been converted to blanks. Totals above $1000 have been adjusted proportionally to reduce the total to $1000. |
| Revenue Change - Shopping Bag Tax | revenue_change_shopping_bag_tax | revenue_change_shopping_bag_tax | Text | Answer for this potential revenue source to the question: "Which revenues would you consider increasing or keeping the same in order to balance the City’s budget? " |
| $1000 Assignment - City Development | _1000_assignment_city_development | _1000_assignment_city_development | Number | Amount of a hypothetical $1000 allocated to this area. Negative values have been converted to blanks. Totals above $1000 have been adjusted proportionally to reduce the total to $1000. |
| $1000 Assignment - Other Public Safety | _1000_assignment_other_public_safety | _1000_assignment_other_public_safety | Number | Amount of a hypothetical $1000 allocated to this area. Negative values have been converted to blanks. Totals above $1000 have been adjusted proportionally to reduce the total to $1000. |
| $1000 Assignment - Infrastructure Services | _1000_assignment_infrastructure_services | _1000_assignment_infrastructure_services | Number | Amount of a hypothetical $1000 allocated to this area. Negative values have been converted to blanks. Totals above $1000 have been adjusted proportionally to reduce the total to $1000. |
| $1000 Assignment - Streets and Sanitation | _1000_assignment_streets_and_sanitation | _1000_assignment_streets_and_sanitation | Number | Amount of a hypothetical $1000 allocated to this area. Negative values have been converted to blanks. Totals above $1000 have been adjusted proportionally to reduce the total to $1000. |
| $1000 Assignment - Regulatory | _1000_assignment_regulatory | _1000_assignment_regulatory | Number | Amount of a hypothetical $1000 allocated to this area. Negative values have been converted to blanks. Totals above $1000 have been adjusted proportionally to reduce the total to $1000. |
Upstream Metadata