aphis_reports: citations: 3 rows where hash

Semantic search

3 rows where hash_id = "053f8c7a192476b2"

Search:

descending

rowid ▼	hash_id	code	desc	narrative
12794	053f8c7a192476b2	3.127(c)	FACILITIES, OUTDOOR.	Standing water (approximately six feet in diameter) and mud surround the elevated llama food tub. The two llamas share an enclosure with one sheep and three goats. Their food tub is elevated to prevent the other animals from ingesting their food. The llamas must walk through the mud and standing water to gain access to their food. Excessive standing water and mud could cause injury to the animals. A suitable method shall be provided to eliminate excess water around the food tub. To be corrected: 10-21-16
12795	053f8c7a192476b2	3.130	WATERING.	The inside of the camel water tub is coated with brown material. This material, if ingested, could cause the camel to become ill. Clean and sanitize the water tub and repeat often enough to prevent build up to assure the camel has access to clean, potable water. To be corrected: 9-23-16
12796	053f8c7a192476b2	3.131(a)	SANITATION.	Excessive dirt and dried mud are smeared on the interior walls inside of the wallaby shelter. Additionally, the majority of the floor in the wallaby shelter is wet. The floor also has dirt and compacted feces on it. Finally, the wallaby has a burlap sack and a small chair inside of its shelter. Both are wet and soiled. Wet, soiled floors and fixtures within the wallaby shelter could cause the animal to become ill. Thoroughly clean and sanitize the affected areas of the shelter and repeat often enough to prevent build up. To be corrected: 9-26-16 This inspection and exit interview were conducted with the 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
);