snapshot_comments

5 rows where snapshot_pk = 35

✎ 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
74 35 35 1 104255188617 9989930592 2025-05-03T16:57:36Z Attended By Officer B.Swapna Sir, this complaint had already been lodged on other token no. and will be cleared shortly by considering the most recent Complaint ID please. {"id": "104255188617", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "Sir, this complaint had already been lodged on other token no. and will be cleared shortly by considering the most recent Complaint ID please.", "status": "Attended By Officer", "time_stamp": "03-MAY-2025 22:27:36"}
75 35 35 2 104255188617 9866466677 2025-05-02T13:57:27Z Open Srinivasarao not glowing of Street lights last one month 15 day problem is not solved {"id": "104255188617", "mobile_number": "9866466677", "posted_by": "Srinivasarao", "remarks": "not glowing of Street lights last one month 15 day problem is not solved", "status": "Open", "time_stamp": "02-MAY-2025 19:27:27"}
76 35 35 3 104255188617 9989930592 2025-04-28T13:42:08Z Attended By Officer B.Swapna Rectified {"id": "104255188617", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "Rectified", "status": "Attended By Officer", "time_stamp": "28-APR-2025 19:12:08"}
77 35 35 4 104255188617 9866466677 2025-04-21T12:39:58Z Open Srinivasarao not attend, last one month lights not digiling, very bad {"id": "104255188617", "mobile_number": "9866466677", "posted_by": "Srinivasarao", "remarks": "not attend, last one month lights not digiling, very bad", "status": "Open", "time_stamp": "21-APR-2025 18:09:58"}
78 35 35 5 104255188617 9989930592 2025-04-21T10:56:30Z Attended By Officer B.Swapna Rectified {"id": "104255188617", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "Rectified", "status": "Attended By Officer", "time_stamp": "21-APR-2025 16:26:30"}

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