home / aphis_reports

Semantic search

citation_inspection

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

6 rows where hash_id = "38cb608c999133e1"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: desc, repeat

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

A female Maltese, microchip number 087057013, has an excessive buildup of a thick, brown substance covering her teeth and a thick, black substance caked in her left ear. Poor dental health and ear cleaning practices can result in discomfort and an increase in disease risks to the dog. Licensee must have this dog evaluated by a licensed veterinarian and establish both dental health and ear cleaning plans to maintain the health and well being of the dog. Correct by: 09/17/14

rowid 12169
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName LEONARD STOVER
kind  
Incident hash_id 38cb608c999133e1
web_inspectionDate 2014-09-09
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 138.0
web_certType Class B - Dealer
pdf_customer_id 8038.0
pdf_customer_name Leonard Stover
pdf_customer_addr P O Box 53 Sheldon, IA 51201
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23496011-aphis-inspection-252141842460423
lat  
lng  

In the outside room, the enclosures are framed with metal pipes. These metal pipes are showing excessive rusting throughout all the enclosures. The rust causes pitting and flaking of the metal and cannot be properly cleaned and sanitized. All rusty metal needs to be replaced or altered in a manner that allows for proper cleaning and sanitization of the metal every two weeks. Correct by: 09/24/14

rowid 12170
desc HOUSING FACILITIES, GENERAL.
web_siteName LEONARD STOVER
kind  
Incident hash_id 38cb608c999133e1
web_inspectionDate 2014-09-09
code 3.1(c)(1)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 138.0
web_certType Class B - Dealer
pdf_customer_id 8038.0
pdf_customer_name Leonard Stover
pdf_customer_addr P O Box 53 Sheldon, IA 51201
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23496011-aphis-inspection-252141842460423
lat  
lng  

In the west whelping room, an enclosure housing three schnauzer puppies has sides constructed of metal wire. The metal wire has broken and twisted inward towards the dogs. In the east whelping room, two enclosures each housing three yorkshire terriers, has wire flooring that has broken and twisted upward into the enclosure. Also, in the east whelping room, an enclosure housing one yorkshire terrier has sides made of wire that has broken and twisted inward towards the dog. In the outside room, two enclosures have access doors with broken metal framing. The metal framing across the bottom of both access doors has broken and twisted upward toward the dogs. These sharp points and edges pose an injury risk to the dogs. All sharp points and edges must be removed or altered in a manner that eliminates the injury risk to the dogs. Correct by: 09/24/14

rowid 12171
desc HOUSING FACILITIES, GENERAL.
web_siteName LEONARD STOVER
kind  
Incident hash_id 38cb608c999133e1
web_inspectionDate 2014-09-09
code 3.1(c)(1)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 138.0
web_certType Class B - Dealer
pdf_customer_id 8038.0
pdf_customer_name Leonard Stover
pdf_customer_addr P O Box 53 Sheldon, IA 51201
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23496011-aphis-inspection-252141842460423
lat  
lng  

In the east whelping room, the enclosures are raised off the ground and have a mesh style flooring. The flooring in one enclosure, housing three dogs, has a hole in it. The hole is approximately three inches wide and poses an injury hazard to the dogs. All flooring must be constructed in a manner that does not allow for the dogs feet and legs to pass through. The flooring needs to be replaced or altered in a manner that protects the dogs from injury and the licensee must establish a maintenance plan for the enclosure flooring to ensure it remains safe for the dogs and in good repair. Correct by: 09/17/14

rowid 12172
desc PRIMARY ENCLOSURES.
web_siteName LEONARD STOVER
kind  
Incident hash_id 38cb608c999133e1
web_inspectionDate 2014-09-09
code 3.6(a)(2)(10)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 138.0
web_certType Class B - Dealer
pdf_customer_id 8038.0
pdf_customer_name Leonard Stover
pdf_customer_addr P O Box 53 Sheldon, IA 51201
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23496011-aphis-inspection-252141842460423
lat  
lng  

In the outside room, at least two feeders have a buildup of hair and dirt in them. Food receptacles must be kept cleaned and sanitized in order to prevent contamination of the feed and protect the health of the animals. Licensee must ensure that all food receptacles are cleaned and sanitized every two weeks or as often as necessary to prevent the buildup of hair, dirt and other contaminates.

rowid 12173
desc FEEDING.
web_siteName LEONARD STOVER
kind  
Incident hash_id 38cb608c999133e1
web_inspectionDate 2014-09-09
code 3.9(b)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 138.0
web_certType Class B - Dealer
pdf_customer_id 8038.0
pdf_customer_name Leonard Stover
pdf_customer_addr P O Box 53 Sheldon, IA 51201
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23496011-aphis-inspection-252141842460423
lat  
lng  

In the outside room, the fronts of the enclosures are made of chain link fencing. There is a buildup of hair and dirt on this fencing which poses a disease risk to the dogs. The fronts of the enclosures must be cleaned and sanitized every two weeks or as often as necessary to reduce the accumulation of hair, dirt and other disease risks. Also in the outside room, there is an enclosure, housing a small brown dog, that has a buildup of hard water minerals on the wall of the enclosure and on the automatic waterer. This buildup of hard water does not allow for proper cleaning and sanitization of the wall or the automatic waterer. This buildup of hard water minerals must be removed in order for the automatic waterer and the enclosure wall to be cleaned and sanitized every two weeks. Exit interview conducted with facility representative.

rowid 12174
desc CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL.
web_siteName LEONARD STOVER
kind  
Incident hash_id 38cb608c999133e1
web_inspectionDate 2014-09-09
code 3.11(b)(2)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 138.0
web_certType Class B - Dealer
pdf_customer_id 8038.0
pdf_customer_name Leonard Stover
pdf_customer_addr P O Box 53 Sheldon, IA 51201
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23496011-aphis-inspection-252141842460423
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 2502.295ms