complaint_snapshots: 27
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27 | 105255241062 | 2026-04-17T05:51:29Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241062 | Non Glowing of Street Lights | near sub station as rao nagar | 8309971662 | 2025-04-30T23:47:21Z | Closed | mnrao | nin glowing of street lights. glowing during day tine | AE/ENG,,Keesara | 8712013141 | 105255241062.jpg p2105255241062.jpg | {"comments": [{"id": "105255241062", "mobile_number": "8309971662", "posted_by": "mnrao", "remarks": "Satisfied", "status": "Closed", "time_stamp": "20-MAY-2025 12:34:14"}, {"id": "105255241062", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "08-MAY-2025 14:46:33"}, {"id": "105255241062", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "farwarded", "status": "Open", "time_stamp": "06-MAY-2025 14:15:09"}, {"id": "105255241062", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "2", "status": "Open", "time_stamp": "06-MAY-2025 09:12:48"}, {"id": "105255241062", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "farwarded", "status": "Open", "time_stamp": "05-MAY-2025 12:57:12"}], "grievance": {"assigned_to": "AE/ENG,,Keesara", "complaint_type": "Non Glowing of Street Lights", "id": "105255241062", "land_mark": "near sub station as rao nagar", "mobile_number": "8309971662", "officer_remarks": "", "phone_to_call": "8712013141", "photo": "105255241062.jpg p2105255241062.jpg", "raised_by": "mnrao", "remarks": "nin glowing of street lights. glowing during day tine", "status": "Closed", "time_stamp": "01-MAY-2025 05:17:21"}, "photos": [{"name": "105255241062.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241062.jpg"}, {"name": "p2105255241062.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2105255241062.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241062"} | sha256:80c8c183849c6cd08f83923054d2fb744f30fab6a50e6fdab48c82398cbc6821 |