Semantic search
citation_inspection
5 rows where hash_id = "b0da8fbc00010aa8"
This data as json, CSV (advanced)
A tri-colored female Beagle without ID was found with excessively long toenails that require trimming. These nails are excessive long can interefere with the dogs abiility to walk normally. In addition, these lons nails are a potential injury hazard should they get caught in the flooring the dog is housed on. Correct this by trimming this dog's nails and maintaining all dogs' nails in the kennel. THIS IS A REPEAT NON-COMPLIANT ITEM THAT REMAINS UNCORRECTED
| rowid | 18691 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | David D Yoder |
| kind | |
| Incident hash_id | b0da8fbc00010aa8 |
| web_inspectionDate | 2014-07-01 |
| code | 2.40(b)(2) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 29.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 30130.0 |
| pdf_customer_name | David D Yoder |
| pdf_customer_addr | 4251 County Road 114 Sugarcreek, OH 44681 |
| customer_state | OH |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23510189-aphis-inspection-183140748320015 |
| lat | |
| lng |
***One adult female tri-colored Beagle ws found in the kennel without identification. This dog was also noted to have excessively long toenails that require trimming. Failure to properly identify animals makes animal tracking difficult to impossible and impedes the inspection process. Correct this by ensure all dogs are properly identified. Correct from this day forward
| rowid | 18692 |
| desc | TIME AND METHOD OF IDENTIFICATION. |
| web_siteName | David D Yoder |
| kind | |
| Incident hash_id | b0da8fbc00010aa8 |
| web_inspectionDate | 2014-07-01 |
| code | 2.50(a)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 29.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 30130.0 |
| pdf_customer_name | David D Yoder |
| pdf_customer_addr | 4251 County Road 114 Sugarcreek, OH 44681 |
| customer_state | OH |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23510189-aphis-inspection-183140748320015 |
| lat | |
| lng |
***Most of the plastic shelters being used for the dogs housed in the outdoor facility are chewed and worn on the edges and at the entryways. These shelters are not in good repair and require maintenance or replacement. Chewed and worn shelters can eventually affect the structural strength of the shelters which can become an injury hazard to the dogs. Correct this by repairing or replacing these shelters. Correct by: 01 August 2014
| rowid | 18693 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | David D Yoder |
| kind | |
| Incident hash_id | b0da8fbc00010aa8 |
| web_inspectionDate | 2014-07-01 |
| code | 3.1(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 29.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 30130.0 |
| pdf_customer_name | David D Yoder |
| pdf_customer_addr | 4251 County Road 114 Sugarcreek, OH 44681 |
| customer_state | OH |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23510189-aphis-inspection-183140748320015 |
| lat | |
| lng |
** The drainage system for the outside washdowns of the sheltered kennel and the outdoor kennel is not functioning properly. This drainage system is a comprised of half circle pieces of pipe that collect the runoff to an open drain. There is excessive splash over of this runoff lying on the ground next to the pipes and areas where the washdowns do not connect to the pipes properly allowing the runoff to fall to the ground. This area has an excessive odor and is a breeding ground for pests. The licensee must repair this drainage system to ensure it is functional and carries the waste and runoff to the drain without allowing it to spill onto the ground and become a disease hazard. Correct by: 01 August 2014
| rowid | 18694 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | David D Yoder |
| kind | |
| Incident hash_id | b0da8fbc00010aa8 |
| web_inspectionDate | 2014-07-01 |
| code | 3.1(f) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 29.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 30130.0 |
| pdf_customer_name | David D Yoder |
| pdf_customer_addr | 4251 County Road 114 Sugarcreek, OH 44681 |
| customer_state | OH |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23510189-aphis-inspection-183140748320015 |
| lat | |
| lng |
*** Many of the self-feeders being used at this facility are worn and chewed. These feeders require repair or replacement to ensure they can be cleaned and sanitized. Excessively chewed cannot be properly cleaned and sanitized as required and can lead to food contamination. One self-feeder was found in the first outdoor enclosure housing an adult female and 6 puppies with caked feed in the bottom. This feed is not safe for the dogs to eat and the feeding of caked feed can lead to health problems or digestive upset. All feeders must be kept in good repair and maintained clean and sanitary. Correct by: 01 AUG 2014 for replacement of chewed feeders, 04 JULY 2014 for cleaning feeder with caked feed. ***Inspection conducted with the licensee's wife. Exit interview conducted by phone with the licensee.
| rowid | 18695 |
| desc | FEEDING. |
| web_siteName | David D Yoder |
| kind | |
| Incident hash_id | b0da8fbc00010aa8 |
| web_inspectionDate | 2014-07-01 |
| code | 3.9(b) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 29.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 30130.0 |
| pdf_customer_name | David D Yoder |
| pdf_customer_addr | 4251 County Road 114 Sugarcreek, OH 44681 |
| customer_state | OH |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23510189-aphis-inspection-183140748320015 |
| 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);