home / dec-2025 / complaint_snapshots

complaint_snapshots: 50

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
50 112255596137 2026-04-13T18:45:42Z https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596137 Repairs to Foot Path 12-11-391/a warisguda secunderabad beside limra chicken centre 9700165778 2025-12-01T02:04:15Z Closed sk I am writing to bring to your urgent attention the problems caused near our house due to the recent installation of electric poles.During the work the staff left behind mud sand and rocks and the dug-up area was not levelled properly. This has created a pit-like areawhich has made it extremely difficult for us to park our vehicleor safely move in and out of our house.Additionally the open waste area has encouraged nearby people to throw sticks garbage and other waste materials making the situation worse. Because of this accumulated waste we are now facing severe rodent issues rats mice and even bandicoots have started entering our house creating a serious health and hygiene risk for our family.I humbly request you to take immediate action to1. Clear all the mud sand rocks and waste material. 2. Remove the cut fiber wires lying on the ground. 3. Level and restore the area properly. 4. Take necessary measures to prevent further garbage dumping.Your prompt response will be greatly appreciated as the situation is becoming increasingly unsafe for residents.Thanking you AE/ENG,,Masab Tank   9063816963 112255596137.jpg p2112255596137.jpg {"comments": [{"id": "112255596137", "mobile_number": "7995009108", "posted_by": "Sri. Kaushik", "remarks": ".", "status": "Closed", "time_stamp": "05-DEC-2025 15:07:42"}, {"id": "112255596137", "mobile_number": "8712013112", "posted_by": "Sri Kancharla Bhargav, Dy.EE(SWM)", "remarks": "ENGINEERING SECTION ELECTION DEPARTMENT", "status": "Open", "time_stamp": "04-DEC-2025 08:31:20"}, {"id": "112255596137", "mobile_number": "9700165778", "posted_by": "sk", "remarks": "waste still there", "status": "Open", "time_stamp": "03-DEC-2025 17:05:41"}, {"id": "112255596137", "mobile_number": "8712013112", "posted_by": "Sri Kancharla Bhargav, Dy.EE(SWM)", "remarks": "Cleared sorry for the inconveniences", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 13:46:10"}, {"id": "112255596137", "mobile_number": "9381459256", "posted_by": "P.Venkateshwar Goud.", "remarks": "forward", "status": "Open", "time_stamp": "02-DEC-2025 12:15:27"}], "grievance": {"assigned_to": "AE/ENG,,Masab Tank", "complaint_type": "Repairs to Foot Path", "id": "112255596137", "land_mark": "12-11-391/a warisguda secunderabad beside limra chicken centre", "mobile_number": "9700165778", "officer_remarks": "", "phone_to_call": "9063816963", "photo": "112255596137.jpg p2112255596137.jpg", "raised_by": "sk", "remarks": "I am writing to bring to your urgent attention the problems caused near our house due to the recent installation of electric poles.During the work the staff left behind mud sand and rocks and the dug-up area was not levelled properly. This has created a pit-like areawhich has made it extremely difficult for us to park our vehicleor safely move in and out of our house.Additionally the open waste area has encouraged nearby people to throw sticks garbage and other waste materials making the situation worse. Because of this accumulated waste we are now facing severe rodent issues rats mice and even bandicoots have started entering our house creating a serious health and hygiene risk for our family.I humbly request you to take immediate action to1. Clear all the mud sand rocks and waste material. 2. Remove the cut fiber wires lying on the ground. 3. Level and restore the area properly. 4. Take necessary measures to prevent further garbage dumping.Your prompt response will be greatly appreciated as the situation is becoming increasingly unsafe for residents.Thanking you", "status": "Closed", "time_stamp": "01-DEC-2025 07:34:15"}, "photos": [{"name": "112255596137.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/112255596137.jpg"}, {"name": "p2112255596137.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2112255596137.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596137"} sha256:82e9c88630db57d4beb4eab7c8cb67e6af0783ac26420e11caeb9c45f22151ac

Links from other tables

  • 2 rows from snapshot_pk in snapshot_photos
  • 5 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 0.96ms