home / nov-2025 / complaint_snapshots

complaint_snapshots: 94

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
94 111255552246 2026-04-15T10:59:18Z https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552246 New Street Light Requirement cmr internatinal school 9677355043 2025-11-01T02:27:20Z Attended By Officer sai require nee street at junction of cmr international school AE/ENG,,Golconda   7995009074 111255552246.jpg p2111255552246.jpg {"comments": [{"id": "111255552246", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "19-NOV-2025 16:57:43"}, {"id": "111255552246", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "it will rectified after getting the administration sanction", "status": "Submitted for Sanction", "time_stamp": "03-NOV-2025 14:30:14"}], "grievance": {"assigned_to": "AE/ENG,,Golconda", "complaint_type": "New Street Light Requirement", "id": "111255552246", "land_mark": "cmr internatinal school", "mobile_number": "9677355043", "officer_remarks": "", "phone_to_call": "7995009074", "photo": "111255552246.jpg p2111255552246.jpg", "raised_by": "sai", "remarks": "require nee street at junction of cmr international school", "status": "Attended By Officer", "time_stamp": "01-NOV-2025 07:57:20"}, "photos": [{"name": "111255552246.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/111255552246.jpg"}, {"name": "p2111255552246.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2111255552246.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552246"} sha256:bfe8b304a56b12a367f24364702ef7fc61504556a3d9e774e04e1e80244acf61

Links from other tables

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