home / jun-2025 / complaint_snapshots

complaint_snapshots: 32

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
32 106255287926 2026-04-16T18:23:29Z https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287926 Non Glowing of Street Lights Ayodhya nagar colony pillar no 28 Gumbad masjid 9705252127 2025-05-31T21:35:40Z Closed SamreenFatima NO STREET LIGHTS IN THE WHOLE LANE. kids and adults cant go outside after 6pm. Anti social elements creating nuisance due to extreme dark. Dogs creating trouble because of darkness. we fear for out safety. PLEASE FIX THE STREET LIGHT PROBLEM. AE/ENG,,Chandrayangutta   7995007382 106255287926.jpg p2106255287926.jpg p3106255287926.jpg {"comments": [{"id": "106255287926", "mobile_number": "9705252127", "posted_by": "SamreenFatima", "remarks": "Attended the non glowing of street light grievance they just came have a talk with us and said that they could not repair the street light as they dont have ladder and asking us for ladder they didnot even bother to solve our isssue and two persons left whole lane is dark at night please take serious action regarding our grievance we couldnot come out of our house after 7", "status": "Closed", "time_stamp": "05-JUN-2025 11:57:41"}, {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "tree cutting", "status": "Attended By Officer", "time_stamp": "03-JUN-2025 15:54:46"}, {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "transfer", "status": "Open", "time_stamp": "02-JUN-2025 15:21:21"}, {"id": "106255287926", "mobile_number": "9705252127", "posted_by": "SamreenFatima", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "02-JUN-2025 15:18:53"}, {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "pertain to Mehdipatnam", "status": "Open", "time_stamp": "02-JUN-2025 10:54:08"}, {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "02-JUN-2025 10:53:21"}], "grievance": {"assigned_to": "AE/ENG,,Chandrayangutta", "complaint_type": "Non Glowing of Street Lights", "id": "106255287926", "land_mark": "Ayodhya nagar colony pillar no 28 Gumbad masjid", "mobile_number": "9705252127", "officer_remarks": "", "phone_to_call": "7995007382", "photo": "106255287926.jpg p2106255287926.jpg p3106255287926.jpg", "raised_by": "SamreenFatima", "remarks": "NO STREET LIGHTS IN THE WHOLE LANE. kids and adults cant go outside after 6pm. Anti social elements creating nuisance due to extreme dark. Dogs creating trouble because of darkness. we fear for out safety. PLEASE FIX THE STREET LIGHT PROBLEM.", "status": "Closed", "time_stamp": "01-JUN-2025 03:05:40"}, "photos": [{"name": "106255287926.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287926.jpg"}, {"name": "p2106255287926.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2106255287926.jpg"}, {"name": "p3106255287926.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3106255287926.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287926"} sha256:ab2da5018ce054263bd77baabd8ee08882d75317453ba7a6375a6b271430b055

Links from other tables

  • 3 rows from snapshot_pk in snapshot_photos
  • 6 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.865ms