complaint_snapshots: 23
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23 | 107255337678 | 2026-04-15T21:46:20Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337678 | Non Glowing of Street Lights | Arif Imadi Manzil | 9398976971 | 2025-06-30T19:43:11Z | Attended By Officer | Khairuddin | street light was working fine for a week and now it went off. kindly check and do the needful | AE/ENG,,Badangpet | 9154172346 | 107255337678.jpg | {"comments": [{"id": "107255337678", "mobile_number": "9704670163", "posted_by": "Sri. Rama rao", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "07-JUL-2025 21:01:10"}, {"id": "107255337678", "mobile_number": "9398976971", "posted_by": "Khairuddin", "remarks": "none attended the request. I would urge the dept. folks to not close the tickets without attending it.", "status": "Open", "time_stamp": "01-JUL-2025 23:51:12"}, {"id": "107255337678", "mobile_number": "9704670163", "posted_by": "Sri. Rama rao", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 22:18:48"}, {"id": "107255337678", "mobile_number": "9398976971", "posted_by": "Khairuddin", "remarks": "the area is, Khayyam Nagar, Attapur, pillar #177, Rajendra Nagar", "status": "Open", "time_stamp": "01-JUL-2025 12:19:38"}], "grievance": {"assigned_to": "AE/ENG,,Badangpet", "complaint_type": "Non Glowing of Street Lights", "id": "107255337678", "land_mark": "Arif Imadi Manzil", "mobile_number": "9398976971", "officer_remarks": "", "phone_to_call": "9154172346", "photo": "107255337678.jpg", "raised_by": "Khairuddin", "remarks": "street light was working fine for a week and now it went off. kindly check and do the needful", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 01:13:11"}, "photos": [{"name": "107255337678.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337678.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337678"} | sha256:0d7f1597184eae06f00bc9156bf8b654bf2f8d82c8bdda12aaf10cdd6eb11802 |