home / nov-2025 / complaint_snapshots

complaint_snapshots: 61

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
61 111255552213 2026-04-15T10:59:14Z https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552213 Repair of Sports Equipment aghapura family park 7799338913 2025-11-01T01:47:52Z Closed shaik abdul saif please jamnastic machine and grass and trees Games Inspector,,Jangammet   8977668380 111255552213.jpg p2111255552213.jpg p3111255552213.jpg {"comments": [{"id": "111255552213", "mobile_number": "7799338913", "posted_by": "Call Centre", "remarks": "Partially Satisfied", "status": "Closed", "time_stamp": "10-NOV-2025 15:56:13"}, {"id": "111255552213", "mobile_number": "8639457193", "posted_by": "Raheena Begum", "remarks": "Sir, please give a representation Concerns Deputy Commissioner at the earliest.", "status": "Attended By Officer", "time_stamp": "04-NOV-2025 12:38:09"}, {"id": "111255552213", "mobile_number": "7799338913", "posted_by": "shaik abdul saif", "remarks": "Officer not come play ground", "status": "Open", "time_stamp": "04-NOV-2025 07:56:23"}, {"id": "111255552213", "mobile_number": "8639457193", "posted_by": "Raheena Begum", "remarks": "We will inform the ground incharge and update the status as soon as possible, sir.", "status": "Attended By Officer", "time_stamp": "03-NOV-2025 15:10:50"}], "grievance": {"assigned_to": "Games Inspector,,Jangammet", "complaint_type": "Repair of Sports Equipment", "id": "111255552213", "land_mark": "aghapura family park", "mobile_number": "7799338913", "officer_remarks": "", "phone_to_call": "8977668380", "photo": "111255552213.jpg p2111255552213.jpg p3111255552213.jpg", "raised_by": "shaik abdul saif", "remarks": "please jamnastic machine and grass and trees", "status": "Closed", "time_stamp": "01-NOV-2025 07:17:52"}, "photos": [{"name": "111255552213.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/111255552213.jpg"}, {"name": "p2111255552213.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2111255552213.jpg"}, {"name": "p3111255552213.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3111255552213.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552213"} sha256:c84b23fb5be5813bf9d34f67631b4819b3fa2a676b43b0224901c389ed64ed19

Links from other tables

  • 3 rows from snapshot_pk in snapshot_photos
  • 4 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.223ms