Semantic search
citation_inspection
1 row where hash_id = "ee329c7aa0f98bc5"
This data as json, CSV (advanced)
-During the cleaning of the female fisher #985112005255670 externally attached den box, a block was used to cover the entrance and the lid was closed. When the worker returned and opened the lid to place the bedding in, the block had been worked free. When the block was moved the fisher ran up and out of the den box. During the attempt to capture the fisher it ran up and over the perimeter fence and has not been recovered. -All animal enclosures must be constructed in such a manner that contain the animals from escaping. A program of identifying and correcting the fisher den box; and other areas of future potential escape routes, must be corrected in a timely manner to ensure the containment of all the animals and to ensure this noncompliant item does not repeat. -To be corrected by: January 19, 2016 Exit interview was conducted with facility representatives
| rowid | 7215 |
| desc | FACILITIES, GENERAL. |
| web_siteName | Animals of Montana Inc - Troy Hyde |
| kind | |
| Incident hash_id | ee329c7aa0f98bc5 |
| web_inspectionDate | 2016-01-05 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 50.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3702.0 |
| pdf_customer_name | Animals Of Montana Inc. |
| pdf_customer_addr | 170 Nixon Peak Road Bozeman, MT 59715 |
| customer_state | MT |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23487780-aphis-inspection-6161230370792 |
| lat | 45.8670572 |
| lng | -110.8093213 |
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);