Semantic search
citation_inspection
1 row where hash_id = "b0049aa2d05edd2f"
This data as json, CSV (advanced)
The chainlink fence surrounding the outdoor goat pen was sagging and detached from several of the upright supports, with some exposed sharp edges of wire along the bottom edge on one side. Sagging fence may fail to contain the animals adequately, and the sharp edges of wire could present a risk for injury. The facility must ensure the fence securely and safely contains the animals. Correct by 30 May 2023. This inspection and exit interview were conducted with the facility representative. n
| rowid | 80 |
| desc | Facilities, general. |
| web_siteName | BUSHOVER'S BIOLOGICALS, INC. |
| kind | |
| Incident hash_id | b0049aa2d05edd2f |
| web_inspectionDate | 2023-05-09 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 53.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 68.0 |
| pdf_customer_name | BUSHOVER'S BIOLOGICALS, INC. |
| pdf_customer_addr | 992 CROSS HILL ROAD VASSALBORO, ME 04989 |
| customer_state | ME |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23837737-aphis-inspection-ins-0000868585 |
| 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);