complaint_snapshots: 88

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
88 110255503158 2026-04-15T13:17:30Z https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503158 HMWSSB bathukamma pond corner 8639022501 2025-10-01T02:47:52Z Closed M J Srihari This Is Drainage Dump. One Kid Fell Into This Today.. Pls Get This Cleaned ASAP.. Many People Come For Walking Here -     110255503158.jpg p2110255503158.jpg {"comments": [{"id": "110255503158", "mobile_number": "9247540142", "posted_by": "Sanchit Gangwar, IAS", "remarks": "na", "status": "Closed", "time_stamp": "24-MAR-2026 12:33:10"}, {"id": "110255503158", "mobile_number": "7331189482", "posted_by": "G.Asha", "remarks": "Hmwssb", "status": "Open", "time_stamp": "03-OCT-2025 23:40:12"}, {"id": "110255503158", "mobile_number": "8712419174", "posted_by": "C. Shiva Prasad", "remarks": "119 ward", "status": "Open", "time_stamp": "01-OCT-2025 09:13:10"}], "grievance": {"assigned_to": "-", "complaint_type": "HMWSSB", "id": "110255503158", "land_mark": "bathukamma pond corner", "mobile_number": "8639022501", "officer_remarks": "", "photo": "110255503158.jpg p2110255503158.jpg", "raised_by": "M J Srihari", "remarks": "This Is Drainage Dump. One Kid Fell Into This Today.. Pls Get This Cleaned ASAP.. Many People Come For Walking Here", "status": "Closed", "time_stamp": "01-OCT-2025 08:17:52"}, "photos": [{"name": "110255503158.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503158.jpg"}, {"name": "p2110255503158.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503158.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503158"} sha256:5038bc4eb079a7787677ccaec5e830b59763015776e36521ae6c225f42bc9f56

Links from other tables