home / sept-2025 / complaint_snapshots

complaint_snapshots: 32

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
32 109255451042 2026-04-15T15:19:02Z https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451042 Garbage Vehicle Not Arrived (SAT) Near st Thomas church 9663887878 2025-09-01T01:14:27Z Closed Srinivasareddy Vehicle not taken dust AE,,Bahadurpura   8125971394   {"comments": [{"id": "109255451042", "mobile_number": "9663887878", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "13-SEP-2025 15:28:39"}, {"id": "109255451042", "mobile_number": "8008103629", "posted_by": "A. Srinivas", "remarks": "attend", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 18:51:34"}], "grievance": {"assigned_to": "AE,,Bahadurpura", "complaint_type": "Garbage Vehicle Not Arrived (SAT)", "id": "109255451042", "land_mark": "Near st Thomas church", "mobile_number": "9663887878", "officer_remarks": "", "phone_to_call": "8125971394", "photo": "", "raised_by": "Srinivasareddy", "remarks": "Vehicle not taken dust", "status": "Closed", "time_stamp": "01-SEP-2025 06:44:27"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451042"} sha256:52a4b0774f46eeff309a61265f7913c7e52f313fa6270d314afb40b91174d17b

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 2.418ms