snapshot_comments

6 rows where snapshot_pk = 32

✎ 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
78 32 32 1 106255287926 9705252127 2025-06-05T06:27:41Z Closed SamreenFatima Attended the non glowing of street light grievance they just came have a talk with us and said that they could not repair the street light as they dont have ladder and asking us for ladder they didnot even bother to solve our isssue and two persons left whole lane is dark at night please take serious action regarding our grievance we couldnot come out of our house after 7 {"id": "106255287926", "mobile_number": "9705252127", "posted_by": "SamreenFatima", "remarks": "Attended the non glowing of street light grievance they just came have a talk with us and said that they could not repair the street light as they dont have ladder and asking us for ladder they didnot even bother to solve our isssue and two persons left whole lane is dark at night please take serious action regarding our grievance we couldnot come out of our house after 7", "status": "Closed", "time_stamp": "05-JUN-2025 11:57:41"}
79 32 32 2 106255287926 9154299704 2025-06-03T10:24:46Z Attended By Officer Sri Narsing Rao tree cutting {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "tree cutting", "status": "Attended By Officer", "time_stamp": "03-JUN-2025 15:54:46"}
80 32 32 3 106255287926 9154299704 2025-06-02T09:51:21Z Open Sri Narsing Rao transfer {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "transfer", "status": "Open", "time_stamp": "02-JUN-2025 15:21:21"}
81 32 32 4 106255287926 9705252127 2025-06-02T09:48:53Z Open SamreenFatima Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. {"id": "106255287926", "mobile_number": "9705252127", "posted_by": "SamreenFatima", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "02-JUN-2025 15:18:53"}
82 32 32 5 106255287926 9154299704 2025-06-02T05:24:08Z Open Musharfuddin pertain to Mehdipatnam {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "pertain to Mehdipatnam", "status": "Open", "time_stamp": "02-JUN-2025 10:54:08"}
83 32 32 6 106255287926 9154299704 2025-06-02T05:23:21Z Under Process Musharfuddin under process {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "02-JUN-2025 10:53:21"}

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