complaint_snapshots: 25
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25 | 110255503095 | 2026-04-15T13:17:23Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503095 | Repairs of Nala / Drain | Behind Matrix School Lane Masjidgadda jawahar nagar vengal rao nagar div | 7093000100 | 2025-09-30T23:02:50Z | Open | Abdul | kindly remove bottleneck. New cc retained walls and ground road level | AE/ENG,,Yousufguda | 7995009079 | 110255503095.jpg p2110255503095.jpg | {"comments": [{"id": "110255503095", "mobile_number": "7093000100", "posted_by": "Abdul", "remarks": "Nala work belongs to hmws ?", "status": "Open", "time_stamp": "15-MAR-2026 22:55:08"}, {"id": "110255503095", "mobile_number": "7995009079", "posted_by": "Sri.G. Bharath Kumar", "remarks": "pertaining to HMWSSB", "status": "Open", "time_stamp": "14-OCT-2025 12:21:17"}], "grievance": {"assigned_to": "AE/ENG,,Yousufguda", "complaint_type": "Repairs of Nala / Drain", "id": "110255503095", "land_mark": "Behind Matrix School Lane Masjidgadda jawahar nagar vengal rao nagar div", "mobile_number": "7093000100", "officer_remarks": "", "phone_to_call": "7995009079", "photo": "110255503095.jpg p2110255503095.jpg", "raised_by": "Abdul", "remarks": "kindly remove bottleneck. New cc retained walls and ground road level", "status": "Open", "time_stamp": "01-OCT-2025 04:32:50"}, "photos": [{"name": "110255503095.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503095.jpg"}, {"name": "p2110255503095.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503095.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503095"} | sha256:8446d520ecf3f84f003f9b13274ea3f89ad8d0ddcee24ef0a6a9accb4875525b |