complaint_snapshots: 15
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 | 106255287911 | 2026-04-16T18:23:27Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287911 | Mosquitoes Fogging Required | Hassan Nagar Bismillah store | 8686661965 | 2025-05-31T19:23:31Z | Attended By Officer | Mohammed Ismail | overflow | Ward Entomology Supervisor,,Badangpet | 9063843616 | 106255287911.jpg | {"comments": [{"id": "106255287911", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "08-JUN-2025 15:27:43"}, {"id": "106255287911", "mobile_number": "8008060477", "posted_by": "N.Uday Kiran", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "05-JUN-2025 17:22:48"}, {"id": "106255287911", "mobile_number": "9989930158", "posted_by": "MD Masood ur rahman", "remarks": "As per location area H No 4-16-59, forward to connect ward Shastripuram Division", "status": "Open", "time_stamp": "02-JUN-2025 12:53:19"}, {"id": "106255287911", "mobile_number": "8686661965", "posted_by": "Ward058", "remarks": "forwarded", "status": "Open", "time_stamp": "02-JUN-2025 12:13:21"}, {"id": "106255287911", "mobile_number": "9989930158", "posted_by": "MD Masood ur rahman", "remarks": "forward to grievance concern ward Shastripuram Division", "status": "Open", "time_stamp": "01-JUN-2025 18:39:49"}], "grievance": {"assigned_to": "Ward Entomology Supervisor,,Badangpet", "complaint_type": "Mosquitoes Fogging Required", "id": "106255287911", "land_mark": "Hassan Nagar Bismillah store", "mobile_number": "8686661965", "officer_remarks": "", "phone_to_call": "9063843616", "photo": "106255287911.jpg", "raised_by": "Mohammed Ismail", "remarks": "overflow", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 00:53:31"}, "photos": [{"name": "106255287911.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287911.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287911"} | sha256:29121fbc075c6303ce98162b1a984b2feeb2b4e2f0f656f318c3fbf824974f87 |