snapshot_comments

5 rows where snapshot_pk = 93

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: mobile_number, status_text, comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
164 93 93 1 107255337748 8008556852 2026-02-23T13:44:40Z Attended By Officer E.NAGI REDDY we will remove encroachment during encroachment drive program {"id": "107255337748", "mobile_number": "8008556852", "posted_by": "E.NAGI REDDY", "remarks": "we will remove encroachment during encroachment drive program", "status": "Attended By Officer", "time_stamp": "23-FEB-2026 19:14:40"}
165 93 93 2 107255337748 6302503323 2026-01-17T10:59:32Z Open A.Vani location is not in Ghatkesar circle judiciary {"id": "107255337748", "mobile_number": "6302503323", "posted_by": "A.Vani", "remarks": "location is not in Ghatkesar circle judiciary", "status": "Open", "time_stamp": "17-JAN-2026 16:29:32"}
166 93 93 3 107255337748 9948850299 2026-01-14T10:35:20Z Open Call Centre Not Satisfied {"id": "107255337748", "mobile_number": "9948850299", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "14-JAN-2026 16:05:20"}
167 93 93 4 107255337748 9948850299 2025-12-24T08:54:58Z Attended By Officer Journlist KP still the issue is nit attended by any officer.. no response for calls {"id": "107255337748", "mobile_number": "9948850299", "posted_by": "Journlist KP", "remarks": "still the issue is nit attended by any officer.. no response for calls", "status": "Attended By Officer", "time_stamp": "24-DEC-2025 14:24:58"}
168 93 93 5 107255337748 9121243819 2025-07-07T11:02:46Z Attended By Officer Sri.P.KrishnaMurthy Encroachment will be removed duly conducting the encroachment drive. {"id": "107255337748", "mobile_number": "9121243819", "posted_by": "Sri.P.KrishnaMurthy", "remarks": "Encroachment will be removed duly conducting the encroachment drive.", "status": "Attended By Officer", "time_stamp": "07-JUL-2025 16:32: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)
);