home / jan-2026 / complaint_snapshots

complaint_snapshots: 4

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
4 101265640096 2026-04-13T10:17:16Z https://igs.ghmc.gov.in/Operator/Status?cpno=0101265640096 Footpath Blocked opposite ek Minar Masjid 9949350271 2025-12-31T19:05:59Z Attended By Officer hadi Footpath encroachment by Furniture and waste material ACP,,Goshamahal   9949994037 101265640096.jpg p2101265640096.jpg p3101265640096.jpg {"comments": [{"id": "101265640096", "mobile_number": "9949994037", "posted_by": "P.BALANANDA SWAMY", "remarks": "inspected the grievance site,further action will be taken as per rules.", "status": "Attended By Officer", "time_stamp": "08-APR-2026 19:55:04"}, {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "01-APR-2026 14:56:57"}, {"id": "101265640096", "mobile_number": "9949994037", "posted_by": "P.BALANANDA SWAMY", "remarks": "inspected the grievance site,further action will be taken as per rules.", "status": "Attended By Officer", "time_stamp": "31-MAR-2026 10:50:05"}, {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "hadi", "remarks": "Encroachment is there since a very long time. Multiple inspections done by government officials but there's no response. Attaching images for reference", "status": "Open", "time_stamp": "30-MAR-2026 09:56:28"}, {"id": "101265640096", "mobile_number": "9949994037", "posted_by": "P.BALANANDA SWAMY", "remarks": "It is to inform you that the special drive for removal of footpath/road encroachment program will be conducted soon with the help of traffic police", "status": "Attended By Officer", "time_stamp": "30-MAR-2026 08:11:05"}, {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "hadi", "remarks": "encroachment still exists. footpath blocked 🚫", "status": "Open", "time_stamp": "29-MAR-2026 23:51:49"}, {"id": "101265640096", "mobile_number": "9949994037", "posted_by": "P.BALANANDA SWAMY", "remarks": "Inspected the grievance site, encroachments will be removed with the assistance of police very soon.", "status": "Attended By Officer", "time_stamp": "28-MAR-2026 11:10:27"}, {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "hadi", "remarks": "encroachment near transformer is still there which is a fire hazard", "status": "Open", "time_stamp": "15-MAR-2026 12:41:07"}, {"id": "101265640096", "mobile_number": "9949994037", "posted_by": "P.BALANANDA SWAMY", "remarks": "inspected the grievance site,further action will be taken as per rules.", "status": "Attended By Officer", "time_stamp": "09-MAR-2026 13:32:09"}, {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "hadi", "remarks": "Encroachment near transformer is still there which can be a fire hazard", "status": "Open", "time_stamp": "04-MAR-2026 23:33:12"}, {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "hadi", "remarks": "Encroachment near transformer is still there which can be a fire hazard", "status": "Open", "time_stamp": "04-MAR-2026 23:33:11"}, {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "hadi", "remarks": "Encroachment near transformer is still there which can be a fire hazard", "status": "Open", "time_stamp": "04-MAR-2026 23:33:10"}, {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "hadi", "remarks": "Encroachment is still not resolved", "status": "Attended By Officer", "time_stamp": "04-MAR-2026 23:28:37"}, {"id": "101265640096", "mobile_number": "9949994037", "posted_by": "P.BALANANDA SWAMY", "remarks": "Inspected the grievance site, encroachments will be removed with the assistance of police very soon.", "status": "Attended By Officer", "time_stamp": "26-FEB-2026 14:34:54"}, {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "hadi", "remarks": "Footpath is still encroached near a transformer which is a potential hazard", "status": "Open", "time_stamp": "19-FEB-2026 13:04:37"}, {"id": "101265640096", "mobile_number": "9949994037", "posted_by": "P.BALANANDA SWAMY", "remarks": "inspected the grievance site,further action will be taken as per rules.", "status": "Attended By Officer", "time_stamp": "19-FEB-2026 12:03:36"}, {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "hadi", "remarks": "Issue not resolved as material is dumped near a transformer which is a hazard", "status": "Open", "time_stamp": "19-FEB-2026 11:52:08"}, {"id": "101265640096", "mobile_number": "9949994037", "posted_by": "P.BALANANDA SWAMY", "remarks": "Inspected the grievance site, encroachments will be removed with the assistance of police very soon.", "status": "Attended By Officer", "time_stamp": "19-FEB-2026 11:19:19"}], "grievance": {"assigned_to": "ACP,,Goshamahal", "complaint_type": "Footpath Blocked", "id": "101265640096", "land_mark": "opposite ek Minar Masjid", "mobile_number": "9949350271", "officer_remarks": "", "phone_to_call": "9949994037", "photo": "101265640096.jpg p2101265640096.jpg p3101265640096.jpg", "raised_by": "hadi", "remarks": "Footpath encroachment by Furniture and waste material", "status": "Attended By Officer", "time_stamp": "01-JAN-2026 00:35:59"}, "photos": [{"name": "101265640096.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/101265640096.jpg"}, {"name": "p2101265640096.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2101265640096.jpg"}, {"name": "p3101265640096.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3101265640096.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0101265640096"} sha256:56a78151fd863cb6081c4a8ef0ab6962d8a202bd255728ef15d27f5d6c472b3f

Links from other tables

  • 3 rows from snapshot_pk in snapshot_photos
  • 18 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 5.56ms