snapshot_comments
7 rows where snapshot_pk = 23
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 |
|---|---|---|---|---|---|---|---|---|---|
| 49 | 23 23 | 1 | 106255287921 | 9154909321 | 2025-09-09T04:28:49Z | Attended By Officer | K.Raju | car not remove | {"id": "106255287921", "mobile_number": "9154909321", "posted_by": "K.Raju", "remarks": "car not remove", "status": "Attended By Officer", "time_stamp": "09-SEP-2025 09:58:49"} |
| 50 | 23 23 | 2 | 106255287921 | 9700953354 | 2025-08-20T10:12:49Z | Open | Habeeb | its been more then two months the problem has bot been resolved....when i am trying to call the ae his phone is switched off | {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "its been more then two months the problem has bot been resolved....when i am trying to call the ae his phone is switched off", "status": "Open", "time_stamp": "20-AUG-2025 15:42:49"} |
| 51 | 23 23 | 3 | 106255287921 | 9700953354 | 2025-07-20T20:56:22Z | Open | Habeeb | The officer came along with the ladder and they told that they cannot climb on such height through ladder,it required crane to solve it..it's been more then 2 months the issue hasn't resolved | {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "The officer came along with the ladder and they told that they cannot climb on such height through ladder,it required crane to solve it..it's been more then 2 months the issue hasn't resolved", "status": "Open", "time_stamp": "21-JUL-2025 02:26:22"} |
| 52 | 23 23 | 4 | 106255287921 | 9700953354 | 2025-07-20T20:48:40Z | Attended By Officer | Habeeb | and moreover the photo uploaded by officer of streetlight is of beside pole | {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "and moreover the photo uploaded by officer of streetlight is of beside pole", "status": "Attended By Officer", "time_stamp": "21-JUL-2025 02:18:40"} |
| 53 | 23 23 | 5 | 106255287921 | 9700953354 | 2025-07-20T20:45:00Z | Attended By Officer | Habeeb | the issue has not been resolved yet....in the status it's showing it's completed..never expected this from ghmc | {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "the issue has not been resolved yet....in the status it's showing it's completed..never expected this from ghmc", "status": "Attended By Officer", "time_stamp": "21-JUL-2025 02:15:00"} |
| 54 | 23 23 | 6 | 106255287921 | - | 2025-06-08T09:58:44Z | - | Call Centre | Not Satisfied | {"id": "106255287921", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "08-JUN-2025 15:28:44"} |
| 55 | 23 23 | 7 | 106255287921 | 9154909321 | 2025-06-06T06:32:48Z | Attended By Officer | K.Raju | model lights rectified | {"id": "106255287921", "mobile_number": "9154909321", "posted_by": "K.Raju", "remarks": "model lights rectified", "status": "Attended By Officer", "time_stamp": "06-JUN-2025 12:02:48"} |
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)
);