home / nov-2025 / complaint_snapshots

complaint_snapshots: 9

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
9 111255552159 2026-04-15T10:59:07Z https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552159 New Street Light Requirement 500059 9032028129 2025-10-31T19:03:21Z Closed RahulKumar We require a new street light in our colony starting lane to enter to the colony we dont have proper light please provide new street light the address is road no 15 laxmi nagar saidabad AE/ENG,,LB Nagar   8074014276 111255552159.jpg p2111255552159.jpg p3111255552159.jpg {"comments": [{"id": "111255552159", "mobile_number": "9032028129", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "03-NOV-2025 15:46:46"}, {"id": "111255552159", "mobile_number": "9848444497", "posted_by": "Sri.B. Charan Singh", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "01-NOV-2025 14:05:53"}], "grievance": {"assigned_to": "AE/ENG,,LB Nagar", "complaint_type": "New Street Light Requirement", "id": "111255552159", "land_mark": "500059", "mobile_number": "9032028129", "officer_remarks": "", "phone_to_call": "8074014276", "photo": "111255552159.jpg p2111255552159.jpg p3111255552159.jpg", "raised_by": "RahulKumar", "remarks": "We require a new street light in our colony starting lane to enter to the colony we dont have proper light please provide new street light the address is road no 15 laxmi nagar saidabad", "status": "Closed", "time_stamp": "01-NOV-2025 00:33:21"}, "photos": [{"name": "111255552159.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/111255552159.jpg"}, {"name": "p2111255552159.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2111255552159.jpg"}, {"name": "p3111255552159.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3111255552159.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552159"} sha256:829fe2c2c9a6c43cdc6618f07bdd0ccb1f3c7388dc5bbb9dfacd481088eec974

Links from other tables

  • 3 rows from snapshot_pk in snapshot_photos
  • 2 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.76ms