Semantic search

citations

1 row where hash_id = "714934aebf292db6"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
29989 714934aebf292db6 3.1(c)(2)   0 HOUSING FACILITIES, GENERAL. (c) Surfaces (2) Maintenance and replacement of surfaces. ****In the sheltered facility, there were three primary enclosures containing four adult dogs. Around the interior surface of the doorways, the edges of the covering of the walls had been chewed away leaving the wooden studs exposed. The exposed studs have also been chewed and scratched and have rough surfaces. The exposed wood has not been sealed against moisture. Unsealed and chewed edges cannot be properly cleaned and sanitized and increases the risk of disease to the animals.. The licensee must repair these surfaces and assure that all surfaces are replaced or repaired as required. To be corrected by January 20, 2015 ****Female white and tan Chichuahua (MC# 0A0224678) and female red and white Boston Terrier (MC# 0A0227479) from the October 29, 2014 inspection report were evaluated by a licensed veterinarian and documentation was presented during inspection. Inspection and exit interview conducted with the licensee. Additional Inspectors Vernon Kathryn, Animal Care Inspector

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "citations" (
   [rowid] INTEGER PRIMARY KEY,
   [hash_id] TEXT REFERENCES [inspections]([hash_id]),
   [code] TEXT,
   [kind] TEXT,
   [repeat] INTEGER,
   [desc] TEXT,
   [narrative] TEXT
);