snapshot_comments

3 rows where snapshot_pk = 61

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: mobile_number, 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
98 61 61 1 103255140357 7989301584 2025-03-05T03:13:40Z Attended By Officer Dr.K.Manjula sweeping clear {"id": "103255140357", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "sweeping clear", "status": "Attended By Officer", "time_stamp": "05-MAR-2025 08:43:40"}
99 61 61 2 103255140357 8885522255 2025-03-04T11:21:49Z Attended By Officer Nagendra No show by the Sweepers inspite of repeated complaints. The Officer is just closing the complaint when ai tried to call and reach no response on the phone number. The image uploaded in the comments is not our street. Wake up {"id": "103255140357", "mobile_number": "8885522255", "posted_by": "Nagendra", "remarks": "No show by the Sweepers inspite of repeated complaints. The Officer is just closing the complaint when ai tried to call and reach no response on the phone number. The image uploaded in the comments is not our street. Wake up", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 16:51:49"}
100 61 61 3 103255140357 7989301584 2025-03-02T22:59:11Z Attended By Officer Dr.K.Manjula sweeping clear {"id": "103255140357", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "sweeping clear", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 04:29:11"}

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