Government Service Request Metrics

This dataset provides detailed metrics on citizen-initiated service requests handled by government agencies, including request lifecycle, timing, location, and citizen feedback. It enables analysis of bottlenecks, agency performance, and public service delivery trends, supporting data-driven improvements in government responsiveness and transparency.

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

Identifying bottlenecks and delays in government service delivery

Sample rows

preview · 8 of 200 rows · all 20 columns
request_idstringrequest_statusstringresponse_time_hoursfloataddress_statestringcitizen_idstringagency_idstringagency_namestringservice_typestringpriority_levelstringsubmission_datetimedatetimelast_updated_datetimedatetimeresolution_datetimedatetimeresolution_time_hoursfloatcitizen_feedback_scorefloatcitizen_feedback_commentstringaddress_streetstringaddress_citystringaddress_postal_codestringaddress_countrystringrequest_descriptionstring
REQ-00001resolved4.07ILCIT-10541AGY-001Department of Sanitationsanitationmedium2024-03-05T09:14:21Z2024-03-05T13:18:55Z2024-03-05T18:20:11Z9.14.5Quick resolution, thank you for addressing the issue.231 Elm StChicago60616USATrash was not collected on scheduled pickup day.
REQ-00002in_progress0.89TXCIT-10783AGY-002Department of Transportationinfrastructureurgent2024-04-17T14:08:44Z2024-04-17T15:02:21Zblankblankblankblank114 Main StDallas75201USALarge pothole on Main St causing traffic delays.
REQ-00003resolved0.57AZCIT-10915AGY-005Department of Waterutilityurgent2024-02-13T10:11:01Z2024-02-13T10:45:31Z2024-02-13T17:55:29Z7.745Excellent and fast response from the water department.7802 Oakridge AvePhoenix85032USAWater leak detected on property, needs urgent repair.
REQ-00004closed12.55PACIT-10632AGY-003Department of Public Safetypublic_safetyhigh2024-01-29T19:41:10Z2024-01-30T08:14:21Z2024-01-30T16:58:02Z21.283.5Issue solved but took longer than expected.401 7th AvePhiladelphia19104USAStreetlight on 7th Ave is not working since last week.
REQ-00005submitted0MACIT-10498AGY-001Department of Sanitationsanitationmedium2024-05-10T07:24:18Zblankblankblankblankblank839 Maple DrBoston02118USAOverflowing trash bins on street corner.
REQ-00006resolved3.79GACIT-11002AGY-009Department of Social Servicessocial_servicesurgent2024-04-23T12:34:29Z2024-04-23T16:22:11Z2024-04-24T10:08:39Z21.574Shelter was provided, grateful for assistance.512 Kings HwyAtlanta30310USARequesting emergency shelter due to eviction.
REQ-00007in_progress16.9TXCIT-10875AGY-002Department of Transportationinfrastructurehigh2024-03-14T16:12:04Z2024-03-15T09:06:05Zblankblankblankblank302 Riverside RdHouston77002USARequest for repair of broken pedestrian bridge.
REQ-00008resolved3.06NYCIT-10714AGY-006Department of Public Healthpublic_healthmedium2024-05-01T08:44:55Z2024-05-01T11:48:21Z2024-05-01T16:55:19Z8.185Very fast and effective mosquito control.194 Parkside AveNew York10016USAMosquito control needed near city park.

What the 200 rows show

from the 200-row sample

Submitted (request status) stands out: mean response_time_hours is 0.0, against 3.3 for the rest.

  • 2.3median response_time_hours
  • 4priority levels
  • 11agencies
  • 11service types
  • 17agency names
  • 8.6median resolution_time_hours
Mean response_time_hours by request_status200 rows
010200.0submi…30 rows2.7in_pr…30 rows3.2resol…114 ro…4.7closed24 rows11.0rejec…1 rows0.42urgent1 rows
response_time_hours200 rows, in bands of 2.5
0551101086612632111012.522.5response_time_hours →

Median 2.3, from 0.0 to 21.0.

address_state200 rows · top 10 of 34 values
  1. CA22
  2. TX21
  3. FL18
  4. OH15
  5. NY13
  6. PA10
  7. MA9
  8. NC9
  9. AZ7
  10. MO7
20 columns by typefrom the column list below
  • string 14
  • float 3
  • datetime 3

Columns

20 columns in three groups
blueprint · 20 columns
columntypedescriptionexample
Text 14 columns
request_idstringUnique identifier for each service requestuniqueREQ-00001
citizen_idstringUnique identifier for the citizen who initiated the request (anonymized if needed)CIT-10541
agency_idstringUnique identifier for the government agency responsible for handling the request11 agenciesAGY-001
agency_namestringName of the government agencyDepartment of Sanitation
service_typestringType or category of service requested (e.g., sanitation, public safety, infrastructure)11 typessanitation
request_descriptionstringDetailed description of the citizen's service requestoptionalWater meter malfunction.
request_statusstringCurrent status of the service request (e.g., submitted, in_progress, resolved, closed, rejected)submitted · in_progress · resolved · closed · rejectedresolved
priority_levelstringPriority level assigned to the request (e.g., low, medium, high, urgent)low · medium · high · urgent · optionalmedium
citizen_feedback_commentstringOptional comments provided by the citizen regarding their experienceoptionalCleaned up promptly.
address_streetstringStreet address associated with the service request locationoptional231 Elm St
address_citystringCity associated with the service request locationoptionalChicago
address_statestringState or province associated with the service request locationoptionalIL
address_postal_codestringPostal code for the service request locationoptional60616
address_countrystringCountry for the service request locationoptionalUSA
Numbers 3 columns
response_time_hoursfloatCalculated time (in hours) from submission to first response by agency0 or more · optional4.07
resolution_time_hoursfloatCalculated time (in hours) from submission to resolution/closure0 or more · optional9.1
citizen_feedback_scorefloatCitizen's rating of the service received (e.g., 1.0 to 5.0)1 to 5 · optional4.5
Dates and times 3 columns
submission_datetimedatetimeDate and time when the request was submitted2024-03-05T09:14:21Z
last_updated_datetimedatetimeDate and time when the request status was last updatedoptional2024-03-05T13:18:55Z
resolution_datetimedatetimeDate and time when the request was resolved or closedoptional2024-03-05T18:20:11Z

Use it for

  • median respons…2.3200 rowsmean response time ho…0.0subm…2.7in_p…3.2reso…4.7clos…

    A government dashboard

    Response_time_hours by request_status and a breakdown of address_state. Excel, Power BI or Tableau.

  • Why do the 30 submitted rows have a mean response_time_hours of 0.0?

    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, agency_id and agency_name 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

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

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

blueprint · government-service-request-metrics

Behind this dataset

Same schema. As many rows as you need.

These 200 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
  • Requests classified by department
  • Exclude duplicate or invalid requests
  • Monthly request summary
  • Flag urgent requests
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
government-service-request-metrics

More in Government

Browse all
Also in GovernmentPublic Service Access LogCivic Participation Event AttendancePublic Service Complaint ResolutionAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.