home / aphis_reports

Semantic search

citation_inspection

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

4 rows where hash_id = "40f83ace89a613a0"

✎ 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

Licensee stated that euthanasia by gunshot was the routine form of euthanasia for the facility. Licensee also said that they were under the impression from their veterinarian, that it was acceptable and he had written it on the old Program of Veterinary Care, which the inspector did not see. The current Program of Veterinary Care states that a lethal injection by the veterinarian is the facilities routine form of euthanasia. The inspector explained to licensee that gunshot is an unacceptable form of routine euthanasia. Euthanasia by gunshot can cause unnecessary pain and distress to the dog. According to the 2013 AVMA (American Veterinary Medical Association) Guidelines for the Euthanasia of Animals, gunshot is not an acceptable routine form of euthanasia for dogs. The licensee agreed to stop using gunshot and will use lethal injection by veterinarian as the facilities routine form of euthanasia. Correction date: Immediately There are multiple bottles and vials of expired medications and vaccinations stored in a small refrigerator along with vaccinations for the dogs that are still of an acceptable date. Expired medications may lose their effectiveness and cause the health of the dogs to suffer. All expired medications should be discarded or removed so they will not be used on the dogs. Correction date: 08/25/14

rowid 9531
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName Loren and Lora Kooiman
kind  
Incident hash_id 40f83ace89a613a0
web_inspectionDate 2014-08-20
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 14.0
web_certType Class A - Breeder
pdf_customer_id 5271.0
pdf_customer_name Lora Kooiman
pdf_customer_addr Loren Kooiman 2703 Garfield Ave Doon, IA 51235
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23491385-aphis-inspection-236141834150455
lat  
lng  

Between the outdoor enclosures housing three cocker spaniels and six cocker spaniels there is a metal pipe running along the floor that fencing is attached to. The pipe is starting to acquire excessive rusting. The rust causes pitting and flaking of the metal and does not allow for proper sanitization of the pipe. The metal pipe needs to be replaced or altered in a way that will allow for proper sanitization of the pipe every two weeks. Correct by 09/03/14

rowid 9532
desc HOUSING FACILITIES, GENERAL.
web_siteName Loren and Lora Kooiman
kind  
Incident hash_id 40f83ace89a613a0
web_inspectionDate 2014-08-20
code 3.1(c)(1)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 14.0
web_certType Class A - Breeder
pdf_customer_id 5271.0
pdf_customer_name Lora Kooiman
pdf_customer_addr Loren Kooiman 2703 Garfield Ave Doon, IA 51235
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23491385-aphis-inspection-236141834150455
lat  
lng  

In the indoor enclosure that houses three english springer spaniels, there is a broken piece of rusty metal along the floor that is twisted upward and at the level of the dogs. The sharp edges of the piece of metal are an injury hazard to the dogs. The broken piece of metal needs to be removed or altered in a way that it will not cause injury to the dogs. Correct by 08/27/14

rowid 9533
desc HOUSING FACILITIES, GENERAL.
web_siteName Loren and Lora Kooiman
kind  
Incident hash_id 40f83ace89a613a0
web_inspectionDate 2014-08-20
code 3.1(c)(1)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 14.0
web_certType Class A - Breeder
pdf_customer_id 5271.0
pdf_customer_name Lora Kooiman
pdf_customer_addr Loren Kooiman 2703 Garfield Ave Doon, IA 51235
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23491385-aphis-inspection-236141834150455
lat  
lng  

The outdoor enclosure housing three cocker spaniels has a mesh style floor that is raised off the ground. The floor is damaged and has a hole in it. The hole is approximately three inches wide. This possess an injury hazard to the dogs. The flooring needs to be replaced or altered in a manner that protects the dogs from injury. Correct by 08/27/14 Exit interview conducted with facility representative.

rowid 9534
desc PRIMARY ENCLOSURES.
web_siteName Loren and Lora Kooiman
kind  
Incident hash_id 40f83ace89a613a0
web_inspectionDate 2014-08-20
code 3.6(a)(2)(10)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 14.0
web_certType Class A - Breeder
pdf_customer_id 5271.0
pdf_customer_name Lora Kooiman
pdf_customer_addr Loren Kooiman 2703 Garfield Ave Doon, IA 51235
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23491385-aphis-inspection-236141834150455
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 2612.964ms