complaint_snapshots: 21

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
21 109255451030 2026-04-15T15:19:00Z https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451030 Bulk garbage dumps on roads Back Side of Savera function hall 7386611173 2025-08-31T21:11:21Z Closed Mohammad Haneef Ur Rahaman Wastage of Garbage Dump DEE,,Moosarambagh   7995007375 109255451030.jpg p2109255451030.jpg p3109255451030.jpg {"comments": [{"id": "109255451030", "mobile_number": "7386611173", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "13-SEP-2025 15:27:54"}, {"id": "109255451030", "mobile_number": "9866505931", "posted_by": "M. Vijay Kumar", "remarks": "grabage", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 08:25:44"}], "grievance": {"assigned_to": "DEE,,Moosarambagh", "complaint_type": "Bulk garbage dumps on roads", "id": "109255451030", "land_mark": "Back Side of Savera function hall", "mobile_number": "7386611173", "officer_remarks": "", "phone_to_call": "7995007375", "photo": "109255451030.jpg p2109255451030.jpg p3109255451030.jpg", "raised_by": "Mohammad Haneef Ur Rahaman", "remarks": "Wastage of Garbage Dump", "status": "Closed", "time_stamp": "01-SEP-2025 02:41:21"}, "photos": [{"name": "109255451030.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/109255451030.jpg"}, {"name": "p2109255451030.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2109255451030.jpg"}, {"name": "p3109255451030.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3109255451030.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451030"} sha256:bea3a4a175d658fde98be001452a213eec80fc39c6e683170f9e6c02d07f404a

Links from other tables