snapshot_comments

11 rows where snapshot_pk = 86

✎ 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
137 86 86 1 108255392701 7757889171 2025-09-24T09:48:34Z Closed Call Centre Not Satisfied {"id": "108255392701", "mobile_number": "7757889171", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "24-SEP-2025 15:18:34"}
138 86 86 2 108255392701 9398508101 2025-09-10T05:51:56Z Attended By Officer Smt. N. Shireesha the BT plant is not working ... whenever plant is open we will rectify the problem very soon {"id": "108255392701", "mobile_number": "9398508101", "posted_by": "Smt. N. Shireesha", "remarks": "the BT plant is not working ... whenever plant is open we will rectify the problem very soon", "status": "Attended By Officer", "time_stamp": "10-SEP-2025 11:21:56"}
139 86 86 3 108255392701 7757889171 2025-08-23T00:00:28Z Open Siva Prasad It's ridiculous noone attended the problem and nothing is done still deep potholes are there any time road may cave in and may lead to major mishap., {"id": "108255392701", "mobile_number": "7757889171", "posted_by": "Siva Prasad", "remarks": "It's ridiculous noone attended the problem and nothing is done still deep potholes are there any time road may cave in and may lead to major mishap.,", "status": "Open", "time_stamp": "23-AUG-2025 05:30:28"}
140 86 86 4 108255392701 7757889171 2025-08-22T23:53:02Z Attended By Officer Siva Prasad It's ridiculous, noone attended the problem and nothing is done , still deep potholes are there and road may collapse any time which may lead to major mishap., {"id": "108255392701", "mobile_number": "7757889171", "posted_by": "Siva Prasad", "remarks": "It's ridiculous, noone attended the problem and nothing is done , still deep potholes are there and road may collapse any time which may lead to major mishap.,", "status": "Attended By Officer", "time_stamp": "23-AUG-2025 05:23:02"}
141 86 86 5 108255392701 9398508101 2025-08-19T11:23:34Z Attended By Officer Smt. N. Shireesha at present bt plant not working we will rectify the problem very soon {"id": "108255392701", "mobile_number": "9398508101", "posted_by": "Smt. N. Shireesha", "remarks": "at present bt plant not working we will rectify the problem very soon", "status": "Attended By Officer", "time_stamp": "19-AUG-2025 16:53:34"}
142 86 86 6 108255392701 7757889171 2025-08-13T10:48:06Z Open Siva Prasad I don't understand what is your problem, I have raised this issue ten days back , but it is still not resolved ,. i will escalate this to higher official and to our corporator too., {"id": "108255392701", "mobile_number": "7757889171", "posted_by": "Siva Prasad", "remarks": "I don't understand what is your problem, I have raised this issue ten days back , but it is still not resolved ,. i will escalate this to higher official and to our corporator too.,", "status": "Open", "time_stamp": "13-AUG-2025 16:18:06"}
143 86 86 7 108255392701 7757889171 2025-08-06T07:29:54Z Open Siva Prasad It's not yet completed, should I go to next higher official to get it done ,. kindly understand road may cave in and collapse at any time,. it may lead to bigger loss ., {"id": "108255392701", "mobile_number": "7757889171", "posted_by": "Siva Prasad", "remarks": "It's not yet completed, should I go to next higher official to get it done ,. kindly understand road may cave in and collapse at any time,. it may lead to bigger loss .,", "status": "Open", "time_stamp": "06-AUG-2025 12:59:54"}
144 86 86 8 108255392701 7331189509 2025-08-04T11:24:11Z Open B Venkanna 38 {"id": "108255392701", "mobile_number": "7331189509", "posted_by": "B Venkanna", "remarks": "38", "status": "Open", "time_stamp": "04-AUG-2025 16:54:11"}
145 86 86 9 108255392701 7757889171 2025-08-03T15:08:37Z Open Siva Prasad No Progress {"id": "108255392701", "mobile_number": "7757889171", "posted_by": "Siva Prasad", "remarks": "No Progress", "status": "Open", "time_stamp": "03-AUG-2025 20:38:37"}
146 86 86 10 108255392701 7757889171 2025-08-03T09:35:21Z Open Siva Prasad It's urgent kindly look into the problem., {"id": "108255392701", "mobile_number": "7757889171", "posted_by": "Siva Prasad", "remarks": "It's urgent kindly look into the problem.,", "status": "Open", "time_stamp": "03-AUG-2025 15:05:21"}
147 86 86 11 108255392701 7757889171 2025-08-02T09:56:13Z Open Siva Prasad No Progress in the issue {"id": "108255392701", "mobile_number": "7757889171", "posted_by": "Siva Prasad", "remarks": "No Progress in the issue", "status": "Open", "time_stamp": "02-AUG-2025 15:26:13"}

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