complaint_snapshots: 3
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 107255337658 | 2026-04-15T21:46:17Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337658 | Payment not Updated | - | 8309293834 | 2025-06-30T18:37:17Z | Attended By Officer | Murali krishna | I have paid amount of Rs 3888 but payment not updated . Pls check | I/c.,,Karwan | 107255337658.png | {"comments": [{"id": "107255337658", "mobile_number": "9989930669", "posted_by": "Ajaj Kumar", "remarks": "close", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 11:30:48"}, {"id": "107255337658", "mobile_number": "8309293834", "posted_by": "Murali krishna", "remarks": "Payment not updated and still showing to pay .", "status": "Open", "time_stamp": "01-JUL-2025 10:08:59"}, {"id": "107255337658", "mobile_number": "9989930669", "posted_by": "Ajaj Kumar", "remarks": "close", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 09:29:04"}], "grievance": {"assigned_to": "I/c.,,Karwan", "complaint_type": "Payment not Updated", "id": "107255337658", "land_mark": "-", "mobile_number": "8309293834", "officer_remarks": "", "photo": "107255337658.png", "raised_by": "Murali krishna", "remarks": "I have paid amount of Rs 3888 but payment not updated . Pls check", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 00:07:17"}, "photos": [{"name": "107255337658.png", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337658.png"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337658"} | sha256:a0a82b044ea583afba2c21b7404d9462b8dfd1bab53e52b2fb1ee943f7256fb6 |