home / aphis_reports

Semantic search

citation_inspection

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

3 rows where hash_id = "dcc3f99c21730209"

✎ 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 alpaca and goat enclosures do not prohibit unsupervised contact between the animal and the guests at the facility. Unsupervised contact between the animals and the public puts the animals and the public at risk of potential harm. Steps should be taken to minimize such risks, either by assuring that a trained attendant is present any time contact could occur, or by installing sufficient barriers to prevent such contact. To be corrected immediately via temporary means, and with a permanent correction to be completed by 12/1/15.

rowid 28924
desc HANDLING OF ANIMALS.
web_siteName Temple of Isis
kind  
Incident hash_id dcc3f99c21730209
web_inspectionDate 2015-10-06
code 2.131(c)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 21.0
web_certType Class C - Exhibitor
pdf_customer_id 328120.0
pdf_customer_name Temple Of Isis
pdf_customer_addr 20889 Geyserville Ave. Geyserville, CA 95441
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23530016-aphis-inspection-281151308060611
lat  
lng  

The rabbit enclosure had a large accumulation of excreta, used bedding, hair, and debris. Inadequate husbandry in the rabbit enclosure could promote disease, parasites and / or vermin. The rabbit enclosure should be cleaned immediately, and maintained in sanitary condition.

rowid 28925
desc SANITATION.
web_siteName Temple of Isis
kind  
Incident hash_id dcc3f99c21730209
web_inspectionDate 2015-10-06
code 3.56(a)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 21.0
web_certType Class C - Exhibitor
pdf_customer_id 328120.0
pdf_customer_name Temple Of Isis
pdf_customer_addr 20889 Geyserville Ave. Geyserville, CA 95441
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23530016-aphis-inspection-281151308060611
lat  
lng  

The enclosures for the alpacas and for the goats contained elements that are potentially hazardous to the animals: - The alpaca enclosure had exposed electrical wires on the ground, inside the enclosure, within reach of the animals. - The goat enclosure contained wooden pallets that had protruding nails. Two exotic feline enclosures were in need of repair: - In the inside shelter enclosure for the bobcat the linoleum on the floor was peeling, and deteriorating. - In the inside shelter enclosure for the serval named "Ptah" the linoleum floor was discolored, buckling and lifting from the floor, suggesting that moisture had gotten underneath of it. Next to the door there was bare wood exposed. Additionally there was a small hole in the wall opposite the door (less than an inch in size), and upon examining the back of the enclosure from the outside it was observed that there was severe deterioration of the wood, threatening the structural integrity of the enclosure. Failure to maintain enclosures in good repair could result in injury or escape. Sharp objects and electrical wires could cause injury or death. Deteriorating surfaces present an ingestion risk, threaten structural strength, and impede cleaning. Animal enclosures should be free of objects that could cause injury to the animals. Enclosures should be maintained in good repair, so that they can be kept clean. Enclosures should be regularly repaired so as to maintain their structural integrity and prevent escape or injury. Steps should be taken immediately to remove all hazards from enclosures. Repairs should be completed by 12/1/15. An exit interview was conducted with facility representatives.

rowid 28926
desc FACILITIES, GENERAL.
web_siteName Temple of Isis
kind  
Incident hash_id dcc3f99c21730209
web_inspectionDate 2015-10-06
code 3.125(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 21.0
web_certType Class C - Exhibitor
pdf_customer_id 328120.0
pdf_customer_name Temple Of Isis
pdf_customer_addr 20889 Geyserville Ave. Geyserville, CA 95441
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23530016-aphis-inspection-281151308060611
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 5269.201ms