complaint_snapshots: 41
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 41 | 111255552191 | 2026-04-15T10:59:11Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552191 | Garbage Vehicle Not Arrived (SAT) | Road Turning point near Narayana School | 9395584129 | 2025-11-01T00:45:41Z | Attended By Officer | B S REDDY | Respected Sir/Madam Garbage lifting by Ramke vehicles at midnight near the turnpoint beside Narayana School is proving ineffective as fresh waste from Preciousday accumulates by then. Kindly reschedule lifting to midday for better hygiene and timely clearance. Notably the vehicle did not lift last night. Immediate action is requested. | AE,,Ghatkesar | 8712034404 | 111255552191.jpg | {"comments": [{"id": "111255552191", "mobile_number": "7337364206", "posted_by": "Sai Tharun DYEE(SWM)", "remarks": "cleared", "status": "Attended By Officer", "time_stamp": "09-NOV-2025 12:16:24"}, {"id": "111255552191", "mobile_number": "9395584129", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "08-NOV-2025 15:58:03"}, {"id": "111255552191", "mobile_number": "7337364206", "posted_by": "Sai Tharun DYEE(SWM)", "remarks": "cleared", "status": "Attended By Officer", "time_stamp": "03-NOV-2025 08:45:27"}], "grievance": {"assigned_to": "AE,,Ghatkesar", "complaint_type": "Garbage Vehicle Not Arrived (SAT)", "id": "111255552191", "land_mark": "Road Turning point near Narayana School", "mobile_number": "9395584129", "officer_remarks": "", "phone_to_call": "8712034404", "photo": "111255552191.jpg", "raised_by": "B S REDDY", "remarks": "Respected Sir/Madam Garbage lifting by Ramke vehicles at midnight near the turnpoint beside Narayana School is proving ineffective as fresh waste from Preciousday accumulates by then. Kindly reschedule lifting to midday for better hygiene and timely clearance. Notably the vehicle did not lift last night. Immediate action is requested.", "status": "Attended By Officer", "time_stamp": "01-NOV-2025 06:15:41"}, "photos": [{"name": "111255552191.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/111255552191.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552191"} | sha256:6ecc8567fac6175f8642d1871a01d2398571d8073b6338ee7cd48cdf79e493c8 |