complaint_snapshots: 23

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
23 102255097108 2026-04-21T22:43:05Z https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097108 Non Glowing of Street Lights Police Lines Yousufguda 8801937552 2025-01-31T19:25:46Z Attended By Officer NaveenKumar No Street lights-null AE/ENG,,Moosarambagh   9154172347 102255097108.jpg p2102255097108.jpg p3102255097108.jpg {"comments": [{"id": "102255097108", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "19-FEB-2025 14:19:31"}, {"id": "102255097108", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "19-FEB-2025 14:17:49"}], "grievance": {"assigned_to": "AE/ENG,,Moosarambagh", "complaint_type": "Non Glowing of Street Lights", "id": "102255097108", "land_mark": "Police Lines Yousufguda", "mobile_number": "8801937552", "officer_remarks": "", "phone_to_call": "9154172347", "photo": "102255097108.jpg p2102255097108.jpg p3102255097108.jpg", "raised_by": "NaveenKumar", "remarks": "No Street lights-null", "status": "Attended By Officer", "time_stamp": "01-FEB-2025 00:55:46"}, "photos": [{"name": "102255097108.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102255097108.jpg"}, {"name": "p2102255097108.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102255097108.jpg"}, {"name": "p3102255097108.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3102255097108.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097108"} sha256:9de0a505a0dd7f8cbff3da5e8c1e3c5ac0f1a85c91a362cf9e9916f75e06b2f7

Links from other tables