complaint_snapshots: 54
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 54 | 112255596140 | 2026-04-13T18:45:43Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596140 | Garbage Dump | kalajyoti to rv panchajanya | 9000656507 | 2025-12-01T02:05:47Z | Attended By Officer | remove garbagevpile | piled up near svc and rv | AE,,Falaknuma | 7674919906 | 112255596140.jpg | {"comments": [{"id": "112255596140", "mobile_number": "7997951620", "posted_by": "Serilingampally", "remarks": "attend", "status": "Attended By Officer", "time_stamp": "15-DEC-2025 10:05:27"}, {"id": "112255596140", "mobile_number": "8125218065", "posted_by": "Dr. Srikanth Reddy", "remarks": "garbage", "status": "Open", "time_stamp": "12-DEC-2025 07:06:20"}, {"id": "112255596140", "mobile_number": "9000656507", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "11-DEC-2025 14:09:34"}, {"id": "112255596140", "mobile_number": "7997951620", "posted_by": "Serilingampally", "remarks": "attend", "status": "Attended By Officer", "time_stamp": "10-DEC-2025 19:00:31"}, {"id": "112255596140", "mobile_number": "8125218065", "posted_by": "Dr. Srikanth Reddy", "remarks": "garbage", "status": "Open", "time_stamp": "03-DEC-2025 10:39:52"}, {"id": "112255596140", "mobile_number": "9000656507", "posted_by": "remove garbagevpile", "remarks": "Did not clear", "status": "Open", "time_stamp": "03-DEC-2025 10:31:49"}, {"id": "112255596140", "mobile_number": "7997951620", "posted_by": "Serilingampally", "remarks": "attend", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 09:24:26"}, {"id": "112255596140", "mobile_number": "8125218065", "posted_by": "Dr. Srikanth Reddy", "remarks": "garbage", "status": "Open", "time_stamp": "01-DEC-2025 08:55:12"}], "grievance": {"assigned_to": "AE,,Falaknuma", "complaint_type": "Garbage Dump", "id": "112255596140", "land_mark": "kalajyoti to rv panchajanya", "mobile_number": "9000656507", "officer_remarks": "", "phone_to_call": "7674919906", "photo": "112255596140.jpg", "raised_by": "remove garbagevpile", "remarks": "piled up near svc and rv", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 07:35:47"}, "photos": [{"name": "112255596140.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/112255596140.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596140"} | sha256:1f608646bf24a2bbe4bf8b886738ee40b571bf385bf1c0452e8341508f5c571a |