home / mar-2025 / complaint_snapshots

complaint_snapshots: 86

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
86 103255140382 2026-04-21T14:15:33Z https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140382 Street Sweeping Not Done Near Lakshmi Kala Mandir, 9951461801 2025-03-01T02:28:48Z Attended By Officer Vijaya lakshmi Citizen Complained regarding Street Sweeping is not done at H NO 24-387,Plot no 1,Sri Sai Nagar,Near Lakshmi Kala Mandir, Lothukunta, Alwal. AE,,Karwan   7995007410   {"comments": [{"id": "103255140382", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "05-MAR-2025 15:54:02"}, {"id": "103255140382", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "05-MAR-2025 15:53:20"}, {"id": "103255140382", "mobile_number": "9703336064", "posted_by": "Smt. Dr. Rajini", "remarks": "resolved", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 12:18:33"}], "grievance": {"assigned_to": "AE,,Karwan", "complaint_type": "Street Sweeping Not Done", "id": "103255140382", "land_mark": "Near Lakshmi Kala Mandir,", "mobile_number": "9951461801", "officer_remarks": "", "phone_to_call": "7995007410", "photo": "", "raised_by": "Vijaya lakshmi", "remarks": "Citizen Complained regarding Street Sweeping is not done at H NO 24-387,Plot no 1,Sri Sai Nagar,Near Lakshmi Kala Mandir, Lothukunta, Alwal.", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 07:58:48"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140382"} sha256:d368857b178a5d0ca34ea26f66b19580c2820c4b1ae9c628e36e9eae7205a4bf

Links from other tables

  • 0 rows from snapshot_pk in snapshot_photos
  • 3 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.183ms