complaint_snapshots: 64

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
64 107255337719 2026-04-15T21:46:25Z https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337719 Water logging Prashanth Nagar Colany 9392011354 2025-07-01T01:23:21Z Attended By Officer Ravindar Rao Stagnation of Rain water AE/ENG,,Karwan   7995009103 107255337719.jpg p2107255337719.jpg p3107255337719.jpg {"comments": [{"id": "107255337719", "mobile_number": "9392011354", "posted_by": "Ravindar Rao", "remarks": "Taken Action, Thank you sir 🙏", "status": "Attended By Officer", "time_stamp": "17-AUG-2025 07:53:14"}, {"id": "107255337719", "mobile_number": "9063816950", "posted_by": "G Varun Dev", "remarks": "Work will be taken up after HMWSSB utility line works", "status": "Attended By Officer", "time_stamp": "24-JUL-2025 15:34:32"}], "grievance": {"assigned_to": "AE/ENG,,Karwan", "complaint_type": "Water logging", "id": "107255337719", "land_mark": "Prashanth Nagar Colany", "mobile_number": "9392011354", "officer_remarks": "", "phone_to_call": "7995009103", "photo": "107255337719.jpg p2107255337719.jpg p3107255337719.jpg", "raised_by": "Ravindar Rao", "remarks": "Stagnation of Rain water", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 06:53:21"}, "photos": [{"name": "107255337719.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337719.jpg"}, {"name": "p2107255337719.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2107255337719.jpg"}, {"name": "p3107255337719.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3107255337719.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337719"} sha256:7a31a1211459e3609b1be8cd2a67527ed462eaaa01a38d58120f7cee74439a97

Links from other tables