snapshot_comments
3 rows where snapshot_pk = 9
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 |
|---|---|---|---|---|---|---|---|---|---|
| 16 | 9 9 | 1 | 104255188589 | 9154901720 | 2025-04-19T05:51:17Z | Attended By Officer | GHMC | Dear citizen, your PT payment of Rs.20228/- was found successful on 30.03.2025 and updated. | {"id": "104255188589", "mobile_number": "9154901720", "posted_by": "GHMC", "remarks": "Dear citizen, your PT payment of Rs.20228/- was found successful on 30.03.2025 and updated.", "status": "Attended By Officer", "time_stamp": "19-APR-2025 11:21:17"} |
| 17 | 9 9 | 2 | 104255188589 | 8143901406 | 2025-04-08T16:45:23Z | Open | MOHD ASIF KARAMAT | I have done the payment towards Property tax , my first transaction got failed but amount got deducted from my credit account and again I did the transaction for the same amount which was succesfull. please refund the failed transaction amount | {"id": "104255188589", "mobile_number": "8143901406", "posted_by": "MOHD ASIF KARAMAT", "remarks": "I have done the payment towards Property tax , my first transaction got failed but amount got deducted from my credit account and again I did the transaction for the same amount which was succesfull. please refund the failed transaction amount", "status": "Open", "time_stamp": "08-APR-2025 22:15:23"} |
| 18 | 9 9 | 3 | 104255188589 | 9154901720 | 2025-04-05T13:56:18Z | Attended By Officer | GHMC | Dear citizen, Failed payments are refunded to the same account within 7 working days. | {"id": "104255188589", "mobile_number": "9154901720", "posted_by": "GHMC", "remarks": "Dear citizen, Failed payments are refunded to the same account within 7 working days.", "status": "Attended By Officer", "time_stamp": "05-APR-2025 19:26:18"} |
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)
);