complaint_snapshots: 4
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | 112255596091 | 2026-04-13T18:45:37Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596091 | Overflowing of Nala / Drain | miyapur new colony ,Malappuram basti road no.4 | 8897636086 | 2025-11-30T19:09:15Z | Closed | sravan kumar | over flowing of drainage | AEE/ENG,,Bahadurpura | 9989211406 | 112255596091.jpg | {"comments": [{"id": "112255596091", "mobile_number": "9000541595", "posted_by": "Orsu Santhosh", "remarks": "this is bilongs to Hmwssb", "status": "Closed", "time_stamp": "02-DEC-2025 11:52:28"}], "grievance": {"assigned_to": "AEE/ENG,,Bahadurpura", "complaint_type": "Overflowing of Nala / Drain", "id": "112255596091", "land_mark": "miyapur new colony ,Malappuram basti road no.4", "mobile_number": "8897636086", "officer_remarks": "", "phone_to_call": "9989211406", "photo": "112255596091.jpg", "raised_by": "sravan kumar", "remarks": "over flowing of drainage", "status": "Closed", "time_stamp": "01-DEC-2025 00:39:15"}, "photos": [{"name": "112255596091.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/112255596091.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596091"} | sha256:1633329b27db8531b0fe87b43671a6ebc35c68e4989ac866eb04b8aa7c1da979 |