complaint_snapshots: 38
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 38 | 111255552188 | 2026-04-15T10:59:11Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552188 | Dumping of un-authorized debris | Next to Vasavi Brindavanam Erragadda | 9701790703 | 2025-11-01T00:31:52Z | Closed | HanumanthaRao | Midnight dumping of some sort of debris disturbing many residents on daily basis Brigade and Vasavi are impacted. unacceptable midnight and early morning noise and dumping | AE,,Charminar | 9063816946 | 111255552188.jpg | {"comments": [{"id": "111255552188", "mobile_number": "9701790703", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "16-NOV-2025 14:43:53"}, {"id": "111255552188", "mobile_number": "9866505931", "posted_by": "M. Vijay Kumar", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-NOV-2025 07:17:04"}], "grievance": {"assigned_to": "AE,,Charminar", "complaint_type": "Dumping of un-authorized debris", "id": "111255552188", "land_mark": "Next to Vasavi Brindavanam Erragadda", "mobile_number": "9701790703", "officer_remarks": "", "phone_to_call": "9063816946", "photo": "111255552188.jpg", "raised_by": "HanumanthaRao", "remarks": "Midnight dumping of some sort of debris disturbing many residents on daily basis Brigade and Vasavi are impacted. unacceptable midnight and early morning noise and dumping", "status": "Closed", "time_stamp": "01-NOV-2025 06:01:52"}, "photos": [{"name": "111255552188.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/111255552188.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552188"} | sha256:27555c7d29d44c8f8f956b22b63500d42e0856269f3d6437737d51a98eef2f9a |