complaint_snapshots: 58

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
58 101255052479 2026-04-22T08:06:17Z https://igs.ghmc.gov.in/Operator/Status?cpno=0101255052479 Repairs to Foot Path sainathpuram park 8099466077 2025-01-01T02:33:14Z Attended By Officer praveen remove benches near children play area-null AE/ENG,,Karwan   7995007400 101255052479.jpg p2101255052479.jpg {"comments": [{"id": "101255052479", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "24-JAN-2025 15:12:10"}, {"id": "101255052479", "mobile_number": "7337557278", "posted_by": "Kum. M. Madhuirima", "remarks": "sir partains horticulture", "status": "Attended By Officer", "time_stamp": "22-JAN-2025 23:57:36"}, {"id": "101255052479", "mobile_number": "9505107172", "posted_by": "Maheshwari", "remarks": "engineering", "status": "Open", "time_stamp": "10-JAN-2025 13:41:08"}], "grievance": {"assigned_to": "AE/ENG,,Karwan", "complaint_type": "Repairs to Foot Path", "id": "101255052479", "land_mark": "sainathpuram park", "mobile_number": "8099466077", "officer_remarks": "", "phone_to_call": "7995007400", "photo": "101255052479.jpg p2101255052479.jpg", "raised_by": "praveen", "remarks": "remove benches near children play area-null", "status": "Attended By Officer", "time_stamp": "01-JAN-2025 08:03:14"}, "photos": [{"name": "101255052479.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/101255052479.jpg"}, {"name": "p2101255052479.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2101255052479.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0101255052479"} sha256:511f0e563c6d841fb10730d8db18090bd5e9df7180dfc7a54c0ec9a8c86585b2

Links from other tables