snapshot_comments

3 rows where snapshot_pk = 30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: status_text, comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
62 30 30 1 104255188612 8008518801 2025-05-26T06:42:47Z Attended By Officer E. Chamundeshwari as per the door no 23-4-204 is in exemption list in the name of Sri.k.venkaiah with PTI no 1042304601 and regarding door no 23-4-197/4 is in 101 property list and it will be enhanced with the verification of TI as early as possible {"id": "104255188612", "mobile_number": "8008518801", "posted_by": "E. Chamundeshwari", "remarks": "as per the door no 23-4-204 is in exemption list in the name of Sri.k.venkaiah with PTI no 1042304601 and regarding door no 23-4-197/4 is in 101 property list and it will be enhanced with the verification of TI as early as possible", "status": "Attended By Officer", "time_stamp": "26-MAY-2025 12:12:47"}
63 30 30 2 104255188612 9849907631 2025-05-21T07:29:11Z Open P Surender Goud, Pertains to Chandrayagutta Circle {"id": "104255188612", "mobile_number": "9849907631", "posted_by": "P Surender Goud,", "remarks": "Pertains to Chandrayagutta Circle", "status": "Open", "time_stamp": "21-MAY-2025 12:59:11"}
64 30 30 3 104255188612 7799447111 2025-03-31T23:13:53Z Open Kiran plz kindly check in your records {"id": "104255188612", "mobile_number": "7799447111", "posted_by": "Kiran", "remarks": "plz kindly check in your records", "status": "Open", "time_stamp": "01-APR-2025 04:43:53"}

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