home / dec-2025 / complaint_snapshots

complaint_snapshots: 13

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
13 112255596100 2026-04-13T18:45:38Z https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596100 Non Glowing of Street Lights near cloud nine 9381007096 2025-11-30T20:16:05Z Closed ali Citizen Complained regarding non glowing of street lights at alkarin colony,near cloud nine,tolichowki AEE/ENG,,Chandrayangutta   8498816472   {"comments": [{"id": "112255596100", "mobile_number": "9381007096", "posted_by": "ali", "remarks": "Good work", "status": "Closed", "time_stamp": "02-DEC-2025 16:27:36"}, {"id": "112255596100", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 14:08:02"}, {"id": "112255596100", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "under process", "status": "Under Process", "time_stamp": "01-DEC-2025 07:04:51"}], "grievance": {"assigned_to": "AEE/ENG,,Chandrayangutta", "complaint_type": "Non Glowing of Street Lights", "id": "112255596100", "land_mark": "near cloud nine", "mobile_number": "9381007096", "officer_remarks": "", "phone_to_call": "8498816472", "photo": "", "raised_by": "ali", "remarks": "Citizen Complained regarding non glowing of street lights at alkarin colony,near cloud nine,tolichowki", "status": "Closed", "time_stamp": "01-DEC-2025 01:46:05"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596100"} sha256:21db873fc76c62c1b4ad98cf7e4bca92762aefed9af5e16f9a9376056e4a6079

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.21ms