home / apr-2025 / complaint_snapshots

complaint_snapshots: 98

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
98 104255188680 2026-04-18T08:22:34Z https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188680 Street Lights Glowing Continuously royal nandanam, madhava hills 2 8919656770 2025-04-01T02:40:10Z Attended By Officer lavakumarreddy street lights were still turned on at 720 Am AE/ENG,,Falaknuma   9398662957 104255188680.jpg p2104255188680.jpg {"comments": [{"id": "104255188680", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "27-APR-2025 11:39:55"}, {"id": "104255188680", "mobile_number": "9154369439", "posted_by": "G Likhitha", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "04-APR-2025 11:16:19"}], "grievance": {"assigned_to": "AE/ENG,,Falaknuma", "complaint_type": "Street Lights Glowing Continuously", "id": "104255188680", "land_mark": "royal nandanam, madhava hills 2", "mobile_number": "8919656770", "officer_remarks": "", "phone_to_call": "9398662957", "photo": "104255188680.jpg p2104255188680.jpg", "raised_by": "lavakumarreddy", "remarks": "street lights were still turned on at 720 Am", "status": "Attended By Officer", "time_stamp": "01-APR-2025 08:10:10"}, "photos": [{"name": "104255188680.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/104255188680.jpg"}, {"name": "p2104255188680.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2104255188680.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188680"} sha256:550ed402a403a48eae3d7746d3fa6768d14f86d40bbcc4efb038a21a18305608

Links from other tables

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