Semantic search

citations

1 row where hash_id = "a520878c34b1abd5"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
14046 a520878c34b1abd5 2.50(a)(1)   0 TIME AND METHOD OF IDENTIFICATION. ** The puppies did not have proper identification. All regulated animals at the facility must be properly identified to aid USDA in the tracking of animals if necessary. A cage card can be used to identify the puppies. The card must have the Licensee's certificate number, the letters USDA, the puppies individual identification numbers, the date of birth, sex and brief description. If litters are mixed then the identification must be on the puppies. The owner must ensure that all regulated animals at the facility are properly identified. To be corrected by: 02-24-15. This inspection and exit briefing conducted with the owner. End of report.

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