snapshot_comments

6 rows where snapshot_pk = 21

✎ 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
47 21 21 1 112255596108 9949994049 2025-12-27T06:58:22Z Attended By Officer E. SURENDER REDDY This office has issued show cause notice and further action will be taken {"id": "112255596108", "mobile_number": "9949994049", "posted_by": "E. SURENDER REDDY", "remarks": "This office has issued show cause notice and further action will be taken", "status": "Attended By Officer", "time_stamp": "27-DEC-2025 12:28:22"}
48 21 21 2 112255596108 9866589490 2025-12-12T11:59:32Z Open Call Centre Not Satisfied {"id": "112255596108", "mobile_number": "9866589490", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "12-DEC-2025 17:29:32"}
49 21 21 3 112255596108 9949994049 2025-12-05T06:29:03Z Attended By Officer E. SURENDER REDDY This office has inspected the site and further necessary action will be taken {"id": "112255596108", "mobile_number": "9949994049", "posted_by": "E. SURENDER REDDY", "remarks": "This office has inspected the site and further necessary action will be taken", "status": "Attended By Officer", "time_stamp": "05-DEC-2025 11:59:03"}
50 21 21 4 112255596108 9866589490 2025-12-02T11:14:30Z Open pavan Height of the building is too much and damaging My house and encouragement to road {"id": "112255596108", "mobile_number": "9866589490", "posted_by": "pavan", "remarks": "Height of the building is too much and damaging My house and encouragement to road", "status": "Open", "time_stamp": "02-DEC-2025 16:44:30"}
51 21 21 5 112255596108 9949994049 2025-12-02T11:03:46Z Attended By Officer E. SURENDER REDDY This office will inspect the site and take further necessary action {"id": "112255596108", "mobile_number": "9949994049", "posted_by": "E. SURENDER REDDY", "remarks": "This office will inspect the site and take further necessary action", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 16:33:46"}
52 21 21 6 112255596108 9866589490 2025-12-01T00:30:25Z Open pavan over height of the building than the cc road is effecting neighbours. 4 to 5 feet height than neighbour so their water or seepage will damage our premises. please try to understand street dogs are jumping or the wall and damage My belongings and disturb the sleep in the mid night. {"id": "112255596108", "mobile_number": "9866589490", "posted_by": "pavan", "remarks": "over height of the building than the cc road is effecting neighbours. 4 to 5 feet height than neighbour so their water or seepage will damage our premises. please try to understand street dogs are jumping or the wall and damage My belongings and disturb the sleep in the mid night.", "status": "Open", "time_stamp": "01-DEC-2025 06:00:25"}

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