home / nov-2025 / complaint_snapshots

complaint_snapshots: 18

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
18 111255552168 2026-04-15T10:59:08Z https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552168 Non Glowing of Street Lights back side azaan school habeeba masjid lane first pole of the lane right side jamali kunta tolichowki 8019237060 2025-10-31T19:46:01Z Closed nawaz sir since last more than one and half years iam complaining the street light of the pole is not coming but it is not resolved and closed the complain in the night sir the street is dark at the begining of habeeba masjid lane when they check in the morning may be it is coming but in the night it is not glowing please request you to permanently solve the issue and glow the street light AEE/ENG,,Chandrayangutta   8498816472 111255552168.jpg {"comments": [{"id": "111255552168", "mobile_number": "8019237060", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "09-NOV-2025 14:59:21"}, {"id": "111255552168", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-NOV-2025 13:19:32"}, {"id": "111255552168", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "under process", "status": "Under Process", "time_stamp": "01-NOV-2025 11:30:40"}], "grievance": {"assigned_to": "AEE/ENG,,Chandrayangutta", "complaint_type": "Non Glowing of Street Lights", "id": "111255552168", "land_mark": "back side azaan school habeeba masjid lane first pole of the lane right side jamali kunta tolichowki", "mobile_number": "8019237060", "officer_remarks": "", "phone_to_call": "8498816472", "photo": "111255552168.jpg", "raised_by": "nawaz", "remarks": "sir since last more than one and half years iam complaining the street light of the pole is not coming but it is not resolved and closed the complain in the night sir the street is dark at the begining of habeeba masjid lane when they check in the morning may be it is coming but in the night it is not glowing please request you to permanently solve the issue and glow the street light", "status": "Closed", "time_stamp": "01-NOV-2025 01:16:01"}, "photos": [{"name": "111255552168.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/111255552168.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552168"} sha256:b7039a4ba5b882632a1b4f4e9827ce3216f91cf4d07159392c01cc25dd331d7e

Links from other tables

  • 1 row from snapshot_pk in snapshot_photos
  • 3 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.204ms