snapshot_comments

22 rows where snapshot_pk = 45

✎ 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
81 45 45 1 101265640138 7995009082 2026-03-12T07:10:03Z Attended By Officer N. Abhishek rectified {"id": "101265640138", "mobile_number": "7995009082", "posted_by": "N. Abhishek", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "12-MAR-2026 12:40:03"}
82 45 45 2 101265640138 9000092421 2026-03-11T17:39:54Z Open Ravi J Not fixed..Don't close without fixing {"id": "101265640138", "mobile_number": "9000092421", "posted_by": "Ravi J", "remarks": "Not fixed..Don't close without fixing", "status": "Open", "time_stamp": "11-MAR-2026 23:09:54"}
83 45 45 3 101265640138 7995009082 2026-03-11T10:59:17Z Attended By Officer N. Abhishek rectified {"id": "101265640138", "mobile_number": "7995009082", "posted_by": "N. Abhishek", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "11-MAR-2026 16:29:17"}
84 45 45 4 101265640138 9000092421 2026-03-10T05:11:44Z Open Call Centre Not Satisfied {"id": "101265640138", "mobile_number": "9000092421", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "10-MAR-2026 10:41:44"}
85 45 45 5 101265640138 7995009082 2026-03-06T06:57:05Z Attended By Officer N. Abhishek rectified {"id": "101265640138", "mobile_number": "7995009082", "posted_by": "N. Abhishek", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "06-MAR-2026 12:27:05"}
86 45 45 6 101265640138 7337557237 2026-03-05T09:41:15Z Open S. Shravanthi pertains to vampuguda {"id": "101265640138", "mobile_number": "7337557237", "posted_by": "S. Shravanthi", "remarks": "pertains to vampuguda", "status": "Open", "time_stamp": "05-MAR-2026 15:11:15"}
87 45 45 7 101265640138 9000092421 2026-02-25T20:43:50Z Open Ravi J Not resolved {"id": "101265640138", "mobile_number": "9000092421", "posted_by": "Ravi J", "remarks": "Not resolved", "status": "Open", "time_stamp": "26-FEB-2026 02:13:50"}
88 45 45 8 101265640138 7207923094 2026-02-25T18:37:20Z Attended By Officer Roopa rectified {"id": "101265640138", "mobile_number": "7207923094", "posted_by": "Roopa", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "26-FEB-2026 00:07:20"}
89 45 45 9 101265640138 9000092421 2026-01-06T17:18:44Z Open Ravi J Reopen count 48 {"id": "101265640138", "mobile_number": "9000092421", "posted_by": "Ravi J", "remarks": "Reopen count 48", "status": "Open", "time_stamp": "06-JAN-2026 22:48:44"}
90 45 45 10 101265640138 9154296619 2026-01-05T11:53:29Z Attended By Officer B.Ravindra rectified {"id": "101265640138", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "05-JAN-2026 17:23:29"}
91 45 45 11 101265640138 9000092421 2026-01-04T16:58:53Z Open Ravi J Not fixed. Reopen count 48 {"id": "101265640138", "mobile_number": "9000092421", "posted_by": "Ravi J", "remarks": "Not fixed. Reopen count 48", "status": "Open", "time_stamp": "04-JAN-2026 22:28:53"}
92 45 45 12 101265640138 9154296619 2026-01-04T16:17:23Z Attended By Officer B.Ravindra rectified {"id": "101265640138", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "04-JAN-2026 21:47:23"}
93 45 45 13 101265640138 9000092421 2026-01-04T03:47:59Z Open Ravi J Reopen count 47 {"id": "101265640138", "mobile_number": "9000092421", "posted_by": "Ravi J", "remarks": "Reopen count 47", "status": "Open", "time_stamp": "04-JAN-2026 09:17:59"}
94 45 45 14 101265640138 9154296619 2026-01-04T00:32:08Z Attended By Officer B.Ravindra rectified {"id": "101265640138", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "04-JAN-2026 06:02:08"}
95 45 45 15 101265640138 9000092421 2026-01-03T16:10:41Z Open Ravi J Reopen count 46 {"id": "101265640138", "mobile_number": "9000092421", "posted_by": "Ravi J", "remarks": "Reopen count 46", "status": "Open", "time_stamp": "03-JAN-2026 21:40:41"}
96 45 45 16 101265640138 9154296619 2026-01-03T16:05:16Z Attended By Officer B.Ravindra rectified {"id": "101265640138", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-JAN-2026 21:35:16"}
97 45 45 17 101265640138 9000092421 2026-01-03T10:10:43Z Open Ravi J Reopening for 46th time {"id": "101265640138", "mobile_number": "9000092421", "posted_by": "Ravi J", "remarks": "Reopening for 46th time", "status": "Open", "time_stamp": "03-JAN-2026 15:40:43"}
98 45 45 18 101265640138 9154296619 2026-01-03T10:09:33Z Attended By Officer B.Ravindra rectified {"id": "101265640138", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-JAN-2026 15:39:33"}
99 45 45 19 101265640138 9000092421 2026-01-02T12:57:35Z Open Ravi J Not fixed since 1 year. Ticket reopen count 45 {"id": "101265640138", "mobile_number": "9000092421", "posted_by": "Ravi J", "remarks": "Not fixed since 1 year. Ticket reopen count 45", "status": "Open", "time_stamp": "02-JAN-2026 18:27:35"}
100 45 45 20 101265640138 9154296619 2026-01-02T11:41:49Z Attended By Officer B.Ravindra rectified {"id": "101265640138", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-JAN-2026 17:11:49"}
101 45 45 21 101265640138 9000092421 2026-01-02T01:39:31Z Open Ravi J Not working. Why are tickets being closed without attending? {"id": "101265640138", "mobile_number": "9000092421", "posted_by": "Ravi J", "remarks": "Not working. Why are tickets being closed without attending?", "status": "Open", "time_stamp": "02-JAN-2026 07:09:31"}
102 45 45 22 101265640138 9154296619 2026-01-02T01:37:27Z Attended By Officer B.Ravindra rectified {"id": "101265640138", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-JAN-2026 07:07: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)
);