complaint_snapshots: 22
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22 | 112255596109 | 2026-04-13T18:45:39Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596109 | Garbage Vehicle Not Arrived (SAT) | Bus stand | 9494566137 | 2025-12-01T00:44:40Z | Closed | A. Srikanth goud | My name is srikanth. Please sanction the bill | DEE,,Moosarambagh | 7995007375 | 112255596109.jpg | {"comments": [{"id": "112255596109", "mobile_number": "9494566137", "posted_by": "A. Srikanth goud", "remarks": "This is the issue of 2016 did not resolved", "status": "Closed", "time_stamp": "04-DEC-2025 05:11:43"}, {"id": "112255596109", "mobile_number": "9154931422", "posted_by": "Dr.Chandra Shekar", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "03-DEC-2025 13:32:08"}, {"id": "112255596109", "mobile_number": "9704456422", "posted_by": "Sri. S . Srinivas", "remarks": "SAT EMI complaint", "status": "Open", "time_stamp": "01-DEC-2025 08:16:04"}], "grievance": {"assigned_to": "DEE,,Moosarambagh", "complaint_type": "Garbage Vehicle Not Arrived (SAT)", "id": "112255596109", "land_mark": "Bus stand", "mobile_number": "9494566137", "officer_remarks": "", "phone_to_call": "7995007375", "photo": "112255596109.jpg", "raised_by": "A. Srikanth goud", "remarks": "My name is srikanth. Please sanction the bill", "status": "Closed", "time_stamp": "01-DEC-2025 06:14:40"}, "photos": [{"name": "112255596109.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/112255596109.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596109"} | sha256:7f87a0a306bd95f1f4de8f04601c37b9ee0c9c5506777f8351b51b66c3f6edcd |