complaint_snapshots: 35
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35 | 104255188617 | 2026-04-18T08:22:28Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188617 | Non Glowing of Street Lights | plot no 1111, bhagth sing nagar pash 2 | 9866466677 | 2025-04-01T00:07:42Z | Attended By Officer | Srinivasarao | hyder Nagar Kukatpally opp. metro pillar no. 661 | AE/ENG,,Attapur | 7337557239 | 104255188617.jpg p2104255188617.jpg p3104255188617.jpg | {"comments": [{"id": "104255188617", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "Sir, this complaint had already been lodged on other token no. and will be cleared shortly by considering the most recent Complaint ID please.", "status": "Attended By Officer", "time_stamp": "03-MAY-2025 22:27:36"}, {"id": "104255188617", "mobile_number": "9866466677", "posted_by": "Srinivasarao", "remarks": "not glowing of Street lights last one month 15 day problem is not solved", "status": "Open", "time_stamp": "02-MAY-2025 19:27:27"}, {"id": "104255188617", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "Rectified", "status": "Attended By Officer", "time_stamp": "28-APR-2025 19:12:08"}, {"id": "104255188617", "mobile_number": "9866466677", "posted_by": "Srinivasarao", "remarks": "not attend, last one month lights not digiling, very bad", "status": "Open", "time_stamp": "21-APR-2025 18:09:58"}, {"id": "104255188617", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "Rectified", "status": "Attended By Officer", "time_stamp": "21-APR-2025 16:26:30"}], "grievance": {"assigned_to": "AE/ENG,,Attapur", "complaint_type": "Non Glowing of Street Lights", "id": "104255188617", "land_mark": "plot no 1111, bhagth sing nagar pash 2", "mobile_number": "9866466677", "officer_remarks": "", "phone_to_call": "7337557239", "photo": "104255188617.jpg p2104255188617.jpg p3104255188617.jpg", "raised_by": "Srinivasarao", "remarks": "hyder Nagar Kukatpally opp. metro pillar no. 661", "status": "Attended By Officer", "time_stamp": "01-APR-2025 05:37:42"}, "photos": [{"name": "104255188617.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/104255188617.jpg"}, {"name": "p2104255188617.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2104255188617.jpg"}, {"name": "p3104255188617.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3104255188617.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188617"} | sha256:21f9bdd6b59c61bfe547681d3b3e29aeffd300d74a75c1fd2a7006f993a643b3 |