Semantic search
citation_inspection
6 rows where hash_id = "38cb608c999133e1"
This data as json, CSV (advanced)
Suggested facets: desc, repeat
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
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);