home / mar-2025 / complaint_snapshots

complaint_snapshots: 84

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
84 103255140380 2026-04-21T14:15:32Z https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140380 Desilting of Nala / Drain Near Raju Tiffin Center 9398944366 2025-03-01T02:26:30Z Attended By Officer Rakesh Citizen requested for removal of Debris rain water mud Wastage at H No 14-9-1196, Near Raju Tiffin Center Opp Lane, Samosa Galli Line, Begum Bazar. AE/ENG,,Hayathnagar   9502025421   {"comments": [{"id": "103255140380", "mobile_number": "7331189514", "posted_by": "M Kalamma", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 14:40:12"}, {"id": "103255140380", "mobile_number": "9398944366", "posted_by": "Rakesh", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir", "status": "Open", "time_stamp": "02-MAR-2025 09:36:32"}], "grievance": {"assigned_to": "AE/ENG,,Hayathnagar", "complaint_type": "Desilting of Nala / Drain", "id": "103255140380", "land_mark": "Near Raju Tiffin Center", "mobile_number": "9398944366", "officer_remarks": "", "phone_to_call": "9502025421", "photo": "", "raised_by": "Rakesh", "remarks": "Citizen requested for removal of Debris rain water mud Wastage at H No 14-9-1196, Near Raju Tiffin Center Opp Lane, Samosa Galli Line, Begum Bazar.", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 07:56:30"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140380"} sha256:dc1abf2503421d39d7b69be7349a5f7c103d50c5bef0df9f9ec7addfe77eff4a

Links from other tables

  • 0 rows from snapshot_pk in snapshot_photos
  • 2 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.293ms