Semantic search
citation_inspection
1 row where hash_id = "090414fb43ad755a"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
Two bottles of Heparin (one partially used, one unopened) and one partially used tube of Puralube eye lubrication ointment were found in room 140 at ATRC building that were expired (06/2017 and 05/2016 respectively). In the refrigerator in the Stallion Barn lab area, a syringe containing a white liquid was unlabeled and undated. Liquids in unlabeled syringes are not identifiable and may be incorrectly administrated or improperly used. Expired medications may have compromised efficacy and potency. Use of unlabeled medication or expired drugs may be harmful or lead to untowards effects or inadequate treatment. The facility needs to ensure that medications are stored and labeled properly and are not being used past their expiration date. Corrected at time of inspection. This inspection and exit interview were conducted with facility representatives. Additional Inspectors Secor Thomas, Veterinary Medical Officer
rowid | 2 |
desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE. |
web_siteName | UTAH STATE UNIVERSITY |
kind | |
Incident hash_id | 090414fb43ad755a |
web_inspectionDate | 2017-09-07 |
code | 2.33(b)(2) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 594.0 |
web_certType | Class R - Research Facility |
pdf_customer_id | 2.0 |
pdf_customer_name | Utah State University |
pdf_customer_addr | V.P. For Research/1450 Old Main Hill Logan, UT 84322 |
customer_state | UT |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23470116-aphis-inspection-2016082568794784 |
lat | 41.7421403 |
lng | -111.809059 |
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);