home / nov-2025 / complaint_snapshots

complaint_snapshots: 20

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
20 111255552169 2026-04-15T10:59:09Z https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552169 Dog bite / Attack govt hospital 9701802589 2025-10-31T19:49:53Z Attended By Officer nagaraju barging Veternary Officer,,Yakutpura   7207923101 111255552169.jpg p2111255552169.jpg p3111255552169.jpg {"comments": [{"id": "111255552169", "mobile_number": "9154710820", "posted_by": "Dr. M. Maruthi", "remarks": "ABC 2to4 dogs", "status": "Attended By Officer", "time_stamp": "13-NOV-2025 10:55:05"}, {"id": "111255552169", "mobile_number": "9701802589", "posted_by": "nagaraju", "remarks": "still I able to see dog which i complain simply share details and closing the ticket kindly check once again inbetween roads and buildings", "status": "Open", "time_stamp": "12-NOV-2025 21:06:12"}, {"id": "111255552169", "mobile_number": "9154710820", "posted_by": "Dr. M. Maruthi", "remarks": "ABC 2to4 dogs", "status": "Attended By Officer", "time_stamp": "11-NOV-2025 09:25:19"}, {"id": "111255552169", "mobile_number": "9701802589", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "10-NOV-2025 13:56:28"}, {"id": "111255552169", "mobile_number": "9154710820", "posted_by": "Dr. M. Maruthi", "remarks": "ABC 2to4 dogs", "status": "Attended By Officer", "time_stamp": "02-NOV-2025 08:30:55"}], "grievance": {"assigned_to": "Veternary Officer,,Yakutpura", "complaint_type": "Dog bite / Attack", "id": "111255552169", "land_mark": "govt hospital", "mobile_number": "9701802589", "officer_remarks": "", "phone_to_call": "7207923101", "photo": "111255552169.jpg p2111255552169.jpg p3111255552169.jpg", "raised_by": "nagaraju", "remarks": "barging", "status": "Attended By Officer", "time_stamp": "01-NOV-2025 01:19:53"}, "photos": [{"name": "111255552169.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/111255552169.jpg"}, {"name": "p2111255552169.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2111255552169.jpg"}, {"name": "p3111255552169.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3111255552169.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552169"} sha256:32083a95918e619abd147c4561d3a882cc4e39118f23fe6a497ab05b27e6d3d5

Links from other tables

  • 3 rows from snapshot_pk in snapshot_photos
  • 5 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.376ms