home / mar-2025 / complaint_snapshots

complaint_snapshots: 66

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
66 103255140362 2026-04-21T14:15:31Z https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140362 HMWSSB near library 9849245101 2025-03-01T02:09:43Z Open Chandrakumar over flow drain -     103255140362.jpg p2103255140362.jpg p3103255140362.jpg {"comments": [{"id": "103255140362", "mobile_number": "9154172347", "posted_by": "Mubeen Pasha", "remarks": "Circular manholes come under the purview of HMWSSB", "status": "Open", "time_stamp": "04-MAR-2025 22:30:11"}], "grievance": {"assigned_to": "-", "complaint_type": "HMWSSB", "id": "103255140362", "land_mark": "near library", "mobile_number": "9849245101", "officer_remarks": "", "photo": "103255140362.jpg p2103255140362.jpg p3103255140362.jpg", "raised_by": "Chandrakumar", "remarks": "over flow drain", "status": "Open", "time_stamp": "01-MAR-2025 07:39:43"}, "photos": [{"name": "103255140362.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/103255140362.jpg"}, {"name": "p2103255140362.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2103255140362.jpg"}, {"name": "p3103255140362.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3103255140362.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140362"} sha256:3dc64d9b8468e9daabf2ccaff83aab6588da6bd057eed1a8517556fb9aed20db

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