complaint_snapshots: 74
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74 | 106255287972 | 2026-04-16T18:23:34Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287972 | Non Glowing of Street Lights | Avanthi Nagar east | 9392471641 | 2025-06-01T02:32:59Z | Attended By Officer | PNarasimhaReddy | from last 6months no street light we complained so many time there is no response and the complained is from Avanthi Nagar east colony president | AE/ENG,,Charminar | 9063816948 | 106255287972.jpg | {"comments": [{"id": "106255287972", "mobile_number": "9154768771", "posted_by": "S.Kiranmayee", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "04-JUN-2025 11:43:05"}, {"id": "106255287972", "mobile_number": "7207923077", "posted_by": "G.Kavitha I/C", "remarks": "out of package", "status": "Open", "time_stamp": "04-JUN-2025 05:32:28"}, {"id": "106255287972", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "another ward", "status": "Open", "time_stamp": "03-JUN-2025 10:51:02"}, {"id": "106255287972", "mobile_number": "9392471641", "posted_by": "Ward101", "remarks": "Pertains to kukatpally ward.", "status": "Open", "time_stamp": "02-JUN-2025 10:47:45"}], "grievance": {"assigned_to": "AE/ENG,,Charminar", "complaint_type": "Non Glowing of Street Lights", "id": "106255287972", "land_mark": "Avanthi Nagar east", "mobile_number": "9392471641", "officer_remarks": "", "phone_to_call": "9063816948", "photo": "106255287972.jpg", "raised_by": "PNarasimhaReddy", "remarks": "from last 6months no street light we complained so many time there is no response and the complained is from Avanthi Nagar east colony president", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 08:02:59"}, "photos": [{"name": "106255287972.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287972.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287972"} | sha256:1a41ffe72ed118c18ffa95081b30e9a5bfbf3c1c2a4bf79c5cba37ef310f9405 |