Semantic search
citation_inspection
1 row where hash_id = "1ea558fb6f511ae0"
This data as json, CSV (advanced)
*Two fly strips above the treatment stall for the goats were full of flies. There were some cobwebs attached to the back and sides of the stall. Debris from older fly strips and cobwebs could allow for contamination of equipment during procedures or while routinely handling the animals. In addition, as weather warms, fly strips that are full may not adequately control flies. Premises shall be kept clean in order to protect the animals from injury. Corrected at time of inspection. The inspection and exit briefing were conducted with the President.
| rowid | 78 |
| desc | SANITATION. |
| web_siteName | BUSHOVER'S BIOLOGICALS, INC. |
| kind | |
| Incident hash_id | 1ea558fb6f511ae0 |
| web_inspectionDate | 2015-04-14 |
| code | 3.131(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 130.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 68.0 |
| pdf_customer_name | Bushover'S Biologicals, Inc. |
| pdf_customer_addr | Cross Hill Road 992 Cross Hill Road Vassalboro, ME 04989 |
| customer_state | ME |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23470507-aphis-inspection-105151729574543 |
| lat | 44.3962793 |
| lng | -69.64576439999999 |
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);