Semantic search
citation_inspection
2 rows where hash_id = "b52e8eb54439d347"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
In the outdoor portion of the sheltered housing facility, the enclosures are separated by vinyl plastic fencing. At the level of the dogs, this fencing has a buildup of dirt and grime on it. This buildup of dirt and grime can cause a risk of disease hazards towards the dogs. The fencing must be cleaned and sanitized every two weeks to prevent the accumulation of dirt and grime. Correct by: 09/23/14
| rowid | 9522 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | JANICE HUGHES |
| kind | |
| Incident hash_id | b52e8eb54439d347 |
| web_inspectionDate | 2014-09-09 |
| code | 3.1(c)(3) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 58.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 5242.0 |
| pdf_customer_name | Janice Hughes |
| pdf_customer_addr | 225 First Street Struble, IA 51031 |
| customer_state | IA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23491346-aphis-inspection-252141240360746 |
| lat | |
| lng |
In all the enclosures containing outside access doors, except for one, the access doors are framed in vinyl plastic and have been excessively chewed by the dogs. This damage allows for dirt and food waste to penetrate the surface of the vinyl which can result in disease hazards to the dogs. The vinyl plastic needs to be replaced or altered in a manner that allows for proper cleaning and sanitization of the enclosures every two weeks. Correct by: 10/15/14 Exit interview conducted with facility representative.
| rowid | 9523 |
| desc | PRIMARY ENCLOSURES. |
| web_siteName | JANICE HUGHES |
| kind | |
| Incident hash_id | b52e8eb54439d347 |
| web_inspectionDate | 2014-09-09 |
| code | 3.6(a)(2)(9) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 58.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 5242.0 |
| pdf_customer_name | Janice Hughes |
| pdf_customer_addr | 225 First Street Struble, IA 51031 |
| customer_state | IA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23491346-aphis-inspection-252141240360746 |
| 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);