Semantic search
citation_inspection
2 rows where hash_id = "1c40687a082c38ec"
This data as json, CSV (advanced)
The two reindeer cows had overgrown hooves to the point that the front dewclaws made contact with the ground and, for the cow named Bossy, the front toes were starting to cross. Excessive hoof growth can contribute to abnormal gait which can cause a change in the toe joints and may contribute to osteoarthritis especially in older animals such as these. The facility needs to have a better plan to manage the growth of the hooves to prevent them from getting too long instead of only once a year when the antler velvet is shed. The attending veterinarian was contacted immediately following the inspection to setup an appointment for hoof trimming and evaluation of the animals. The program of veterinary care must include appropriate methods to prevent, control, diagnose, and treat diseases, injuries, and other conditions that may arise. To be corrected by 7/31/2014.
| rowid | 25311 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | Bath, Inc. |
| kind | |
| Incident hash_id | 1c40687a082c38ec |
| web_inspectionDate | 2014-07-22 |
| code | 2.40(b)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 2.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 323171.0 |
| pdf_customer_name | Bath Inc. |
| pdf_customer_addr | 2000 E. Prospect Rd. Fort Collins, CO 80525 |
| customer_state | CO |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23523525-aphis-inspection-205141016540901 |
| lat | |
| lng |
The hay and mineral block supplement for two reindeer cows are being fed directly on the ground. These food items can be easily contaminated by excreta in the pen and by the animals walking through the hay, which is directly in front of the water receptacle and the entrance to the shelter structure. Contamination of feed can lead to intestinal parasitism or overgrowth of microorganisms which pose a risk to the health of these animals and feeding off the ground reduces this risk. The food shall be wholesome, palatable, and free from contamination and of sufficient quantity and nutritive value to maintain all animals in good health. To be corrected by 7/26/2014. Inspection and exit interview conducted with facility representatives, APHIS AC VMO, and APHIS HACU intern.
| rowid | 25312 |
| desc | FEEDING. |
| web_siteName | Bath, Inc. |
| kind | |
| Incident hash_id | 1c40687a082c38ec |
| web_inspectionDate | 2014-07-22 |
| code | 3.129(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 2.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 323171.0 |
| pdf_customer_name | Bath Inc. |
| pdf_customer_addr | 2000 E. Prospect Rd. Fort Collins, CO 80525 |
| customer_state | CO |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23523525-aphis-inspection-205141016540901 |
| 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);