Semantic search
citation_inspection
5 rows where hash_id = "29cd19cbcb5e03d9"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
The licensee has 4 French Bulldogs that are approximately 5 months old and 3 puppies about 12 weeks old that have no form of identification. Identification of dogs and puppies is necessary for record keeping, in the provision and recording of medical treatments, and provides important information in case of disease outbreaks. All dogs on the premises need to be identified using a USDA approved method. To be corrected by: May 16, 2023
| rowid | 20900 |
| desc | Time and method of identification. |
| web_siteName | William Davenport |
| kind | |
| Incident hash_id | 29cd19cbcb5e03d9 |
| web_inspectionDate | 2023-05-02 |
| code | 2.50(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 27.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 37551.0 |
| pdf_customer_name | William Davenport |
| pdf_customer_addr | 1946 High School Drive Afton, IA 50830 |
| customer_state | IA |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23902833-aphis-inspection-ins-0000877999 |
| lat | |
| lng |
The licensee has 24 adult French Bulldogs and 3 puppies in their possession for which there are no records written using APHIS Form 7005. The licensee currently has no 7006 (disposition) papers for 3 puppies that were recently given to another person. Accurate and complete records are necessary for tracking the location and movement of dogs to aid in regulation and provide important information in case of disease outbreak. Each dealer shall make, keep, and maintain records and forms which fully and correctly disclose the information concerning each dog purchased or otherwise acquired, owned, held, or otherwise in his or her possession or under his or her control, or which is transported, euthanized, sold, or otherwise disposed of by that dealer. APHIS Forms 7005 and 7006 must be used. To be corrected by: May 16, 2023
| rowid | 20901 |
| desc | Records: Dealers and exhibitors. |
| web_siteName | William Davenport |
| kind | |
| Incident hash_id | 29cd19cbcb5e03d9 |
| web_inspectionDate | 2023-05-02 |
| code | 2.75 |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 27.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 37551.0 |
| pdf_customer_name | William Davenport |
| pdf_customer_addr | 1946 High School Drive Afton, IA 50830 |
| customer_state | IA |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23902833-aphis-inspection-ins-0000877999 |
| lat | |
| lng |
The licensee does not have a written contingency plan. All dealers must develop, document, and follow an appropriate plan to provide for the humane handling, treatment, transportation, housing, and care of their animals in the event of an emergency or disaster (one which could reasonably be anticipated and expected to be detrimental to the good health and well-being of the animals in their possession). To be corrected by: May 16, 2023
| rowid | 20902 |
| desc | Contingency planning. |
| web_siteName | William Davenport |
| kind | |
| Incident hash_id | 29cd19cbcb5e03d9 |
| web_inspectionDate | 2023-05-02 |
| code | 2.134(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 27.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 37551.0 |
| pdf_customer_name | William Davenport |
| pdf_customer_addr | 1946 High School Drive Afton, IA 50830 |
| customer_state | IA |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23902833-aphis-inspection-ins-0000877999 |
| lat | |
| lng |
The licensee does not have a documented exercise plan. Provision of adequate space and time for exercise is very important for the health and wellbeing of dogs. Dealers must develop, document, and follow an appropriate plan to provide dogs with the opportunity for exercise. In addition, the plan must be approved by the attending veterinarian. The plan must include written standard procedures to be followed in providing the opportunity for exercise. To be corrected by: May16, 2023
| rowid | 20903 |
| desc | Exercise for dogs. |
| web_siteName | William Davenport |
| kind | |
| Incident hash_id | 29cd19cbcb5e03d9 |
| web_inspectionDate | 2023-05-02 |
| code | 3.8 |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 27.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 37551.0 |
| pdf_customer_name | William Davenport |
| pdf_customer_addr | 1946 High School Drive Afton, IA 50830 |
| customer_state | IA |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23902833-aphis-inspection-ins-0000877999 |
| lat | |
| lng |
The licensee does not have written program of veterinary care for dogs. The program of veterinary care establishes guidelines for preventative medicine, husbandry, and veterinary care that are vital for protecting the health and wellbeing of the dogs. Each dealer must follow an appropriate program of veterinary care for dogs that is developed, documented in writing, and signed by the attending veterinarian and must keep and maintain the written program and make it available for inspection. To be corrected by: May 16, 2023 This inspection and exit interview were conducted with a facility representative. n
| rowid | 20904 |
| desc | Veterinary care for dogs. |
| web_siteName | William Davenport |
| kind | |
| Incident hash_id | 29cd19cbcb5e03d9 |
| web_inspectionDate | 2023-05-02 |
| code | 3.13(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 27.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 37551.0 |
| pdf_customer_name | William Davenport |
| pdf_customer_addr | 1946 High School Drive Afton, IA 50830 |
| customer_state | IA |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23902833-aphis-inspection-ins-0000877999 |
| 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);