Semantic search
citation_inspection
1 row where hash_id = "d92872eefcec9855"
This data as json, CSV (advanced)
A ram at a sheep flock that is used under a holding protocol and a teaching protocol approved by the facility's Institutional Animal Care and Use Committee was found to be unable to stand on January 24, 2014. The herdsman who discovered the animal in this condition monitored and treated the animal for three days without consulting the attending veterinarian. The animal did not improve, and was subsequently euthanized. Animals should be observed on a daily basis to assess their well-being, and any problems should be promptly communicated to the attending veterinarian, so that appropriate steps can be taken to address health problems. In this case the animal clearly needed prompt veterinary attention, and it was not received. Failure to communicate problems and provide adequate care can result in unnecessary suffering. The facility recognized this failure, reported the event, and has taken appropriate action to correct the problem with the personnel involved. An exit interview was conducted on 9/21/15 with facility representatives.
rowid | 29 |
desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE. |
web_siteName | UNIVERSITY OF HAWAII AT MANOA |
kind | |
Incident hash_id | d92872eefcec9855 |
web_inspectionDate | 2015-09-16 |
code | 2.33(b)(3) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 0.0 |
web_certType | Class R - Research Facility |
pdf_customer_id | 19.0 |
pdf_customer_name | University Of Hawaii At Manoa |
pdf_customer_addr | 2425 Campus Road, Sinclair 10 Honolulu, HI 96822 |
customer_state | HI |
pdf_site_id | 006 |
doccloud_url | https://www.documentcloud.org/documents/23470231-aphis-inspection-328151904460592 |
lat | 21.2984663 |
lng | -157.8204149 |
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);