snapshot_comments

8 rows where snapshot_pk = 47

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: mobile_number, status_text, posted_by, remarks, comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
85 47 47 1 105255241083 - 2025-06-29T11:10:10Z - Call Centre Not Satisfied {"id": "105255241083", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "29-JUN-2025 16:40:10"}
86 47 47 2 105255241083 7995009074 2025-06-17T06:35:55Z Attended By Officer Sri Uday Kumar solved {"id": "105255241083", "mobile_number": "7995009074", "posted_by": "Sri Uday Kumar", "remarks": "solved", "status": "Attended By Officer", "time_stamp": "17-JUN-2025 12:05:55"}
87 47 47 3 105255241083 8328418879 2025-06-14T06:21:26Z Open Kammar Begum Citicen informed that the grievence has been pending.so please take necessary action.Thank you sir {"id": "105255241083", "mobile_number": "8328418879", "posted_by": "Kammar Begum", "remarks": "Citicen informed that the grievence has been pending.so please take necessary action.Thank you sir", "status": "Open", "time_stamp": "14-JUN-2025 11:51:26"}
88 47 47 4 105255241083 8328418879 2025-05-31T05:19:47Z Open Kammar Begum Citicen informed that the grievence has been pending.so please take necessary action.Thank you sir {"id": "105255241083", "mobile_number": "8328418879", "posted_by": "Kammar Begum", "remarks": "Citicen informed that the grievence has been pending.so please take necessary action.Thank you sir", "status": "Open", "time_stamp": "31-MAY-2025 10:49:47"}
89 47 47 5 105255241083 8328418879 2025-05-28T05:43:59Z Open Kammar Begum Citicen informed that the grievence has been pending.so please take necessary action.Thank you sir {"id": "105255241083", "mobile_number": "8328418879", "posted_by": "Kammar Begum", "remarks": "Citicen informed that the grievence has been pending.so please take necessary action.Thank you sir", "status": "Open", "time_stamp": "28-MAY-2025 11:13:59"}
90 47 47 6 105255241083 8328418879 2025-05-20T04:07:55Z Open Kammar Begum Citicen informed that the grievence has been pending.so please take necessary action.Thank you sir {"id": "105255241083", "mobile_number": "8328418879", "posted_by": "Kammar Begum", "remarks": "Citicen informed that the grievence has been pending.so please take necessary action.Thank you sir", "status": "Open", "time_stamp": "20-MAY-2025 09:37:55"}
91 47 47 7 105255241083 8328418879 2025-05-15T04:59:08Z Open Kammar Begum Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. {"id": "105255241083", "mobile_number": "8328418879", "posted_by": "Kammar Begum", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "15-MAY-2025 10:29:08"}
92 47 47 8 105255241083 8328418879 2025-05-06T09:17:26Z Open Kammar Begum Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "105255241083", "mobile_number": "8328418879", "posted_by": "Kammar Begum", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "06-MAY-2025 14:47:26"}

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