Semantic search

citation_inspection

Table actions

1 row where hash_id = "feb38644f9cc71b9"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

During the on-site inspection of animal facilities, it appeared that all nonhuman primates were receiving basic enrichment as directed by the environmental enrichment plan. Animals requiring special attention under this section were receiving an extra enrichment device each week. The duration of interaction with this enrichment was less than one day. The success or failure of special attention being provided to these animals was not sufficiently documented to determine if the special attention was effective, and/or if adjustments were needed to help address the psychological distress. Correct by assessing and documenting the effectiveness of the special attention being provided, and implementing modifications to the environmental enrichment provided to these animals as needed and as approved by the attending veterinarian. To be corrected prior to the next inspection. An exit briefing was conducted with the attending veterinarian. Additional Inspectors Brandes Robert, Veterinary Medical Officer

rowid 86
desc ENVIRONMENT ENHANCEMENT TO PROMOTE PSYCHOLOGICAL WELL-BEING.
web_siteName The Johns Hopkins University
kind  
Incident hash_id feb38644f9cc71b9
web_inspectionDate 2016-07-15
code 3.81(c)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 448.0
web_certType Class A - Breeder
pdf_customer_id 81.0
pdf_customer_name The Johns Hopkins University
pdf_customer_addr 265 Garland Hall 3400 N Charles Street Baltimore, MD 21218
customer_state MD
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470574-aphis-inspection-2016082568010845
lat 39.3273434
lng -76.62155039999999

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);