complaint_snapshots: 7
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7 | 110255503077 | 2026-04-15T13:17:20Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503077 | Non Glowing of Street Lights | 11-2-557/17, Darul Qhushal Apartments Line | 8978434143 | 2025-09-30T18:58:42Z | Attended By Officer | Ali | 4 Months Street Light Not Working 2 Light are not working | AE/ENG,,Jangammet | 8712013103 | 110255503077.jpg p2110255503077.jpg p3110255503077.jpg | {"comments": [{"id": "110255503077", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "22-OCT-2025 19:02:34"}, {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Street lights he said within 4 days its will be completed still now it’s pending", "status": "Open", "time_stamp": "18-OCT-2025 09:46:44"}, {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Not Attend", "status": "Attended By Officer", "time_stamp": "18-OCT-2025 09:45:27"}, {"id": "110255503077", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "15-OCT-2025 12:47:19"}, {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Still its Pending from 27 July … No work is done simply without any resolution closing Ticket. If citizens have given complaint you have to rectified.. not to give Fake comments", "status": "Open", "time_stamp": "08-OCT-2025 21:08:00"}, {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "not Attending", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 21:05:41"}, {"id": "110255503077", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 13:58:58"}, {"id": "110255503077", "mobile_number": "9154295249", "posted_by": "Sai Chandana", "remarks": "forward to Red hills", "status": "Open", "time_stamp": "04-OCT-2025 13:44:24"}, {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Not Attending", "status": "Open", "time_stamp": "01-OCT-2025 16:34:37"}, {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Not attend", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 16:34:06"}, {"id": "110255503077", "mobile_number": "9154295249", "posted_by": "Sai Chandana", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 15:55:47"}], "grievance": {"assigned_to": "AE/ENG,,Jangammet", "complaint_type": "Non Glowing of Street Lights", "id": "110255503077", "land_mark": "11-2-557/17, Darul Qhushal Apartments Line", "mobile_number": "8978434143", "officer_remarks": "", "phone_to_call": "8712013103", "photo": "110255503077.jpg p2110255503077.jpg p3110255503077.jpg", "raised_by": "Ali", "remarks": "4 Months Street Light Not Working 2 Light are not working", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 00:28:42"}, "photos": [{"name": "110255503077.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503077.jpg"}, {"name": "p2110255503077.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503077.jpg"}, {"name": "p3110255503077.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3110255503077.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503077"} | sha256:442b1074eacf8066e9aa3b41aa62f9201a28597ecced822bde3124fda0c12315 |