snapshot_comments

18 rows where snapshot_pk = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: mobile_number, status_text, posted_by, remarks, comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
4 4 4 1 101265640096 9949994037 2026-04-08T14:25:04Z Attended By Officer P.BALANANDA SWAMY inspected the grievance site,further action will be taken as per rules. {"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"}
5 4 4 2 101265640096 9949350271 2026-04-01T09:26:57Z Open Call Centre Not Satisfied {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "01-APR-2026 14:56:57"}
6 4 4 3 101265640096 9949994037 2026-03-31T05:20:05Z Attended By Officer P.BALANANDA SWAMY inspected the grievance site,further action will be taken as per rules. {"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"}
7 4 4 4 101265640096 9949350271 2026-03-30T04:26:28Z Open hadi Encroachment is there since a very long time. Multiple inspections done by government officials but there's no response. Attaching images for reference {"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"}
8 4 4 5 101265640096 9949994037 2026-03-30T02:41:05Z Attended By Officer P.BALANANDA SWAMY 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 {"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"}
9 4 4 6 101265640096 9949350271 2026-03-29T18:21:49Z Open hadi encroachment still exists. footpath blocked 🚫 {"id": "101265640096", "mobile_number": "9949350271", "posted_by": "hadi", "remarks": "encroachment still exists. footpath blocked 🚫", "status": "Open", "time_stamp": "29-MAR-2026 23:51:49"}
10 4 4 7 101265640096 9949994037 2026-03-28T05:40:27Z Attended By Officer P.BALANANDA SWAMY Inspected the grievance site, encroachments will be removed with the assistance of police very soon. {"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"}
11 4 4 8 101265640096 9949350271 2026-03-15T07:11:07Z Open hadi encroachment near transformer is still there which is a fire hazard {"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"}
12 4 4 9 101265640096 9949994037 2026-03-09T08:02:09Z Attended By Officer P.BALANANDA SWAMY inspected the grievance site,further action will be taken as per rules. {"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"}
13 4 4 10 101265640096 9949350271 2026-03-04T18:03:12Z Open hadi Encroachment near transformer is still there which can be a fire hazard {"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"}
14 4 4 11 101265640096 9949350271 2026-03-04T18:03:11Z Open hadi Encroachment near transformer is still there which can be a fire hazard {"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"}
15 4 4 12 101265640096 9949350271 2026-03-04T18:03:10Z Open hadi Encroachment near transformer is still there which can be a fire hazard {"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"}
16 4 4 13 101265640096 9949350271 2026-03-04T17:58:37Z Attended By Officer hadi Encroachment is still not resolved {"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"}
17 4 4 14 101265640096 9949994037 2026-02-26T09:04:54Z Attended By Officer P.BALANANDA SWAMY Inspected the grievance site, encroachments will be removed with the assistance of police very soon. {"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"}
18 4 4 15 101265640096 9949350271 2026-02-19T07:34:37Z Open hadi Footpath is still encroached near a transformer which is a potential hazard {"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"}
19 4 4 16 101265640096 9949994037 2026-02-19T06:33:36Z Attended By Officer P.BALANANDA SWAMY inspected the grievance site,further action will be taken as per rules. {"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"}
20 4 4 17 101265640096 9949350271 2026-02-19T06:22:08Z Open hadi Issue not resolved as material is dumped near a transformer which is a hazard {"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"}
21 4 4 18 101265640096 9949994037 2026-02-19T05:49:19Z Attended By Officer P.BALANANDA SWAMY Inspected the grievance site, encroachments will be removed with the assistance of police very soon. {"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"}

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE snapshot_comments (
    comment_pk INTEGER PRIMARY KEY,
    snapshot_pk INTEGER NOT NULL REFERENCES complaint_snapshots(snapshot_pk) ON DELETE CASCADE,
    ordinal INTEGER NOT NULL,
    complaint_id TEXT NOT NULL,
    mobile_number TEXT NOT NULL,
    comment_timestamp TEXT NOT NULL,
    status_text TEXT NOT NULL,
    posted_by TEXT NOT NULL,
    remarks TEXT NOT NULL,
    raw_comment_json TEXT NOT NULL,
    UNIQUE(snapshot_pk, ordinal)
);