complaint_snapshots: 73
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 73 | 101255052495 | 2026-04-22T08:06:18Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0101255052495 | Non Glowing of Street Lights | Lane opposite Alpine Manor apartment West Marredpally | 9849023228 | 2025-01-01T02:59:12Z | Attended By Officer | Suhas B Rao | Last two streetlights in our lane havent the working from last few weeks -null | AE/ENG,,Goshamahal | 9063836132 | 101255052495.jpg | {"comments": [{"id": "101255052495", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "24-JAN-2025 15:13:09"}, {"id": "101255052495", "mobile_number": "9121242764", "posted_by": "P Anusha", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "21-JAN-2025 17:16:14"}, {"id": "101255052495", "mobile_number": "9849023228", "posted_by": "Suhas B Rao", "remarks": "Issue has been resolved to our complete satisfaction. Thanks!", "status": "Open", "time_stamp": "11-JAN-2025 19:02:59"}, {"id": "101255052495", "mobile_number": "9849023228", "posted_by": "Suhas B Rao", "remarks": "Madam, we are living in darkness in the centre of West Marredpally! Kindly repair the streetlights immediately.", "status": "Open", "time_stamp": "03-JAN-2025 12:46:31"}], "grievance": {"assigned_to": "AE/ENG,,Goshamahal", "complaint_type": "Non Glowing of Street Lights", "id": "101255052495", "land_mark": "Lane opposite Alpine Manor apartment West Marredpally", "mobile_number": "9849023228", "officer_remarks": "", "phone_to_call": "9063836132", "photo": "101255052495.jpg", "raised_by": "Suhas B Rao", "remarks": "Last two streetlights in our lane havent the working from last few weeks -null", "status": "Attended By Officer", "time_stamp": "01-JAN-2025 08:29:12"}, "photos": [{"name": "101255052495.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/101255052495.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0101255052495"} | sha256:97cbfa8e5d3fa6ae71052a17c7f85d5e989c33fd0df7f711f95e8198cd59de7e |