snapshot_comments
3 rows where snapshot_pk = 5
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 |
|---|---|---|---|---|---|---|---|---|---|
| 9 | 5 5 | 1 | 102265688260 | 9848463818 | 2026-02-03T11:56:26Z | Attended By Officer | K Bhanuprasad | I had filed a complaint regarding garbage in our area. Workers came and swept the area, but the garbage was not properly collected. As a result, the wind is blowing it across the road, creating a mess and a potential health hazard. Please ensure the garbage is fully removed and the area is kept clean | {"id": "102265688260", "mobile_number": "9848463818", "posted_by": "K Bhanuprasad", "remarks": "I had filed a complaint regarding garbage in our area. Workers came and swept the area, but the garbage was not properly collected. As a result, the wind is blowing it across the road, creating a mess and a potential health hazard. Please ensure the garbage is fully removed and the area is kept clean", "status": "Attended By Officer", "time_stamp": "03-FEB-2026 17:26:26"} |
| 10 | 5 5 | 2 | 102265688260 | 7995009113 | 2026-02-02T02:00:39Z | Attended By Officer | K. Swathi | ok | {"id": "102265688260", "mobile_number": "7995009113", "posted_by": "K. Swathi", "remarks": "ok", "status": "Attended By Officer", "time_stamp": "02-FEB-2026 07:30:39"} |
| 11 | 5 5 | 3 | 102265688260 | 9848463818 | 2026-01-31T18:46:17Z | Open | K Bhanuprasad | Garbage is being dumped repeatedly near and around HIG-73 KPHB Phase-9 by nearby buildings/people. Despite informing sanitation workers through our watchman garbage is not being collected regularly and sweeping is not done properly in front of our house. Surrounding areas are being cleaned but our frontage is being neglected. This is creating an unhygienic and unsafe environment. Kindly arrange immediate garbage clearance and daily sweeping as done in other stretches. | {"id": "102265688260", "mobile_number": "9848463818", "posted_by": "K Bhanuprasad", "remarks": "Garbage is being dumped repeatedly near and around HIG-73 KPHB Phase-9 by nearby buildings/people. Despite informing sanitation workers through our watchman garbage is not being collected regularly and sweeping is not done properly in front of our house. Surrounding areas are being cleaned but our frontage is being neglected. This is creating an unhygienic and unsafe environment. Kindly arrange immediate garbage clearance and daily sweeping as done in other stretches.", "status": "Open", "time_stamp": "01-FEB-2026 00:16:17"} |
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)
);