complaint_snapshots: 117
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117 | 103255140413 | 2026-04-21T14:15:36Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140413 | HMWSSB | road no. 13 green park colony | 9885218684 | 2025-03-01T02:55:32Z | Closed | KAREEM UNNISA | water line busted water floating on the road | - | 103255140413.jpg p2103255140413.jpg p3103255140413.jpg | {"comments": [{"id": "103255140413", "mobile_number": "9000554766", "posted_by": "Y Srikanth", "remarks": "Pertains to HMWSSB", "status": "Closed", "time_stamp": "14-OCT-2025 16:04:33"}, {"id": "103255140413", "mobile_number": "7995009122", "posted_by": "VIJAY", "remarks": "pertains to HMWSSB", "status": "Open", "time_stamp": "01-MAR-2025 08:26:39"}], "grievance": {"assigned_to": "-", "complaint_type": "HMWSSB", "id": "103255140413", "land_mark": "road no. 13 green park colony", "mobile_number": "9885218684", "officer_remarks": "", "photo": "103255140413.jpg p2103255140413.jpg p3103255140413.jpg", "raised_by": "KAREEM UNNISA", "remarks": "water line busted water floating on the road", "status": "Closed", "time_stamp": "01-MAR-2025 08:25:32"}, "photos": [{"name": "103255140413.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/103255140413.jpg"}, {"name": "p2103255140413.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2103255140413.jpg"}, {"name": "p3103255140413.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3103255140413.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140413"} | sha256:86a5c7262303f56d01f54915c003fbfbca70c546716b18a7556c5d677ffb0bc4 |