snapshot_comments

6 rows where snapshot_pk = 51

✎ 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
97 51 51 1 105255241087 - 2025-05-11T09:44:06Z - Call Centre Satisfied {"id": "105255241087", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "11-MAY-2025 15:14:06"}
98 51 51 2 105255241087 9966759696 2025-05-07T09:31:35Z Attended By Officer Sri.P.Raghuveer Reddy complint attended and closed {"id": "105255241087", "mobile_number": "9966759696", "posted_by": "Sri.P.Raghuveer Reddy", "remarks": "complint attended and closed", "status": "Attended By Officer", "time_stamp": "07-MAY-2025 15:01:35"}
99 51 51 3 105255241087 9966759696 2025-05-07T03:56:23Z Open Sri.P.Raghuveer Reddy address at Qutubullapir {"id": "105255241087", "mobile_number": "9966759696", "posted_by": "Sri.P.Raghuveer Reddy", "remarks": "address at Qutubullapir", "status": "Open", "time_stamp": "07-MAY-2025 09:26:23"}
100 51 51 4 105255241087 9966759696 2025-05-05T05:49:36Z Open Sri.P.Raghuveer Reddy forward to another ward 131 quthubullapur area {"id": "105255241087", "mobile_number": "9966759696", "posted_by": "Sri.P.Raghuveer Reddy", "remarks": "forward to another ward 131 quthubullapur area", "status": "Open", "time_stamp": "05-MAY-2025 11:19:36"}
101 51 51 5 105255241087 9966759696 2025-05-05T05:48:44Z Open Sri.P.Raghuveer Reddy forward to another ward {"id": "105255241087", "mobile_number": "9966759696", "posted_by": "Sri.P.Raghuveer Reddy", "remarks": "forward to another ward", "status": "Open", "time_stamp": "05-MAY-2025 11:18:44"}
102 51 51 6 105255241087 9966759696 2025-05-05T05:47:46Z Open Sri.P.Raghuveer Reddy forward to another ward {"id": "105255241087", "mobile_number": "9966759696", "posted_by": "Sri.P.Raghuveer Reddy", "remarks": "forward to another ward", "status": "Open", "time_stamp": "05-MAY-2025 11:17:46"}

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