snapshot_comments

6 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
72 35 35 1 101265640127 7331189506 2026-01-21T07:50:50Z Attended By Officer D.Karthik Kiran Complainant not responded to calls, SAT vehicle TS13UC7456, Harikrishna- 9398482359 tie-up is available may be contacted {"id": "101265640127", "mobile_number": "7331189506", "posted_by": "D.Karthik Kiran", "remarks": "Complainant not responded to calls, SAT vehicle TS13UC7456, Harikrishna- 9398482359 tie-up is available may be contacted", "status": "Attended By Officer", "time_stamp": "21-JAN-2026 13:20:50"}
73 35 35 2 101265640127 7995007410 2026-01-20T02:59:46Z Open Mohd Fareed pls contact {"id": "101265640127", "mobile_number": "7995007410", "posted_by": "Mohd Fareed", "remarks": "pls contact", "status": "Open", "time_stamp": "20-JAN-2026 08:29:46"}
74 35 35 3 101265640127 7995007410 2026-01-20T02:51:19Z Open Mohd Fareed pls contact {"id": "101265640127", "mobile_number": "7995007410", "posted_by": "Mohd Fareed", "remarks": "pls contact", "status": "Open", "time_stamp": "20-JAN-2026 08:21:19"}
75 35 35 4 101265640127 9700241486 2026-01-05T11:39:53Z Open Call Centre Not Satisfied {"id": "101265640127", "mobile_number": "9700241486", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "05-JAN-2026 17:09:53"}
76 35 35 5 101265640127 9063843649 2026-01-02T04:29:36Z Attended By Officer Dr. Ravinder Goud Resolved {"id": "101265640127", "mobile_number": "9063843649", "posted_by": "Dr. Ravinder Goud", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "02-JAN-2026 09:59:36"}
77 35 35 6 101265640127 8712419173 2026-01-01T06:02:51Z Open Sri K Rajesh, DYEE SWM Pertaining to the other ward {"id": "101265640127", "mobile_number": "8712419173", "posted_by": "Sri K Rajesh, DYEE SWM", "remarks": "Pertaining to the other ward", "status": "Open", "time_stamp": "01-JAN-2026 11:32:51"}

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