Semantic search
citation_inspection
2 rows where hash_id = "a2c96a390803b164"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
The outside wire runs of the Stacker building that are coated with a material (plastic/fiberglass/rubber, etc.) have numerous missing pieces of the material, leaving bare wire that is not adequate flooring for dogs to walk on. Metal strands of wire used for flooring must be greater than 1/8 of an inch in diameter (9 gauge) or coated. These missing pieces of coating leave the wire flooring less that 9 gauge. This flooring must be repaired or replaced. This will help ensure that the dogs in this building are on flooring that will allow them to move around comfortable and be injury free. Correct by 10-09-2014.
| rowid | 15323 |
| desc | PRIMARY ENCLOSURES. |
| web_siteName | Judy Raney |
| kind | |
| Incident hash_id | a2c96a390803b164 |
| web_inspectionDate | 2014-09-09 |
| code | 3.6(a)(2)(12) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 87.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 16158.0 |
| pdf_customer_name | Judy Raney |
| pdf_customer_addr | 3069 County Road 5500 Liberty, KS 67351 |
| customer_state | KS |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23502164-aphis-inspection-252141747160832 |
| lat | |
| lng |
The shelters in the outdoor housing kennels need to be sanitized. The shelters have grease, grim, and dirt on the sides, inside and out. These shelters need to be sanitized least once every 2 weeks and more often if needed to help prevent an accumulation and help keep disease hazards from dogs. The owner stated it had been a couple of months since the shelters were sanitize. The owner needs to spot clean shelters daily and sanitize these shelters. This will help dogs to be in a healthy environment. The owner must sanitize these shelters. Correct by 09-16-2014 This inspection and exit briefing were conducted with the owner.
| rowid | 15324 |
| desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
| web_siteName | Judy Raney |
| kind | |
| Incident hash_id | a2c96a390803b164 |
| web_inspectionDate | 2014-09-09 |
| code | 3.11(b)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 87.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 16158.0 |
| pdf_customer_name | Judy Raney |
| pdf_customer_addr | 3069 County Road 5500 Liberty, KS 67351 |
| customer_state | KS |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23502164-aphis-inspection-252141747160832 |
| 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);