Semantic search
citation_inspection
1 row where hash_id = "08ba0ed985a26dfc"
This data as json, CSV (advanced)
Multiple small areas areas associated with seams along the metal lining on the wall of the goat pen were rusted and peeling up away from the wall, creating roughened edges with the potential for goats to rub against and pull apart further. If the metal wall liners are not kept in good repair, there is a potential for animal injury. The facility must ensure that the facility is structurally sound and maintained in good repair to protect the animals from injury. To be corrected by: August 10, 2021 This inspection and exit interview were conducted with facility representative. End Section
| rowid | 79 |
| desc | Facilities, general. |
| web_siteName | BUSHOVER'S BIOLOGICALS, INC. |
| kind | |
| Incident hash_id | 08ba0ed985a26dfc |
| web_inspectionDate | 2021-07-27 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 66.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/23470513-aphis-inspection-2016090000667801 |
| 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);