snapshot_comments
3 rows where snapshot_pk = 98
This data as json, CSV (advanced)
Suggested facets: status_text, comment_timestamp (date)
| comment_pk ▼ | snapshot_pk | ordinal | complaint_id | mobile_number | comment_timestamp | status_text | posted_by | remarks | raw_comment_json |
|---|---|---|---|---|---|---|---|---|---|
| 155 | 98 98 | 1 | 105255241133 | 9959997758 | 2025-05-03T03:32:33Z | Attended By Officer | S.Nagaraju | clear sir | {"id": "105255241133", "mobile_number": "9959997758", "posted_by": "S.Nagaraju", "remarks": "clear sir", "status": "Attended By Officer", "time_stamp": "03-MAY-2025 09:02:33"} |
| 156 | 98 98 | 2 | 105255241133 | 8333874389 | 2025-05-02T09:14:14Z | Open | pavani | Subject: Urgent: Garbage Dumping in Front of My House - Follow-up REMINDER -2 To GHMC Authorities, I am writing to express my extreme disappointment and frustration at the persistent dumping of garbage in front of my house, despite my previous complaints. The rickshaw fellow continues to recklessly drop garbage in front of my residence, posing a serious health hazard. I had expected a prompt response and resolution within 24 hours, as stated in my previous email. However, no action has been taken till now. I demand that you take immediate and stringent action against the team responsible for this gross negligence. I urge you to: - Issue a strict warning to the team - Ensure that garbage is not dumped in front of my house henceforth - Provide a timeline for resolving this issue I request a prompt response and resolution to this issue within the next 12 hours. Sincerely, Pavani 8333874389 | {"id": "105255241133", "mobile_number": "8333874389", "posted_by": "pavani", "remarks": "Subject: Urgent: Garbage Dumping in Front of My House - Follow-up REMINDER -2 To GHMC Authorities, I am writing to express my extreme disappointment and frustration at the persistent dumping of garbage in front of my house, despite my previous complaints. The rickshaw fellow continues to recklessly drop garbage in front of my residence, posing a serious health hazard. I had expected a prompt response and resolution within 24 hours, as stated in my previous email. However, no action has been taken till now. I demand that you take immediate and stringent action against the team responsible for this gross negligence. I urge you to: - Issue a strict warning to the team - Ensure that garbage is not dumped in front of my house henceforth - Provide a timeline for resolving this issue I request a prompt response and resolution to this issue within the next 12 hours. Sincerely, Pavani 8333874389", "status": "Open", "time_stamp": "02-MAY-2025 14:44:14"} |
| 157 | 98 98 | 3 | 105255241133 | 7997951601 | 2025-05-01T05:26:18Z | Attended By Officer | Kapra | close | {"id": "105255241133", "mobile_number": "7997951601", "posted_by": "Kapra", "remarks": "close", "status": "Attended By Officer", "time_stamp": "01-MAY-2025 10:56: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)
);