complaint_snapshots: 98
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 98 | 107255337753 | 2026-04-15T21:46:30Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337753 | Fallen Tree Branch | TKR CAMMAN | 9951288530 | 2025-07-01T02:13:08Z | Closed | Sharath Chandra | Tree branches fell on middle of the road in Rajeev shetty nagar road number -4 causing problem to commuters and the road got blocked. | UBD Manager,,Kapra | 6302963065 | 107255337753.jpg p2107255337753.jpg | {"comments": [{"id": "107255337753", "mobile_number": "9951288530", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "09-JUL-2025 14:31:04"}, {"id": "107255337753", "mobile_number": "9866309144", "posted_by": "Sri. A.Srinivasa Chary", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "06-JUL-2025 07:46:16"}, {"id": "107255337753", "mobile_number": "9951288530", "posted_by": "Sharath Chandra", "remarks": "Hello sir, Please clear the tree branches (Remainder)", "status": "Open", "time_stamp": "02-JUL-2025 18:53:27"}], "grievance": {"assigned_to": "UBD Manager,,Kapra", "complaint_type": "Fallen Tree Branch", "id": "107255337753", "land_mark": "TKR CAMMAN", "mobile_number": "9951288530", "officer_remarks": "", "phone_to_call": "6302963065", "photo": "107255337753.jpg p2107255337753.jpg", "raised_by": "Sharath Chandra", "remarks": "Tree branches fell on middle of the road in Rajeev shetty nagar road number -4 causing problem to commuters and the road got blocked.", "status": "Closed", "time_stamp": "01-JUL-2025 07:43:08"}, "photos": [{"name": "107255337753.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337753.jpg"}, {"name": "p2107255337753.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2107255337753.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337753"} | sha256:afd1b36799cc152eb6931c49a2f0a04c88e23cbf9da3e65e39d6798ec1fe3442 |