Semantic search
citation_inspection
2 rows where hash_id = "fb7b6f4ba32491f4"
This data as json, CSV (advanced)
A current Program of Veterinary Care (PVC) was not available for review during this inspection. Licensees' with part time attending veterinarians must have a formal written arrangement with a veterinarian (PVC). This is required so that USDA personnel can confirm that the licensee is working with a veterinarian and is following the recommendations from that veterinarian. A program of veterinary care needs to be developed for this facility by the attending veterinarian that includes recommendations for all regulated species at the facility. Examples of some of the topics to be covered in the PVC are: *The veterinarian's schedule for visits to the facility. *Parasite control program if appropriate for the species. *Vaccination recommendations if appropriate for the species. *Routine medical testing if appropriate for the species. *Instructions on necropsies for unexpected deaths. *Any other recommendations the veterinarian feels necessary for this facility. *Emergency contact information. *Veterinarian's signature and date. This document must indicate to USDA that you and your veterinarian have an active working relationship. To be corrected immediately.
| rowid | 22437 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | LORNE MC MILLAN |
| kind | |
| Incident hash_id | fb7b6f4ba32491f4 |
| web_inspectionDate | 2015-08-18 |
| code | 2.40(a)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 44.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 42105.0 |
| pdf_customer_name | Lorne Mc Millan |
| pdf_customer_addr | 328 Blue Ribbon Road Waxahachie, TX 75165 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23518113-aphis-inspection-232151020430538 |
| lat | |
| lng |
Multiple fences were in poor repair. Some of the animals held at this facility are camels and zebra. One of the fences containing a female camel and her baby was constructed of 2 x 4 inch bendable wire and welded wire goat panel. This was all attached to the posts with baling wire. The fence surrounding an area with farm equipment was a hodgepodge of different materials. None of which were securely attached. These fences are not considered appropriate for animals the size of camels and zebra. A camel or a zebra could easily go through these fences which could result in injury to the animals on both sides of the fence. Fences must be constructed of materials that are appropriate for the animals being contained. All fences that are not structurally sound and constructed of material adequate for camels and zebra need to be repaired or replaced. To be corrected by Jan1, 2016 Inspection and exit interview conducted with the licensee.
| rowid | 22438 |
| desc | FACILITIES, GENERAL. |
| web_siteName | LORNE MC MILLAN |
| kind | |
| Incident hash_id | fb7b6f4ba32491f4 |
| web_inspectionDate | 2015-08-18 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 44.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 42105.0 |
| pdf_customer_name | Lorne Mc Millan |
| pdf_customer_addr | 328 Blue Ribbon Road Waxahachie, TX 75165 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23518113-aphis-inspection-232151020430538 |
| 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);