Semantic search
citation_inspection
3 rows where hash_id = "d90289888302ddc8"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
The metal roof of the enclosure housing the female coatimundi is damaged. Some sections of the roof are missing and other sections are bent and twisted. The roof appears structurally unsound and continued deterioration could cause injury to the animal. Housing facilities must be kept in good repair in order to safely contain the animals and prevent injury. The damaged roof should be repaired or replaced. Correct by: November 12, 2016.
| rowid | 21365 |
| desc | FACILITIES, GENERAL. |
| web_siteName | Mike Smilie |
| kind | |
| Incident hash_id | d90289888302ddc8 |
| web_inspectionDate | 2016-10-12 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 26.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 38755.0 |
| pdf_customer_name | Mike Smilie |
| pdf_customer_addr | 118 F M 2027 Rosebud, TX 76570 |
| customer_state | TX |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23515765-aphis-inspection-2016082567962843 |
| lat | |
| lng |
Several goats, a deer and a calf were housed in an enclosure that contained a large pile of discarded materials. These items included chain link type fencing, metal supports and other construction type materials. Accidental access to these items could result in injury to the animals. Accumulations of trash and unused items should be cleared as necessary from animal enclosures to protect the health of the animals and protect them from injury. Correct by: November 12, 2016.
| rowid | 21366 |
| desc | SANITATION. |
| web_siteName | Mike Smilie |
| kind | |
| Incident hash_id | d90289888302ddc8 |
| web_inspectionDate | 2016-10-12 |
| code | 3.131(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 26.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 38755.0 |
| pdf_customer_name | Mike Smilie |
| pdf_customer_addr | 118 F M 2027 Rosebud, TX 76570 |
| customer_state | TX |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23515765-aphis-inspection-2016082567962843 |
| lat | |
| lng |
Excessive numbers of black flies covered the wooden floor of the primary enclosure housing the young male coatimundi. Hundreds of flies were noted in and around the enclosure. Insects can cause irritation to the animal by biting or swarming. Flies can also transmit disease causing pathogens. A safe and effective program for insect control must be established and maintained. Correct by: October 22, 2016. Inspection and exit interview conducted with licensee.
| rowid | 21367 |
| desc | SANITATION. |
| web_siteName | Mike Smilie |
| kind | |
| Incident hash_id | d90289888302ddc8 |
| web_inspectionDate | 2016-10-12 |
| code | 3.131(d) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 26.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 38755.0 |
| pdf_customer_name | Mike Smilie |
| pdf_customer_addr | 118 F M 2027 Rosebud, TX 76570 |
| customer_state | TX |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23515765-aphis-inspection-2016082567962843 |
| 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);