home / aphis_reports

Semantic search

citations

1 row where hash_id = "4d090bac2db41ae1"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
10863 4d090bac2db41ae1 3.6(c)(1)(1)   0 PRIMARY ENCLOSURES. *** At the time of inspection a pen in canine building #3 housed six dogs. The pen measured 58 inches by 50 inches for a total of 20.13 sq ft. The six dogs in the pen require 42.6 sq ft. The facility needs to ensure that animals are provided with the proper amount of space under regulation. Correct from this date An exit interview was conducted with facility personnel on 9/10/14. Additional Inspectors Lopinto John, Veterinary Medical Officer Hadjis Tonya, Supervisory Animal Care Specialist

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
);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 1922.569ms