complaint_snapshots: 28

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
28 110255503098 2026-04-15T13:17:23Z https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503098 Dog Menace CIRCLE 10 SK GARDEN GUDI KA DAWA KHANA N. S KUNTA 9247868055 2025-09-30T23:35:50Z Attended By Officer Dr sohail Dear sir lot of dogs in our streets barking whole nights we are cant sleeping please catch them Veternary Officer,,Nagole   9346014249 110255503098.jpg p2110255503098.jpg p3110255503098.jpg {"comments": [{"id": "110255503098", "mobile_number": "9154369429", "posted_by": "Dr.Srikanth", "remarks": "caught 2dogs", "status": "Attended By Officer", "time_stamp": "10-OCT-2025 12:21:32"}], "grievance": {"assigned_to": "Veternary Officer,,Nagole", "complaint_type": "Dog Menace", "id": "110255503098", "land_mark": "CIRCLE 10 SK GARDEN GUDI KA DAWA KHANA N. S KUNTA", "mobile_number": "9247868055", "officer_remarks": "", "phone_to_call": "9346014249", "photo": "110255503098.jpg p2110255503098.jpg p3110255503098.jpg", "raised_by": "Dr sohail", "remarks": "Dear sir lot of dogs in our streets barking whole nights we are cant sleeping please catch them", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 05:05:50"}, "photos": [{"name": "110255503098.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503098.jpg"}, {"name": "p2110255503098.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503098.jpg"}, {"name": "p3110255503098.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3110255503098.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503098"} sha256:f704f760c32100025ded87c167de834552d6cada8595c0a68e3ca9a68e3d3365

Links from other tables