snapshot_comments

10 rows where snapshot_pk = 43

✎ 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
71 43 43 1 108255392653 9154686556 2025-08-16T08:19:47Z Attended By Officer T.Sowmya . {"id": "108255392653", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": ".", "status": "Attended By Officer", "time_stamp": "16-AUG-2025 13:49:47"}
72 43 43 2 108255392653 9030033936 2025-08-14T10:52:27Z Open Murali Mohan Citizen informed that the grievance has been pending So please take necessary action Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 16:22:27"}
73 43 43 3 108255392653 9030033936 2025-08-14T10:34:46Z Open Murali Mohan Kept Conference with concern officer T.Sowmya,AE/AEE 9154686556 Officer number is not connected {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Kept Conference with concern officer T.Sowmya,AE/AEE 9154686556 Officer number is not connected", "status": "Open", "time_stamp": "14-AUG-2025 16:04:46"}
74 43 43 4 108255392653 9030033936 2025-08-14T10:33:48Z Open Murali Mohan Citizen informed that the grievance has been pending So please take necessary action Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 16:03:48"}
75 43 43 5 108255392653 9030033936 2025-08-14T00:07:55Z Open Murali Mohan Citizen informed that the grievance has been pending So please take necessary action Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 05:37:55"}
76 43 43 6 108255392653 9030033936 2025-08-14T00:01:39Z Open Murali Mohan Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 05:31:39"}
77 43 43 7 108255392653 9030033936 2025-08-12T13:24:46Z Open Murali Mohan Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "12-AUG-2025 18:54:46"}
78 43 43 8 108255392653 9030033936 2025-08-08T08:56:28Z Open Call Centre Not Satisfied {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "08-AUG-2025 14:26:28"}
79 43 43 9 108255392653 9154686556 2025-08-07T17:13:50Z Attended By Officer T.Sowmya . {"id": "108255392653", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": ".", "status": "Attended By Officer", "time_stamp": "07-AUG-2025 22:43:50"}
80 43 43 10 108255392653 9030033936 2025-08-05T00:08:08Z Open Murali Mohan Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "05-AUG-2025 05:38:08"}

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)
);