complaint_snapshots: 78
This data as json
| snapshot_pk | complaint_id | scraped_at | source_url | complaint_type | landmark | mobile_number | grievance_timestamp | status_text | raised_by | remarks | assigned_to | officer_remarks | phone_to_call | grievance_photo_text | raw_payload_json | content_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78 | 103255140374 | 2026-04-21T14:15:32Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140374 | Non Glowing of Street Lights | Near Bapu khan meliniyam | 9246578980 | 2025-03-01T02:20:11Z | Attended By Officer | Shankar | Citizen complained regarding Non glowing of street lights at H no 6-3-10991100/16 Near Bapu khan meliniyam SOMAJIGUDA | AE/ENG,,Charminar | 9063816947 | {"comments": [{"id": "103255140374", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "06-APR-2025 12:25:12"}, {"id": "103255140374", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "resolved", "status": "Attended By Officer", "time_stamp": "05-APR-2025 17:06:39"}, {"id": "103255140374", "mobile_number": "9246578980", "posted_by": "Shankar", "remarks": "Citizen Called and Informed that the Grievance has been pending.So please take necessary action.Thank you Sir.", "status": "Open", "time_stamp": "01-MAR-2025 13:44:27"}], "grievance": {"assigned_to": "AE/ENG,,Charminar", "complaint_type": "Non Glowing of Street Lights", "id": "103255140374", "land_mark": "Near Bapu khan meliniyam", "mobile_number": "9246578980", "officer_remarks": "", "phone_to_call": "9063816947", "photo": "", "raised_by": "Shankar", "remarks": "Citizen complained regarding Non glowing of street lights at H no 6-3-10991100/16 Near Bapu khan meliniyam SOMAJIGUDA", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 07:50:11"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140374"} | sha256:3cfe6e982fdafeb67da5d34f47924b1e8c06bb5c11ba900e94f6318803458004 |