home / aphis_reports

Semantic search

citation_inspection

Table actions
  • Semantic search against this table
  • Semantic search against this table

5 rows where hash_id = "438112b6c3f14225"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: desc

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

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

CSV options:

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);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 3266.248ms