complaint_snapshots: 93
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93 | 104255188675 | 2026-04-18T08:22:34Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188675 | Desilting of Nala / Drain | near banjara function hall | 9885210501 | 2025-04-01T02:37:26Z | Attended By Officer | Padmajasivaraju | nala blocked due to dumping of waste | AE/ENG,,Jangammet | 8712013103 | p2104255188675.jpg | {"comments": [{"id": "104255188675", "mobile_number": "7331170680", "posted_by": "P Sateesh", "remarks": "desilting in progress", "status": "Attended By Officer", "time_stamp": "20-JUN-2025 17:55:26"}, {"id": "104255188675", "mobile_number": "7995007427", "posted_by": "B.S.D Nagesh Babu", "remarks": "Desilting and maintenance of Bulkapur nala upto pension office is under the jurisdiction of Ahmednagar ward.", "status": "Open", "time_stamp": "20-JUN-2025 16:34:27"}, {"id": "104255188675", "mobile_number": "7331170680", "posted_by": "P Sateesh", "remarks": "Banjarahills", "status": "Open", "time_stamp": "20-JUN-2025 16:07:26"}, {"id": "104255188675", "mobile_number": "9154909250", "posted_by": "Dr.Md Irshad Iqbal", "remarks": "It pertains to Engineering wing please contact", "status": "Open", "time_stamp": "01-APR-2025 10:12:22"}], "grievance": {"assigned_to": "AE/ENG,,Jangammet", "complaint_type": "Desilting of Nala / Drain", "id": "104255188675", "land_mark": "near banjara function hall", "mobile_number": "9885210501", "officer_remarks": "", "phone_to_call": "8712013103", "photo": "p2104255188675.jpg", "raised_by": "Padmajasivaraju", "remarks": "nala blocked due to dumping of waste", "status": "Attended By Officer", "time_stamp": "01-APR-2025 08:07:26"}, "photos": [{"name": "p2104255188675.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2104255188675.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188675"} | sha256:9c51caef46fb6fef7a1e210cbd19e6a7d0e03e92b8e1421b2b47ce58eb1030e1 |