Semantic search
citation_inspection
1 row where hash_id = "553396bb9bd960ea"
This data as json, CSV (advanced)
One expired bottle of Isoflourane (expiration date 20 Aug 2014) was found on a shelf in the procedure room. The procedure utilizing this anesthetic agent had been removed from the protocol in May 2017. Expired medications may have compromised efficacy and potency and use of such does not constitute adequate veterinary care. The institution needs to ensure that medications are not being used past their expiration date. Expired bottle was disposed of at the end of the inspection. This inspection and exit interview were conducted with facility representative.
| rowid | 3 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE. |
| web_siteName | WEBER STATE UNIVERSITY |
| kind | |
| Incident hash_id | 553396bb9bd960ea |
| web_inspectionDate | 2017-08-16 |
| code | 2.33(b)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 37.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 5.0 |
| pdf_customer_name | Weber State University |
| pdf_customer_addr | 3850 Dixon Parkway Department 1027 Ogden, UT 84408 |
| customer_state | UT |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23470143-aphis-inspection-2016082568752284 |
| lat | 41.1932542 |
| lng | -111.9460555 |
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);