home / may-2025 / complaint_snapshots

complaint_snapshots: 41

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
41 105255241077 2026-04-17T05:51:35Z https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241077 Timer Settings of Street Lights SRI INDRAPRASTHA COLONY NAGOLE 9702073700 2025-05-01T01:02:42Z Attended By Officer B AJAY KUMAR 1 . Road no. 5 little master high school towards Ketrish landmark . 2 . Road no. 5 little master high school towards Sri indraprastha colony .3 . Road No. 8 all lights not glowing. AE/ENG,,Boduppal   9963370985 105255241077.jpg {"comments": [{"id": "105255241077", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "20-MAY-2025 17:14:28"}, {"id": "105255241077", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "08-MAY-2025 15:15:05"}, {"id": "105255241077", "mobile_number": "9702073700", "posted_by": "B AJAY KUMAR", "remarks": "when will these 25 odd street lights start glowing. everyone moving along in these streets in darkness for last six days.", "status": "Under Process", "time_stamp": "05-MAY-2025 10:18:32"}, {"id": "105255241077", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "informed to electrician", "status": "Under Process", "time_stamp": "03-MAY-2025 22:58:47"}], "grievance": {"assigned_to": "AE/ENG,,Boduppal", "complaint_type": "Timer Settings of Street Lights", "id": "105255241077", "land_mark": "SRI INDRAPRASTHA COLONY NAGOLE", "mobile_number": "9702073700", "officer_remarks": "", "phone_to_call": "9963370985", "photo": "105255241077.jpg", "raised_by": "B AJAY KUMAR", "remarks": "1 . Road no. 5 little master high school towards Ketrish landmark . 2 . Road no. 5 little master high school towards Sri indraprastha colony .3 . Road No. 8 all lights not glowing.", "status": "Attended By Officer", "time_stamp": "01-MAY-2025 06:32:42"}, "photos": [{"name": "105255241077.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241077.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241077"} sha256:da1ce64d57c62f1ce7828bab732b37acb8a01463e9e72e6c4abacde93d488f92

Links from other tables

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