complaint_snapshots: 64
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64 | 110255503134 | 2026-04-15T13:17:27Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503134 | Water logging | NRp colony | 9059631654 | 2025-10-01T02:06:42Z | Attended By Officer | Sandhya rani | our road is full of mud and sand is there..due to this water is stagnating on road.. | AE/ENG,,Attapur | 7337557239 | 110255503134.jpg p2110255503134.jpg p3110255503134.jpg | {"comments": [{"id": "110255503134", "mobile_number": "7337367271", "posted_by": "Sri Y.Shiva kumar", "remarks": "Sir, Complaint will be resolved soon.", "status": "Attended By Officer", "time_stamp": "16-OCT-2025 11:11:42"}, {"id": "110255503134", "mobile_number": "9133471055", "posted_by": "Sri. N. Venkatesh", "remarks": "please do the needful", "status": "Open", "time_stamp": "14-OCT-2025 17:41:11"}, {"id": "110255503134", "mobile_number": "7337367271", "posted_by": "Sri Y.Shiva kumar", "remarks": "dear citizen please contact hmws manager for this drainage related issue pl", "status": "Open", "time_stamp": "11-OCT-2025 10:34:29"}, {"id": "110255503134", "mobile_number": "9133471055", "posted_by": "Sri. N. Venkatesh", "remarks": "please do the needful", "status": "Open", "time_stamp": "11-OCT-2025 07:00:30"}, {"id": "110255503134", "mobile_number": "9885198396", "posted_by": "Dr. Vijay Mohan Rao", "remarks": "drinage owerflow", "status": "Open", "time_stamp": "10-OCT-2025 07:30:05"}, {"id": "110255503134", "mobile_number": "7337367271", "posted_by": "Sri Y.Shiva kumar", "remarks": "sir, / mdm Contact to Sanitation wing.", "status": "Open", "time_stamp": "09-OCT-2025 13:46:01"}, {"id": "110255503134", "mobile_number": "9133471055", "posted_by": "Sri. N. Venkatesh", "remarks": "please do the needful", "status": "Open", "time_stamp": "06-OCT-2025 11:28:40"}, {"id": "110255503134", "mobile_number": "9885198396", "posted_by": "Dr. Vijay Mohan Rao", "remarks": "drinage owerflow", "status": "Open", "time_stamp": "06-OCT-2025 08:04:12"}], "grievance": {"assigned_to": "AE/ENG,,Attapur", "complaint_type": "Water logging", "id": "110255503134", "land_mark": "NRp colony", "mobile_number": "9059631654", "officer_remarks": "", "phone_to_call": "7337557239", "photo": "110255503134.jpg p2110255503134.jpg p3110255503134.jpg", "raised_by": "Sandhya rani", "remarks": "our road is full of mud and sand is there..due to this water is stagnating on road..", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 07:36:42"}, "photos": [{"name": "110255503134.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503134.jpg"}, {"name": "p2110255503134.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503134.jpg"}, {"name": "p3110255503134.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3110255503134.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503134"} | sha256:c76eedcf6092dacead05fdb83c8afab3f4b953436b6db3af9a212769b3adc1f8 |