complaint_snapshots: 35
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35 | 105255241072 | 2026-04-17T05:51:33Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241072 | Timer Settings of Street Lights | H.No.4 - 9 - 533/5, Yellareddy colony, Road No.12, Hayathnagar near H P Gas Godown | 9247462250 | 2025-05-01T01:00:30Z | Attended By Officer | R Yeshwanth Rao | nearly 15 days the problem was not solved. Street lights are glowing from 8 pm to 8 am. It is the problem of timer. please rectify the problem. | AE/ENG,,Boduppal | 9963370985 | p2105255241072.jpg | {"comments": [{"id": "105255241072", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "20-MAY-2025 15:06:45"}, {"id": "105255241072", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "07-MAY-2025 17:00:22"}, {"id": "105255241072", "mobile_number": "9247462250", "posted_by": "R Yeshwanth Rao", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Under Process", "time_stamp": "06-MAY-2025 16:08:36"}, {"id": "105255241072", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "informed to technicians", "status": "Under Process", "time_stamp": "03-MAY-2025 22:59:57"}], "grievance": {"assigned_to": "AE/ENG,,Boduppal", "complaint_type": "Timer Settings of Street Lights", "id": "105255241072", "land_mark": "H.No.4 - 9 - 533/5, Yellareddy colony, Road No.12, Hayathnagar near H P Gas Godown", "mobile_number": "9247462250", "officer_remarks": "", "phone_to_call": "9963370985", "photo": "p2105255241072.jpg", "raised_by": "R Yeshwanth Rao", "remarks": "nearly 15 days the problem was not solved. Street lights are glowing from 8 pm to 8 am. It is the problem of timer. please rectify the problem.", "status": "Attended By Officer", "time_stamp": "01-MAY-2025 06:30:30"}, "photos": [{"name": "p2105255241072.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2105255241072.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241072"} | sha256:3d661ea9a84b2f4e754c8f59a8adfa6e8d8e1f4984eda36e9088aadcd7e06e48 |