snapshot_comments
6 rows where snapshot_pk = 5
This data as json, CSV (advanced)
Suggested facets: mobile_number, status_text, comment_timestamp (date)
| comment_pk ▼ | snapshot_pk | ordinal | complaint_id | mobile_number | comment_timestamp | status_text | posted_by | remarks | raw_comment_json |
|---|---|---|---|---|---|---|---|---|---|
| 6 | 5 5 | 1 | 110255503075 | 8341712808 | 2025-11-02T08:32:23Z | Closed | Call Centre | Not Satisfied | {"id": "110255503075", "mobile_number": "8341712808", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "02-NOV-2025 14:02:23"} |
| 7 | 5 5 | 2 | 110255503075 | 7331189190 | 2025-10-10T06:11:18Z | Attended By Officer | P Vigneshwari | Sir, patch work is pending due to water supply line leakage. However, our team has temporarily addressed the issue with WMM to make the road motorable. | {"id": "110255503075", "mobile_number": "7331189190", "posted_by": "P Vigneshwari", "remarks": "Sir, patch work is pending due to water supply line leakage. However, our team has temporarily addressed the issue with WMM to make the road motorable.", "status": "Attended By Officer", "time_stamp": "10-OCT-2025 11:41:18"} |
| 8 | 5 5 | 3 | 110255503075 | 8341712808 | 2025-10-07T09:43:07Z | Open | ShivaChandan | Why are you claiming that you have resolved when it is not. Not even an inch of work has started there. | {"id": "110255503075", "mobile_number": "8341712808", "posted_by": "ShivaChandan", "remarks": "Why are you claiming that you have resolved when it is not. Not even an inch of work has started there.", "status": "Open", "time_stamp": "07-OCT-2025 15:13:07"} |
| 9 | 5 5 | 4 | 110255503075 | 8247250922 | 2025-10-07T08:28:39Z | Attended By Officer | Smt. Sakina fatima | this issue resolved h | {"id": "110255503075", "mobile_number": "8247250922", "posted_by": "Smt. Sakina fatima", "remarks": "this issue resolved h", "status": "Attended By Officer", "time_stamp": "07-OCT-2025 13:58:39"} |
| 10 | 5 5 | 5 | 110255503075 | 7331186857 | 2025-10-06T07:47:22Z | Open | Kedareshwari | pertains to ward15 | {"id": "110255503075", "mobile_number": "7331186857", "posted_by": "Kedareshwari", "remarks": "pertains to ward15", "status": "Open", "time_stamp": "06-OCT-2025 13:17:22"} |
| 11 | 5 5 | 6 | 110255503075 | 8341712808 | 2025-10-01T05:46:42Z | Open | Ward019 | HASTINAPURAM WARD 16 | {"id": "110255503075", "mobile_number": "8341712808", "posted_by": "Ward019", "remarks": "HASTINAPURAM WARD 16", "status": "Open", "time_stamp": "01-OCT-2025 11:16:42"} |
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)
);