Semantic search
citation_inspection
5 rows where hash_id = "6cebdb4f3f313492"
This data as json, CSV (advanced)
Suggested facets: desc, repeat
***A female Shiba Inu, microchip # 0A02314605, was observed shaking her head and tilting it to the right. Upon closer observation noticed a very wet, heavy, and yellowish discharge in the ear and adhered to the hair around the ear, the skin in the ear canal also appeared reddened and inflamed. As the inspector tried to gently lift the ear flap for a better view of the ear canal the dog winced and tried to pull back as though this condition was painful. The licensee was not aware of this dog's condition until it was pointed out to her by the inspectors. This could be the result of an injury, infection, illness or other veterinary medical condition which may cause discomfort. The licensee must have this dog examined by a veterinarian by close of business on 19 Aug 15. The licensee must ensure all animals receive adequate veterinary care at all times.
| rowid | 22575 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | RAYMOND LAWSON |
| kind | Direct |
| Incident hash_id | 6cebdb4f3f313492 |
| web_inspectionDate | 2015-08-18 |
| code | 2.40(b)(2) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 70.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 42626.0 |
| pdf_customer_name | Raymond Lawson |
| pdf_customer_addr | 40839 Dirt Rd Clifton Hill, MO 65244 |
| customer_state | MO |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23518419-aphis-inspection-230151627050800 |
| lat | |
| lng |
Structure. ***In the sheltered housing there is a woven wire divider panel in between two enclosures, affecting 5 dogs, which has a section of approximately 2 feet long by 2 inches in height, and at the dogs' leg level, that has become unattached from the O-rings creating a gap large enough that the dogs' legs could become trapped or the dogs could become injured. The licensee must repair or replace this section and ensure that all enclosures are kept in good repair and they must protect the dogs from injury at all times. To be corrected by: August 22, 2015.
| rowid | 22576 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | RAYMOND LAWSON |
| kind | |
| Incident hash_id | 6cebdb4f3f313492 |
| web_inspectionDate | 2015-08-18 |
| code | 3.1(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 70.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 42626.0 |
| pdf_customer_name | Raymond Lawson |
| pdf_customer_addr | 40839 Dirt Rd Clifton Hill, MO 65244 |
| customer_state | MO |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23518419-aphis-inspection-230151627050800 |
| lat | |
| lng |
Drainage ***Immediately next to 4 enclosures affecting 11 dogs, the ground was puddled with standing waste water. This puddled area had a mixture of feces, food, green and black slimy material, and crawling, wiggling and flying insects. Having waste close to the enclosures can attract pest and vermin that can harm the dogs. The licensee must dispose the waste far enough from the facility as to not attract pests or vermin near the animals and ensure proper drainage occurs. To be corrected by: August 22, 2015.
| rowid | 22577 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | RAYMOND LAWSON |
| kind | |
| Incident hash_id | 6cebdb4f3f313492 |
| web_inspectionDate | 2015-08-18 |
| code | 3.1(f) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 70.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 42626.0 |
| pdf_customer_name | Raymond Lawson |
| pdf_customer_addr | 40839 Dirt Rd Clifton Hill, MO 65244 |
| customer_state | MO |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23518419-aphis-inspection-230151627050800 |
| lat | |
| lng |
Construction ***The facility has outdoor enclosures with wood floors and shelters, not impervious to moisture. The wood floors and dog shelters had water and urine soaking into the wood. There were 11 outdoor enclosures with 27 dogs that had wood plank floors and dog shelters that were constructed with wood on the inside in contact with the dogs. Three of the shelters in the enclosures had wood slatted floors with gaps between the boards, preventing proper cleaning and sanitization. These wood surfaces are not impervious to moisture, and cannot be properly cleaned and sanitized. Licensee stated the wood was treated last spring. The licensee must ensure all surfaces in contact with animals are impervious to moisture and readily cleaned and sanitized. The licensee must ensure all surfaces must be maintained on a regular basis.
| rowid | 22578 |
| desc | OUTDOOR HOUSING FACILITIES. |
| web_siteName | RAYMOND LAWSON |
| kind | |
| Incident hash_id | 6cebdb4f3f313492 |
| web_inspectionDate | 2015-08-18 |
| code | 3.4(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 70.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 42626.0 |
| pdf_customer_name | Raymond Lawson |
| pdf_customer_addr | 40839 Dirt Rd Clifton Hill, MO 65244 |
| customer_state | MO |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23518419-aphis-inspection-230151627050800 |
| lat | |
| lng |
The food inside 3 of the metal self-feeders, affecting 6 dogs, contains several bugs. When the inspectors lifted the lid off of the self-feeder the bugs were seen crawling on and through the food. These bugs could contaminate the food. When questioned by the inspector as to how often the self- feeders are cleaned and refilled, she replied that it "was last cleaned about 4-5 weeks ago" and she refills the feeders "about once a week". The licensee must discard the contaminated food in the affected self-feeders and ensure that all food given to the dogs is uncontaminated, wholesome, palatable, and of sufficient quantity and nutritive value. To be corrected by: August 20, 2015. Veterinary care for dog 0A01341025 from the 2/5/2015 report has been addressed. Inspection and exit interview was conducted with facility representative, Chad Proctor ACI, Stephanie Osborne ACI. Additional Inspectors Osborne Stephanie, Animal Care Inspector
| rowid | 22579 |
| desc | FEEDING. |
| web_siteName | RAYMOND LAWSON |
| kind | Direct |
| Incident hash_id | 6cebdb4f3f313492 |
| web_inspectionDate | 2015-08-18 |
| code | 3.9(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 70.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 42626.0 |
| pdf_customer_name | Raymond Lawson |
| pdf_customer_addr | 40839 Dirt Rd Clifton Hill, MO 65244 |
| customer_state | MO |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23518419-aphis-inspection-230151627050800 |
| 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);