complaint_snapshots: 37

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
37 110255503107 2026-04-15T13:17:24Z https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503107 Water Stagnation opp pvr colony vanasthalipuram hyderabad 8686705994 2025-10-01T00:56:56Z Closed Ayesha jabeen Road manhole full -     110255503107.jpg p2110255503107.jpg p3110255503107.jpg {"comments": [{"id": "110255503107", "mobile_number": "8686705994", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "15-NOV-2025 15:48:57"}, {"id": "110255503107", "mobile_number": "8121041509", "posted_by": "DRF TEAM", "remarks": "solved the problem", "status": "Attended By Officer", "time_stamp": "01-NOV-2025 14:40:38"}, {"id": "110255503107", "mobile_number": "7337557266", "posted_by": "Sri. R. Hemu Naik", "remarks": "Pertaining to B N reddy nagar ward", "status": "Open", "time_stamp": "31-OCT-2025 19:01:51"}], "grievance": {"assigned_to": "-", "complaint_type": "Water Stagnation", "id": "110255503107", "land_mark": "opp pvr colony vanasthalipuram hyderabad", "mobile_number": "8686705994", "officer_remarks": "", "photo": "110255503107.jpg p2110255503107.jpg p3110255503107.jpg", "raised_by": "Ayesha jabeen", "remarks": "Road manhole full", "status": "Closed", "time_stamp": "01-OCT-2025 06:26:56"}, "photos": [{"name": "110255503107.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503107.jpg"}, {"name": "p2110255503107.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503107.jpg"}, {"name": "p3110255503107.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3110255503107.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503107"} sha256:78b87e7c3057ad4ff76f01adee5efe1f745085f2b61f944af74479126b634941

Links from other tables