complaint_snapshots: 27
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27 | 102255097112 | 2026-04-21T22:43:06Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097112 | Non Glowing of Street Lights | H.no 8-3-172/38 Raghavendra Nagar Meerpet Hyderabad Near Good life school | 9000176036 | 2025-01-31T19:34:59Z | Attended By Officer | Shiva | Street Light not working -null | AE/ENG,,Kapra | 7337557237 | 102255097112.jpg | {"comments": [{"id": "102255097112", "mobile_number": "9000176036", "posted_by": "Shiva", "remarks": "Did not attend", "status": "Attended By Officer", "time_stamp": "28-AUG-2025 22:46:10"}, {"id": "102255097112", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "08-FEB-2025 15:00:17"}, {"id": "102255097112", "mobile_number": "9121240332", "posted_by": "Sri TR Prasad", "remarks": "meerpet muncipality", "status": "Attended By Officer", "time_stamp": "05-FEB-2025 09:11:00"}], "grievance": {"assigned_to": "AE/ENG,,Kapra", "complaint_type": "Non Glowing of Street Lights", "id": "102255097112", "land_mark": "H.no 8-3-172/38 Raghavendra Nagar Meerpet Hyderabad Near Good life school", "mobile_number": "9000176036", "officer_remarks": "", "phone_to_call": "7337557237", "photo": "102255097112.jpg", "raised_by": "Shiva", "remarks": "Street Light not working -null", "status": "Attended By Officer", "time_stamp": "01-FEB-2025 01:04:59"}, "photos": [{"name": "102255097112.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102255097112.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097112"} | sha256:98e7b83fc24c29a2174da0e3cce4fb9873a6cd9c75db5fde0b8e5fd815bc70e1 |