Semantic search
citation_inspection
4 rows where hash_id = "40f83ace89a613a0"
This data as json, CSV (advanced)
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
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);