complaint_snapshots: 69
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69 | 110255503139 | 2026-04-15T13:17:28Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503139 | Repairs of Nala / Drain | rajarajeshwari temple | 8143675789 | 2025-10-01T02:14:39Z | Closed | swathi swathi | Drainage water enters our house due to clogged drains. | AE/ENG,,Karwan | 7995009103 | p2110255503139.jpg | {"comments": [{"id": "110255503139", "mobile_number": "9063816950", "posted_by": "G Varun Dev", "remarks": "Pertains to HMWSSB", "status": "Closed", "time_stamp": "01-OCT-2025 08:00:32"}], "grievance": {"assigned_to": "AE/ENG,,Karwan", "complaint_type": "Repairs of Nala / Drain", "id": "110255503139", "land_mark": "rajarajeshwari temple", "mobile_number": "8143675789", "officer_remarks": "", "phone_to_call": "7995009103", "photo": "p2110255503139.jpg", "raised_by": "swathi swathi", "remarks": "Drainage water enters our house due to clogged drains.", "status": "Closed", "time_stamp": "01-OCT-2025 07:44:39"}, "photos": [{"name": "p2110255503139.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503139.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503139"} | sha256:dbbfc6bcebe8f92eb9c3c4168cb037374d6a798b7952aa12df9af1b159640810 |