complaint_snapshots: 45
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45 | 106255287939 | 2026-04-16T18:23:30Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287939 | Repairs of Nala / Drain | Sajjad Colony, water tank lane | 8977438131 | 2025-06-01T00:25:26Z | Attended By Officer | Faiyaz | 9-8-480/a/58 chotta bazar Golconda fort | AEE/ENG,,Chandrayangutta | 8498816472 | 106255287939.jpg | {"comments": [{"id": "106255287939", "mobile_number": "8712013115", "posted_by": "T Ravi chandra AEE", "remarks": "solved", "status": "Attended By Officer", "time_stamp": "08-JUL-2025 12:37:48"}, {"id": "106255287939", "mobile_number": "8008066911", "posted_by": "Sri. P.Rama Krishna", "remarks": "pertains to tolichowki", "status": "Open", "time_stamp": "21-JUN-2025 14:37:28"}, {"id": "106255287939", "mobile_number": "7995007385", "posted_by": "Sri.Uma mallikarjun", "remarks": "Nill", "status": "Open", "time_stamp": "19-JUN-2025 21:38:57"}], "grievance": {"assigned_to": "AEE/ENG,,Chandrayangutta", "complaint_type": "Repairs of Nala / Drain", "id": "106255287939", "land_mark": "Sajjad Colony, water tank lane", "mobile_number": "8977438131", "officer_remarks": "", "phone_to_call": "8498816472", "photo": "106255287939.jpg", "raised_by": "Faiyaz", "remarks": "9-8-480/a/58 chotta bazar Golconda fort", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 05:55:26"}, "photos": [{"name": "106255287939.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287939.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287939"} | sha256:ba52010f90fc5ae213f3fe2dc8a3feb632dc15658c8c796118d0cca347db5d9b |