snapshot_comments

4 rows where snapshot_pk = 12

✎ 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
17 12 12 1 108255392622 9619933063 2025-10-18T07:46:02Z Attended By Officer ShashankBhogi this was attended {"id": "108255392622", "mobile_number": "9619933063", "posted_by": "ShashankBhogi", "remarks": "this was attended", "status": "Attended By Officer", "time_stamp": "18-OCT-2025 13:16:02"}
18 12 12 2 108255392622 9949619958 2025-08-11T02:08:21Z Attended By Officer Jameel Ahmed Clear {"id": "108255392622", "mobile_number": "9949619958", "posted_by": "Jameel Ahmed", "remarks": "Clear", "status": "Attended By Officer", "time_stamp": "11-AUG-2025 07:38:21"}
19 12 12 3 108255392622 9619933063 2025-08-02T04:12:59Z Open ShashankBhogi thanks for attending the issue I am closing this {"id": "108255392622", "mobile_number": "9619933063", "posted_by": "ShashankBhogi", "remarks": "thanks for attending the issue I am closing this", "status": "Open", "time_stamp": "02-AUG-2025 09:42:59"}
20 12 12 4 108255392622 9619933063 2025-08-02T03:58:36Z Open ShashankBhogi ghmc official asked to close n promised to clear the {"id": "108255392622", "mobile_number": "9619933063", "posted_by": "ShashankBhogi", "remarks": "ghmc official asked to close n promised to clear the", "status": "Open", "time_stamp": "02-AUG-2025 09:28:36"}

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