complaint_snapshots: 23
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23 | 106255287921 | 2026-04-16T18:23:28Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287921 | Non Glowing of Street Lights | Beside Mandal Office Dabeerpura | 9700953354 | 2025-05-31T20:45:43Z | Attended By Officer | Habeeb | Street light not working since 15 days.Due to the lack of lighting the area remains dark at night which has become a serious safety concern. Street dogs have started gathering and staying in the area during the night increasing the risk of dogs gathering . The darkness also raises the risk of theft or other criminal activities | AE/ENG,,Saroornagar | 7331189499 | 106255287921.jpg p2106255287921.jpg p3106255287921.jpg | {"comments": [{"id": "106255287921", "mobile_number": "9154909321", "posted_by": "K.Raju", "remarks": "car not remove", "status": "Attended By Officer", "time_stamp": "09-SEP-2025 09:58:49"}, {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "its been more then two months the problem has bot been resolved....when i am trying to call the ae his phone is switched off", "status": "Open", "time_stamp": "20-AUG-2025 15:42:49"}, {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "The officer came along with the ladder and they told that they cannot climb on such height through ladder,it required crane to solve it..it's been more then 2 months the issue hasn't resolved", "status": "Open", "time_stamp": "21-JUL-2025 02:26:22"}, {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "and moreover the photo uploaded by officer of streetlight is of beside pole", "status": "Attended By Officer", "time_stamp": "21-JUL-2025 02:18:40"}, {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "the issue has not been resolved yet....in the status it's showing it's completed..never expected this from ghmc", "status": "Attended By Officer", "time_stamp": "21-JUL-2025 02:15:00"}, {"id": "106255287921", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "08-JUN-2025 15:28:44"}, {"id": "106255287921", "mobile_number": "9154909321", "posted_by": "K.Raju", "remarks": "model lights rectified", "status": "Attended By Officer", "time_stamp": "06-JUN-2025 12:02:48"}], "grievance": {"assigned_to": "AE/ENG,,Saroornagar", "complaint_type": "Non Glowing of Street Lights", "id": "106255287921", "land_mark": "Beside Mandal Office Dabeerpura", "mobile_number": "9700953354", "officer_remarks": "", "phone_to_call": "7331189499", "photo": "106255287921.jpg p2106255287921.jpg p3106255287921.jpg", "raised_by": "Habeeb", "remarks": "Street light not working since 15 days.Due to the lack of lighting the area remains dark at night which has become a serious safety concern. Street dogs have started gathering and staying in the area during the night increasing the risk of dogs gathering . The darkness also raises the risk of theft or other criminal activities", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 02:15:43"}, "photos": [{"name": "106255287921.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287921.jpg"}, {"name": "p2106255287921.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2106255287921.jpg"}, {"name": "p3106255287921.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3106255287921.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287921"} | sha256:29adf44e166e9df7da84db2c7233d61c51c7664cef2e579ce741abdb24947dfe |