home / jan-2025 / complaint_snapshots

complaint_snapshots: 8

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
8 101255052431 2026-04-22T08:06:11Z https://igs.ghmc.gov.in/Operator/Status?cpno=0101255052431 Dog Menace Near Sai baba temple ,Milk Center 9014661487 2024-12-31T19:44:56Z Closed marie alexander . Citizen requested to send Dogs Squard team at Plot no 86 ,Saipuri colony ,Near Sai baba temple ,Milk Center ,Kapra Veternary Officer,,Keesara   9247540129   {"comments": [{"id": "101255052431", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "10-JAN-2025 10:06:56"}, {"id": "101255052431", "mobile_number": "7207923101", "posted_by": "Dr.YADAGIRI", "remarks": "Attended caught 1dog", "status": "Attended By Officer", "time_stamp": "02-JAN-2025 15:30:28"}], "grievance": {"assigned_to": "Veternary Officer,,Keesara", "complaint_type": "Dog Menace", "id": "101255052431", "land_mark": "Near Sai baba temple ,Milk Center", "mobile_number": "9014661487", "officer_remarks": "", "phone_to_call": "9247540129", "photo": "", "raised_by": "marie alexander .", "remarks": "Citizen requested to send Dogs Squard team at Plot no 86 ,Saipuri colony ,Near Sai baba temple ,Milk Center ,Kapra", "status": "Closed", "time_stamp": "01-JAN-2025 01:14:56"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0101255052431"} sha256:918ee2dae5cd003c0e29be2b6b9ea11f164d0fe7377ae34127270951ca164fc2

Links from other tables

  • 0 rows from snapshot_pk in snapshot_photos
  • 2 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 4.325ms