complaint_snapshots: 27
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27 | 110255503097 | 2026-04-15T13:17:23Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503097 | Dustbin Not Cleared | Amazon -13 Near Gate-5 | 7842547676 | 2025-09-30T23:31:13Z | Closed | Amazon | Need to be clean garbage | AE,,Falaknuma | 7674919906 | 110255503097.jpg | {"comments": [{"id": "110255503097", "mobile_number": "7842547676", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "27-OCT-2025 14:25:34"}, {"id": "110255503097", "mobile_number": "7997951620", "posted_by": "Serilingampally", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 07:31:19"}], "grievance": {"assigned_to": "AE,,Falaknuma", "complaint_type": "Dustbin Not Cleared", "id": "110255503097", "land_mark": "Amazon -13 Near Gate-5", "mobile_number": "7842547676", "officer_remarks": "", "phone_to_call": "7674919906", "photo": "110255503097.jpg", "raised_by": "Amazon", "remarks": "Need to be clean garbage", "status": "Closed", "time_stamp": "01-OCT-2025 05:01:13"}, "photos": [{"name": "110255503097.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503097.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503097"} | sha256:f9a9d256fc0acd02836c2a5db5868e44413bbde9449e6ffa6621660c404bf376 |