Semantic search
citation_inspection
5 rows where hash_id = "438112b6c3f14225"
This data as json, CSV (advanced)
Suggested facets: desc
2.40 (b)(2) A white, adult female Chihuahua ID # 0A01474835 had a haunched posture and walked with her back legs close together in a tucked position. The kennel staff stated that the dog had looked that way for approximately two months and that she had alerted the licensee to the unusual behavior but no action was taken. During further evaluation of the animal it was evident that the rear section of her mammary area was enlarged. In addition the left rear section had golf ball size mass. The kennel staff stated that the dog was not bred and had not had puppies recently. Abnormal behavior, altered posture and swollen tissue indicate the animal may have a medical condition and/or is in pain. The licensee shall ensure all animals receive adequate veterinary care. The licensee shall obtain a written diagnosis and treatment plan from a licensed veterinarian within 48 hours and provide care as prescribed. ** This NCI was identified during the inspection and the licensee was notified that the animal would need to be seen by a vet within 48 hours. There were two dogs at the facility with matted unkempt hair coats. The gray and white male ID # 0A01451969 had long facial hair that covered his eyes. He had large mats covering his body with tight matting on his legs. The white female poodle ID # 0A01473961 also had dangling mats from his face and body with tight matting on his rear legs. Matted hair and unkempt hair coats can effect the dogs vision, cause discomfort and itching and may lead to serious skin conditions, The licensee shall provide adequate veterinary care which includes routine grooming and hair coat maintenance. A proactive approach should be taken so that mats do not form.
rowid | 10673 |
desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
web_siteName | WILMA JINSON |
kind | |
Incident hash_id | 438112b6c3f14225 |
web_inspectionDate | 2014-08-14 |
code | 2.40(b)(2) |
repeat | 1 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 84.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 6514.0 |
pdf_customer_name | Wilma Jinson |
pdf_customer_addr | 1161 Beaver Road Stella, MO 64867 |
customer_state | MO |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23493508-aphis-inspection-226141642360369 |
lat | |
lng |
3.1 (c) Surfaces(3) Cleaning There was a thick, brown grime on at least 5 of the metal dog doors of the sheltered facility housing adult dogs. Sufficient cleaning and sanitization reduces disease risks and is an important aspect of animal husbandry. The licensee shall spot clean all hard surfaces that come into contact with the animals, daily and sanitize accordingly to prevent a build-up of grime. TO BE CORRECTED BY: 8/22/14
rowid | 10674 |
desc | HOUSING FACILITIES, GENERAL. |
web_siteName | WILMA JINSON |
kind | |
Incident hash_id | 438112b6c3f14225 |
web_inspectionDate | 2014-08-14 |
code | 3.1(c)(3) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 84.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 6514.0 |
pdf_customer_name | Wilma Jinson |
pdf_customer_addr | 1161 Beaver Road Stella, MO 64867 |
customer_state | MO |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23493508-aphis-inspection-226141642360369 |
lat | |
lng |
3.1 (e) Storage There were roaches living inside the gray plastic tote used to store adult dog food. The licensee had a lid on the tote however, roaches were able to fit through the space in between the lid and tote. Roaches can spread disease and have contaminated the food intended for the adult dogs at the facility. The licensee shall ensure all open supplies of food are kept in leakproof containers with tightly fitting lids to prevent contamination and spoilage. TO BE CORRECTED BY: 8/18/2014
rowid | 10675 |
desc | HOUSING FACILITIES, GENERAL. |
web_siteName | WILMA JINSON |
kind | |
Incident hash_id | 438112b6c3f14225 |
web_inspectionDate | 2014-08-14 |
code | 3.1(e) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 84.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 6514.0 |
pdf_customer_name | Wilma Jinson |
pdf_customer_addr | 1161 Beaver Road Stella, MO 64867 |
customer_state | MO |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23493508-aphis-inspection-226141642360369 |
lat | |
lng |
3.11(a) Cleaning of primary enclosures. There was standing water in the animal area of the sheltered building housing adult dogs. The building is constructed of a metal grated floor with coated wire over the top of it. This leaves approximately a 2 inch space that is used to carry wash down water under each enclosure. The drain at the end of the facility is not functioning properly and the last 5 enclosures of the facility had standing wash down water above the coated wire. This exposes the animals to all of the material and contaminated cleaning water from the rest of the enclosures in the facility. The contaminated water may spread bacteria and disease and does not provide a clean dry environment for the animals to seek shelter from the outdoors. The licensee shall ensure standing water is removed from the primary enclosures and that the animals are protected from being contaminated with water and other wastes during cleaning. TO BE CORRECTED BY: 8/17/14
rowid | 10676 |
desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
web_siteName | WILMA JINSON |
kind | |
Incident hash_id | 438112b6c3f14225 |
web_inspectionDate | 2014-08-14 |
code | 3.11(a) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 84.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 6514.0 |
pdf_customer_name | Wilma Jinson |
pdf_customer_addr | 1161 Beaver Road Stella, MO 64867 |
customer_state | MO |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23493508-aphis-inspection-226141642360369 |
lat | |
lng |
3.11 (d) Pest control There were roaches crawling along the walls of the indoor portion of the whelping facility.There were also roaches inside the plastic tote containing adult dog food. Pests such as roaches can contaminate food and spread disease. The licensee shall incorporate an effective pest control method to remove the roaches from the facility. TO BE CORRECTED BY: 8/29/14 This inspection was conducted with the licensee and kennel staff. An attempt was made to deliver the report on the morning of 8/15/14 however, the licensee was not available. An exit briefing was conducted with the licensee both at the close of the inspection and during the report delivery on 8/18/14.
rowid | 10677 |
desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
web_siteName | WILMA JINSON |
kind | |
Incident hash_id | 438112b6c3f14225 |
web_inspectionDate | 2014-08-14 |
code | 3.11(d) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 84.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 6514.0 |
pdf_customer_name | Wilma Jinson |
pdf_customer_addr | 1161 Beaver Road Stella, MO 64867 |
customer_state | MO |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23493508-aphis-inspection-226141642360369 |
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);