Semantic search

citation_inspection

Table actions

1 row where hash_id = "a2d17e556e14642a"

✎ 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

Item Environment Enhancement 3.81 c 3 At the time of inspection primate R11001 showed areas of hair loss along the back. In reviewing the animals record this was first seen back in Feb 2015 .The next entry in the animals record was in June of 2015 indicating patchy alopecia. There were no further entries in the animals record since then. The enrichment program of non human primates indicates that atypical behavior will be evaluated regularly and written in the animals record. The facility needs to follow their plan and insure atypical behavior is documented and treated. Correct from this day 1/5/2016 Exit interview took place at the end of inspection Inspection took place over 2 days 1/4-5/2016

rowid 27185
desc ENVIRONMENT ENHANCEMENT TO PROMOTE PSYCHOLOGICAL WELL-BEING.
web_siteName NEW YORK STATE PSYCHIATRIC INSTITUTE
kind  
Incident hash_id a2d17e556e14642a
web_inspectionDate 2016-01-05
code 3.81(c)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 185.0
web_certType Class R - Research Facility
pdf_customer_id 325904.0
pdf_customer_name New York State Psychiatric Institute
pdf_customer_addr 1051 Riverside Drive New York, NY 10032
customer_state NY
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23526783-aphis-inspection-5161121190525
lat  
lng  

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