snapshot_comments

3 rows where snapshot_pk = 26

✎ 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
58 26 26 1 109255451036 9246163445 2025-09-09T16:21:47Z Attended By Officer Kishore still not working {"id": "109255451036", "mobile_number": "9246163445", "posted_by": "Kishore", "remarks": "still not working", "status": "Attended By Officer", "time_stamp": "09-SEP-2025 21:51:47"}
59 26 26 2 109255451036 9154296589 2025-09-07T20:23:30Z Attended By Officer P.Venkateshwar Goud rectifird {"id": "109255451036", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "rectifird", "status": "Attended By Officer", "time_stamp": "08-SEP-2025 01:53:30"}
60 26 26 3 109255451036 9246163445 2025-09-03T13:35:18Z Open Kishore please let me know the status {"id": "109255451036", "mobile_number": "9246163445", "posted_by": "Kishore", "remarks": "please let me know the status", "status": "Open", "time_stamp": "03-SEP-2025 19:05:18"}

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