snapshot_comments

3 rows where snapshot_pk = 92

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: mobile_number, posted_by, comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
161 92 92 1 107255337747 7337557254 2025-07-04T04:23:46Z Open M Thirupathi illegal parking {"id": "107255337747", "mobile_number": "7337557254", "posted_by": "M Thirupathi", "remarks": "illegal parking", "status": "Open", "time_stamp": "04-JUL-2025 09:53:46"}
162 92 92 2 107255337747 6309919063 2025-07-03T08:58:35Z Open S.Haripriya Construction of community hall is done by engineering section. {"id": "107255337747", "mobile_number": "6309919063", "posted_by": "S.Haripriya", "remarks": "Construction of community hall is done by engineering section.", "status": "Open", "time_stamp": "03-JUL-2025 14:28:35"}
163 92 92 3 107255337747 6309919063 2025-07-03T08:52:38Z Open S.Haripriya This community hall is not handed over by engineering section to UCD section hence it has to go engineering section {"id": "107255337747", "mobile_number": "6309919063", "posted_by": "S.Haripriya", "remarks": "This community hall is not handed over by engineering section to UCD section hence it has to go engineering section", "status": "Open", "time_stamp": "03-JUL-2025 14:22:38"}

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