snapshot_comments

3 rows where snapshot_pk = 5

✎ 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
10 5 5 1 105255241041 7993360321 2025-05-27T05:39:21Z Closed Smt.Preethi Vennila Palagani resolved by the respondents {"id": "105255241041", "mobile_number": "7993360321", "posted_by": "Smt.Preethi Vennila Palagani", "remarks": "resolved by the respondents", "status": "Closed", "time_stamp": "27-MAY-2025 11:09:21"}
11 5 5 2 105255241041 7075501390 2025-05-01T02:18:40Z Open Shashi samha shiva rao Citizen informed that the grievance has been pending So please take necessary action Thank you sir. {"id": "105255241041", "mobile_number": "7075501390", "posted_by": "Shashi samha shiva rao", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "01-MAY-2025 07:48:40"}
12 5 5 3 105255241041 7075501390 2025-04-30T19:17:18Z Open Shashi samha shiva rao Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "105255241041", "mobile_number": "7075501390", "posted_by": "Shashi samha shiva rao", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "01-MAY-2025 00:47:18"}

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