complaint_snapshots: 2
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 101265640097 | 2026-04-13T10:17:16Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0101265640097 | Segregation of Waste is Not Done | azmi clinic opposite lane , atiya kirana store lane | 9985858546 | 2025-12-31T19:09:18Z | Closed | shaikh | Are we not citizens of HyderabadVirat Nagar Hakeempet Kunta Atiya Kirana Store laneFor 1 month sewage water is entering our homes due to broken drainage after road work.Children sick. Elderly suffering. Act now. | AE,,Malakpet | 9247540131 | 101265640097.jpg p2101265640097.jpg p3101265640097.jpg | {"comments": [{"id": "101265640097", "mobile_number": "8712419173", "posted_by": "Sri K Rajesh, DYEE SWM", "remarks": "belongs to hmwssb", "status": "Closed", "time_stamp": "01-JAN-2026 09:38:46"}], "grievance": {"assigned_to": "AE,,Malakpet", "complaint_type": "Segregation of Waste is Not Done", "id": "101265640097", "land_mark": "azmi clinic opposite lane , atiya kirana store lane", "mobile_number": "9985858546", "officer_remarks": "", "phone_to_call": "9247540131", "photo": "101265640097.jpg p2101265640097.jpg p3101265640097.jpg", "raised_by": "shaikh", "remarks": "Are we not citizens of HyderabadVirat Nagar Hakeempet Kunta Atiya Kirana Store laneFor 1 month sewage water is entering our homes due to broken drainage after road work.Children sick. Elderly suffering. Act now.", "status": "Closed", "time_stamp": "01-JAN-2026 00:39:18"}, "photos": [{"name": "101265640097.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/101265640097.jpg"}, {"name": "p2101265640097.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2101265640097.jpg"}, {"name": "p3101265640097.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3101265640097.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0101265640097"} | sha256:649e395420befbb1764b24b70b560c2ea849b0cb182f989fcb478b922f605c15 |