complaint_snapshots: 18
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18 | 112255596105 | 2026-04-13T18:45:38Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596105 | Repairs to Road (Pot holes) | Iqura school | 8008880102 | 2025-11-30T22:21:00Z | Closed | Mohd abed | Road in my area is under construction but the demolition part is not completely they have broken the footpath as well as the drains but not the complete road due to which my elderly are have issue to move in and out of the home please look into it | AE/ENG,,Malakpet | 7995007385 | 112255596105.jpg p2112255596105.jpg p3112255596105.jpg | {"comments": [{"id": "112255596105", "mobile_number": "8008880102", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "04-DEC-2025 14:53:50"}, {"id": "112255596105", "mobile_number": "9000744055", "posted_by": "K. Mohan Rao", "remarks": "sorry for the inconvenience", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 13:22:07"}], "grievance": {"assigned_to": "AE/ENG,,Malakpet", "complaint_type": "Repairs to Road (Pot holes)", "id": "112255596105", "land_mark": "Iqura school", "mobile_number": "8008880102", "officer_remarks": "", "phone_to_call": "7995007385", "photo": "112255596105.jpg p2112255596105.jpg p3112255596105.jpg", "raised_by": "Mohd abed", "remarks": "Road in my area is under construction but the demolition part is not completely they have broken the footpath as well as the drains but not the complete road due to which my elderly are have issue to move in and out of the home please look into it", "status": "Closed", "time_stamp": "01-DEC-2025 03:51:00"}, "photos": [{"name": "112255596105.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/112255596105.jpg"}, {"name": "p2112255596105.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2112255596105.jpg"}, {"name": "p3112255596105.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3112255596105.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596105"} | sha256:138174cc298a429c39b72aa1b2bca6ba27a7e50b2fbb6c373f346e62ec829131 |