Semantic search

citations

3 rows where hash_id = "10225ae8057e42e9"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
15726 10225ae8057e42e9 2.40(b)(2)   0 ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). There are several bottles of expired medications ( atropine , oxytocin and vitamins ) stored with non expired medications . Medications that are past their expiration date may no longer be effective in treating diseases and injuries.Supplies of drugs must remain in date to ensure that adequate veterinary care is provided. CORRECTED AT TIME OF INSPECTION ( Note : Expired drugs were discarded )
15727 10225ae8057e42e9 3.125(c)   0 FACILITIES, GENERAL. The frozen meat being thawed for the tigers in the back of the facility was on an outside table which contained tools. a bag of open insecticide and motor oil. The meat was not being thawed under refrigeration. Meat must be thawed in a refrigerator to prevent spoilage . Supplies such as motor oil and insecticide may accidentally contaminate the food . Refrigeration shall be provided for supplies of perishable food and the food stored away from pesticides and other chemicals to prevent contamination . CORRECT BY : 10-13 -16
15728 10225ae8057e42e9 3.130   0 WATERING. The water for the younger bear is dark green . Fresh potable water is necessary for good health and must be provided daily. Water containers must be maintained in a clean and sanitary condition . CORRECT BY : 10-13-16 The inspection and exit briefing was conducted with facility employees .

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