County Budgeted Expenditures By Service Area By Fiscal Year
mydata.iowa.gov | Last Updated 30 Aug 2023This dataset provides budgeted expenditures for the counties within the State of Iowa beginning with FY 2005 (fiscal year ending 6/30/2005).
This dataset has the following 22 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Unique Line ID | unique_line_id | text | Unique code identifier for the line of data within the dataset. | view top 100 |
| Fiscal Year Ending | fiscal_year_ending | text | Fiscal year budgeted expenditures are associated with. Fiscal year runs from July 1 through June 30 and is labeled for the year it ends. | 2013 2014 2016 2015 2011 view top 100 |
| County | county | number | Iowa county code (1-99) associated with the county the budgeted expenditures are related to. | 8 33 70 19 55 view top 100 |
| County Name | county_name | text | Name of county the budgeted expenditures are related to. | Des Moines Davis Louisa Warren Jefferson view top 100 |
| Public Safety & Legal Services | public_safety_legal_services | number | Budgeted expenditures for Law Enforcement, Legal Services, Emergency Services, Assistance to District Court System, Court Proceedings, and Juvenile Justice Administration. | 2432752 4076444 1637291 3879456 4620762 view top 100 |
| Physical Health & Social Services | physical_health_social_services | number | Budgeted expenditures for Physical Health Services, Services to the Poor, Services to Military Veterans, Children 's and Family Services, Services to Other Adults, and the Chemical Dependency Program. | 1698439 538297 559609 6236276 2310834 view top 100 |
| Mental Health MR, DD | mental_health_mr_dd | number | Budgeted expenditures for Services to Persons with Mental Illness, Persons with Chronic Mental Illness, Persons with Intellectual Disability, and Persons with Other Developmental Disabilities | 1298380 877000 1549000 1699500 495156 view top 100 |
| County Environment & Education | co_environment_education | number | Budgeted expenditures for Environmental Quality, Conservation and Recreational Services, Animal Control, Educational Services and County Development. | 366383 699926 3941075 1521000 936997 view top 100 |
| Roads & Transportation | roads_transportation | number | Budgeted expenditures for Secondary Roads Administration and Engineering, Roadway maintenance, General Roadway Expenditures, and Mass Transit. | 4595000 4380000 4575000 2184800 4298000 view top 100 |
| Government Services to Residents | government_services_to_residents | number | Budgeted expenditures for Representation Services (e.g. election administration, local elections) and State Administrative Services (e.g. motor vehicle registrations, driver license services, recording of public documents) | 2402067 304140 488164 1107747 515208 view top 100 |
| Administration | administration | number | Budgeted expenditures for Policy & Administration, Central Services, and Risk Management Services. | 1453313 1764749 1866518 1308532 2351413 view top 100 |
| Nonprogram Current | nonprogram_current | number | This includes refunds of amounts recorded as revenues in prior years, pass-through grants, and budgeted expenditures related to county farm. | 0 20000 5000 10000 1000 view top 100 |
| Debt Service | debt_service | number | Budgeted expenditures related to general obligation bonds or other long-term debt | 0 8490 55000 15300 75000 view top 100 |
| Capital Projects | capital_projects | number | Budgeted expenditures related to roadway construction, county conservation land acquisition, and other capital improvement projects. | 400000 750000 200000 500000 775000 view top 100 |
| Sub-Total Expenditures | sub_total_expenditures | number | Sum of operating budgeted expenditures, including: public safety and legal services; physical health and social services; mental health, ID & DD; county environment and education; roads & transportation; government services to residents; administration; nonprogram current; debt service and capital projects. | 15708304 13602766 10070352 8187563 12764255 view top 100 |
| Operating Transfers Out | operating_transfers_out | number | Budgeted expenditures associated with loans from budgeted funds to other budgeted funds not repaid before the end of the fiscal year. | 1315000 1200000 1000000 1400000 1004000 view top 100 |
| Refunded Debt/Escrow | refunded_debt_escrow | number | Accounts for principal payments to refund debt and payments to escrow agents for defeased debt. | 0 195173 4203975 view top 100 |
| Total Expenditures | total_expenditures | number | Sum of Sub-Total Expenditures, Operating Transfers Out and Refunded Debt/Escrow. | 19041794 34340585 15071519 25095850 15524604 view top 100 |
| Increase (Decrease) in Reserves | increase_decrease_in_reserves | number | 0 922521 view top 100 | |
| Total Ending Fund Balance | total_ending_fund_balance | number | Ending fund balance as of June 30. | 8277545 9450024 2641037 2949979 3454904 view top 100 |
| Total Requirements | total_requirements | number | Sum of total expenditures, increase (decrease) in reserves and total ending fund balance. | 20795527 10595767 18774226 28785178 19247964 view top 100 |
| Primary County Coordinates | primary_county_coordinates | point | Primary latitude and longitude in decimal degrees for the county as provided by U.S. Geological Survey, 19810501, U.S. Geographic Names Information System (GNIS): U.S. Geological Survey, Reston, VA. | {"coordinates":[-91.34143280000002,42.8447493],"type":"Point"} {"coordinates":[-96.2102924,43.380497],"type":"Point"} {"coordinates":[-93.7862815,40.7376827],"type":"Point"} {"coordinates":[-95.62132670000001,41.0334523],"type":"Point"} {"coordinates":[-95.6248784,43.0837527],"type":"Point"} view top 100 |