home / aphis_reports

Semantic search

citation_inspection

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

3 rows where hash_id = "65f6ca1143bf20d4"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repeat

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

2.131 (d) (2) Handling of animals During the time of inspection in the lower enclosure holding two llamas and 25 fallow deer, there was not an identifiable attendant present when the public was in contact with the animals through the enclosure fence. While conducting the inspection the attendant returned on or about 15 minutes from the start of the inspection on this enclosure. An identifiable attendant should be present when the public is able to contact the animals in order to prevent injury to the animals and/or public and to ensure that all handling and feeding is done according to the requirements of this Section of the AWA regulations. During all times of public contact there must be a responsible, knowledgeable, and readily identifiable employee or attendant present. This is a repeat from inspection conducted on November, 18, 2013 with an original correction date of December 19, 2013.

rowid 6673
desc HANDLING OF ANIMALS.
web_siteName SANTA'S WORKSHOP
kind  
Incident hash_id 65f6ca1143bf20d4
web_inspectionDate 2014-06-17
code 2.131(d)(2)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 31.0
web_certType Class C - Exhibitor
pdf_customer_id 3505.0
pdf_customer_name Santa'S Workshop
pdf_customer_addr P O Box 246 Cascade, CO 80809
customer_state CO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23486602-aphis-inspection-169141752490227
lat 38.8966566
lng -104.9722013

3.125 (a) Structural Strength The upper enclosure holding the four male fallow deer, on the back side of the shelter there are broken boards with gaps large enough for animals to get their hooves/foot caught and potentially cause injuries. Maintain outdoor facilities so that it is structurally sound and good repair to protect animals from injury. To be corrected by: June 23, 2014

rowid 6674
desc FACILITIES, GENERAL.
web_siteName SANTA'S WORKSHOP
kind  
Incident hash_id 65f6ca1143bf20d4
web_inspectionDate 2014-06-17
code 3.125(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 31.0
web_certType Class C - Exhibitor
pdf_customer_id 3505.0
pdf_customer_name Santa'S Workshop
pdf_customer_addr P O Box 246 Cascade, CO 80809
customer_state CO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23486602-aphis-inspection-169141752490227
lat 38.8966566
lng -104.9722013

3.131 (a) Cleaning of enclosures The upper enclosure housing the four male fallow deer had excessive feces inside the shelter structure; the excess accumulation of feces can cause diseases, parasite and pest infestation. Remove excreta in the primary enclosure as often as necessary to prevent contamination, minimize disease hazards and reduce odors. To be corrected by: July 1, 2014 Inspection and exit interview conducted by APHIS personnel and facility representative. Additional Inspectors Irwin Bryan, Compliance Specialist

rowid 6675
desc SANITATION.
web_siteName SANTA'S WORKSHOP
kind  
Incident hash_id 65f6ca1143bf20d4
web_inspectionDate 2014-06-17
code 3.131(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 31.0
web_certType Class C - Exhibitor
pdf_customer_id 3505.0
pdf_customer_name Santa'S Workshop
pdf_customer_addr P O Box 246 Cascade, CO 80809
customer_state CO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23486602-aphis-inspection-169141752490227
lat 38.8966566
lng -104.9722013

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 2844.984ms