Semantic search
citation_inspection
4 rows where hash_id = "c59139a6c8ac433e"
This data as json, CSV (advanced)
***The program of veterinary care was incomplete. The program of veterinary care needed an updated date and, signature from the veterinarian and exhibitor. The program also needed to included the goats, pigs and rabbits.The program needs to be updated and signed to ensure that the plan has been reviewed and animals have been seen at least once a year. Also the exhibitor has to arrange a formal written agreement with a veterinarian to provide adequate veterinary care to the animals in the event veterinary care needs to be provided for the betterment of the animals. The plan didn't include any euthanasia and emergency procedure. The program should inlcude these components to ensure there is a plan in place if an animal must be euthanized or if there is an emergency. The program needs to be complete so that appropriate measures can be taken and promptly addressed.
| rowid | 20977 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | FUNNY FARM PETTING FARM INC |
| kind | |
| Incident hash_id | c59139a6c8ac433e |
| web_inspectionDate | 2014-08-20 |
| code | 2.40(a)(1) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 28.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 37785.0 |
| pdf_customer_name | Funny Farm Petting Farm Inc |
| pdf_customer_addr | 17347 Krchak Ln Robertsdale, AL 36567 |
| customer_state | AL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23515148-aphis-inspection-231140746460301 |
| lat | |
| lng |
***There was a brown rabbit that was reluctant to move and looked lethargic. When the rabbit moved it stumbled to the right. The right ear was drooping and had a reddish brown flaky debris that was in the lower half of the ear which the owner did not notice prior to the inspection. The attending veterinarian needs to be contacted and consulted immediately and veterinarian care should be provided as soon as possible. There should be a daily observation made of all animals to assess their health and well-being. There should be a direct and frequent communication of timely and accurate information on problems of animal health, behavior, and well-being to the attending veterinarian.
| rowid | 20978 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | FUNNY FARM PETTING FARM INC |
| kind | Direct |
| Incident hash_id | c59139a6c8ac433e |
| web_inspectionDate | 2014-08-20 |
| code | 2.40(b)(3) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 28.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 37785.0 |
| pdf_customer_name | Funny Farm Petting Farm Inc |
| pdf_customer_addr | 17347 Krchak Ln Robertsdale, AL 36567 |
| customer_state | AL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23515148-aphis-inspection-231140746460301 |
| lat | |
| lng |
***There were no records documenting the acquisition of any of the covered species and the exhibitor shall make, keep and maintain records or forms which correctly disclose the information of these animals. The records shall include offspring born of any animals while in his/her possession or under his or her control.
| rowid | 20979 |
| desc | RECORDS: DEALERS AND EXHIBITORS. |
| web_siteName | FUNNY FARM PETTING FARM INC |
| kind | |
| Incident hash_id | c59139a6c8ac433e |
| web_inspectionDate | 2014-08-20 |
| code | 2.75(b)(1) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 28.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 37785.0 |
| pdf_customer_name | Funny Farm Petting Farm Inc |
| pdf_customer_addr | 17347 Krchak Ln Robertsdale, AL 36567 |
| customer_state | AL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23515148-aphis-inspection-231140746460301 |
| lat | |
| lng |
***All of the rabbits were observed panting and stretched out in their cages reluctant to move. The heat index was 104.7 degrees F using the kestrel at approximately 6:00 pm. There was also one lethargic rabbit that appeared to be in distress that was subjected to these conditions. Each cage had a little fan above it to keep the animals cool but this was insufficient in improving the climatic conditions. When climatic conditions present a threat to an animal's health or well-being, appropriate measures must be taken to alleviate the impact of those conditions. An animal may never be subjected to any combination of temperature, humidity, and time that is detrimental to the animal's health or well-being, taking into consideration such factors as the animal's age, species, breed, overall health status, and acclimation. Correct by August 21, 2014 The inspection and exit briefing was conducted with the partner. Additional Inspectors Der Christina, Veterinary Medical Officer
| rowid | 20980 |
| desc | HANDLING OF ANIMALS. |
| web_siteName | FUNNY FARM PETTING FARM INC |
| kind | |
| Incident hash_id | c59139a6c8ac433e |
| web_inspectionDate | 2014-08-20 |
| code | 2.131(e) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 28.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 37785.0 |
| pdf_customer_name | Funny Farm Petting Farm Inc |
| pdf_customer_addr | 17347 Krchak Ln Robertsdale, AL 36567 |
| customer_state | AL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23515148-aphis-inspection-231140746460301 |
| 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);