complaint_snapshots: 61
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61 | 107255337716 | 2026-04-15T21:46:25Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337716 | Non Glowing of Street Lights | GREEN PARK COLONY, B - 404, Road 14 | 9849128341 | 2025-07-01T01:13:54Z | Closed | CHANDRA | Street Light not glowing | AE/ENG,,Nacharam | 7337557241 | 107255337716.jpg | {"comments": [{"id": "107255337716", "mobile_number": "9849128341", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "09-JUL-2025 14:26:14"}, {"id": "107255337716", "mobile_number": "7207923077", "posted_by": "G.Kavitha", "remarks": "street lights problem rectified sir", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 12:38:40"}], "grievance": {"assigned_to": "AE/ENG,,Nacharam", "complaint_type": "Non Glowing of Street Lights", "id": "107255337716", "land_mark": "GREEN PARK COLONY, B - 404, Road 14", "mobile_number": "9849128341", "officer_remarks": "", "phone_to_call": "7337557241", "photo": "107255337716.jpg", "raised_by": "CHANDRA", "remarks": "Street Light not glowing", "status": "Closed", "time_stamp": "01-JUL-2025 06:43:54"}, "photos": [{"name": "107255337716.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337716.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337716"} | sha256:b0bdd871ee2ab8ad2e8dbb8010789536adc85496daa1166830c14b222113d951 |