complaint_snapshots: 43
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43 | 108255392653 | 2026-04-15T19:21:07Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392653 | Timer Settings of Street Lights | ,Near opp marthamma Church , | 9030033936 | 2025-08-01T00:01:14Z | Attended By Officer | Murali Mohan | Citizen Complained regarding Timer setting of street Lights at h no 1-1-18/14 , Jawahar Nagar Colony ,Near opp marthamma Church , MUSHEERABAD . | AE/ENG,,Santosh Nagar | 9398508101 | {"comments": [{"id": "108255392653", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": ".", "status": "Attended By Officer", "time_stamp": "16-AUG-2025 13:49:47"}, {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 16:22:27"}, {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Kept Conference with concern officer T.Sowmya,AE/AEE 9154686556 Officer number is not connected", "status": "Open", "time_stamp": "14-AUG-2025 16:04:46"}, {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 16:03:48"}, {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 05:37:55"}, {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 05:31:39"}, {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "12-AUG-2025 18:54:46"}, {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "08-AUG-2025 14:26:28"}, {"id": "108255392653", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": ".", "status": "Attended By Officer", "time_stamp": "07-AUG-2025 22:43:50"}, {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "05-AUG-2025 05:38:08"}], "grievance": {"assigned_to": "AE/ENG,,Santosh Nagar", "complaint_type": "Timer Settings of Street Lights", "id": "108255392653", "land_mark": ",Near opp marthamma Church ,", "mobile_number": "9030033936", "officer_remarks": "", "phone_to_call": "9398508101", "photo": "", "raised_by": "Murali Mohan", "remarks": "Citizen Complained regarding Timer setting of street Lights at h no 1-1-18/14 , Jawahar Nagar Colony ,Near opp marthamma Church , MUSHEERABAD .", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 05:31:14"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392653"} | sha256:5f27825df6aa9ee0b9192e089ed548146e62856da083ccb9fceada1f19aed587 |