snapshot_comments

1 row where snapshot_pk = 56

✎ 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
95 56 56 1 102265688311 8712499203 2026-02-08T05:05:04Z Attended By Officer Dr. P.Prasanna Dear citizen attended your grievance, dogs in your locality are sterilized, as per rules sterilized dogs cannot be relocated hence released then and there only after vaccinating with ARV. {"id": "102265688311", "mobile_number": "8712499203", "posted_by": "Dr. P.Prasanna", "remarks": "Dear citizen attended your grievance, dogs in your locality are sterilized, as per rules sterilized dogs cannot be relocated hence released then and there only after vaccinating with ARV.", "status": "Attended By Officer", "time_stamp": "08-FEB-2026 10:35: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)
);