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 103255140333 2026-04-21T14:15:27Z https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140333 Non Glowing of Street Lights Near Raghanra school, Street No 18, Lalitha Nagar 9966651103 2025-03-01T00:07:18Z Attended By Officer BVenkat Street lights not glowing AE/ENG,,Khairatabad   7993360291 103255140333.jpg p2103255140333.jpg p3103255140333.jpg {"comments": [{"id": "103255140333", "mobile_number": "9121242764", "posted_by": "P Anusha", "remarks": "r", "status": "Attended By Officer", "time_stamp": "11-APR-2025 18:33:26"}, {"id": "103255140333", "mobile_number": "9966651103", "posted_by": "BVenkat", "remarks": "working now", "status": "Open", "time_stamp": "05-MAR-2025 20:07:09"}], "grievance": {"assigned_to": "AE/ENG,,Khairatabad", "complaint_type": "Non Glowing of Street Lights", "id": "103255140333", "land_mark": "Near Raghanra school, Street No 18, Lalitha Nagar", "mobile_number": "9966651103", "officer_remarks": "", "phone_to_call": "7993360291", "photo": "103255140333.jpg p2103255140333.jpg p3103255140333.jpg", "raised_by": "BVenkat", "remarks": "Street lights not glowing", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 05:37:18"}, "photos": [{"name": "103255140333.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/103255140333.jpg"}, {"name": "p2103255140333.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2103255140333.jpg"}, {"name": "p3103255140333.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3103255140333.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140333"} sha256:b20762074f1b65dd5cff0a497a28a513cdf4ec5f1f19df971895902ab97e2285

Links from other tables