home / jun-2025 / complaint_snapshots

complaint_snapshots: 81

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
81 106255287976 2026-04-16T18:23:35Z https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287976 New Street Light Requirement sai leela enclave kapra 7799991113 2025-06-01T02:35:29Z Attended By Officer Mopidevi sarada I request a street light near my house as it too dark a pole is already installed only a light is required AE/ENG,,Keesara   8712013141 106255287976.jpg p2106255287976.jpg {"comments": [{"id": "106255287976", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-JUN-2025 11:34:02"}], "grievance": {"assigned_to": "AE/ENG,,Keesara", "complaint_type": "New Street Light Requirement", "id": "106255287976", "land_mark": "sai leela enclave kapra", "mobile_number": "7799991113", "officer_remarks": "", "phone_to_call": "8712013141", "photo": "106255287976.jpg p2106255287976.jpg", "raised_by": "Mopidevi sarada", "remarks": "I request a street light near my house as it too dark a pole is already installed only a light is required", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 08:05:29"}, "photos": [{"name": "106255287976.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287976.jpg"}, {"name": "p2106255287976.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2106255287976.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287976"} sha256:6857c13aeaeea744ea26b0c16438a4553a679ee99c29d61add19dfaf28bc0130

Links from other tables

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