home / aphis_reports

Semantic search

citation_inspection

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

4 rows where hash_id = "f6cc9c5975cb6778"

✎ 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 two small dog buildings the enclosures are framed in wood and there are at least nine enclosures, containing fourteen dogs, which have the sharp ends of screws penetrating through the wood framing and into the dog enclosures. The screws are located in the wood that is framing the top of the enclosures and the dogs could come into contact with the sharp points. Multiple sharp points are located in at least three outdoor enclosures, containing four Golden retrievers. The sharp points are found at the level of the dogs and are created by the ends of wires that are used to attach buckets and feeders to the fence and along some of the enclosure fence panels. Sharp points can cause injury to the dogs. Housing facilities for dogs must be free of sharp points and jagged edges that could injure the animals. The licensee must remove the sharp points from the dog enclosures in order to eliminate the injury risk towards the dogs. The licensee must ensure that all housing facilities remain safe for the dogs at all times. Correction date: June 28, 2016

rowid 12047
desc HOUSING FACILITIES, GENERAL.
web_siteName JULIE A NELSON
kind  
Incident hash_id f6cc9c5975cb6778
web_inspectionDate 2016-06-14
code 3.1(c)(1)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 76.0
web_certType Class A - Breeder
pdf_customer_id 7878.0
pdf_customer_name Julie A Nelson
pdf_customer_addr 3053 190th Street Fairfield, IA 52556
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23495770-aphis-inspection-167161213170478
lat  
lng  

In the two small dog buildings there are at least sixteen enclosures, containing twenty dogs, that are framed in wood and the wood along the tops of the enclosures has been chewed and shredded by the dogs. The outdoor enclosures housing the Golden retrievers have shelters with flaps over the doors that act as wind and rain breaks. At least three of the flaps have been shredded and torn by the dogs. At least three dogs are housed in these enclosures. The outdoor enclosures each contain a shelter for the dogs. In one enclosure, containing two Golden retrievers, the floor of the shelter is constructed of wooden boards and the dogs have damaged the wood resulting in a large hole in the floor. The damage to the wood and the shelter flaps does not allow for proper cleaning and sanitization of these surfaces to occur and could increase the disease risk towards the dogs. All surfaces must be maintained on a regular basis. Any surface that cannot be readily cleaned and sanitized must be replaced if worn or soiled. The licensee must replace the damaged wood and shelter flaps or alter them in a manner that allows for cleaning and sanitization of the surfaces to occur. The licensee must ensure that all surfaces of housing facilities are maintained and kept in good repair.

rowid 12048
desc HOUSING FACILITIES, GENERAL.
web_siteName JULIE A NELSON
kind  
Incident hash_id f6cc9c5975cb6778
web_inspectionDate 2016-06-14
code 3.1(c)(2)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 76.0
web_certType Class A - Breeder
pdf_customer_id 7878.0
pdf_customer_name Julie A Nelson
pdf_customer_addr 3053 190th Street Fairfield, IA 52556
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23495770-aphis-inspection-167161213170478
lat  
lng  

There is one outdoor enclosure, containing one Golden retriever, which has no wind and rain break at the entrance to the shelter. Another enclosure, containing one Golden retriever, has just one small strip remaining of the flap that covers the entrance to the shelter. Wind and rain breaks located at the shelter entrance are necessary to ensure that the dog can adequately escape uncomfortable weather. All outdoor housing shelters must be provided with a wind and rain break at the entrance. The licensee must add a sufficient wind and rain break to the front of the shelters. The licensee must ensure that all outdoor shelters have a wind and rain break at all times for the health and well-being of the dogs. Correction date: June 28, 2016

rowid 12049
desc OUTDOOR HOUSING FACILITIES.
web_siteName JULIE A NELSON
kind  
Incident hash_id f6cc9c5975cb6778
web_inspectionDate 2016-06-14
code 3.4(b)(3)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 76.0
web_certType Class A - Breeder
pdf_customer_id 7878.0
pdf_customer_name Julie A Nelson
pdf_customer_addr 3053 190th Street Fairfield, IA 52556
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23495770-aphis-inspection-167161213170478
lat  
lng  

In at least two outdoor enclosures, containing three Golden retrievers, there is a thick buildup of dirt on the interior walls of the shelters. In the enclosure containing two young adult Golden retrievers there is also a buildup of dirt on the wooden floor of the enclosure. The buildup of dirt could increase the risk of disease towards the dogs. Used primary enclosures for dogs must be sanitized at least once every two weeks, or more often if necessary to prevent the buildup of dirt, debris, food waste, excreta, and other disease hazards. The licensee must remove the buildup of dirt from the interior surfaces of the shelters. The licensee must ensure that the buildup of dirt on the surfaces of all used primary enclosures is eliminated for the health and well-being of the dogs. Correction date: June 28. 2016 Exit interview conducted with Kelly Maxwell, ACI, Heather Cole, VMO and the facility representative. Additional Inspectors Cole Heather, Supervisory Animal Care Specialist

rowid 12050
desc CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL.
web_siteName JULIE A NELSON
kind  
Incident hash_id f6cc9c5975cb6778
web_inspectionDate 2016-06-14
code 3.11(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 76.0
web_certType Class A - Breeder
pdf_customer_id 7878.0
pdf_customer_name Julie A Nelson
pdf_customer_addr 3053 190th Street Fairfield, IA 52556
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23495770-aphis-inspection-167161213170478
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 6098.055ms