Semantic search

citations

1 row where hash_id = "dd02e2b33effa7d6"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
40340 dd02e2b33effa7d6 2.1(a)(1)   0 Requirements and application. The facility is conducting regulated activity without a valid USDA license. The facility consigned exotic animals (5 Flying Squirrels) to an auction. Upon arrival at the sale, the facility was informed that they needed a USDA license and would receive a citation if the animals were consigned. The facility chose to proceed and consigned the animals to the auction. A valid license is necessary to protect the health and well-being of the animals and to comply with the Animal Welfare Act and Regulations. Correct by obtaining a USDA license or discontinuing regulated activities. No regulated activities may be conducted until a USDA license is obtained. This inspection and exit interview were conducted with the facility Representative. This inspection was conducted in Mount Hope, Ohio. Additional Inspectors: Jonathan Tomkovitch, VETERINARY MEDICAL OFFICER Lauren Murphy, VETERINARY MEDICAL OFFICER Charles Palmer, VETERINARY MEDICAL OFFICER DIANA CARE, VETERINARY MEDICAL OFFICER 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
);