Semantic search
citation_inspection
1 row where hash_id = "0ee581633712ea85"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
The African Rock Hyrax's primary enclosure had two mice that were eating food from a feeding utensil. It is important in order to prevent disease to make sure unwanted pests are not accessing primary enclosures. A safe and effective program for the control of insects, ectoparasites, and avian and mammalian pests shall be established and maintained. Correct by October 26,2016. This inspection and exit interview were conducted with owner.
| rowid | 15377 |
| desc | SANITATION. |
| web_siteName | RAINFOREST ADVENTURES INC |
| kind | |
| Incident hash_id | 0ee581633712ea85 |
| web_inspectionDate | 2016-10-12 |
| code | 3.131(d) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 124.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 16346.0 |
| pdf_customer_name | Rainforest Adventures Inc |
| pdf_customer_addr | 109 Nascar Drive Sevierville, TN 37862 |
| customer_state | TN |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23502292-aphis-inspection-2016082567958488 |
| lat | |
| lng |
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);