Public Service Complaint Resolution

This dataset provides detailed records of public service complaints, including citizen and incident information, complaint categorization, departmental assignments, resolution outcomes, escalation details, and citizen feedback. It enables comprehensive tracking of government accountability, service quality, and responsiveness, supporting transparency and continuous improvement in public sector services.

  • opened 7 times
  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Analyzing complaint resolution times and departmental performance

Sample rows

preview · 8 of 110 rows · all 27 columns
complaint_idintegerresolution_typestringcitizen_feedback_ratingintegerescalatedbooleanincident_location_countrystringcitizen_idstringcitizen_namestringcitizen_contact_emailstringcitizen_contact_phonestringcomplaint_datedatetimeservice_departmentstringservice_typestringcomplaint_categorystringincident_datedateincident_location_streetstringincident_location_citystringincident_location_statestringincident_location_postal_codestringstatusstringassigned_officer_idstringassigned_officer_namestringresolution_datedatetimeescalation_levelstringlast_updateddatetimecomplaint_descriptionstringresolution_summarystringcitizen_feedback_commentsstring
1action_taken4falseIndiaCITZ2F8K7Priya Anandpriya.anand23@gmail.com+91 98207 433212023-11-21T10:42:36Sanitation Departmentsanitationpoor service2023-11-1312 MG RoadBengaluruKarnataka560001resolvedSND224Rakesh Kumar2023-11-27T14:23:11blank2023-11-28T09:14:40Garbage collection has been irregular for two weeks, leading to overflowing bins and unpleasant odor in the neighborhood.Garbage collection schedule was restored, and additional staff assigned to the locality for improved service.Service improved after complaint, but bins still overflow occasionally.
2blankblankfalseChinaCITZ9L3QPJin Wenjin.wen2000@163.comblank2024-02-05T17:12:55Water Supply Authoritywater supplycontamination2024-02-0388 Zhongshan RdShanghaiShanghai200001in_reviewWSA513Li Zhangblankblank2024-02-05T18:02:41Tap water has a strange color and odor, suspecting contamination in the supply line for the last three days.blankblank
3compensation5falseSaudi ArabiaCITZK7X1QFatima Al-Harbifatima.harbi@outlook.sa+966 53 849 29312022-08-09T09:58:44Electricity Boardelectricitypower outage2022-08-0845 King Fahd RdRiyadhRiyadh11564resolvedELB843Salman Al-Farsi2022-08-10T11:21:12blank2022-08-11T08:40:17There was a power outage for more than six hours yesterday, causing inconvenience and loss of perishables.Technical fault was repaired and power restored. Compensation offered for loss.Quick response and helpful staff. Thank you for resolving the issue promptly.
4blankblankfalseUKCITZ6J0LBOlivia Martinblank+44 20 7946 00212023-03-26T13:35:54Public Transport Agencypublic transportdelay2023-03-2521 Queen's RdLondonEnglandSW1A 1AAin_reviewPTA108James Thompsonblankblank2023-03-26T14:03:12Bus service 15 was delayed by over 40 minutes without any notification, causing disruption to commuters.blankblank
5blankblankfalseIrelandCITZ8N6V2blankblankblank2024-04-17T07:53:21Healthcare Serviceshealthcaremisconduct2024-04-16Main St 12CorkMunsterT12 XYZsubmittedblankblankblankblank2024-04-17T08:10:01Staff at the public clinic were rude and did not address my concerns.blankblank
6action_taken3falseBrazilCITZM8P0DLucas da Silvalucas.silva@terra.com.br+55 11 98473-62912023-07-04T18:27:49Water Supply Authoritywater supplyleakage2023-07-03Rua Oscar Freire 210São PauloSP01426-001closedWSB219Ana Pereira2023-07-10T09:53:10blank2023-07-11T10:30:55There is a persistent water leakage on the street, causing flooding and inconvenience to pedestrians.Pipe was repaired and flooding cleared after public complaint.Issue fixed but took longer than expected.
7blankblankfalseItalyCITZ5A2HVBarbara Rossib.rossi@email.itblank2023-10-15T11:29:38Housing Authoritypublic housingdelay2023-09-10Via Garibaldi 43MilanLombardia20121submittedblankblankblankblank2023-10-15T12:04:09Repair request for leaking roof has not been attended for more than a month.blankblank
8blankblankfalseUSACITZD5N76Alex Johnsonalex.johnson@mail.com+1 202-555-01982024-01-12T16:03:27Public Transport Agencypublic transportmisconduct2024-01-121600 Pennsylvania Ave NWWashingtonDC20006in_reviewPTA217Emily Carterblankblank2024-01-13T09:44:38Bus driver was rude to passengers and refused to answer queries about the route.blankblank

