snapshot_comments

8 rows where snapshot_pk = 32

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: mobile_number, status_text, 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
66 32 32 1 104255188614 9702073700 2025-04-16T05:24:24Z Closed B AJAY KUMAR 04 months to fix the street light. {"id": "104255188614", "mobile_number": "9702073700", "posted_by": "B AJAY KUMAR", "remarks": "04 months to fix the street light.", "status": "Closed", "time_stamp": "16-APR-2025 10:54:24"}
67 32 32 2 104255188614 9154299632 2025-04-16T02:31:05Z Attended By Officer Sri T R Prasad solved by eesl team {"id": "104255188614", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "solved by eesl team", "status": "Attended By Officer", "time_stamp": "16-APR-2025 08:01:05"}
68 32 32 3 104255188614 9702073700 2025-04-11T00:54:31Z Open B AJAY KUMAR grievance attended yesterday 10th March 2025 , light glowing now. refer attached picture. kindly close the grievance. {"id": "104255188614", "mobile_number": "9702073700", "posted_by": "B AJAY KUMAR", "remarks": "grievance attended yesterday 10th March 2025 , light glowing now. refer attached picture. kindly close the grievance.", "status": "Open", "time_stamp": "11-APR-2025 06:24:31"}
69 32 32 4 104255188614 9702073700 2025-04-02T14:42:28Z Open B AJAY KUMAR not glowing, video shared with all concerned GHMC STAFF VIKRAM, VITAL, T R PRASAD {"id": "104255188614", "mobile_number": "9702073700", "posted_by": "B AJAY KUMAR", "remarks": "not glowing, video shared with all concerned GHMC STAFF VIKRAM, VITAL, T R PRASAD", "status": "Open", "time_stamp": "02-APR-2025 20:12:28"}
70 32 32 5 104255188614 9154299632 2025-04-02T08:33:20Z Attended By Officer Sri T R Prasad Carbor removed and rectified {"id": "104255188614", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "Carbor removed and rectified", "status": "Attended By Officer", "time_stamp": "02-APR-2025 14:03:20"}
71 32 32 6 104255188614 9702073700 2025-04-01T15:28:20Z Open B AJAY KUMAR As per the staff he doesn't have the ladder to fix this street light during telephinic conversation. {"id": "104255188614", "mobile_number": "9702073700", "posted_by": "B AJAY KUMAR", "remarks": "As per the staff he doesn't have the ladder to fix this street light during telephinic conversation.", "status": "Open", "time_stamp": "01-APR-2025 20:58:20"}
72 32 32 7 104255188614 9154299632 2025-04-01T12:05:59Z Attended By Officer Sri T R Prasad Carbor removed and rectified {"id": "104255188614", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "Carbor removed and rectified", "status": "Attended By Officer", "time_stamp": "01-APR-2025 17:35:59"}
73 32 32 8 104255188614 9154299632 2025-04-01T01:59:53Z Under Process Sri T R Prasad informed to Eesl team {"id": "104255188614", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "informed to Eesl team", "status": "Under Process", "time_stamp": "01-APR-2025 07:29:53"}

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