complaint_snapshots: 42

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
42 109255451052 2026-04-15T15:19:03Z https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451052 Mosquitoes Fogging Required Singareni officers colony ,IS sadan ward,38Santhosh nagar circle,Road number 217-1-391/s/209 9989624364 2025-09-01T01:31:46Z Closed Ravikanth required mosquitoes fogging Ward Entomology Supervisor,,Uppal   9640064614 109255451052.jpg {"comments": [{"id": "109255451052", "mobile_number": "9989624364", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "24-SEP-2025 15:26:56"}, {"id": "109255451052", "mobile_number": "8008060371", "posted_by": "Sri. M.Srinivas", "remarks": "Circle 7 Complaint", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 08:20:34"}, {"id": "109255451052", "mobile_number": "9989930527", "posted_by": "D.Meneamma", "remarks": "santhosh Nagar", "status": "Open", "time_stamp": "02-SEP-2025 18:01:19"}], "grievance": {"assigned_to": "Ward Entomology Supervisor,,Uppal", "complaint_type": "Mosquitoes Fogging Required", "id": "109255451052", "land_mark": "Singareni officers colony ,IS sadan ward,38Santhosh nagar circle,Road number 217-1-391/s/209", "mobile_number": "9989624364", "officer_remarks": "", "phone_to_call": "9640064614", "photo": "109255451052.jpg", "raised_by": "Ravikanth", "remarks": "required mosquitoes fogging", "status": "Closed", "time_stamp": "01-SEP-2025 07:01:46"}, "photos": [{"name": "109255451052.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/109255451052.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451052"} sha256:98181ac441b9646af2e842a5cba76508f39d98b403aa6aaa2d17fc36aa3a0599

Links from other tables