snapshot_comments

2 rows where snapshot_pk = 45

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
70 45 45 1 101255052466 - 2025-01-06T08:30:17Z - Call Centre Partially Satisfied {"id": "101255052466", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Partially Satisfied", "status": "-", "time_stamp": "06-JAN-2025 14:00:17"}
71 45 45 2 101255052466 7207923086 2025-01-02T10:10:13Z Attended By Officer Dr. M. Vivekananda Dear citizen attended your grievance, dogs in your locality are sterilized, as per rules sterilized dogs cannot be relocated hence released then and there only after vaccinating with ARV. {"id": "101255052466", "mobile_number": "7207923086", "posted_by": "Dr. M. Vivekananda", "remarks": "Dear citizen attended your grievance, dogs in your locality are sterilized, as per rules sterilized dogs cannot be relocated hence released then and there only after vaccinating with ARV.", "status": "Attended By Officer", "time_stamp": "02-JAN-2025 15:40:13"}

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