snapshot_comments

11 rows where snapshot_pk = 7

✎ 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
15 7 7 1 110255503077 9154299704 2025-10-22T13:32:34Z Attended By Officer Sri Narsing Rao k {"id": "110255503077", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "22-OCT-2025 19:02:34"}
16 7 7 2 110255503077 8978434143 2025-10-18T04:16:44Z Open Ali Street lights he said within 4 days its will be completed still now it’s pending {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Street lights he said within 4 days its will be completed still now it’s pending", "status": "Open", "time_stamp": "18-OCT-2025 09:46:44"}
17 7 7 3 110255503077 8978434143 2025-10-18T04:15:27Z Attended By Officer Ali Not Attend {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Not Attend", "status": "Attended By Officer", "time_stamp": "18-OCT-2025 09:45:27"}
18 7 7 4 110255503077 9154299704 2025-10-15T07:17:19Z Attended By Officer Sri Narsing Rao k {"id": "110255503077", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "15-OCT-2025 12:47:19"}
19 7 7 5 110255503077 8978434143 2025-10-08T15:38:00Z Open Ali Still its Pending from 27 July … No work is done simply without any resolution closing Ticket. If citizens have given complaint you have to rectified.. not to give Fake comments {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Still its Pending from 27 July … No work is done simply without any resolution closing Ticket. If citizens have given complaint you have to rectified.. not to give Fake comments", "status": "Open", "time_stamp": "08-OCT-2025 21:08:00"}
20 7 7 6 110255503077 8978434143 2025-10-08T15:35:41Z Attended By Officer Ali not Attending {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "not Attending", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 21:05:41"}
21 7 7 7 110255503077 9154299704 2025-10-08T08:28:58Z Attended By Officer Sri Narsing Rao k {"id": "110255503077", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 13:58:58"}
22 7 7 8 110255503077 9154295249 2025-10-04T08:14:24Z Open Sai Chandana forward to Red hills {"id": "110255503077", "mobile_number": "9154295249", "posted_by": "Sai Chandana", "remarks": "forward to Red hills", "status": "Open", "time_stamp": "04-OCT-2025 13:44:24"}
23 7 7 9 110255503077 8978434143 2025-10-01T11:04:37Z Open Ali Not Attending {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Not Attending", "status": "Open", "time_stamp": "01-OCT-2025 16:34:37"}
24 7 7 10 110255503077 8978434143 2025-10-01T11:04:06Z Attended By Officer Ali Not attend {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Not attend", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 16:34:06"}
25 7 7 11 110255503077 9154295249 2025-10-01T10:25:47Z Attended By Officer Sai Chandana rectified {"id": "110255503077", "mobile_number": "9154295249", "posted_by": "Sai Chandana", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 15:55:47"}

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