home / aphis_reports

Semantic search

citation_inspection

Table actions
  • Semantic search against this table
  • Semantic search against this table

3 rows where hash_id = "ce4fde9aea7a75b4"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

The inventory and acquisition records were either incomplete or completely missing for all the animals but 12 goats. Lack of accurate and up-to-date inventory and acquisition records does not ensure for the proper tracking of the animals by APHIS Officials as necessary. Update the facility inventory and acquisition records with all required information so they accurately reflect the current inventory of animals. Correct by 10/5/16.

rowid 18608
desc RECORDS: DEALERS AND EXHIBITORS.
web_siteName DAVID ERICKSON
kind  
Incident hash_id ce4fde9aea7a75b4
web_inspectionDate 2016-09-21
code 2.75(b)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 49.0
web_certType Class C - Exhibitor
pdf_customer_id 29944.0
pdf_customer_name David J Erickson
pdf_customer_addr 11890 Hope Rd Se Osakis, MN 56360
customer_state MN
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23509949-aphis-inspection-2016082567939719
lat  
lng  

An enclosure containing two rabbits had chicken wire on one wall where the top half of it was hanging down with multiple sharp points sticking out into the enclosure. Sharp points in an enclosure could potentially cause injury to the animals within that enclosure. The enclosure shall be maintained in good repair to protect the animals from injury. Correct by 9/28/16.

rowid 18609
desc PRIMARY ENCLOSURES.
web_siteName DAVID ERICKSON
kind  
Incident hash_id ce4fde9aea7a75b4
web_inspectionDate 2016-09-21
code 3.53(a)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 49.0
web_certType Class C - Exhibitor
pdf_customer_id 29944.0
pdf_customer_name David J Erickson
pdf_customer_addr 11890 Hope Rd Se Osakis, MN 56360
customer_state MN
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23509949-aphis-inspection-2016082567939719
lat  
lng  

An enclosure containing one of the llamas had part of the fence line that was in disrepair from a tree branch that had fallen on it a few years ago. This part of the fence line was not stable and was mangled to the point where the llama could potentially get its head stuck in it. Two enclosures containing a total of 9 goats, 5 sheep, and 1 deer had wooden bridges for the goats to walk across. Both bridges had screw heads sticking out of it. Screw heads sticking out could potentially be stepped on by any animals walking across the bridge causing a potential injury to an animal's feet. All housing facilities must be maintained in good repair to protect the animals from injury. This inspection and exit interview were conducted with the licensee. Note: The veterinary care issues identified during the last inspection on February 17, 2016 have been corrected as of the time of this inspection.

rowid 18610
desc FACILITIES, GENERAL.
web_siteName DAVID ERICKSON
kind  
Incident hash_id ce4fde9aea7a75b4
web_inspectionDate 2016-09-21
code 3.125(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 49.0
web_certType Class C - Exhibitor
pdf_customer_id 29944.0
pdf_customer_name David J Erickson
pdf_customer_addr 11890 Hope Rd Se Osakis, MN 56360
customer_state MN
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23509949-aphis-inspection-2016082567939719
lat  
lng  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "citation_inspection" (
   [rowid] INTEGER PRIMARY KEY,
   [narrative] TEXT,
   [desc] TEXT,
   [web_siteName] TEXT,
   [kind] TEXT,
   [hash_id] TEXT REFERENCES [inspections]([hash_id]),
   [web_inspectionDate] TEXT,
   [code] TEXT,
   [repeat] INTEGER,
   [pdf_insp_type] TEXT,
   [pdf_animals_total] FLOAT,
   [web_certType] TEXT,
   [pdf_customer_id] FLOAT,
   [pdf_customer_name] TEXT,
   [pdf_customer_addr] TEXT,
   [customer_state] TEXT,
   [pdf_site_id] TEXT,
   [doccloud_url] TEXT
, lat double precision, lng double precision);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 3007.543ms