complaint_snapshots: 102
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102 | 101265640200 | 2026-04-13T10:17:47Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0101265640200 | Unauthorized Hoardings | matrusrinagar | 9963152244 | 2026-01-01T04:19:52Z | Attended By Officer | anil | near SBI bank | AMC,,Miyapur | 9989930654 | 101265640200.jpg | {"comments": [{"id": "101265640200", "mobile_number": "9989930654", "posted_by": "K. Bikshapathi", "remarks": "Concerned Madhapur Circle", "status": "Attended By Officer", "time_stamp": "22-MAR-2026 11:33:08"}, {"id": "101265640200", "mobile_number": "7702522448", "posted_by": "U. Venkatramulu", "remarks": "concern", "status": "Open", "time_stamp": "24-JAN-2026 14:49:46"}, {"id": "101265640200", "mobile_number": "7702522448", "posted_by": "U. Venkatramulu", "remarks": "concern", "status": "Open", "time_stamp": "24-JAN-2026 14:48:56"}, {"id": "101265640200", "mobile_number": "7702522448", "posted_by": "1. U. Venkatramulu, AMC", "remarks": "forwarded to concern", "status": "Open", "time_stamp": "24-JAN-2026 14:02:59"}, {"id": "101265640200", "mobile_number": "9040480817", "posted_by": "Sri S Chandra Prakash", "remarks": "under process", "status": "Under Process", "time_stamp": "05-JAN-2026 12:47:18"}], "grievance": {"assigned_to": "AMC,,Miyapur", "complaint_type": "Unauthorized Hoardings", "id": "101265640200", "land_mark": "matrusrinagar", "mobile_number": "9963152244", "officer_remarks": "", "phone_to_call": "9989930654", "photo": "101265640200.jpg", "raised_by": "anil", "remarks": "near SBI bank", "status": "Attended By Officer", "time_stamp": "01-JAN-2026 09:49:52"}, "photos": [{"name": "101265640200.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/101265640200.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0101265640200"} | sha256:ced756ac9c95bc87b7ee1d51ebf868c65f4b841a9ee29244221db0ca009e6f1a |