snapshot_comments

3 rows where snapshot_pk = 22

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
53 22 22 1 112255596109 9494566137 2025-12-03T23:41:43Z Closed A. Srikanth goud This is the issue of 2016 did not resolved {"id": "112255596109", "mobile_number": "9494566137", "posted_by": "A. Srikanth goud", "remarks": "This is the issue of 2016 did not resolved", "status": "Closed", "time_stamp": "04-DEC-2025 05:11:43"}
54 22 22 2 112255596109 9154931422 2025-12-03T08:02:08Z Attended By Officer Dr.Chandra Shekar clear {"id": "112255596109", "mobile_number": "9154931422", "posted_by": "Dr.Chandra Shekar", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "03-DEC-2025 13:32:08"}
55 22 22 3 112255596109 9704456422 2025-12-01T02:46:04Z Open Sri. S . Srinivas SAT EMI complaint {"id": "112255596109", "mobile_number": "9704456422", "posted_by": "Sri. S . Srinivas", "remarks": "SAT EMI complaint", "status": "Open", "time_stamp": "01-DEC-2025 08:16:04"}

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