complaint_snapshots: 10
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 109255451019 | 2026-04-15T15:18:59Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451019 | Non Glowing of Street Lights | Near Venkateshwara Swamy Temple | 9290544519 | 2025-08-31T19:05:56Z | Closed | Shravan Kumar | Citizen Complained regarding non glowing of street lights at Block-3,Near Venkateshwara Swamy Temple,Mohan nagar,KOTHAPET. | AE/ENG,,Nacharam | 7331186855 | {"comments": [{"id": "109255451019", "mobile_number": "9290544519", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "05-SEP-2025 15:20:41"}, {"id": "109255451019", "mobile_number": "9849324700", "posted_by": "Kiranmayee I/C", "remarks": "rectified Sir", "status": "Attended By Officer", "time_stamp": "02-SEP-2025 14:11:01"}], "grievance": {"assigned_to": "AE/ENG,,Nacharam", "complaint_type": "Non Glowing of Street Lights", "id": "109255451019", "land_mark": "Near Venkateshwara Swamy Temple", "mobile_number": "9290544519", "officer_remarks": "", "phone_to_call": "7331186855", "photo": "", "raised_by": "Shravan Kumar", "remarks": "Citizen Complained regarding non glowing of street lights at Block-3,Near Venkateshwara Swamy Temple,Mohan nagar,KOTHAPET.", "status": "Closed", "time_stamp": "01-SEP-2025 00:35:56"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451019"} | sha256:692ae3fb29d62a406ad1b2ac7395d8a52df3a51794197359989b60bb8866d209 |