snapshot_comments
3 rows where snapshot_pk = 26
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 |
|---|---|---|---|---|---|---|---|---|---|
| 60 | 26 26 | 1 | 106255287919 | - | 2025-06-07T08:30:49Z | - | Call Centre | Not Satisfied | {"id": "106255287919", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "07-JUN-2025 14:00:49"} |
| 61 | 26 26 | 2 | 106255287919 | 9154797217 | 2025-06-06T11:19:31Z | Attended By Officer | Y.Rajitha | Fogging done. | {"id": "106255287919", "mobile_number": "9154797217", "posted_by": "Y.Rajitha", "remarks": "Fogging done.", "status": "Attended By Officer", "time_stamp": "06-JUN-2025 16:49:31"} |
| 62 | 26 26 | 3 | 106255287919 | 9959542712 | 2025-06-04T13:55:17Z | Open | Umer | Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. | {"id": "106255287919", "mobile_number": "9959542712", "posted_by": "Umer", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "04-JUN-2025 19:25:17"} |
Advanced export
JSON shape: default, array, newline-delimited, object
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)
);