complaint_snapshots: 46
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46 | 107255337701 | 2026-04-15T21:46:23Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337701 | Tree fall | NERA BY SHIVAM TEMPLE LANE | 9908021829 | 2025-07-01T00:22:04Z | Closed | shiva kumar | Citizen Complained regarding Tree fallen at,MANGIRA HOSTEL, NERA BY SHIVAM TEMPLE LANE,Tarnaka | - | {"comments": [{"id": "107255337701", "mobile_number": "9908021829", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "12-OCT-2025 09:47:47"}, {"id": "107255337701", "mobile_number": "6309919070", "posted_by": "DRF TEAM", "remarks": "cleared", "status": "Attended By Officer", "time_stamp": "11-OCT-2025 14:20:52"}, {"id": "107255337701", "mobile_number": "9505107172", "posted_by": "Maheshwari", "remarks": "DRF", "status": "Open", "time_stamp": "02-JUL-2025 18:14:37"}], "grievance": {"assigned_to": "-", "complaint_type": "Tree fall", "id": "107255337701", "land_mark": "NERA BY SHIVAM TEMPLE LANE", "mobile_number": "9908021829", "officer_remarks": "", "photo": "", "raised_by": "shiva kumar", "remarks": "Citizen Complained regarding Tree fallen at,MANGIRA HOSTEL, NERA BY SHIVAM TEMPLE LANE,Tarnaka", "status": "Closed", "time_stamp": "01-JUL-2025 05:52:04"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337701"} | sha256:5e899f9d9552f9a5475412137e107e875d426d8b9bc69ca03f85b542e73b9737 |