Semantic search
citation_inspection
2 rows where hash_id = "3fad57a32534c9a3"
This data as json, CSV (advanced)
Sale records listing the complete name and address and USDA license of the buyer were not being maintained. Licensee must make and maintain sale records which fully and correctly discloses the name and address of the buyer, the date animals were sold, buyer's USDA license number, and a description and number of animals sold. Sale records must be maintained to keep track of animal shipments for health and regulatory purposes and to document changes in ownership. APHIS form 7020 were left with owner to help maintain records of animals sold. Correct by July 3, 2014
| rowid | 27079 |
| desc | RECORDS: DEALERS AND EXHIBITORS. |
| web_siteName | LESTER BRUBACHER |
| kind | |
| Incident hash_id | 3fad57a32534c9a3 |
| web_inspectionDate | 2014-07-01 |
| code | 2.75(b)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 147.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 325795.0 |
| pdf_customer_name | Lester B Brubacher |
| pdf_customer_addr | 5 Brick Church Rd Leola, PA 17540 |
| customer_state | PA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23526667-aphis-inspection-181141519487258 |
| lat | |
| lng |
Two enclosures housing approximately 30 guinea pigs each had accumulations of soiled bedding. These two enclosures had more excreta than clean bedding. Primary enclosures must be cleaned often enough to prevent an accumulation of excreta, dirty bedding and debris. Primary enclosures must be cleaned and sanitized at least once every 2 weeks to maintain the health of the animals. Correct by ensuring that all primary enclosures are kept clean and sanitzed often enough to prevent and accumulation of excreta, dirty bedding and debris. Correct by July 2, 2014. An exit briefing was conducted with owner.
| rowid | 27080 |
| desc | SANITATION. |
| web_siteName | LESTER BRUBACHER |
| kind | |
| Incident hash_id | 3fad57a32534c9a3 |
| web_inspectionDate | 2014-07-01 |
| code | 3.31(a)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 147.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 325795.0 |
| pdf_customer_name | Lester B Brubacher |
| pdf_customer_addr | 5 Brick Church Rd Leola, PA 17540 |
| customer_state | PA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23526667-aphis-inspection-181141519487258 |
| 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);