complaint_snapshots: 30
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30 | 107255337685 | 2026-04-15T21:46:21Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337685 | Non Glowing of Street Lights | Triveni Nagar phase 1 | 9848022770 | 2025-06-30T20:32:07Z | Attended By Officer | Sudarshan | lights not glowing | AE/ENG,,Malakpet | 7995007385 | 107255337685.jpg | {"comments": [{"id": "107255337685", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "retrieved", "status": "Attended By Officer", "time_stamp": "08-JUL-2025 16:11:40"}, {"id": "107255337685", "mobile_number": "9154768771", "posted_by": "S.Kiranmayee", "remarks": "other package", "status": "Open", "time_stamp": "07-JUL-2025 11:02:59"}, {"id": "107255337685", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "Forward", "status": "Open", "time_stamp": "05-JUL-2025 15:30:38"}, {"id": "107255337685", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "Forward", "status": "Open", "time_stamp": "05-JUL-2025 15:29:38"}, {"id": "107255337685", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "Forward", "status": "Open", "time_stamp": "05-JUL-2025 15:27:52"}], "grievance": {"assigned_to": "AE/ENG,,Malakpet", "complaint_type": "Non Glowing of Street Lights", "id": "107255337685", "land_mark": "Triveni Nagar phase 1", "mobile_number": "9848022770", "officer_remarks": "", "phone_to_call": "7995007385", "photo": "107255337685.jpg", "raised_by": "Sudarshan", "remarks": "lights not glowing", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 02:02:07"}, "photos": [{"name": "107255337685.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337685.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337685"} | sha256:3f79ffe36f2e13a463df011f174cc17b3dafcf51ecf8809984074e67d182a8d9 |