snapshot_comments

8 rows where snapshot_pk = 64

✎ 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
137 64 64 1 110255503134 7337367271 2025-10-16T05:41:42Z Attended By Officer Sri Y.Shiva kumar Sir, Complaint will be resolved soon. {"id": "110255503134", "mobile_number": "7337367271", "posted_by": "Sri Y.Shiva kumar", "remarks": "Sir, Complaint will be resolved soon.", "status": "Attended By Officer", "time_stamp": "16-OCT-2025 11:11:42"}
138 64 64 2 110255503134 9133471055 2025-10-14T12:11:11Z Open Sri. N. Venkatesh please do the needful {"id": "110255503134", "mobile_number": "9133471055", "posted_by": "Sri. N. Venkatesh", "remarks": "please do the needful", "status": "Open", "time_stamp": "14-OCT-2025 17:41:11"}
139 64 64 3 110255503134 7337367271 2025-10-11T05:04:29Z Open Sri Y.Shiva kumar dear citizen please contact hmws manager for this drainage related issue pl {"id": "110255503134", "mobile_number": "7337367271", "posted_by": "Sri Y.Shiva kumar", "remarks": "dear citizen please contact hmws manager for this drainage related issue pl", "status": "Open", "time_stamp": "11-OCT-2025 10:34:29"}
140 64 64 4 110255503134 9133471055 2025-10-11T01:30:30Z Open Sri. N. Venkatesh please do the needful {"id": "110255503134", "mobile_number": "9133471055", "posted_by": "Sri. N. Venkatesh", "remarks": "please do the needful", "status": "Open", "time_stamp": "11-OCT-2025 07:00:30"}
141 64 64 5 110255503134 9885198396 2025-10-10T02:00:05Z Open Dr. Vijay Mohan Rao drinage owerflow {"id": "110255503134", "mobile_number": "9885198396", "posted_by": "Dr. Vijay Mohan Rao", "remarks": "drinage owerflow", "status": "Open", "time_stamp": "10-OCT-2025 07:30:05"}
142 64 64 6 110255503134 7337367271 2025-10-09T08:16:01Z Open Sri Y.Shiva kumar sir, / mdm Contact to Sanitation wing. {"id": "110255503134", "mobile_number": "7337367271", "posted_by": "Sri Y.Shiva kumar", "remarks": "sir, / mdm Contact to Sanitation wing.", "status": "Open", "time_stamp": "09-OCT-2025 13:46:01"}
143 64 64 7 110255503134 9133471055 2025-10-06T05:58:40Z Open Sri. N. Venkatesh please do the needful {"id": "110255503134", "mobile_number": "9133471055", "posted_by": "Sri. N. Venkatesh", "remarks": "please do the needful", "status": "Open", "time_stamp": "06-OCT-2025 11:28:40"}
144 64 64 8 110255503134 9885198396 2025-10-06T02:34:12Z Open Dr. Vijay Mohan Rao drinage owerflow {"id": "110255503134", "mobile_number": "9885198396", "posted_by": "Dr. Vijay Mohan Rao", "remarks": "drinage owerflow", "status": "Open", "time_stamp": "06-OCT-2025 08:04:12"}

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