complaint_snapshots: 80
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80 | 112255596168 | 2026-04-13T18:45:46Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596168 | Street Sweeping Not Done | Padmarao Nagar SBI Bank Saptagiri p4 lane | 7093900628 | 2025-12-01T02:34:56Z | Closed | Bandaru Deepak | Street sweeping not done since a week | AE,,Goshamahal | 7331189514 | 112255596168.jpg p2112255596168.jpg | {"comments": [{"id": "112255596168", "mobile_number": "7093900628", "posted_by": "Bandaru Deepak", "remarks": "Good", "status": "Closed", "time_stamp": "02-DEC-2025 13:37:31"}, {"id": "112255596168", "mobile_number": "9701365515", "posted_by": "Sri Venkatesh Dy.EE(SWM)", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 13:25:16"}, {"id": "112255596168", "mobile_number": "7093900628", "posted_by": "Bandaru Deepak", "remarks": "The garbage is still there. No one has reached the location nor called me", "status": "Open", "time_stamp": "01-DEC-2025 13:14:01"}, {"id": "112255596168", "mobile_number": "9701365515", "posted_by": "Sri Venkatesh Dy.EE(SWM)", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 13:06:33"}, {"id": "112255596168", "mobile_number": "8712013112", "posted_by": "Sri Kancharla Bhargav, Dy.EE(SWM)", "remarks": "Another circle", "status": "Open", "time_stamp": "01-DEC-2025 08:07:40"}], "grievance": {"assigned_to": "AE,,Goshamahal", "complaint_type": "Street Sweeping Not Done", "id": "112255596168", "land_mark": "Padmarao Nagar SBI Bank Saptagiri p4 lane", "mobile_number": "7093900628", "officer_remarks": "", "phone_to_call": "7331189514", "photo": "112255596168.jpg p2112255596168.jpg", "raised_by": "Bandaru Deepak", "remarks": "Street sweeping not done since a week", "status": "Closed", "time_stamp": "01-DEC-2025 08:04:56"}, "photos": [{"name": "112255596168.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/112255596168.jpg"}, {"name": "p2112255596168.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2112255596168.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596168"} | sha256:e8e56de5e9c724806a570281c9df800d28500032a11854abe4dfa52a63e15d65 |