Semantic search
citation_inspection
2 rows where hash_id = "b7b14dac41ee8062"
This data as json, CSV (advanced)
All watering receptacles shall be sanitized when dirty..... At least 4 water bottles had a dark layer of algae on the inside. Water bottles must be sanitized when dirty. Water bottles must be cleaned at least every two weeks or as often as needed to maintain them clean. Dirty water bottles can cause many animals to get sick. Clean water bottles as a routine practice, minimally every 2 weeks but more often if they are dirty. Correct by 8-21-14.
| rowid | 24380 |
| desc | WATERING. |
| web_siteName | ELI KING |
| kind | |
| Incident hash_id | b7b14dac41ee8062 |
| web_inspectionDate | 2014-08-20 |
| code | 3.30 |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 458.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 321615.0 |
| pdf_customer_name | Eli S King |
| pdf_customer_addr | 15710 Co Hwy F Darlington, WI 53530 |
| customer_state | WI |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23521731-aphis-inspection-232141534460848 |
| lat | |
| lng |
Pest control. Many black flies were observed to be in the building and the enclosures. No method of fly control was seen to be in place. Flies were landing on guinea pigs and in their feed. Large numbers of flies and pests can cause animals to get sick and can spread sickness to other animals. Effective and safe methods to control pests must be put into practice and maintained to protect the health and wellbeing of the guinea pigs. Correct by 8-22-14. Exit interview conducted with facility representative.
| rowid | 24381 |
| desc | SANITATION. |
| web_siteName | ELI KING |
| kind | |
| Incident hash_id | b7b14dac41ee8062 |
| web_inspectionDate | 2014-08-20 |
| code | 3.31(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 458.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 321615.0 |
| pdf_customer_name | Eli S King |
| pdf_customer_addr | 15710 Co Hwy F Darlington, WI 53530 |
| customer_state | WI |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23521731-aphis-inspection-232141534460848 |
| 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);