home / aphis_reports

Semantic search

citation_inspection

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

5 rows where hash_id = "02dc0dd3ce136739"

✎ 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

In the western most animal room of the newly occupied indoor building there are two double stack rows of raised wire enclosures. The indoor housing room is a high moisture environment. The first two enclosures on the lower western side of the room contain a total of four adult dogs. Above these enclosures is a hot electrical wire connected to a light bulb fixture. The electrical wire and light fixture are attached to the underside of the wash down for the upper enclosures. The wire and light fixture are not properly or safely installed. The electrical wire is hanging above the enclosures and there are breaks in it's external yellow coating. With the room being a high moisture area the all wires and light fixtures must be properly and safely installed to protect all of the contained animals from injury and prevent any type of health hazard. Affects four adults. Correct by February 14, 2015

rowid 13759
desc HOUSING FACILITIES, GENERAL.
web_siteName BILL NORED
kind  
Incident hash_id 02dc0dd3ce136739
web_inspectionDate 2015-02-10
code 3.1(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 178.0
web_certType Class B - Dealer
pdf_customer_id 10614.0
pdf_customer_name Bill Nored
pdf_customer_addr P.O. Box 71 Prim, AR 72130
customer_state AR
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23498985-aphis-inspection-41151612160737
lat  
lng  

The kennel facility consists of one indoor housing building. The building is divided into three parts, two animal housing rooms and a food storage room. In the animal rooms there are double stacked rows of enclosures along two walls. There is a wash down structure between the upper and lower sets of raised wire enclosures. The wash downs are higher on the northern end to enhance flow of waste to the southern end. At the southern end of the wash down the waste washes over the side and onto the floor where a drain is located. On the western side of the second (western) dog room the last lower enclosure contains two adult dogs. When the waste is washed over the end of the wash down it can splash into the bottom enclosure onto the two adults. The dealer must repair or replace the drainage system to prevent the animals from being contaminated from the waste material. Housing facilities must be equipped with disposal facilities and drainage systems that are constructed and operated so that animal waste and water are rapidly eliminated and animals stay dry, to protect the health and welfare of the animal, and to prevent the spread of disease. Affects two adults. Correct by February 18, 2015

rowid 13760
desc HOUSING FACILITIES, GENERAL.
web_siteName BILL NORED
kind  
Incident hash_id 02dc0dd3ce136739
web_inspectionDate 2015-02-10
code 3.1(f)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 178.0
web_certType Class B - Dealer
pdf_customer_id 10614.0
pdf_customer_name Bill Nored
pdf_customer_addr P.O. Box 71 Prim, AR 72130
customer_state AR
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23498985-aphis-inspection-41151612160737
lat  
lng  

The kennel animals have been moved from the previous trailers to one indoor housing building. The building is divided into three rooms. Two rooms are animal housing areas which contain two double rows of enclosures along two walls. The enclosures in the building are constructed of coated wire and in some cases wooden materials. In the western room there are three raised wire enclosures containing a total of six adults which have broken and or protruding wires in the enclosures. The broken wires must be repaired or removed to protect the contained animals from injury and to protect their health and welfare. Affects six adults.

rowid 13761
desc PRIMARY ENCLOSURES.
web_siteName BILL NORED
kind  
Incident hash_id 02dc0dd3ce136739
web_inspectionDate 2015-02-10
code 3.6(a)(2)(1)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 178.0
web_certType Class B - Dealer
pdf_customer_id 10614.0
pdf_customer_name Bill Nored
pdf_customer_addr P.O. Box 71 Prim, AR 72130
customer_state AR
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23498985-aphis-inspection-41151612160737
lat  
lng  

In the newly occupied indoor housing building there are a total of 3 primary enclosures each containing three adults. These enclosures and animals were measured to show they did not provide the contained animals with the minimum amount of floor space. One enclosure contains three Pomeranians sixteen inches in length. These animals require ten square feet but only have 9.7sqft. The other two enclosures each contain three adult Dachshunds nineteen inches in length. The two enclosures each require thirteen sq ft but only have 11.3 sq ft. Each dog housed in a primary enclosure must be provided a minimum amount of floor space to protect the health and welfare of the contained animals. The dealer must insure each animal has it's required minimum floor space. Affects nine adults. Correct by February 15, 2015

rowid 13762
desc PRIMARY ENCLOSURES.
web_siteName BILL NORED
kind  
Incident hash_id 02dc0dd3ce136739
web_inspectionDate 2015-02-10
code 3.6(c)(1)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 178.0
web_certType Class B - Dealer
pdf_customer_id 10614.0
pdf_customer_name Bill Nored
pdf_customer_addr P.O. Box 71 Prim, AR 72130
customer_state AR
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23498985-aphis-inspection-41151612160737
lat  
lng  

The newly occupied indoor housing building is divided into three parts. In the food storage room there is an accumulation of dirt, debris and personal items such as egg cartons, a cross bow, old self feeders and used syringes. On the exterior of the building there are accumulations of trash such as paper, plastic, empty gas cans, soda bottles and metal. Premises where housing facilities are located, including buildings and surrounding grounds, must be kept clean and in good repair to protect the animals from injury, to facilitate the husbandry practices, and to reduce or eliminate breeding and living areas for rodents and other pests and vermin. Premises must be kept free of accumulations of trash, junk, waste products, and discarded matter. Affects one hundred forty-three adults and thirty-five puppies. The inspection and exit briefing was conducted with the facility representatives. Additional Inspectors Cooper Natalie, Veterinary Medical Officer

rowid 13763
desc CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL.
web_siteName BILL NORED
kind  
Incident hash_id 02dc0dd3ce136739
web_inspectionDate 2015-02-10
code 3.11(c)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 178.0
web_certType Class B - Dealer
pdf_customer_id 10614.0
pdf_customer_name Bill Nored
pdf_customer_addr P.O. Box 71 Prim, AR 72130
customer_state AR
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23498985-aphis-inspection-41151612160737
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 7684.227ms