snapshot_comments
7 rows where snapshot_pk = 44
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 |
|---|---|---|---|---|---|---|---|---|---|
| 79 | 44 44 | 1 | 111255552195 | 9849995922 | 2026-01-05T05:31:39Z | Attended By Officer | M.B.GAJANANDAN | this office inspected the site and notices were issued and further action will be initiated under due process of law | {"id": "111255552195", "mobile_number": "9849995922", "posted_by": "M.B.GAJANANDAN", "remarks": "this office inspected the site and notices were issued and further action will be initiated under due process of law", "status": "Attended By Officer", "time_stamp": "05-JAN-2026 11:01:39"} |
| 80 | 44 44 | 2 | 111255552195 | 9550079759 | 2025-12-09T07:19:07Z | Open | Mohammed Mukarram | Nobody checked and simply closed the ticket | {"id": "111255552195", "mobile_number": "9550079759", "posted_by": "Mohammed Mukarram", "remarks": "Nobody checked and simply closed the ticket", "status": "Open", "time_stamp": "09-DEC-2025 12:49:07"} |
| 81 | 44 44 | 3 | 111255552195 | 9849995922 | 2025-12-09T07:18:05Z | Attended By Officer | M.B.GAJANANDAN | this office inspected the site and notice issued to the site owners and further action will be initiated under due course of law. | {"id": "111255552195", "mobile_number": "9849995922", "posted_by": "M.B.GAJANANDAN", "remarks": "this office inspected the site and notice issued to the site owners and further action will be initiated under due course of law.", "status": "Attended By Officer", "time_stamp": "09-DEC-2025 12:48:05"} |
| 82 | 44 44 | 4 | 111255552195 | 9550079759 | 2025-11-10T15:59:09Z | Open | Mohammed Mukarram | This request is getting closed without any action. | {"id": "111255552195", "mobile_number": "9550079759", "posted_by": "Mohammed Mukarram", "remarks": "This request is getting closed without any action.", "status": "Open", "time_stamp": "10-NOV-2025 21:29:09"} |
| 83 | 44 44 | 5 | 111255552195 | 9849995922 | 2025-11-10T07:25:13Z | Attended By Officer | M.B.GAJANANDAN | this office will inspect the site and notices will be issued | {"id": "111255552195", "mobile_number": "9849995922", "posted_by": "M.B.GAJANANDAN", "remarks": "this office will inspect the site and notices will be issued", "status": "Attended By Officer", "time_stamp": "10-NOV-2025 12:55:13"} |
| 84 | 44 44 | 6 | 111255552195 | 9550079759 | 2025-11-10T05:59:20Z | Open | Mohammed Mukarram | As attached in photo, 2 shops are being open in this narrow road which will create issues for bypassers. Complaint is being raised by infront house owner Anwar mobile number 9652343278 | {"id": "111255552195", "mobile_number": "9550079759", "posted_by": "Mohammed Mukarram", "remarks": "As attached in photo, 2 shops are being open in this narrow road which will create issues for bypassers. Complaint is being raised by infront house owner Anwar mobile number 9652343278", "status": "Open", "time_stamp": "10-NOV-2025 11:29:20"} |
| 85 | 44 44 | 7 | 111255552195 | 9849995922 | 2025-11-10T05:48:56Z | Attended By Officer | M.B.GAJANANDAN | this office will inspect the site and further action will be taken as per law | {"id": "111255552195", "mobile_number": "9849995922", "posted_by": "M.B.GAJANANDAN", "remarks": "this office will inspect the site and further action will be taken as per law", "status": "Attended By Officer", "time_stamp": "10-NOV-2025 11:18:56"} |
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)
);