What the 110 rows show

from the 110-row sample
  • 6%escalated = true
  • 4median citizen_feedback_rating
  • 6statuses
  • 9service types
  • 15service departments
resolution_type54 rows by value
0255049action_taken45%2compensation2%3apology3%
citizen_feedback_rating54 rows, in bands of 0.2
01530900002500020345citizen_feedback_rating →

Median 4, from 3 to 5.

incident_location_country107 rows with a value · 3 left blank
  1. New Zealand10
  2. Egypt9
  3. China8
  4. Ireland8
  5. Brazil7
  6. USA7
  7. Pakistan7
  8. Italy6
  9. Japan6
  10. France6
27 columns by typefrom the column list below
  • string 20
  • integer 2
  • date 1
  • datetime 3
  • boolean 1

Columns

27 columns in four groups
blueprint · 27 columns
columntypedescriptionexample
Text 20 columns
citizen_idstringAnonymized unique identifier for the citizen lodging the complaint.CITZ2F8K7
citizen_namestringName of the citizen lodging the complaint (can be anonymized or pseudonymized as per privacy requirements).optionalPriya Anand
citizen_contact_emailstringContact email of the citizen lodging the complaint.optionalpriya.anand23@gmail.com
citizen_contact_phonestringContact phone number of the citizen lodging the complaint.optional+91 98207 43321
service_departmentstringName of the public service department or agency the complaint is directed to.Sanitation Department
service_typestringType of public service involved (e.g., sanitation, water supply, transportation).9 typessanitation
complaint_categorystringCategory or nature of the complaint (e.g., delay, poor service, misconduct).poor service
complaint_descriptionstringDetailed description of the complaint provided by the citizen.Garbage collection has be…
incident_location_streetstringStreet address where the incident occurred.optional12 MG Road
incident_location_citystringCity where the incident occurred.optionalBengaluru
incident_location_statestringState or province where the incident occurred.optionalKarnataka
incident_location_postal_codestringPostal code of the incident location.optional560001
incident_location_countrystringCountry where the incident occurred.optionalIndia
statusstringCurrent status of the complaint (e.g., submitted, in_review, resolved, rejected, escalated, closed).6 valuesresolved
assigned_officer_idstringUnique identifier for the officer assigned to resolve the complaint.optionalSND224
assigned_officer_namestringName of the officer assigned to the complaint.optionalRakesh Kumar
resolution_summarystringSummary of the resolution provided for the complaint.optionalGarbage collection schedu…
resolution_typestringType of resolution provided (e.g., action_taken, compensation, apology, no_action_needed).5 values · optionalaction_taken
citizen_feedback_commentsstringAdditional comments or feedback from the citizen regarding the resolution.optionalService improved after co…
escalation_levelstringLevel to which the complaint was escalated (e.g., department_head, ombudsman, minister).3 levels · optionalombudsman
Numbers 2 columns
complaint_idintegerUnique identifier for each complaint lodged with public services.unique1
citizen_feedback_ratingintegerRating provided by the citizen for the resolution (1-5 scale).1 to 5 · optional4
Dates and times 4 columns
complaint_datedatetimeDate and time when the complaint was lodged.2023-11-21T10:42:36
incident_datedateDate when the incident leading to the complaint occurred.optional2023-11-13
resolution_datedatetimeDate and time when the complaint was resolved or closed.optional2023-11-27T14:23:11
last_updateddatetimeTimestamp of the last update to the complaint record.2023-11-28T09:14:40
True or false 1 column
escalatedbooleanIndicates if the complaint was escalated to a higher authority.optionalfalse

Use it for

  • escalated6%7 of 110 rowsmean citizen feedback…4.2action…5.0compen…3.3apology

    A government dashboard

    The escalated rate, citizen_feedback_rating by resolution_type and a breakdown of incident_location_country. Excel, Power BI or Tableau.

  • Why do 7 of 110 rows have escalated = true?

    A class exercise

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

  • A software demo

    Believable rows with citizen_id, citizen_name and citizen_contact_email to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 27 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 dataset110 rows27 columns
Yours10,000 rows27 columnsincident_location_street: UK only

blueprint · public-service-complaint-resolution

Behind this dataset

Same schema. As many rows as you need.

These 110 rows came out of a blueprint — 27 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
  • Log complaint type and date
  • Record resolution status and time taken
  • Flag unresolved complaints over 14 days
  • Aggregate by department
  • Summarize monthly trends
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
public-service-complaint-resolution

More in Government

Browse all
Also in GovernmentMunicipal Service Request ProgressPublic Procurement Transparency LogsCivic Engagement Crowdsourcing SignalsAll 1,947 datasets

What should your data show?

Preview 20 rows free
No signup. No card.