home / aug-2025 / complaint_snapshots

complaint_snapshots: 40

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
40 108255392650 2026-04-15T19:21:07Z https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392650 Repairs to Road (Pot holes) adjusted lane to Taaza Kitchen 7893020370 2025-07-31T21:23:10Z Closed Manne Kishore 3 months back road was digged for rainwater pipe lane and total road is collapsed only one side passege is available.full of potholes even rain water manholes not covered properly. AE/ENG,,Charminar   9063816947 108255392650.jpg p2108255392650.jpg {"comments": [{"id": "108255392650", "mobile_number": "7893020370", "posted_by": "Manne Kishore", "remarks": ".", "status": "Closed", "time_stamp": "13-OCT-2025 22:32:31"}, {"id": "108255392650", "mobile_number": "8790624601", "posted_by": "Sri Jameel", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "13-OCT-2025 21:04:13"}, {"id": "108255392650", "mobile_number": "7893020370", "posted_by": "Manne Kishore", "remarks": "After visiting the CM Sri Revanth Reddy Garu and Sri Ranganathan Garu we have blessed with glossy finished road provided by authorities only the problem is walkers are slipping on the road due to over smooth finishing. Kindly Give a Glance. Shubhodayam.", "status": "Open", "time_stamp": "02-SEP-2025 14:32:36"}, {"id": "108255392650", "mobile_number": "7893020370", "posted_by": "Manne Kishore", "remarks": "Kept Conference with concern officer Sri Jameel ,AE/ENG(8790624601) Officer number is not connected", "status": "Open", "time_stamp": "08-AUG-2025 13:36:34"}, {"id": "108255392650", "mobile_number": "7995009076", "posted_by": "Sri.M.Bharat Kumar", "remarks": "Area pertains to ameerpet ward", "status": "Open", "time_stamp": "01-AUG-2025 06:23:55"}], "grievance": {"assigned_to": "AE/ENG,,Charminar", "complaint_type": "Repairs to Road (Pot holes)", "id": "108255392650", "land_mark": "adjusted lane to Taaza Kitchen", "mobile_number": "7893020370", "officer_remarks": "", "phone_to_call": "9063816947", "photo": "108255392650.jpg p2108255392650.jpg", "raised_by": "Manne Kishore", "remarks": "3 months back road was digged for rainwater pipe lane and total road is collapsed only one side passege is available.full of potholes even rain water manholes not covered properly.", "status": "Closed", "time_stamp": "01-AUG-2025 02:53:10"}, "photos": [{"name": "108255392650.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/108255392650.jpg"}, {"name": "p2108255392650.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2108255392650.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392650"} sha256:0c7f1eea762fbc31dc566e488deb83bc3e3226bd121f1c58ecb4eb4ce39db7b8

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.599ms