home / dec-2025 / complaint_snapshots

complaint_snapshots: 38

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
38 112255596125 2026-04-13T18:45:41Z https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596125 Branch Pruning Beside SBI, Bhaskar Rao Nagar 8919171597 2025-12-01T01:45:43Z Closed Venugopal Park Branches entered to our flat.Branch Pruning required UBD Manager,,Keesara   6302963065 112255596125.jpg p2112255596125.jpg p3112255596125.jpg {"comments": [{"id": "112255596125", "mobile_number": "8019918839", "posted_by": "Sri S Lokesh Kumar", "remarks": "tgspdcl electrical wing", "status": "Closed", "time_stamp": "17-DEC-2025 07:21:19"}], "grievance": {"assigned_to": "UBD Manager,,Keesara", "complaint_type": "Branch Pruning", "id": "112255596125", "land_mark": "Beside SBI, Bhaskar Rao Nagar", "mobile_number": "8919171597", "officer_remarks": "", "phone_to_call": "6302963065", "photo": "112255596125.jpg p2112255596125.jpg p3112255596125.jpg", "raised_by": "Venugopal", "remarks": "Park Branches entered to our flat.Branch Pruning required", "status": "Closed", "time_stamp": "01-DEC-2025 07:15:43"}, "photos": [{"name": "112255596125.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/112255596125.jpg"}, {"name": "p2112255596125.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2112255596125.jpg"}, {"name": "p3112255596125.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3112255596125.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596125"} sha256:8e82f2ff20a237a14ca4647f64d982037d05620d31f50bb70abf74bc0d0c9c5d

Links from other tables

  • 3 rows from snapshot_pk in snapshot_photos
  • 1 row from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.34ms