complaint_snapshots: 36
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36 | 109255451046 | 2026-04-15T15:19:02Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451046 | Overflowing of Nala / Drain | in front of Childrens park Singareni Colony | 9848043148 | 2025-09-01T01:19:41Z | Attended By Officer | Md Abdul Mutalib | water overflowing | AE/ENG,,LB Nagar | 8074014276 | 109255451046.jpg p2109255451046.jpg | {"comments": [{"id": "109255451046", "mobile_number": "9398508101", "posted_by": "Smt. N. Shireesha", "remarks": "resolved", "status": "Attended By Officer", "time_stamp": "08-SEP-2025 13:17:18"}, {"id": "109255451046", "mobile_number": "7995009122", "posted_by": "VIJAY", "remarks": "pertaining to IS sadan ward", "status": "Open", "time_stamp": "01-SEP-2025 07:05:53"}], "grievance": {"assigned_to": "AE/ENG,,LB Nagar", "complaint_type": "Overflowing of Nala / Drain", "id": "109255451046", "land_mark": "in front of Childrens park Singareni Colony", "mobile_number": "9848043148", "officer_remarks": "", "phone_to_call": "8074014276", "photo": "109255451046.jpg p2109255451046.jpg", "raised_by": "Md Abdul Mutalib", "remarks": "water overflowing", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 06:49:41"}, "photos": [{"name": "109255451046.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/109255451046.jpg"}, {"name": "p2109255451046.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2109255451046.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451046"} | sha256:838cfa255b6d3c659203e4b252484444a3ff42447590cbd2b29201b7e9ec5c47 |