Municipal AI Service Request Logs
This dataset provides detailed logs of municipal service requests managed by AI-driven systems, including operational metrics, routing decisions, resolution times, and citizen feedback. It enables smart city teams to benchmark digital transformation, optimize workflows, and enhance citizen engagement by analyzing automated service delivery outcomes and identifying process bottlenecks.
Sample rows
preview · 8 of 132 rows · all 20 columns| request_idstring | priority_levelstring | ai_confidence_scorefloat | escalated_to_humanboolean | service_location_citystring | citizen_idstring | request_typestring | submission_datetimedatetime | ai_routing_decisionstring | assigned_teamstring | statusstring | resolution_datetimedatetime | resolution_time_hoursfloat | citizen_feedback_scoreinteger | citizen_feedback_commentsstring | service_location_streetstring | service_location_statestring | service_location_postal_codestring | service_location_countrystring | request_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| REQ-000001 | urgent | 0.95 | true | Chicago | CITZ-ALPHA-101 | pothole_repair | 2024-06-03T09:14:00Z | Public Works Department - Pothole Team | Road Crew A | resolved | 2024-06-03T13:41:00Z | 4.45 | 5 | Quick service, thank you! | 155 Main St | IL | 60617 | US | Large pothole near intersection needs urgent fixing. |
| REQ-000002 | medium | 0.78 | false | Los Angeles | CITZ-BETA-209 | waste_collection | 2024-06-02T08:10:00Z | Sanitation Services - Waste Pickup | Waste Collection Team North | in_progress | blank | blank | blank | blank | 234 Oak Ave | CA | 90012 | US | Missed waste pickup on scheduled day. |
| REQ-000003 | high | 0.87 | true | Springfield | CITZ-GAMMA-302 | street_light_issue | 2024-06-01T22:33:00Z | Infrastructure Division - Lighting Unit | Lighting Repair Team West | closed | 2024-06-02T03:15:00Z | 4.7 | 4 | Resolved after reporting, thanks. | 87 Elm St | MA | 01108 | US | Street light flickers and doesn't stay on. |
| REQ-000004 | medium | 0.79 | false | Buffalo | CITZ-DELTA-412 | graffiti_removal | 2024-06-04T07:49:00Z | Community Services - Parks Clean Up | Park Maintenance Team | open | blank | blank | blank | blank | 310 Maple Dr | NY | 14201 | US | Graffiti on public park wall. |
| REQ-000005 | high | 0.84 | true | New York | CITZ-EPSILON-511 | noise_complaint | 2024-06-03T23:51:00Z | Compliance Office - Noise Enforcement | Noise Compliance Team | resolved | 2024-06-04T07:10:00Z | 7.32 | 3 | Issue resolved, but took longer than expected. | 56 River Rd | NY | 10032 | US | Constant loud music at night from nearby apartment. |
| REQ-000006 | medium | 0.62 | false | San Diego | CITZ-ZETA-613 | other | 2024-06-01T12:25:00Z | Public Works Department - Sidewalk Repair | Sidewalk Crew | open | blank | blank | blank | blank | 210 Forest Ln | CA | 92101 | US | Requesting sidewalk repair due to cracks. |
| REQ-000007 | low | 0.48 | false | Atlanta | CITZ-THETA-701 | waste_collection | 2024-06-02T14:18:00Z | Sanitation Services - Public Waste | Waste Collection Team Central | in_progress | blank | blank | blank | blank | 92 5th Ave | GA | 30303 | US | Overflowing public trash bin at bus stop. |
| REQ-000008 | high | 0.91 | false | Riverton | CITZ-IOTA-802 | pothole_repair | 2024-06-03T16:37:00Z | Public Works Department - Pothole Team | Road Crew B | closed | 2024-06-04T08:10:00Z | 15.55 | 4 | Prompt fix, good job. | 333 School St | UT | 84065 | US | Small pothole near school entrance. |
| REQ-000009 | medium | 0.82 | false | Seattle | CITZ-KAPPA-901 | graffiti_removal | 2024-06-02T11:05:00Z | Community Services - Facility Clean Up | Facility Maintenance Team | resolved | 2024-06-02T19:43:00Z | 8.63 | 5 | Very fast and professional. | 600 Library St | WA | 98104 | US | Graffiti on city library wall. |
| REQ-000010 | urgent | 0.98 | true | Chicago | CITZ-ALPHA-101 | street_light_issue | 2024-06-03T19:22:00Z | Infrastructure Division - Lighting Unit | Lighting Repair Team East | resolved | 2024-06-04T01:00:00Z | 5.63 | 4 | Resolved quickly, but not notified. | 155 Main St | IL | 60617 | US | Street light is completely out on Main St. |
| REQ-000011 | low | 0.39 | false | Boston | CITZ-LAMBDA-105 | other | 2024-06-02T10:11:00Z | Public Works Department - Tree Maintenance | Tree Trimming Team | open | blank | blank | blank | blank | 412 Pine St | MA | 02108 | US | Requesting tree trimming for safety reasons. |
| REQ-000012 | urgent | 0.73 | true | Dallas | CITZ-MU-215 | noise_complaint | 2024-06-04T06:58:00Z | Compliance Office - Construction Noise | Noise Compliance Team | in_progress | blank | blank | blank | blank | 89 7th St | TX | 75201 | US | Construction noise very early in the morning. |
| REQ-000013 | high | 0.88 | false | Miami | CITZ-NU-320 | waste_collection | 2024-06-02T13:45:00Z | Sanitation Services - Bulk Waste Pickup | Bulk Waste Team | closed | 2024-06-03T08:00:00Z | 18.25 | 3 | Bulk items collected a day late. | 142 Cedar St | FL | 33101 | US | Bulk waste pickup missed scheduled date. |
| REQ-000014 | urgent | 0.93 | true | Houston | CITZ-XI-425 | pothole_repair | 2024-06-03T11:34:00Z | Public Works Department - Pothole Team | Road Crew C | in_progress | blank | blank | blank | blank | 501 Gas Ave | TX | 77002 | US | Pothole causing tire damage near gas station. |
| REQ-000015 | medium | 0.77 | false | San Jose | CITZ-OMICRON-530 | graffiti_removal | 2024-06-01T08:20:00Z | Community Services - Parks Clean Up | Park Maintenance Team | resolved | 2024-06-01T12:05:00Z | 3.75 | 5 | Cleaned up same day, excellent! | 10 School Rd | CA | 95112 | US | Graffiti on school playground fence. |
| REQ-000016 | high | 0.89 | true | Raleigh | CITZ-PI-640 | street_light_issue | 2024-06-02T21:41:00Z | Infrastructure Division - Lighting Unit | Lighting Repair Team South | closed | 2024-06-03T05:20:00Z | 7.65 | 4 | Fixed in reasonable time. | 69 Oak Circle | NC | 27601 | US | Street light constantly blinking near residence. |
| REQ-000017 | medium | 0.53 | false | Phoenix | CITZ-RHO-750 | noise_complaint | 2024-06-04T02:17:00Z | Compliance Office - Noise Enforcement | Noise Compliance Team | open | blank | blank | blank | blank | 23 Sunset Blvd | AZ | 85001 | US | Car alarms going off repeatedly at night. |
| REQ-000018 | urgent | 0.96 | true | Denver | CITZ-SIGMA-801 | other | 2024-06-02T18:03:00Z | Public Works Department - Stormwater Team | Stormwater Crew | resolved | 2024-06-02T21:50:00Z | 3.78 | 5 | Great response to urgent issue. | 400 Water St | CO | 80202 | US | Flooded storm drain, urgent attention needed. |
| REQ-000019 | high | 0.86 | false | Fort Worth | CITZ-TAU-902 | pothole_repair | 2024-06-04T09:01:00Z | Public Works Department - Pothole Team | Road Crew D | in_progress | blank | blank | blank | blank | Exit 18 Hwy | TX | 76102 | US | Several potholes forming on highway exit ramp. |
| REQ-000020 | medium | 0.75 | false | Detroit | CITZ-UPSILON-103 | graffiti_removal | 2024-06-03T10:17:00Z | Community Services - Facility Clean Up | Facility Maintenance Team | closed | 2024-06-03T13:30:00Z | 3.22 | 3 | Clean up took a few hours. | 78 Commerce St | MI | 48226 | US | Graffiti on downtown office building wall. |
What the 132 rows show
from the 132-row sampleLow (priority level) stands out: mean ai_
- 29%escalated_
to_ human = true - 0.79median ai_
confidence_ score - 3service location countries
- 4statuses
- 6request types
- 21service location states
Median 0.79, from 0.27 to 0.99.
- string 14
- integer 1
- float 2
- datetime 2
- boolean 1
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
request_id | string | Unique identifier for the service requestunique | REQ-000001 |
citizen_id | string | Anonymized identifier for the citizen submitting the request | CITZ-ALPHA-101 |
request_type | string | Type of municipal service requested (e.g., pothole repair, waste collection)6 values | pothole_repair |
request_description | string | Detailed description of the issue or request provided by the citizenoptional | Large pothole near inters… |
ai_routing_decision | string | AI system's routing decision (e.g., assigned department/team) | Parks Department Routing |
assigned_team | string | Name of the municipal team assigned to resolve the request | Road Crew A |
priority_level | string | Priority level assigned by AI (e.g., low, medium, high, urgent)low · medium · high · urgent | urgent |
status | string | Current status of the request (e.g., open, in_progress, resolved, closed, rejected)open · in_progress · resolved · closed · rejected | resolved |
citizen_feedback_comments | string | Optional comments provided by the citizen after resolutionoptional | Prompt fix, good job. |
service_location_street | string | Street address where the service is neededoptional | 155 Main St |
service_location_city | string | City of the service location | Chicago |
service_location_state | string | State of the service location | IL |
service_location_postal_code | string | Postal code of the service location | 60617 |
service_location_country | string | Country of the service location3 countries | US |
| Numbers 3 columns | |||
resolution_time_hours | float | Total time taken to resolve the request, in hours0 or more · optional | 4.45 |
citizen_feedback_score | integer | Citizen's feedback rating after resolution (1-5 scale)1 to 5 · optional | 5 |
ai_confidence_score | float | AI system's confidence score in routing decision (0-1 scale)0 to 1 · optional | 0.95 |
| Dates and times 2 columns | |||
submission_datetime | datetime | Timestamp when the request was submitted | 2024-06-03T09:14:00Z |
resolution_datetime | datetime | Timestamp when the request was resolved (if applicable)optional | 2024-06-03T13:41:00Z |
| True or false 1 column | |||
escalated_to_human | boolean | Indicates if the request was escalated from AI to a human operator | true |
Use it for
A government dashboard
The escalated_
to_ human rate, ai_ confidence_ score by priority_ level and a breakdown of service_ location_ city. Excel, Power BI or Tableau. Why do the 13 low rows have a mean ai_
confidence_ score of 0.42? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Requests132REQ-0000010.95urgentREQ-0000020.78mediumREQ-0000030.87high
A software demo
Believable requests with citizen_
id, request_ type and request_ description to fill a screen in front of a buyer.
blueprint · municipal-ai-service-request-logs
Behind this dataset
Same schema. As many rows as you need.
These 132 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.
- Each row represents a unique citizen service request
- Requests are assigned to departments via AI algorithm
- Include timestamps for request creation, assignment, and resolution
- Log automated vs manual routing decisions
- Track outcome: resolved, pending, or escalated
- Capture feedback rating if available
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-ai-service-request-logs