complaint_snapshots: 63

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
63 105255241099 2026-04-17T05:51:45Z https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241099 Timer Settings of Street Lights Behind SSS Vidyanikethan School 9440403737 2025-05-01T01:54:17Z Attended By Officer Shiva Prasad Street lights are glowing up to 9AM AEE/ENG,,Kapra   7995009082 105255241099.jpg p2105255241099.jpg p3105255241099.jpg {"comments": [{"id": "105255241099", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "07-MAY-2025 15:56:06"}, {"id": "105255241099", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "informed to electrician", "status": "Under Process", "time_stamp": "03-MAY-2025 22:57:49"}], "grievance": {"assigned_to": "AEE/ENG,,Kapra", "complaint_type": "Timer Settings of Street Lights", "id": "105255241099", "land_mark": "Behind SSS Vidyanikethan School", "mobile_number": "9440403737", "officer_remarks": "", "phone_to_call": "7995009082", "photo": "105255241099.jpg p2105255241099.jpg p3105255241099.jpg", "raised_by": "Shiva Prasad", "remarks": "Street lights are glowing up to 9AM", "status": "Attended By Officer", "time_stamp": "01-MAY-2025 07:24:17"}, "photos": [{"name": "105255241099.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241099.jpg"}, {"name": "p2105255241099.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2105255241099.jpg"}, {"name": "p3105255241099.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3105255241099.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241099"} sha256:5750868d34c3b48d300a3bb61234212d215f5052d68607069ebe1d5a207ea22b

Links from other tables