Municipal Service Request Progress

This dataset provides a comprehensive record of digital municipal service requests, capturing submission details, status updates, departmental assignments, resolution outcomes, and citizen feedback. It enables municipalities and civic tech teams to analyze service delivery efficiency, identify operational bottlenecks, and prioritize improvements for better digital public service adoption.

  • last updated 29 Jan 2026
  • by GoMask
The brief that made it

Analyzing municipal service delivery efficiency and identifying process bottlenecks

Sample rows

preview · 8 of 120 rows · all 20 columns
request_idstringservice_typestringcitizen_feedback_ratingintegerpriority_levelstringcitizen_idstringsubmission_datetimedatetimerequest_statusstringstatus_update_datetimedatetimeresolution_datetimedatetimeassigned_departmentstringassigned_staff_idstringlocation_street_addressstringlocation_citystringlocation_statestringlocation_postal_codestringlocation_countrystringchannel_submittedstringrequest_descriptionstringresolution_notesstringcitizen_feedback_commentsstring
REQ000001pothole repairblankblankCIT1000012023-11-12T09:18:45submitted2023-11-12T09:18:45blankblankblank721 Forest AveDenverCO80205USAwebLarge pothole near intersection causing traffic delays.blankblank
REQ000002waste collection5highCIT1000022024-03-04T14:27:38resolved2024-03-06T10:15:152024-03-06T09:50:12SanitationSTAFF10262 Oak StRaleighNC27609USAmobile_appMissed garbage pickup on Monday, bins overflowing.Extra collection scheduled and completed.Fast and helpful response, thanks for resolving quickly.
REQ000003streetlight maintenanceblankmediumCIT1000032024-05-21T19:12:34in_progress2024-05-22T08:40:17blankElectricalSTAFF205420 Maple RdDallasTX75204USAphoneStreetlight in front of 420 Maple Rd flickering nightly.blankblank
REQ000004graffiti removal2highCIT1000042024-06-02T10:01:03closed2024-06-04T12:20:242024-06-04T09:55:00FacilitiesSTAFF30311 Sunset BlvdPhoenixAZ85016USAwebGraffiti on the playground wall needs cleaning.Wall cleaned; graffiti removed.The wall looks better but some residue remains.
REQ000005otherblankurgentCIT1000052024-06-07T16:45:29on_hold2024-06-08T13:33:30blankParks & RecreationblankblankPortlandOR97214USAotherblankblankblank
REQ000006pothole repair4highCIT1000062024-02-18T08:59:11resolved2024-02-19T15:21:102024-02-19T14:55:12Road MaintenanceSTAFF003680 Lincoln HwyCincinnatiOH45202USAwebDeep pothole on highway entry ramp, risk of tire damage.Ramp repaired and inspected for safety.Quick work, but would have liked more updates.
REQ000007waste collectionblankmediumCIT1000072024-04-15T12:22:41in_progress2024-04-15T16:02:19blankSanitationSTAFF11529 8th AveBostonMA02118USAmobile_appRecycling bin not emptied, request urgent collection.blankblank
REQ000008streetlight maintenanceblankblankCIT1000082024-05-30T21:14:32submitted2024-05-30T21:14:32blankblankblank200 Main StSan DiegoCA92101USAwebBroken lamppost at 200 Main St, unsafe at night.blankblank

What the 120 rows show

from the 120-row sample

Pothole repair (service type) stands out: mean citizen_feedback_rating is 4.3, against 3.2 for the rest.

  • 4median citizen_feedback_rating
  • 5assigned departments
  • 6request statuses
  • 6channel submitteds
Mean citizen_feedback_rating by service_type38 rows
0484.3pothol…11 rows4.5waste …8 rows3.6street…8 rows1.7graffi…9 rows3.0other2 rows
citizen_feedback_rating38 rows, in bands of 0.5
0612406070912135citizen_feedback_rating →

Median 4, from 1 to 5.

priority_level87 rows with a value · 33 left blank
  1. high32
  2. medium29
  3. low17
  4. urgent9
20 columns by typefrom the column list below
  • string 16
  • integer 1
  • datetime 3

Columns

20 columns in three groups
blueprint · 20 columns
columntypedescriptionexample
Text 16 columns
request_idstringUnique identifier for the service requestuniqueREQ000001
citizen_idstringAnonymized unique identifier for the citizen submitting the requestCIT100001
service_typestringCategory or type of municipal service requested (e.g., pothole repair, waste collection)5 valuespothole repair
request_descriptionstringDetailed description of the issue or service requestedoptionalLarge pothole near inters…
request_statusstringCurrent status of the service request6 valuessubmitted
resolution_notesstringNotes or comments about how the request was resolvedoptionalExtra collection schedule…
priority_levelstringPriority assigned to the requestlow · medium · high · urgent · optionalhigh
assigned_departmentstringMunicipal department responsible for handling the request5 departments · optionalSanitation
assigned_staff_idstringUnique identifier for the staff member assigned to the requestoptionalSTAFF102
location_street_addressstringStreet address where the service is requestedoptional721 Forest Ave
location_citystringCity where the service is requestedoptionalDenver
location_statestringState or province where the service is requestedoptionalCO
location_postal_codestringPostal code for the service locationoptional80205
location_countrystringCountry where the service is requestedoptionalUSA
channel_submittedstringChannel through which the request was submitted (e.g., web, mobile app, phone, in person)6 valuesweb
citizen_feedback_commentsstringAdditional comments provided by the citizen after resolutionoptionalFast and helpful response…
Numbers 1 column
citizen_feedback_ratingintegerCitizen's rating of the resolution (e.g., 1-5 scale)1 to 5 · optional5
Dates and times 3 columns
submission_datetimedatetimeDate and time when the service request was submitted2023-11-12T09:18:45
status_update_datetimedatetimeDate and time of the most recent status update2023-11-12T09:18:45
resolution_datetimedatetimeDate and time when the request was resolved or closedoptional2024-03-06T09:50:12

Use it for

  • median citizen…438 rowsmean citizen feedback…4.3poth…4.5wast…3.6stre…1.7graf…

    A government dashboard

    Citizen_feedback_rating by service_type and a breakdown of priority_level. Excel, Power BI or Tableau.

  • Why do the 11 pothole repair rows have a mean citizen_feedback_rating of 4.3?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable requests with citizen_id, submission_datetime and service_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset120 rows20 columns
Yours10,000 rows20 columnslocation_street_address: UK only

blueprint · municipal-service-request-progress

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 20 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 represents a unique public service request.
  • Include submission, assignment, first response, and final resolution timestamps.
  • Requests may remain open, in progress, or resolved.
  • Capture channel used (web, app, hotline) and department assigned.
  • Track citizen satisfaction score (1-5) on resolution.
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
municipal-service-request-progress

More in Government

Browse all
Also in GovernmentGovernment AI Chatbot LogsConsumer Product Safety ComplaintsPublic Funding Allocation BreakdownAll 1,947 datasets

What should your data show?

Preview 20 rows free
No signup. No card.