complaint_snapshots: 15
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 | 110255503085 | 2026-04-15T13:17:21Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503085 | Repairs to Road (Pot holes) | bhel vistas road | 9652153950 | 2025-09-30T19:39:57Z | Submitted for Sanction | kiran | sir here more senior citizen are living we request you to closer the holes which we are sending in pictures kids also suffering please any thing you peoples want please let us know sir thank you from Billa kiran | AE/ENG,,Jeedimetla | 8712013135 | 110255503085.jpg p2110255503085.jpg p3110255503085.jpg | {"comments": [{"id": "110255503085", "mobile_number": "7331170020", "posted_by": "S Mahadev Anurag", "remarks": "need proposal", "status": "Submitted for Sanction", "time_stamp": "04-OCT-2025 09:19:32"}, {"id": "110255503085", "mobile_number": "8712034414", "posted_by": "Sri S Sai Yugandhar Reddy", "remarks": "132", "status": "Open", "time_stamp": "04-OCT-2025 08:51:26"}], "grievance": {"assigned_to": "AE/ENG,,Jeedimetla", "complaint_type": "Repairs to Road (Pot holes)", "id": "110255503085", "land_mark": "bhel vistas road", "mobile_number": "9652153950", "officer_remarks": "", "phone_to_call": "8712013135", "photo": "110255503085.jpg p2110255503085.jpg p3110255503085.jpg", "raised_by": "kiran", "remarks": "sir here more senior citizen are living we request you to closer the holes which we are sending in pictures kids also suffering please any thing you peoples want please let us know sir thank you from Billa kiran", "status": "Submitted for Sanction", "time_stamp": "01-OCT-2025 01:09:57"}, "photos": [{"name": "110255503085.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503085.jpg"}, {"name": "p2110255503085.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503085.jpg"}, {"name": "p3110255503085.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3110255503085.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503085"} | sha256:3cc3cec375b135762f62356761cffb364490c6324a4b4ce3ef636a5d3f450fb0 |