Semantic search
citation_inspection
1 row where hash_id = "749f21ef155db196"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
Section 3.53(a)(1) Primary enclosures: In the enclosure housing two rabbits the ramp on the right side going up to the shelter has a screw head that is protruding up out of the horizontal wood slat (2nd from the bottom). The slat is no longer secured to the ramp on its right side and the right side of the slat has slid down to the next horizontal slat on the ramp. The rabbits may be injured on the screw head or lose slat. Correct by reattaching the slat to the ramp or remove the slat to protect the rabbits from injury. Correct by October 13, 2016. This inspection and exit interview were conducted with the facility secretary.
| rowid | 15210 |
| desc | PRIMARY ENCLOSURES. |
| web_siteName | VARNERS TREE FARM |
| kind | |
| Incident hash_id | 749f21ef155db196 |
| web_inspectionDate | 2016-10-12 |
| code | 3.53(a)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 13.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 15335.0 |
| pdf_customer_name | Varners Tree Farm |
| pdf_customer_addr | 746 S Trappe Rd Collegeville, PA 19426 |
| customer_state | PA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23501713-aphis-inspection-2016082567956974 |
| 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);