complaint_snapshots: 11
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | 110255503081 | 2026-04-15T13:17:21Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503081 | Non Glowing of Street Lights | near Indian gas Gowdown Renuka nagar | 7981836439 | 2025-09-30T19:13:59Z | Closed | Sahil | street light is not working since 1 week | AE/ENG,,Charminar | 9063816947 | 110255503081.jpg | {"comments": [{"id": "110255503081", "mobile_number": "7981836439", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "20-OCT-2025 15:34:17"}, {"id": "110255503081", "mobile_number": "8500496801", "posted_by": "Smt R Shirisha", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "07-OCT-2025 16:24:34"}, {"id": "110255503081", "mobile_number": "9059345525", "posted_by": "G Kavitha", "remarks": "out of package", "status": "Open", "time_stamp": "06-OCT-2025 10:48:57"}, {"id": "110255503081", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "balkampet", "status": "Open", "time_stamp": "01-OCT-2025 10:01:22"}], "grievance": {"assigned_to": "AE/ENG,,Charminar", "complaint_type": "Non Glowing of Street Lights", "id": "110255503081", "land_mark": "near Indian gas Gowdown Renuka nagar", "mobile_number": "7981836439", "officer_remarks": "", "phone_to_call": "9063816947", "photo": "110255503081.jpg", "raised_by": "Sahil", "remarks": "street light is not working since 1 week", "status": "Closed", "time_stamp": "01-OCT-2025 00:43:59"}, "photos": [{"name": "110255503081.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503081.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503081"} | sha256:6b81964aa95f8fc78cb7b7e36cfc22ab65ec4201e57ef45a62548f2e9162e24a |