Municipality Budget Item Breakdown

This dataset provides a detailed breakdown of budget allocations for small municipalities, including category, subcategory, financial amounts, approval status, responsible departments, and contact details. It is designed to support civic technology, fiscal transparency, and public accountability initiatives, enabling analysis of spending patterns and project implementation across local governments.

  • last updated 21 Aug 2025
  • by GoMask
The brief that made it

Civic tech platforms for visualizing and comparing municipal spending

Sample rows

preview · 8 of 200 rows · all 23 columns
budget_item_idstringapproval_statusstringallocated_amountfloatbudget_categorystringmunicipality_idstringmunicipality_namestringfiscal_yearintegerbudget_subcategorystringactual_spent_amountfloatcurrencystringapproval_datedateproject_start_datedateproject_end_datedateresponsible_departmentstringcontact_person_namestringcontact_person_emailstringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringaddress_countrystringlast_updateddatetimeitem_descriptionstring
BATCH1-001Approved320000InfrastructureMUNI-101Lakeview2023Roads315500.75USD2023-02-212023-03-012023-09-30EngineeringSamantha Brookssbrooks@lakeview.gov124 Main AveLakeviewIllinois60144USA2023-09-28T14:22:10Resurfacing main avenue and installing street lights
BATCH1-002Approved85000HealthMUNI-101Lakeview2024Clinic Upgrades67950.32USD2024-01-102024-02-152024-07-01Health ServicesMichael Tranmtran@lakeview.gov17 Wellness BlvdLakeviewIllinois60144USA2024-06-15T09:12:45Renovation of community health clinic
BATCH1-003Approved12000EducationMUNI-102Riverside2022School Supplies11820.5USD2022-03-152022-04-012022-06-10EducationLinda Garcialgarcia@riverside.gov413 School LaneRiversideMichigan49084USA2022-06-12T11:35:20Provision of textbooks and learning materials for elementary schools
BATCH1-004Approved210000AdministrationMUNI-103Cedar Grove2024Salaries210000USD2024-01-052024-01-062024-12-31Human ResourcesRichard Leerlee@cedargrove.gov85 Cedar RdCedar GroveWisconsin53013USA2024-04-02T16:48:33Annual salaries for administrative staff
BATCH1-005Approved130000Public WorksMUNI-104Springfield2023Waste Management127000USD2023-03-102023-03-202023-07-15SanitationAngela Whiteawhite@springfield.gov56 Main StSpringfieldOhio45506USA2023-07-20T08:22:05Procurement of new garbage trucks
BATCH1-006Approved95000InfrastructureMUNI-105Hillcrest2022Water Supply92000.5USD2022-02-122022-03-012022-09-30UtilitiesPaul Nicholspnichols@hillcrest.gov12 Water StHillcrestKentucky41056USA2022-09-28T13:05:11Expansion of water supply network in eastern district
BATCH1-007Approved18000EducationMUNI-106Meadowbrook2024Library Resources16700USD2024-02-052024-02-152024-04-30Library ServicesEmily Carterecarter@meadowbrook.gov2 Library RdMeadowbrookIndiana46001USA2024-05-01T10:29:00Acquisition of new books for municipal library
BATCH1-008Approved20000HealthMUNI-107Maplewood2023Vaccination Programs19850USD2023-01-182023-01-252023-06-15Health ServicesJoan Myersjmyers@maplewood.gov100 Pine StMaplewoodMinnesota55109USA2023-06-18T13:21:00COVID-19 vaccination outreach and supplies

What the 200 rows show

from the 200-row sample
  • 14,100median allocated_amount
  • 43address states
  • 13,725median actual_spent_amount
approval_status200 rows by value
0100200199Approved100%1Pending1%
allocated_amount200 rows, in bands of 50k
08517017020421120200k350kallocated_amount →

Median 14,100, from 2,100 to 320,000.

budget_category200 rows · 6 values
  1. Infrastructure41
  2. Public Works36
  3. Health34
  4. Education32
  5. Administration31
  6. Other26
23 columns by typefrom the column list below
  • string 16
  • integer 1
  • float 2
  • date 3
  • datetime 1

Columns

23 columns in three groups
blueprint · 23 columns
columntypedescriptionexample
Text 16 columns
budget_item_idstringUnique identifier for each budget item allocation recorduniqueBATCH1-001
municipality_idstringUnique identifier for the municipalityMUNI-101
municipality_namestringOfficial name of the municipalityLakeview
budget_categorystringHigh-level category of the budget item (e.g., Infrastructure, Public Works, Administration)6 valuesInfrastructure
budget_subcategorystringSpecific subcategory within the budget category (e.g., Roads, Water Supply, Salaries)optionalRoads
item_descriptionstringDetailed description of the budget item or projectPurchase of snow plows
currencystringCurrency code for the allocated and spent amounts (e.g., USD, EUR, ZAR)USD
approval_statusstringStatus of the budget item (e.g., Approved, Pending, Rejected)Approved · Pending · RejectedApproved
responsible_departmentstringMunicipal department responsible for the budget itemoptionalEngineering
contact_person_namestringName of the contact person for the budget itemoptionalSamantha Brooks
contact_person_emailstringEmail address of the contact person for the budget itemoptionalsbrooks@lakeview.gov
address_streetstringStreet address of the municipality officeoptional124 Main Ave
address_citystringCity where the municipality is locatedoptionalLakeview
address_statestringState or province where the municipality is locatedoptionalIllinois
address_postal_codestringPostal code of the municipality officeoptional60144
address_countrystringCountry where the municipality is locatedoptionalUSA
Numbers 3 columns
fiscal_yearintegerFiscal year for which the budget item is allocated (e.g., 2024)1,900 to 2,1002023
allocated_amountfloatAmount of money allocated for the budget item (local currency)0 or more320000
actual_spent_amountfloatActual amount spent on the budget item (local currency)0 or more · optional315500.75
Dates and times 4 columns
approval_datedateDate when the budget item was approvedoptional2023-02-21
project_start_datedatePlanned or actual start date of the budget item/projectoptional2023-03-01
project_end_datedatePlanned or actual end date of the budget item/projectoptional2023-09-30
last_updateddatetimeTimestamp when the record was last updated2023-09-28T14:22:10

Use it for

  • median allocat…14,100200 rowsmean allocated amount…29.8kApprov…50kPending

    A government dashboard

    Allocated_amount by approval_status and a breakdown of budget_category. Excel, Power BI or Tableau.

  • What pattern can you find in 200 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

    Believable budget items with municipality_id, municipality_name and fiscal_year to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 23 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows23 columns
Yours1,000 rows23 columnsaddress_street: UK only

blueprint · municipality-budget-item-breakdown

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 23 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each row covers a single budget item
  • Budget categorized by department
  • Allocation amounts in standardized currency
  • Fiscal year and quarter specified
  • Includes approval status
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
municipality-budget-item-breakdown

More in Government

Browse all
Also in GovernmentOpen Government Spending RecordsCivic Participation Event AttendanceLocal Government Feedback SurveyAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.