snapshot_comments

5 rows where snapshot_pk = 50

✎ 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
99 50 50 1 112255596137 7995009108 2025-12-05T09:37:42Z Closed Sri. Kaushik . {"id": "112255596137", "mobile_number": "7995009108", "posted_by": "Sri. Kaushik", "remarks": ".", "status": "Closed", "time_stamp": "05-DEC-2025 15:07:42"}
100 50 50 2 112255596137 8712013112 2025-12-04T03:01:20Z Open Sri Kancharla Bhargav, Dy.EE(SWM) ENGINEERING SECTION ELECTION DEPARTMENT {"id": "112255596137", "mobile_number": "8712013112", "posted_by": "Sri Kancharla Bhargav, Dy.EE(SWM)", "remarks": "ENGINEERING SECTION ELECTION DEPARTMENT", "status": "Open", "time_stamp": "04-DEC-2025 08:31:20"}
101 50 50 3 112255596137 9700165778 2025-12-03T11:35:41Z Open sk waste still there {"id": "112255596137", "mobile_number": "9700165778", "posted_by": "sk", "remarks": "waste still there", "status": "Open", "time_stamp": "03-DEC-2025 17:05:41"}
102 50 50 4 112255596137 8712013112 2025-12-02T08:16:10Z Attended By Officer Sri Kancharla Bhargav, Dy.EE(SWM) Cleared sorry for the inconveniences {"id": "112255596137", "mobile_number": "8712013112", "posted_by": "Sri Kancharla Bhargav, Dy.EE(SWM)", "remarks": "Cleared sorry for the inconveniences", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 13:46:10"}
103 50 50 5 112255596137 9381459256 2025-12-02T06:45:27Z Open P.Venkateshwar Goud. forward {"id": "112255596137", "mobile_number": "9381459256", "posted_by": "P.Venkateshwar Goud.", "remarks": "forward", "status": "Open", "time_stamp": "02-DEC-2025 12:15:27"}

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