Semantic search
citation_inspection
1 row where hash_id = "01d0ae7720af0962"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
The plan for environment enhancement adequate to promote the psychological well-being of nonhuman primates had not been reviewed by the new veterinarian. The current plan does not accurately reflect the significant human interaction that Chloe receives during the day. The plan for environmental enhancement needs to be approved by the current veterinarian and accurately reflect the environmental enhancement for Chloe. Correction Date 31 July 2015 Exit Interview conducted with facility representative. Additional Inspectors Lorang Jeanne, Animal Care Inspector
| rowid | 6721 |
| desc | ENVIRONMENT ENHANCEMENT TO PROMOTE PSYCHOLOGICAL WELL-BEING. |
| web_siteName | COUGAR HILL RANCH, INC. |
| kind | |
| Incident hash_id | 01d0ae7720af0962 |
| web_inspectionDate | 2015-06-30 |
| code | 3.81 |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 16.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3517.0 |
| pdf_customer_name | Cougar Hill Ranch Inc. |
| pdf_customer_addr | P.O. Box 132 Littlerock, CA 93543 |
| customer_state | CA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23486671-aphis-inspection-182151240080098 |
| lat | 34.521104 |
| lng | -117.9836793 |
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);