Semantic search
citations
2 rows where hash_id = "b52e8eb54439d347"
This data as json, CSV (advanced)
| rowid ▼ | hash_id | code | kind | repeat | desc | narrative |
|---|---|---|---|---|---|---|
| 9522 | b52e8eb54439d347 | 3.1(c)(3) | 0 | HOUSING FACILITIES, GENERAL. | In the outdoor portion of the sheltered housing facility, the enclosures are separated by vinyl plastic fencing. At the level of the dogs, this fencing has a buildup of dirt and grime on it. This buildup of dirt and grime can cause a risk of disease hazards towards the dogs. The fencing must be cleaned and sanitized every two weeks to prevent the accumulation of dirt and grime. Correct by: 09/23/14 | |
| 9523 | b52e8eb54439d347 | 3.6(a)(2)(9) | 0 | PRIMARY ENCLOSURES. | In all the enclosures containing outside access doors, except for one, the access doors are framed in vinyl plastic and have been excessively chewed by the dogs. This damage allows for dirt and food waste to penetrate the surface of the vinyl which can result in disease hazards to the dogs. The vinyl plastic needs to be replaced or altered in a manner that allows for proper cleaning and sanitization of the enclosures every two weeks. Correct by: 10/15/14 Exit interview conducted with facility representative. |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "citations" ( [rowid] INTEGER PRIMARY KEY, [hash_id] TEXT REFERENCES [inspections]([hash_id]), [code] TEXT, [kind] TEXT, [repeat] INTEGER, [desc] TEXT, [narrative] TEXT );