complaint_snapshots: 37
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37 | 112255596124 | 2026-04-13T18:45:41Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596124 | Non Glowing of Street Lights | Near Bhuvana Vijjayam Grounds main gate line | 9440946919 | 2025-12-01T01:43:32Z | Closed | D Sudheer | ToGHMC Electricity/Ward OfficeKPHB DivisionSubject Request for Restoration of Non-Functioning Street LightsRespected Sir/MadamI would like to bring to your notice that the street lights near H.No. 776 MIGH MIGH-II KPHB opposite Bhuvana Vijjayam Grounds main gate have not been functioning for a long time. The entire stretch becomes very dark in the evenings causing inconvenience and posing safety risks to residents and pedestrians.I kindly request you to look into this issue and arrange for immediate repair or replacement of the street lights.Thank you for your prompt attention. | AE/ENG,,Falaknuma | 9398662957 | 112255596124.jpg p2112255596124.jpg p3112255596124.jpg | {"comments": [{"id": "112255596124", "mobile_number": "9440946919", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "10-DEC-2025 14:37:53"}, {"id": "112255596124", "mobile_number": "9154369439", "posted_by": "Likhitha", "remarks": "closed this moosapet circle not lingampally circle please current location submit in moosapet circle", "status": "Attended By Officer", "time_stamp": "05-DEC-2025 20:04:33"}, {"id": "112255596124", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "forward", "status": "Open", "time_stamp": "03-DEC-2025 11:26:00"}], "grievance": {"assigned_to": "AE/ENG,,Falaknuma", "complaint_type": "Non Glowing of Street Lights", "id": "112255596124", "land_mark": "Near Bhuvana Vijjayam Grounds main gate line", "mobile_number": "9440946919", "officer_remarks": "", "phone_to_call": "9398662957", "photo": "112255596124.jpg p2112255596124.jpg p3112255596124.jpg", "raised_by": "D Sudheer", "remarks": "ToGHMC Electricity/Ward OfficeKPHB DivisionSubject Request for Restoration of Non-Functioning Street LightsRespected Sir/MadamI would like to bring to your notice that the street lights near H.No. 776 MIGH MIGH-II KPHB opposite Bhuvana Vijjayam Grounds main gate have not been functioning for a long time. The entire stretch becomes very dark in the evenings causing inconvenience and posing safety risks to residents and pedestrians.I kindly request you to look into this issue and arrange for immediate repair or replacement of the street lights.Thank you for your prompt attention.", "status": "Closed", "time_stamp": "01-DEC-2025 07:13:32"}, "photos": [{"name": "112255596124.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/112255596124.jpg"}, {"name": "p2112255596124.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2112255596124.jpg"}, {"name": "p3112255596124.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3112255596124.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596124"} | sha256:a87dfd02561a7d6dc6fe7c288a6b6b2adb3ed97106f4a149f6996e9865829999 |