Semantic search
citation_inspection
2 rows where hash_id = "f8d79bf0189f7e9b"
This data as json, CSV (advanced)
The barn where the rabbit enclosures are located had excessive clutter and debris, including shelves with chemical products, cobwebs, and dust. The building and grounds should be maintained in a cleanly manner, in order to reduce the risk of disease and vermin, and promote good husbandry. Trash should be removed, and chemicals stored in a safe manner. To be corrected by 11/6/15.
| rowid | 23035 |
| desc | SANITATION. |
| web_siteName | THE FRIENDLY FARM FOUNDATION |
| kind | |
| Incident hash_id | f8d79bf0189f7e9b |
| web_inspectionDate | 2015-10-06 |
| code | 3.56(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 14.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 43816.0 |
| pdf_customer_name | The Friendly Farm |
| pdf_customer_addr | 1671 Boonville Road Ukiah, CA 95482 |
| customer_state | CA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23519366-aphis-inspection-281151302170694 |
| lat | |
| lng |
The enclosures for the calf and sheep / goats have many dangling and protruding pieces of wire that could potentially cause injury to the animals. Animal enclosures should be constructed and maintained in a manner that minimizes the risk of injury. To be corrected by 10/16/15. An exit briefing was conducted with the exhibitor.
| rowid | 23036 |
| desc | FACILITIES, GENERAL. |
| web_siteName | THE FRIENDLY FARM FOUNDATION |
| kind | |
| Incident hash_id | f8d79bf0189f7e9b |
| web_inspectionDate | 2015-10-06 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 14.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 43816.0 |
| pdf_customer_name | The Friendly Farm |
| pdf_customer_addr | 1671 Boonville Road Ukiah, CA 95482 |
| customer_state | CA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23519366-aphis-inspection-281151302170694 |
| 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);