home / sept-2025 / complaint_snapshots

complaint_snapshots: 52

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
52 109255451063 2026-04-15T15:19:05Z https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451063 Dog Menace pochamma bagh, srikrishna towers road, saroornagar 7013623544 2025-09-01T01:54:08Z Closed Venu There is no. of dogs moveing on the road and threat for the citizens. they may bite public please take immediate on this subject. Veternary Officer,,Nacharam   8712034408 109255451063.jpg {"comments": [{"id": "109255451063", "mobile_number": "7013623544", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "17-SEP-2025 10:30:33"}, {"id": "109255451063", "mobile_number": "7207923101", "posted_by": "Dr.YADAGIRI", "remarks": "operate dogs", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 13:22:51"}], "grievance": {"assigned_to": "Veternary Officer,,Nacharam", "complaint_type": "Dog Menace", "id": "109255451063", "land_mark": "pochamma bagh, srikrishna towers road, saroornagar", "mobile_number": "7013623544", "officer_remarks": "", "phone_to_call": "8712034408", "photo": "109255451063.jpg", "raised_by": "Venu", "remarks": "There is no. of dogs moveing on the road and threat for the citizens. they may bite public please take immediate on this subject.", "status": "Closed", "time_stamp": "01-SEP-2025 07:24:08"}, "photos": [{"name": "109255451063.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/109255451063.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451063"} sha256:ec2b88bd36f2f4e562343a4a0f4f228473249ef359e6a4b863826713af3a03e6

Links from other tables

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