home / mar-2025 / complaint_snapshots

complaint_snapshots: 65

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
65 103255140361 2026-04-21T14:15:30Z https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140361 Garbage Burning near community hall 8978019091 2025-03-01T02:07:33Z Attended By Officer rama swamy Citizen Complained regarding Garbage Burning at h no lig 1/15 uday nagar colony near community hall SANATH NAGAR b.k. guda AE,,Charminar   9063816946   {"comments": [{"id": "103255140361", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "10-MAR-2025 15:12:49"}, {"id": "103255140361", "mobile_number": "9154931422", "posted_by": "Dr.Chandra Shekar", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 10:40:20"}, {"id": "103255140361", "mobile_number": "8978019091", "posted_by": "rama swamy", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "01-MAR-2025 08:18:09"}, {"id": "103255140361", "mobile_number": "8978019091", "posted_by": "rama swamy", "remarks": "Kept conference with concern office Sri. Kailash Chand Shrivastav-Ward Officer 9000994031 Officer said To give Chandra Shekar AMOH Officer Number 9154931422", "status": "Open", "time_stamp": "01-MAR-2025 08:10:33"}, {"id": "103255140361", "mobile_number": "8978019091", "posted_by": "rama swamy", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "01-MAR-2025 07:43:01"}], "grievance": {"assigned_to": "AE,,Charminar", "complaint_type": "Garbage Burning", "id": "103255140361", "land_mark": "near community hall", "mobile_number": "8978019091", "officer_remarks": "", "phone_to_call": "9063816946", "photo": "", "raised_by": "rama swamy", "remarks": "Citizen Complained regarding Garbage Burning at h no lig 1/15 uday nagar colony near community hall SANATH NAGAR b.k. guda", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 07:37:33"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140361"} sha256:93fb863616d1854f919366cd85d6384d00073e3e3a915774c2c0877e4ba23db2

Links from other tables

  • 0 rows from snapshot_pk in snapshot_photos
  • 5 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.203ms