snapshot_comments
4 rows where snapshot_pk = 7
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 |
|---|---|---|---|---|---|---|---|---|---|
| 11 | 7 7 | 1 | 109255451017 | 9885510510 | 2025-09-04T05:20:25Z | Closed | Sri.Vinay | please look into the matter | {"id": "109255451017", "mobile_number": "9885510510", "posted_by": "Sri.Vinay", "remarks": "please look into the matter", "status": "Closed", "time_stamp": "04-SEP-2025 10:50:25"} |
| 12 | 7 7 | 2 | 109255451017 | 9701363239 | 2025-09-01T11:22:26Z | Open | Smt Chandana, DYEE | pertains to police department | {"id": "109255451017", "mobile_number": "9701363239", "posted_by": "Smt Chandana, DYEE", "remarks": "pertains to police department", "status": "Open", "time_stamp": "01-SEP-2025 16:52:26"} |
| 13 | 7 7 | 3 | 109255451017 | 9912478361 | 2025-09-01T07:04:05Z | Open | Sri. S. Goverdhan | The matter pertains to Deputy Commissioner, Circle - 5, GHMC. | {"id": "109255451017", "mobile_number": "9912478361", "posted_by": "Sri. S. Goverdhan", "remarks": "The matter pertains to Deputy Commissioner, Circle - 5, GHMC.", "status": "Open", "time_stamp": "01-SEP-2025 12:34:05"} |
| 14 | 7 7 | 4 | 109255451017 | 8019349909 | 2025-08-31T18:41:12Z | Open | Preetham | As per Telangana High court direction, No loud band or music allowed after 10 PM as part of Ganesh festival. However, In P and T colony road, there is a huge violation of the aforesaid rule. A lot many bands with high decibels of volumes for Ganesh procession have been keep on coming in P and T colony road in Dilshuknagar till late night. We have persons having health issues at home. Kindly ask the police personnel to do the patrolling frequently and prevent this noise pollution please after 10 PM. This is a request as we have health relates issues | {"id": "109255451017", "mobile_number": "8019349909", "posted_by": "Preetham", "remarks": "As per Telangana High court direction, No loud band or music allowed after 10 PM as part of Ganesh festival. However, In P and T colony road, there is a huge violation of the aforesaid rule. A lot many bands with high decibels of volumes for Ganesh procession have been keep on coming in P and T colony road in Dilshuknagar till late night. We have persons having health issues at home. Kindly ask the police personnel to do the patrolling frequently and prevent this noise pollution please after 10 PM. This is a request as we have health relates issues", "status": "Open", "time_stamp": "01-SEP-2025 00:11:12"} |
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)
);