snapshot_comments

3 rows where snapshot_pk = 75

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: status_text, comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
162 75 75 1 106255287969 9000541595 2025-06-13T05:52:55Z Attended By Officer Orsu Santhosh rectified {"id": "106255287969", "mobile_number": "9000541595", "posted_by": "Orsu Santhosh", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "13-JUN-2025 11:22:55"}
163 75 75 2 106255287969 7331189194 2025-06-04T06:59:41Z Open Prathap Pertains to Miyapur Ward Thank U {"id": "106255287969", "mobile_number": "7331189194", "posted_by": "Prathap", "remarks": "Pertains to Miyapur Ward Thank U", "status": "Open", "time_stamp": "04-JUN-2025 12:29:41"}
164 75 75 3 106255287969 7331151746 2025-06-03T08:08:55Z Open N.Prashant .. {"id": "106255287969", "mobile_number": "7331151746", "posted_by": "N.Prashant", "remarks": "..", "status": "Open", "time_stamp": "03-JUN-2025 13:38:55"}

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