Semantic search
citation_inspection
3 rows where hash_id = "1a3bf4aa1801d9e9"
This data as json, CSV (advanced)
There are several doggy doors in Building #2 that do not have any trim surrounding the insert/wall connection, resulting is gaps where dirt, debris and fecal material can accumulate. There are 2 door frames where the metal trim has been chewed and the pointed ends are pulled away from the wall. Sharp corners of metal trim can be a possible source of injury for the dogs. Any unfinished surfaces or doorway inserts with gaps can be a possible source of bacteria and health hazards due to an accumulation of dirt, debris or feces that buildup and are not able to be washed out. The licensee must repair all chewed or damaged trim or surfaces in the kennel, and fill in the cracks surrounding the inserts where they meet the wall, or put on some sort of trim to cover that exposed area. To be corrected by: September 6, 2015
rowid | 27675 |
desc | HOUSING FACILITIES, GENERAL. |
web_siteName | MARVIN LEE KNEPP |
kind | |
Incident hash_id | 1a3bf4aa1801d9e9 |
web_inspectionDate | 2015-08-18 |
code | 3.1(a) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 78.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 326577.0 |
pdf_customer_name | Marvin Lee Knepp |
pdf_customer_addr | 8803 East 400 North Montgomery, IN 47558 |
customer_state | IN |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23527872-aphis-inspection-230151653500310 |
lat | |
lng |
There are 2 outdoor kennels with 4 dogs that have an insolated dog house on a cement pad, however there has been no other method of shade provided for the animals. During the heat of the day there is no shade available for these dogs. There are 1 play yard that is used to house dogs for several hours at a time that does not have adequate shade for the dogs during the heat of the day or for any inclement weather. The lack of proper shade and an escape from the sun can cause heat related health risks for the regulated animals. In addition to the shelter structures, one or more separate outside areas of shade must be provided, large enough to contain all the animals at one time and protect them from the direct rays of the sun. To be corrected by: August 23, 2015
rowid | 27676 |
desc | OUTDOOR HOUSING FACILITIES. |
web_siteName | MARVIN LEE KNEPP |
kind | |
Incident hash_id | 1a3bf4aa1801d9e9 |
web_inspectionDate | 2015-08-18 |
code | 3.4(b) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 78.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 326577.0 |
pdf_customer_name | Marvin Lee Knepp |
pdf_customer_addr | 8803 East 400 North Montgomery, IN 47558 |
customer_state | IN |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23527872-aphis-inspection-230151653500310 |
lat | |
lng |
Building #1 has multiple doggy doors that have a buildup of dark brown/black dirt and grime on the surfaces of the doors. There are several back walls and inside the feeders that have a buildup of dirt and grime that is brown in color. While the enclosures are being cleaned daily, they need to have these surfaces scrubbed to remove the grime buildup. There are several kennels that have a buildup of hair along the front of the cages in the rubber coated wire. The buildup of dirt, grime and hair can be a source of disease or possible health risks to the animals, as proper sanitization can not occur with this grime present. The licensee must increase the cleaning to include proper scrubbing of surfaces on the doggie doors, inserts, back walls and wire fencing and inside and outside of feeders in order to remove any dirt or grime covering the surfaces. Only when the grime is removed can proper cleaning and sanitization occur. To be corrected by: August 23, 2014 Inspection and exit interview conducted with licensee.
rowid | 27677 |
desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
web_siteName | MARVIN LEE KNEPP |
kind | |
Incident hash_id | 1a3bf4aa1801d9e9 |
web_inspectionDate | 2015-08-18 |
code | 3.11(b) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 78.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 326577.0 |
pdf_customer_name | Marvin Lee Knepp |
pdf_customer_addr | 8803 East 400 North Montgomery, IN 47558 |
customer_state | IN |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23527872-aphis-inspection-230151653500310 |
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);