home / jun-2025 / complaint_snapshots

complaint_snapshots: 2

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
2 106255287895 2026-04-16T18:23:25Z https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287895 Non Glowing of Street Lights Near Akpari Masjid, 8019500797 2025-05-31T18:30:02Z Attended By Officer Julfakar Hussain Khan Citizen Complained regarding non glowing of street lights at H.NO 9-10-703,Dilawar Nagar,Near Akpari Masjid,Golconda AE/ENG,,Shamshabad   8639447493   {"comments": [{"id": "106255287895", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "05-JUN-2025 14:45:18"}, {"id": "106255287895", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-JUN-2025 15:04:35"}, {"id": "106255287895", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "01-JUN-2025 20:05:45"}], "grievance": {"assigned_to": "AE/ENG,,Shamshabad", "complaint_type": "Non Glowing of Street Lights", "id": "106255287895", "land_mark": "Near Akpari Masjid,", "mobile_number": "8019500797", "officer_remarks": "", "phone_to_call": "8639447493", "photo": "", "raised_by": "Julfakar Hussain Khan", "remarks": "Citizen Complained regarding non glowing of street lights at H.NO 9-10-703,Dilawar Nagar,Near Akpari Masjid,Golconda", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 00:00:02"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287895"} sha256:ab3ca76d3bba3e7efe6d9cdef4cb71773ae23e6275515e64cfadb8ef68b4b7d3

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