snapshot_comments

1 row where snapshot_pk = 33

✎ 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
66 33 33 1 101265640126 9705869992 2026-01-05T07:13:34Z Attended By Officer Sri. L. Swamy Naik It is to inform you that special drive program for removal of road encroachment will be conducted very soon with the help of traffic police. {"id": "101265640126", "mobile_number": "9705869992", "posted_by": "Sri. L. Swamy Naik", "remarks": "It is to inform you that special drive program for removal of road encroachment will be conducted very soon with the help of traffic police.", "status": "Attended By Officer", "time_stamp": "05-JAN-2026 12:43:34"}

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