snapshot_comments

3 rows where snapshot_pk = 47

✎ View and edit SQL

This data as json, CSV (advanced)

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

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
85 47 47 1 108255392656 7993360321 2025-10-22T16:48:02Z Closed Smt.Preethi Vennila Palagani others {"id": "108255392656", "mobile_number": "7993360321", "posted_by": "Smt.Preethi Vennila Palagani", "remarks": "others", "status": "Closed", "time_stamp": "22-OCT-2025 22:18:02"}
86 47 47 2 108255392656 8686240719 2025-08-14T10:26:09Z Open muzaffer ? {"id": "108255392656", "mobile_number": "8686240719", "posted_by": "muzaffer", "remarks": "?", "status": "Open", "time_stamp": "14-AUG-2025 15:56:09"}
87 47 47 3 108255392656 8686240719 2025-08-09T20:31:02Z Open muzaffer any update {"id": "108255392656", "mobile_number": "8686240719", "posted_by": "muzaffer", "remarks": "any update", "status": "Open", "time_stamp": "10-AUG-2025 02:01:02"}

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