Semantic search

citations

1 row where hash_id = "1c64bba92a5cabc6"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
17680 1c64bba92a5cabc6 3.6(a)(2)(i)   0 Primary enclosures. Two enclosures containing 3 dogs had sharp points protruding into the primary enclosures. Two female Yorkshire Terriers, Annabelle (1553) and Autumn (1554), and one male Yorkshire Terrier, Sampson (1654) are housed in indoor- outdoor suspended wire cages. The roof of the enclosures is an uncoated wire. In both the indoor and outdoor portions of the two enclosures, the wire roof had rusted and broken and was protruding into the enclosure. When the dogs jumped, played, and stood up against the side of the enclosure, the protruding wires were very close to their faces. Protruding wires and other sharp points can cause injury to the dogs. Primary enclosures must be constructed and maintained so that they contain no sharp points or edges that could injure the animals. Correct by replacing the broken wire by 5/16/23 This inspection and exit interview were conducted with the licensee. n

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
);