home / feb-2025 / complaint_snapshots

complaint_snapshots: 63

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
63 102255097148 2026-04-21T22:43:09Z https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097148 Repairs to Road (Pot holes) Vysya bank colony hasmathpet old Bowenpally 8885440475 2025-02-01T01:36:14Z Attended By Officer anuradha Pasupula Bad Road conditions already complaint filed to Work Inspector -null AE/ENG,,Bowenpally   9700407166 102255097148.jpg p2102255097148.jpg {"comments": [{"id": "102255097148", "mobile_number": "9700407166", "posted_by": "Soundarya", "remarks": "CC patch work completed", "status": "Attended By Officer", "time_stamp": "27-JAN-2026 18:21:17"}, {"id": "102255097148", "mobile_number": "9700407166", "posted_by": "Soundarya", "remarks": "road work to be sanction", "status": "Under Process", "time_stamp": "22-JAN-2026 18:48:19"}, {"id": "102255097148", "mobile_number": "7331189482", "posted_by": "G.Asha", "remarks": "submitted for sanction", "status": "Submitted for Sanction", "time_stamp": "11-OCT-2025 15:31:38"}, {"id": "102255097148", "mobile_number": "7331189482", "posted_by": "G.Asha", "remarks": "after laying UGD pipe line", "status": "Submitted for Sanction", "time_stamp": "07-OCT-2025 21:25:02"}, {"id": "102255097148", "mobile_number": "7331189482", "posted_by": "G.Asha", "remarks": "dear citizen file as submitted for administrative sanction", "status": "Submitted for Sanction", "time_stamp": "03-FEB-2025 09:04:16"}], "grievance": {"assigned_to": "AE/ENG,,Bowenpally", "complaint_type": "Repairs to Road (Pot holes)", "id": "102255097148", "land_mark": "Vysya bank colony hasmathpet old Bowenpally", "mobile_number": "8885440475", "officer_remarks": "", "phone_to_call": "9700407166", "photo": "102255097148.jpg p2102255097148.jpg", "raised_by": "anuradha Pasupula", "remarks": "Bad Road conditions already complaint filed to Work Inspector -null", "status": "Attended By Officer", "time_stamp": "01-FEB-2025 07:06:14"}, "photos": [{"name": "102255097148.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102255097148.jpg"}, {"name": "p2102255097148.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102255097148.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097148"} sha256:f1c78579e8d819820acd7fb31c2a8970ae2c659ebc188555c813b33bd59b5e92

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