snapshot_comments

4 rows where snapshot_pk = 8

✎ 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
12 8 8 1 104255188592 - 2025-04-05T10:49:57Z - Call Centre Not Satisfied {"id": "104255188592", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "05-APR-2025 16:19:57"}
13 8 8 2 104255188592 9949994017 2025-04-04T07:48:53Z Attended By Officer Ms.K.Moulika Conducted inspection and notice to be issued for further action. {"id": "104255188592", "mobile_number": "9949994017", "posted_by": "Ms.K.Moulika", "remarks": "Conducted inspection and notice to be issued for further action.", "status": "Attended By Officer", "time_stamp": "04-APR-2025 13:18:53"}
14 8 8 3 104255188592 8897713985 2025-04-02T04:24:10Z Open Smt.Ch.Rajeshwari belongs to jublihills circle {"id": "104255188592", "mobile_number": "8897713985", "posted_by": "Smt.Ch.Rajeshwari", "remarks": "belongs to jublihills circle", "status": "Open", "time_stamp": "02-APR-2025 09:54:10"}
15 8 8 4 104255188592 8125016072 2025-03-31T19:10:38Z Open MD Wasif note: its an emergency complaint 9 members hospitalized {"id": "104255188592", "mobile_number": "8125016072", "posted_by": "MD Wasif", "remarks": "note: its an emergency complaint 9 members hospitalized", "status": "Open", "time_stamp": "01-APR-2025 00:40:38"}

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