complaint_snapshots: 5
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 106255287897 | 2026-04-16T18:23:26Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287897 | Street Sweeping Not Done | Sumadhura Acropolis | 9951361246 | 2025-05-31T18:42:30Z | Attended By Officer | Rajshekhar Vaka | This is everyday menace and no solution we everyday talk about keeping clean Hyderabad, neighbour society never listen and all this is everyday on our so called Posh IT area | AE,,Falaknuma | 7674919906 | 106255287897.jpg | {"comments": [{"id": "106255287897", "mobile_number": "8125218065", "posted_by": "Dr. Srikanth Reddy", "remarks": "claer", "status": "Attended By Officer", "time_stamp": "03-JUN-2025 09:17:02"}, {"id": "106255287897", "mobile_number": "7997951620", "posted_by": "Serilingampally", "remarks": "citizen saying sweeping not done", "status": "Open", "time_stamp": "03-JUN-2025 06:40:27"}, {"id": "106255287897", "mobile_number": "7997951629", "posted_by": "Secunderabad-29", "remarks": "it is not related circle 29", "status": "Open", "time_stamp": "01-JUN-2025 10:12:38"}, {"id": "106255287897", "mobile_number": "7997951627", "posted_by": "Alwal-27", "remarks": "Another ward", "status": "Open", "time_stamp": "01-JUN-2025 08:19:10"}], "grievance": {"assigned_to": "AE,,Falaknuma", "complaint_type": "Street Sweeping Not Done", "id": "106255287897", "land_mark": "Sumadhura Acropolis", "mobile_number": "9951361246", "officer_remarks": "", "phone_to_call": "7674919906", "photo": "106255287897.jpg", "raised_by": "Rajshekhar Vaka", "remarks": "This is everyday menace and no solution we everyday talk about keeping clean Hyderabad, neighbour society never listen and all this is everyday on our so called Posh IT area", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 00:12:30"}, "photos": [{"name": "106255287897.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287897.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287897"} | sha256:2e7ae8d841e25423d72911b1e8f433ab9f3b7e3b4478387fce61612e8787f555 |