complaint_snapshots: 33

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
33 102255097118 2026-04-21T22:43:06Z https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097118 Non Glowing of Street Lights afsar khan colony near tutti dewar aleem patel house 7993727839 2025-01-31T20:20:41Z Attended By Officer sajid ahmed street light are not glowing in front of my house please resolve the issue ASAP -null AE/ENG,,Shamshabad   8639447493 102255097118.jpg p2102255097118.jpg p3102255097118.jpg {"comments": [{"id": "102255097118", "mobile_number": "9154299704", "posted_by": "Sri. MD. Musharraffuddin", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-FEB-2025 16:34:52"}], "grievance": {"assigned_to": "AE/ENG,,Shamshabad", "complaint_type": "Non Glowing of Street Lights", "id": "102255097118", "land_mark": "afsar khan colony near tutti dewar aleem patel house", "mobile_number": "7993727839", "officer_remarks": "", "phone_to_call": "8639447493", "photo": "102255097118.jpg p2102255097118.jpg p3102255097118.jpg", "raised_by": "sajid ahmed", "remarks": "street light are not glowing in front of my house please resolve the issue ASAP -null", "status": "Attended By Officer", "time_stamp": "01-FEB-2025 01:50:41"}, "photos": [{"name": "102255097118.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102255097118.jpg"}, {"name": "p2102255097118.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102255097118.jpg"}, {"name": "p3102255097118.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3102255097118.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097118"} sha256:0eb662e821e7eabd7cea69566fc1bcf878da80a71a31d90af16b94b3c50ed84a

Links from other tables