snapshot_comments

5 rows where snapshot_pk = 40

✎ 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
64 40 40 1 108255392650 7893020370 2025-10-13T17:02:31Z Closed Manne Kishore . {"id": "108255392650", "mobile_number": "7893020370", "posted_by": "Manne Kishore", "remarks": ".", "status": "Closed", "time_stamp": "13-OCT-2025 22:32:31"}
65 40 40 2 108255392650 8790624601 2025-10-13T15:34:13Z Attended By Officer Sri Jameel Resolved {"id": "108255392650", "mobile_number": "8790624601", "posted_by": "Sri Jameel", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "13-OCT-2025 21:04:13"}
66 40 40 3 108255392650 7893020370 2025-09-02T09:02:36Z Open Manne Kishore After visiting the CM Sri Revanth Reddy Garu and Sri Ranganathan Garu we have blessed with glossy finished road provided by authorities only the problem is walkers are slipping on the road due to over smooth finishing. Kindly Give a Glance. Shubhodayam. {"id": "108255392650", "mobile_number": "7893020370", "posted_by": "Manne Kishore", "remarks": "After visiting the CM Sri Revanth Reddy Garu and Sri Ranganathan Garu we have blessed with glossy finished road provided by authorities only the problem is walkers are slipping on the road due to over smooth finishing. Kindly Give a Glance. Shubhodayam.", "status": "Open", "time_stamp": "02-SEP-2025 14:32:36"}
67 40 40 4 108255392650 7893020370 2025-08-08T08:06:34Z Open Manne Kishore Kept Conference with concern officer Sri Jameel ,AE/ENG(8790624601) Officer number is not connected {"id": "108255392650", "mobile_number": "7893020370", "posted_by": "Manne Kishore", "remarks": "Kept Conference with concern officer Sri Jameel ,AE/ENG(8790624601) Officer number is not connected", "status": "Open", "time_stamp": "08-AUG-2025 13:36:34"}
68 40 40 5 108255392650 7995009076 2025-08-01T00:53:55Z Open Sri.M.Bharat Kumar Area pertains to ameerpet ward {"id": "108255392650", "mobile_number": "7995009076", "posted_by": "Sri.M.Bharat Kumar", "remarks": "Area pertains to ameerpet ward", "status": "Open", "time_stamp": "01-AUG-2025 06:23:55"}

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