complaint_snapshots: 27
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27 | 101265640119 | 2026-04-13T10:17:23Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0101265640119 | Overflowing of Nala / Drain | near Chishti chaman, Mangalhat | 9440495390 | 2026-01-01T01:32:17Z | Closed | MerajJabri | Drainage is overflowing request to clear the silt and garbage from main hole | AE/ENG,,Goshamahal | 7331189192 | 101265640119.jpg p2101265640119.jpg | {"comments": [{"id": "101265640119", "mobile_number": "9440495390", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "10-FEB-2026 16:36:11"}, {"id": "101265640119", "mobile_number": "7331189192", "posted_by": "V.Thirumal reddy", "remarks": "pipeline work in progress", "status": "Attended By Officer", "time_stamp": "02-FEB-2026 11:33:19"}, {"id": "101265640119", "mobile_number": "9440495390", "posted_by": "Ward148", "remarks": "forwarded", "status": "Open", "time_stamp": "28-JAN-2026 11:17:57"}], "grievance": {"assigned_to": "AE/ENG,,Goshamahal", "complaint_type": "Overflowing of Nala / Drain", "id": "101265640119", "land_mark": "near Chishti chaman, Mangalhat", "mobile_number": "9440495390", "officer_remarks": "", "phone_to_call": "7331189192", "photo": "101265640119.jpg p2101265640119.jpg", "raised_by": "MerajJabri", "remarks": "Drainage is overflowing request to clear the silt and garbage from main hole", "status": "Closed", "time_stamp": "01-JAN-2026 07:02:17"}, "photos": [{"name": "101265640119.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/101265640119.jpg"}, {"name": "p2101265640119.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2101265640119.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0101265640119"} | sha256:eff190da43290eeba9504f56ba6e8285da87022313151af8db934397d49b0a23 |