home / oct-2025 / complaint_snapshots

complaint_snapshots: 71

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
71 110255503140 2026-04-15T13:17:28Z https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503140 Garbage Vehicle Not Arrived (SAT) Surya enclave gayatri enclave road 9989141211 2025-10-01T02:19:38Z Closed murali garbage is not collecting evethough I have paid 1700 they rudely went off AE,,Rajendra Nagar   9154172348 110255503140.jpg {"comments": [{"id": "110255503140", "mobile_number": "9989141211", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "02-OCT-2025 10:59:07"}, {"id": "110255503140", "mobile_number": "8712419174", "posted_by": "C. Shiva Prasad", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 08:46:51"}], "grievance": {"assigned_to": "AE,,Rajendra Nagar", "complaint_type": "Garbage Vehicle Not Arrived (SAT)", "id": "110255503140", "land_mark": "Surya enclave gayatri enclave road", "mobile_number": "9989141211", "officer_remarks": "", "phone_to_call": "9154172348", "photo": "110255503140.jpg", "raised_by": "murali", "remarks": "garbage is not collecting evethough I have paid 1700 they rudely went off", "status": "Closed", "time_stamp": "01-OCT-2025 07:49:38"}, "photos": [{"name": "110255503140.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503140.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503140"} sha256:1420e7a01a995543f719f1190931596454aacdd715ad32b4e487316658c863f2

Links from other tables

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