complaint_snapshots: 91
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 91 | 108255392706 | 2026-04-15T19:21:13Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392706 | Non Glowing of Street Lights | opp mamatha packagings(paper plate), street light pole no. 1513090291/028, street no. 1, annapurna colony, near mudra school, mallapur, 500076. | 9502013084 | 2025-08-01T01:48:02Z | Closed | Nandikanti Divya | non glowing of street light since 3 days... H. No.3-4-144/1 | AE/ENG,,Ghatkesar | 6309919057 | 108255392706.jpg p2108255392706.jpg | {"comments": [{"id": "108255392706", "mobile_number": "9502013084", "posted_by": "Nandikanti Divya", "remarks": "Yes rectified.. thanks", "status": "Closed", "time_stamp": "07-AUG-2025 21:36:27"}, {"id": "108255392706", "mobile_number": "9502013084", "posted_by": "Nandikanti Divya", "remarks": "yes , rectified thankyou", "status": "Attended By Officer", "time_stamp": "07-AUG-2025 21:35:48"}, {"id": "108255392706", "mobile_number": "9100025128", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "07-AUG-2025 18:20:21"}, {"id": "108255392706", "mobile_number": "9502013084", "posted_by": "Nandikanti Divya", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "07-AUG-2025 12:06:42"}, {"id": "108255392706", "mobile_number": "9502013084", "posted_by": "Nandikanti Divya", "remarks": "Not rectified... so much negligence", "status": "Open", "time_stamp": "07-AUG-2025 11:47:38"}, {"id": "108255392706", "mobile_number": "9502013084", "posted_by": "Nandikanti Divya", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "06-AUG-2025 11:36:22"}, {"id": "108255392706", "mobile_number": "9502013084", "posted_by": "Nandikanti Divya", "remarks": "Sir, why not rectifying this issue till now taking so many days and still not interested to proceed.. If you not resolve this issue today. I will complain to your officials...", "status": "Open", "time_stamp": "06-AUG-2025 11:33:12"}, {"id": "108255392706", "mobile_number": "9502013084", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "04-AUG-2025 13:22:19"}, {"id": "108255392706", "mobile_number": "9502013084", "posted_by": "Nandikanti Divya", "remarks": "దయచేసి తొందరగా rectify చేయగలరు. చేసిన పిదప చేసాము అని కన్ఫర్మేషన్ కోసం ఫోన్ చేయగలరు. మా వ్యక్తికి చూపించగలరు.", "status": "Attended By Officer", "time_stamp": "02-AUG-2025 10:11:53"}, {"id": "108255392706", "mobile_number": "9502013084", "posted_by": "Nandikanti Divya", "remarks": "not resolved... waste staff... please repair urgently", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 19:53:06"}, {"id": "108255392706", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 15:23:15"}], "grievance": {"assigned_to": "AE/ENG,,Ghatkesar", "complaint_type": "Non Glowing of Street Lights", "id": "108255392706", "land_mark": "opp mamatha packagings(paper plate), street light pole no. 1513090291/028, street no. 1, annapurna colony, near mudra school, mallapur, 500076.", "mobile_number": "9502013084", "officer_remarks": "", "phone_to_call": "6309919057", "photo": "108255392706.jpg p2108255392706.jpg", "raised_by": "Nandikanti Divya", "remarks": "non glowing of street light since 3 days... H. No.3-4-144/1", "status": "Closed", "time_stamp": "01-AUG-2025 07:18:02"}, "photos": [{"name": "108255392706.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/108255392706.jpg"}, {"name": "p2108255392706.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2108255392706.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392706"} | sha256:2d375641ce6c854c6342125c251e31e2ca9baaae9727766c685a49da8312133b |