complaint_snapshots: 77
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77 | 106255287970 | 2026-04-16T18:23:34Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287970 | HMWSSB | Rahul colony phase 1 | 9000977651 | 2025-06-01T02:24:01Z | Open | sailaja | drainages over flow very difficulty to walk on road please resolve this immediately.thank you | - | 106255287970.jpg p2106255287970.jpg p3106255287970.jpg | {"comments": [{"id": "106255287970", "mobile_number": "9000744055", "posted_by": "K. Mohan Rao", "remarks": "forward", "status": "Open", "time_stamp": "06-JUN-2025 12:14:08"}, {"id": "106255287970", "mobile_number": "8712013115", "posted_by": "T Ravi chandra AEE", "remarks": "pertaining to shaikpet ward", "status": "Open", "time_stamp": "02-JUN-2025 17:01:30"}], "grievance": {"assigned_to": "-", "complaint_type": "HMWSSB", "id": "106255287970", "land_mark": "Rahul colony phase 1", "mobile_number": "9000977651", "officer_remarks": "", "photo": "106255287970.jpg p2106255287970.jpg p3106255287970.jpg", "raised_by": "sailaja", "remarks": "drainages over flow very difficulty to walk on road please resolve this immediately.thank you", "status": "Open", "time_stamp": "01-JUN-2025 07:54:01"}, "photos": [{"name": "106255287970.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287970.jpg"}, {"name": "p2106255287970.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2106255287970.jpg"}, {"name": "p3106255287970.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3106255287970.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287970"} | sha256:ca5220491cfdc71b3efbe81606e9abae90b028cd044e9b680f90980e2d2a3950 |