complaint_snapshots: 68

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
68 112255596154 2026-04-13T18:45:44Z https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596154 Garbage Dump eseva road rtc colony Ramanthapur hyderabad 9949910462 2025-12-01T02:19:48Z Closed Ebenezer p garbage is dumping as a like and not lifting timely AE,,Ghatkesar   8712034404 112255596154.jpg p2112255596154.jpg p3112255596154.jpg {"comments": [{"id": "112255596154", "mobile_number": "9949910462", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "02-DEC-2025 14:29:44"}, {"id": "112255596154", "mobile_number": "9948963533", "posted_by": "D. CHANDRAKANTH", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 08:51:16"}], "grievance": {"assigned_to": "AE,,Ghatkesar", "complaint_type": "Garbage Dump", "id": "112255596154", "land_mark": "eseva road rtc colony Ramanthapur hyderabad", "mobile_number": "9949910462", "officer_remarks": "", "phone_to_call": "8712034404", "photo": "112255596154.jpg p2112255596154.jpg p3112255596154.jpg", "raised_by": "Ebenezer p", "remarks": "garbage is dumping as a like and not lifting timely", "status": "Closed", "time_stamp": "01-DEC-2025 07:49:48"}, "photos": [{"name": "112255596154.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/112255596154.jpg"}, {"name": "p2112255596154.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2112255596154.jpg"}, {"name": "p3112255596154.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3112255596154.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596154"} sha256:2f5733f480f48384e5f0b5906e6e9efac4e98d2ce60411cea41741c9310135bc

Links from other tables