complaint_snapshots: 34

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
34 107255337689 2026-04-15T21:46:22Z https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337689 Non Glowing of Street Lights Shama talkies X road 7659014351 2025-06-30T20:56:39Z Attended By Officer mohd Nawaz please make sure of switch AE/ENG,,Adibatla   9581004920 107255337689.jpg p2107255337689.jpg p3107255337689.jpg {"comments": [{"id": "107255337689", "mobile_number": "9154369423", "posted_by": "M.satyanarayana Reddy", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "26-JUL-2025 08:02:55"}, {"id": "107255337689", "mobile_number": "9704234838", "posted_by": "M Satya Narayana Reddy", "remarks": "belongs to falaknama", "status": "Open", "time_stamp": "01-JUL-2025 09:02:08"}], "grievance": {"assigned_to": "AE/ENG,,Adibatla", "complaint_type": "Non Glowing of Street Lights", "id": "107255337689", "land_mark": "Shama talkies X road", "mobile_number": "7659014351", "officer_remarks": "", "phone_to_call": "9581004920", "photo": "107255337689.jpg p2107255337689.jpg p3107255337689.jpg", "raised_by": "mohd Nawaz", "remarks": "please make sure of switch", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 02:26:39"}, "photos": [{"name": "107255337689.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337689.jpg"}, {"name": "p2107255337689.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2107255337689.jpg"}, {"name": "p3107255337689.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3107255337689.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337689"} sha256:5c6344cb3f74063a269fe15fc3ad60e6dd8e7831fde748dab05523ff585475a7

Links from other tables