home / aphis_reports

Semantic search

citation_inspection

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

3 rows where hash_id = "1a3bf4aa1801d9e9"

✎ 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

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

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