snapshot_comments

3 rows where snapshot_pk = 35

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: mobile_number, status_text, posted_by, comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
89 35 35 1 106255287929 8008556852 2025-10-03T06:56:56Z Attended By Officer Sri E. Nagi Reddy Action willbe initiated following due procedure of law. {"id": "106255287929", "mobile_number": "8008556852", "posted_by": "Sri E. Nagi Reddy", "remarks": "Action willbe initiated following due procedure of law.", "status": "Attended By Officer", "time_stamp": "03-OCT-2025 12:26:56"}
90 35 35 2 106255287929 7075543399 2025-06-22T12:36:29Z Open Not What type of solution u done.no one can attend still now. {"id": "106255287929", "mobile_number": "7075543399", "posted_by": "Not", "remarks": "What type of solution u done.no one can attend still now.", "status": "Open", "time_stamp": "22-JUN-2025 18:06:29"}
91 35 35 3 106255287929 8008556852 2025-06-21T11:30:28Z Attended By Officer Sri E. Nagi Reddy Encroachments drive will be conducted with the coordination of traffic police and will be removed. {"id": "106255287929", "mobile_number": "8008556852", "posted_by": "Sri E. Nagi Reddy", "remarks": "Encroachments drive will be conducted with the coordination of traffic police and will be removed.", "status": "Attended By Officer", "time_stamp": "21-JUN-2025 17:00:28"}

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