Semantic search

citations

2 rows where hash_id = "3fad57a32534c9a3"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
27079 3fad57a32534c9a3 2.75(b)(1)   0 RECORDS: DEALERS AND EXHIBITORS. Sale records listing the complete name and address and USDA license of the buyer were not being maintained. Licensee must make and maintain sale records which fully and correctly discloses the name and address of the buyer, the date animals were sold, buyer's USDA license number, and a description and number of animals sold. Sale records must be maintained to keep track of animal shipments for health and regulatory purposes and to document changes in ownership. APHIS form 7020 were left with owner to help maintain records of animals sold. Correct by July 3, 2014
27080 3fad57a32534c9a3 3.31(a)(1)   0 SANITATION. Two enclosures housing approximately 30 guinea pigs each had accumulations of soiled bedding. These two enclosures had more excreta than clean bedding. Primary enclosures must be cleaned often enough to prevent an accumulation of excreta, dirty bedding and debris. Primary enclosures must be cleaned and sanitized at least once every 2 weeks to maintain the health of the animals. Correct by ensuring that all primary enclosures are kept clean and sanitzed often enough to prevent and accumulation of excreta, dirty bedding and debris. Correct by July 2, 2014. An exit briefing was conducted with owner.

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