snapshot_comments

7 rows where snapshot_pk = 86

✎ 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
164 86 86 1 101265640183 7331186855 2026-02-27T10:11:40Z Submitted for Sanction B. Suraj Desya It is kindly requested to contact : Sri Raj Mohammed- 8374264972( Mallapur Electrician) Sri Umesh- 8522993069 ( Nacharam Electrician). Thank you. {"id": "101265640183", "mobile_number": "7331186855", "posted_by": "B. Suraj Desya", "remarks": "It is kindly requested to contact : Sri Raj Mohammed- 8374264972( Mallapur Electrician) Sri Umesh- 8522993069 ( Nacharam Electrician). Thank you.", "status": "Submitted for Sanction", "time_stamp": "27-FEB-2026 15:41:40"}
165 86 86 2 101265640183 6302503323 2026-01-17T10:46:26Z Open A.Vani location is not in Ghatkesar circle judiciary {"id": "101265640183", "mobile_number": "6302503323", "posted_by": "A.Vani", "remarks": "location is not in Ghatkesar circle judiciary", "status": "Open", "time_stamp": "17-JAN-2026 16:16:26"}
166 86 86 3 101265640183 9440354087 2026-01-08T08:37:41Z Open Call Centre Not Satisfied {"id": "101265640183", "mobile_number": "9440354087", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "08-JAN-2026 14:07:41"}
167 86 86 4 101265640183 9154296619 2026-01-03T10:09:06Z Attended By Officer B.Ravindra rectified {"id": "101265640183", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-JAN-2026 15:39:06"}
168 86 86 5 101265640183 9440354087 2026-01-02T15:13:39Z Open K V avadhanulu Not resolved {"id": "101265640183", "mobile_number": "9440354087", "posted_by": "K V avadhanulu", "remarks": "Not resolved", "status": "Open", "time_stamp": "02-JAN-2026 20:43:39"}
169 86 86 6 101265640183 9154296619 2026-01-02T11:41:16Z Attended By Officer B.Ravindra rectified {"id": "101265640183", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-JAN-2026 17:11:16"}
170 86 86 7 101265640183 9381459256 2026-01-02T02:30:30Z Open P.Venkateshwar Goud. forward {"id": "101265640183", "mobile_number": "9381459256", "posted_by": "P.Venkateshwar Goud.", "remarks": "forward", "status": "Open", "time_stamp": "02-JAN-2026 08:00:30"}

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