home / oct-2025 / complaint_snapshots

complaint_snapshots: 5

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
5 110255503075 2026-04-15T13:17:20Z https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503075 Repairs to Road (Pot holes) Sagar Ring Road Junction(Beside Bharath Petrol Bunk) 8341712808 2025-09-30T18:40:08Z Closed ShivaChandan I had been seeing these potholes since a year but no one from the GHMC is taking the initiative to fix them. Salute to the Officers. I hope after this complain they will fix it AE/ENG,,Kapra   7331189511 110255503075.jpg p2110255503075.jpg p3110255503075.jpg {"comments": [{"id": "110255503075", "mobile_number": "8341712808", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "02-NOV-2025 14:02:23"}, {"id": "110255503075", "mobile_number": "7331189190", "posted_by": "P Vigneshwari", "remarks": "Sir, patch work is pending due to water supply line leakage. However, our team has temporarily addressed the issue with WMM to make the road motorable.", "status": "Attended By Officer", "time_stamp": "10-OCT-2025 11:41:18"}, {"id": "110255503075", "mobile_number": "8341712808", "posted_by": "ShivaChandan", "remarks": "Why are you claiming that you have resolved when it is not. Not even an inch of work has started there.", "status": "Open", "time_stamp": "07-OCT-2025 15:13:07"}, {"id": "110255503075", "mobile_number": "8247250922", "posted_by": "Smt. Sakina fatima", "remarks": "this issue resolved h", "status": "Attended By Officer", "time_stamp": "07-OCT-2025 13:58:39"}, {"id": "110255503075", "mobile_number": "7331186857", "posted_by": "Kedareshwari", "remarks": "pertains to ward15", "status": "Open", "time_stamp": "06-OCT-2025 13:17:22"}, {"id": "110255503075", "mobile_number": "8341712808", "posted_by": "Ward019", "remarks": "HASTINAPURAM WARD 16", "status": "Open", "time_stamp": "01-OCT-2025 11:16:42"}], "grievance": {"assigned_to": "AE/ENG,,Kapra", "complaint_type": "Repairs to Road (Pot holes)", "id": "110255503075", "land_mark": "Sagar Ring Road Junction(Beside Bharath Petrol Bunk)", "mobile_number": "8341712808", "officer_remarks": "", "phone_to_call": "7331189511", "photo": "110255503075.jpg p2110255503075.jpg p3110255503075.jpg", "raised_by": "ShivaChandan", "remarks": "I had been seeing these potholes since a year but no one from the GHMC is taking the initiative to fix them. Salute to the Officers. I hope after this complain they will fix it", "status": "Closed", "time_stamp": "01-OCT-2025 00:10:08"}, "photos": [{"name": "110255503075.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503075.jpg"}, {"name": "p2110255503075.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503075.jpg"}, {"name": "p3110255503075.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3110255503075.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503075"} sha256:a9d6f2a4e705fb99b8331b6ec65fb59417f2e7c9e2b37e36af431b37e0f15b5c

Links from other tables

  • 3 rows from snapshot_pk in snapshot_photos
  • 6 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.342ms