complaint_snapshots: 28
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28 | 106255287924 | 2026-04-16T18:23:29Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287924 | Non Glowing of Street Lights | Near Old Reddy Jana Sangam | 7989464894 | 2025-05-31T21:18:13Z | Attended By Officer | BalukarSangameshwar | We are really feeling unsafe in the nights as we dont have street light working in our society. I and my wife works in night shift we reach at home @ 3 oclock midnight. Requesting you to please look into this on priority basis and do the needful. Thanks in advance. | AE/ENG,,Hayathnagar | 9502025421 | 106255287924.jpg p2106255287924.jpg p3106255287924.jpg | {"comments": [{"id": "106255287924", "mobile_number": "9704234838", "posted_by": "M Satya Narayana Reddy", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "05-JUN-2025 11:35:02"}, {"id": "106255287924", "mobile_number": "9154369423", "posted_by": "M.satyanarayana Reddy", "remarks": "ae", "status": "Open", "time_stamp": "03-JUN-2025 23:20:42"}, {"id": "106255287924", "mobile_number": "8555902142", "posted_by": "Sri.K.Raju", "remarks": "forward", "status": "Open", "time_stamp": "02-JUN-2025 08:29:18"}], "grievance": {"assigned_to": "AE/ENG,,Hayathnagar", "complaint_type": "Non Glowing of Street Lights", "id": "106255287924", "land_mark": "Near Old Reddy Jana Sangam", "mobile_number": "7989464894", "officer_remarks": "", "phone_to_call": "9502025421", "photo": "106255287924.jpg p2106255287924.jpg p3106255287924.jpg", "raised_by": "BalukarSangameshwar", "remarks": "We are really feeling unsafe in the nights as we dont have street light working in our society. I and my wife works in night shift we reach at home @ 3 oclock midnight. Requesting you to please look into this on priority basis and do the needful. Thanks in advance.", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 02:48:13"}, "photos": [{"name": "106255287924.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287924.jpg"}, {"name": "p2106255287924.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2106255287924.jpg"}, {"name": "p3106255287924.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3106255287924.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287924"} | sha256:05b2a3649680e8b40e0eeccd50b47c561e330b58d6ba13f61dce68b9503a924c |