complaint_snapshots: 30

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
30 102265688285 2026-04-12T19:37:27Z https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688285 Mosquitoes Fogging Required near bollywood the salon Fatima Nagar 8801564541 2026-01-31T20:25:21Z Attended By Officer IRMAN KHAN In My area most pollution like water blocking and drainage overflow and we are facing maleria dango skin infection plz send here mosquitoes fogging vehicle Ward Entomology Supervisor,,Falaknuma   9581179879 102265688285.jpg p2102265688285.jpg {"comments": [{"id": "102265688285", "mobile_number": "7993360295", "posted_by": "Sri M Satish kumar", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "06-FEB-2026 13:03:26"}], "grievance": {"assigned_to": "Ward Entomology Supervisor,,Falaknuma", "complaint_type": "Mosquitoes Fogging Required", "id": "102265688285", "land_mark": "near bollywood the salon Fatima Nagar", "mobile_number": "8801564541", "officer_remarks": "", "phone_to_call": "9581179879", "photo": "102265688285.jpg p2102265688285.jpg", "raised_by": "IRMAN KHAN", "remarks": "In My area most pollution like water blocking and drainage overflow and we are facing maleria dango skin infection plz send here mosquitoes fogging vehicle", "status": "Attended By Officer", "time_stamp": "01-FEB-2026 01:55:21"}, "photos": [{"name": "102265688285.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102265688285.jpg"}, {"name": "p2102265688285.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102265688285.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688285"} sha256:5f15a57a9b9ac459e55f67f0e794054eb0090b1e7c1db601d0b298fae144f81e

Links from other tables