home / may-2025 / complaint_snapshots

complaint_snapshots: 81

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
81 105255241118 2026-04-17T05:51:52Z https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241118 Overflowing of Nala / Drain 6-6-426/193 cha cha nehru nagar, bansilalpet, secunderabad 500003 8074831812 2025-05-01T02:16:03Z Closed sai kiran hello ghmc from so many days Im applying it but not service is not done yet so kindly do needfull and this problem is in every one home AE/ENG,,Masab Tank   8712013115 105255241118.jpg p2105255241118.jpg {"comments": [{"id": "105255241118", "mobile_number": "7386487194", "posted_by": "M Chaithanya", "remarks": "pertains to HMWSSB", "status": "Closed", "time_stamp": "01-MAY-2025 08:09:46"}], "grievance": {"assigned_to": "AE/ENG,,Masab Tank", "complaint_type": "Overflowing of Nala / Drain", "id": "105255241118", "land_mark": "6-6-426/193 cha cha nehru nagar, bansilalpet, secunderabad 500003", "mobile_number": "8074831812", "officer_remarks": "", "phone_to_call": "8712013115", "photo": "105255241118.jpg p2105255241118.jpg", "raised_by": "sai kiran", "remarks": "hello ghmc from so many days Im applying it but not service is not done yet so kindly do needfull and this problem is in every one home", "status": "Closed", "time_stamp": "01-MAY-2025 07:46:03"}, "photos": [{"name": "105255241118.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241118.jpg"}, {"name": "p2105255241118.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2105255241118.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241118"} sha256:2c553d688e90a3feb48247e7e43f3cfeb051598e3b6c3b2d6e1af243df788948

Links from other tables

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