home / jan-2026 / complaint_snapshots

complaint_snapshots: 34

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
34 101265640125 2026-04-13T10:17:25Z https://igs.ghmc.gov.in/Operator/Status?cpno=0101265640125 Footpath Blocked Road Number 1,KPHB COLONY, AED HOSPITAL 9553312464 2026-01-01T02:05:04Z Closed Jagadeesh Kumar entire footpath blocked and occupied as car parking for their premises earlier also completed but no response not only this hospital all car decoration shops like this there is no route to walking for travellers and they were painted for car parking lines also here I am attaching photos also.. please resolve the problem officers ACP,,Kukatpally   8328385936 101265640125.jpg p2101265640125.jpg {"comments": [{"id": "101265640125", "mobile_number": "9553312464", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "08-MAR-2026 10:48:22"}, {"id": "101265640125", "mobile_number": "8328385936", "posted_by": "KARUNAKER", "remarks": "Encroachment drives will be conducted with the coordination of traffic police department", "status": "Attended By Officer", "time_stamp": "07-MAR-2026 14:44:21"}, {"id": "101265640125", "mobile_number": "9553312464", "posted_by": "Jagadeesh Kumar", "remarks": "why delay sir", "status": "Open", "time_stamp": "16-JAN-2026 23:29:16"}, {"id": "101265640125", "mobile_number": "9553312464", "posted_by": "Jagadeesh Kumar", "remarks": "how many days required to resolve..", "status": "Open", "time_stamp": "08-JAN-2026 19:54:41"}, {"id": "101265640125", "mobile_number": "9553312464", "posted_by": "Jagadeesh Kumar", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.y action.Thank you sir.", "status": "Open", "time_stamp": "06-JAN-2026 20:06:57"}], "grievance": {"assigned_to": "ACP,,Kukatpally", "complaint_type": "Footpath Blocked", "id": "101265640125", "land_mark": "Road Number 1,KPHB COLONY, AED HOSPITAL", "mobile_number": "9553312464", "officer_remarks": "", "phone_to_call": "8328385936", "photo": "101265640125.jpg p2101265640125.jpg", "raised_by": "Jagadeesh Kumar", "remarks": "entire footpath blocked and occupied as car parking for their premises earlier also completed but no response not only this hospital all car decoration shops like this there is no route to walking for travellers and they were painted for car parking lines also here I am attaching photos also.. please resolve the problem officers", "status": "Closed", "time_stamp": "01-JAN-2026 07:35:04"}, "photos": [{"name": "101265640125.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/101265640125.jpg"}, {"name": "p2101265640125.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2101265640125.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0101265640125"} sha256:f1ecde34585793928ca8e880a7480fcc929e385ec453a341f5b8760d71bb0380

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 1.327ms