complaint_snapshots: 9
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9 | 106255287907 | 2026-04-16T18:23:26Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287907 | Non Glowing of Street Lights | B R Hitech theatre opp aadi tiffins Arunodaya colony Madhapur Hyderabad | 7013560947 | 2025-05-31T19:11:52Z | Attended By Officer | vijay kumar | almost a week onwards street lights not glowing i have many complaints every day a new person calling asking about the location and saying will send a person but still no one came and resolved the problem | AE/ENG,,Falaknuma | 9398662957 | 106255287907.jpg p2106255287907.jpg | {"comments": [{"id": "106255287907", "mobile_number": "9154369439", "posted_by": "G Likhitha", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "02-JUN-2025 19:35:32"}], "grievance": {"assigned_to": "AE/ENG,,Falaknuma", "complaint_type": "Non Glowing of Street Lights", "id": "106255287907", "land_mark": "B R Hitech theatre opp aadi tiffins Arunodaya colony Madhapur Hyderabad", "mobile_number": "7013560947", "officer_remarks": "", "phone_to_call": "9398662957", "photo": "106255287907.jpg p2106255287907.jpg", "raised_by": "vijay kumar", "remarks": "almost a week onwards street lights not glowing i have many complaints every day a new person calling asking about the location and saying will send a person but still no one came and resolved the problem", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 00:41:52"}, "photos": [{"name": "106255287907.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287907.jpg"}, {"name": "p2106255287907.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2106255287907.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287907"} | sha256:51f1ab070bff03de2d083ba41235abd0e7446bc1446e94585e54cadc68e9e7e6 |