City Budget and Actual Expenditures

mydata.iowa.gov | Last Updated 7 Jun 2019

The budget and actual expenditures self-reported by each city via their yearly budget forms filed with the Department of Management. Actual expenditure data lags budget expenditures by a couple of fiscal years.

Tags: city, budget, actual

This dataset has the following 34 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Fiscal Yearfiscal_yeartextFiscal year is represented by the final calendar year of the fiscal year. Example: FY 2006-2007 - 2007. Fiscal years run from July 1st to June 30th.
County Codecounty_codenumberInternal use code denoting the county in which the city (or majority of the city) resides.
CountycountytextName of the county in which the city (or majority of the city) resides.
GNIS Feature IDgnis_feature_idtext
City FIPScity_fipstext
City Codecity_codetextInternal use code for tracking individual city data.
City Namecity_nametext
Public Safety Budgetpublic_safety_budgetnumberBudgeted expenditure total of all public safety functions of the city during the budget fiscal year.
Public Works Budgetpublic_works_budgetnumberBudgeted expenditure total of all public works functions of the city during the budget fiscal year.
Health and Social Services Budgethealth_and_social_services_budgetnumberBudgeted expenditure total of all public heath and social service functions of the city during the budget fiscal year.
Culture and Recreation Budgetculture_and_recreation_budgetnumberBudgeted expenditure total of all recreation or culture-focused functions of the city during the budget fiscal year.
Community and Economic Development Budgetcommunity_and_economic_development_budgetnumberBudgeted expenditure total of all economic or community improvement functions of the city during the budget fiscal year.
General Government Budgetgeneral_government_budgetnumberBudgeted expenditure total of general administrative functions of the city during the budget fiscal year.
Debt Service Budgetdebt_service_budgetnumberBudgeted expenditure total of all payments to outstanding debts of the city during the budget fiscal year.
Capital Projects Budgetcapital_projects_budgetnumberBudgeted expenditure total of all higher cost, non-yearly project work of the city during the budget fiscal year.
Business Type / Enterprise Budgetbusiness_type_enterprise_budgetnumberBudgeted expenditure total of all fee-supported programs during the budget fiscal year. Examples: Water/Sewer/Gas/Electric/Telecom utilities, Parking systems, etc...
Transfers Out Total Budgettransfers_out_total_budgetnumberTotal of all budgeted fund to fund transfers for the year. This expenditure total does not leave the city.
Total Expenditures Budgettotal_budgetnumberTotal of all budgeted expenditures and internal transfers for the budget fiscal year.
Public Safety Actualpublic_safety_actualnumberActual total of all public safety expenditures of the city during the fiscal year. Self reported by the city at year end.
Public Works Actualpublic_works_actualnumberActual total of all public works expenditures of the city during the fiscal year. Self reported by the city at year end.
Health and Social Services Actualhealth_and_social_services_actualnumberActual total of all public health and social service expenditures of the city during the fiscal year. Self reported by the city at year end.
Culture and Recreation Actualculture_and_recreation_actualnumberActual total of all recreation and cultural purpose expenditures of the city during the fiscal year. Self reported by the city at year end.
Community and Economic Development Actualcommunity_and_economic_development_actualnumberActual total of all economic and community improvement expenditures of the city during the fiscal year. Self reported by the city at year end.
General Government Actualgeneral_government_actualnumberActual total of all general administration expenditures of the city during the fiscal year. Self reported by the city at year end.
Debt Service Actualdebt_service_actualnumberActual total of all expenditures toward paying the outstanding debts of the city during the fiscal year. Self reported by the city at year end.
Capital Projects Actualcapital_projects_actualnumberActual total of all expenditures toward higher cost, non-yearly projects of the city during the fiscal year. Self reported by the city at year end.
Business Type / Enterprise Actualbusiness_type_enterprise_actualnumberActual total of all expenditures toward fee-supported programs of the city during the fiscal year. Self reported by the city at year end.
Transfers Out Totaltransfers_out_totalnumberActual total of all internal transfers of funds in the city during the fiscal year. Self reported by the city at year end.
Total Actualtotal_actualnumberTotal actual expenditures and internal transfers of the city during the fiscal year. Self-reported by the city at fiscal year end.
Primary City Coordinatesprimary_city_coordinatespoint
Primary City Coordinates (address)primary_city_coordinates_addresstext
Primary City Coordinates (city)primary_city_coordinates_citytext
Primary City Coordinates (state)primary_city_coordinates_statetext
Primary City Coordinates (zip)primary_city_coordinates_ziptext