Semantic search

citations

1 row where hash_id = "3e9e5ac38b5e6a64"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
157 3e9e5ac38b5e6a64 3.75(c)(2)   0 Housing facilities, general. The floors in the animal rooms (the older part of the facility) are pitted and stained floors. The condition of the floors are past normal wear and tear and can no longer be adequately cleaned and sanitized. The floors have not been maintained at a frequency that facilitates good husbandry practices. The floors must be replaced for effective cleaning and sanitization and a proper gradient that will allow water to flow towards the drains. established. Worn floors must be replaced when it cannot be readily cleaned and sanitized. Correct by following a schedule for replacement and developing a plan to ensure proper maintenance of the floors on a regular basis. Correct by March 31, 2022. This inspection and exit interview were conducted with the facility representatives. The protocol review was conducted under site 001. End Section

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