complaint_snapshots: 32
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32 | 112255596119 | 2026-04-13T18:45:40Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596119 | Street Sweeping Not Done | Sai Baba | 7842136224 | 2025-12-01T01:27:49Z | Closed | Shruthi | There is no sweeping in the colony not even one in a week..People clean only when complained else no one cares...see how bad the roads are | AE,,Boduppal | 7995007379 | {"comments": [{"id": "112255596119", "mobile_number": "7842136224", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "08-DEC-2025 15:40:30"}, {"id": "112255596119", "mobile_number": "7337364206", "posted_by": "Sai Tharun DYEE(SWM)", "remarks": "Complete Attend", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 09:02:10"}], "grievance": {"assigned_to": "AE,,Boduppal", "complaint_type": "Street Sweeping Not Done", "id": "112255596119", "land_mark": "Sai Baba", "mobile_number": "7842136224", "officer_remarks": "", "phone_to_call": "7995007379", "photo": "", "raised_by": "Shruthi", "remarks": "There is no sweeping in the colony not even one in a week..People clean only when complained else no one cares...see how bad the roads are", "status": "Closed", "time_stamp": "01-DEC-2025 06:57:49"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596119"} | sha256:f00bb9ef7f567a567367fa1ef9a2f0232f8d9cdcea230af454601a3440bfc6a2 |