home / aphis_reports

Semantic search

citation_inspection

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

4 rows where hash_id = "500f3a48ddd4f801"

✎ View and edit SQL

This data as json, CSV (advanced)

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

There is a container of an unlabeled bottle containing a white liquid in the refrigerator of the whelping building. The licensee states that this was a mixture of amoxicillin. There is an expired bottle of oxytocin (14 Jun) and an expired can of Blu-Kote (05-11) stored with the medications currently in use in the treatment area of the whelping building. Unlabeled medications can be used incorrectly and be mistaken for other medications. The usage of expired medical materials such as drugs, fluids, or sutures on regulated animals is not considered to be an acceptable veterinary practice and does not constitute adequate veterinary care. The effectiveness of the dosage level and expected results when expired drugs are administrated to animals could be drastically changed or may not work as anticipated. The applicant must ensure that all medications used are not expired and are labeled properly in accordance with standard veterinary practices. The attending veterinarian has a written protocol for this licensee to use for nebulization of the puppies. The protocol calls for the use of sterile water to be mixed with antibiotics. The licensee is using tap water in place of the sterile water. Failure to follow directions for treatments from a veterinarian can lead to unintended side effects such as infections. The licensee must follow all treatment protocols from the attending veterinarian as they are written.

rowid 15543
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName Pat Crabtree
kind  
Incident hash_id 500f3a48ddd4f801
web_inspectionDate 2015-01-06
code 2.40(b)(2)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 337.0
web_certType Class A - Breeder
pdf_customer_id 16834.0
pdf_customer_name Pat Crabtree
pdf_customer_addr 1525 Rd O Saint Francis, KS 67756
customer_state KS
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/23502574-aphis-inspection-6151728490207
lat  
lng  

There are 15 litters of puppies that range in age from a few days to a few weeks old that do not have their official identification number assigned to them. Proper record-keeping is essential for tracking the movement of puppies and to facilitate the inspection process. The licensee must ensure that identification numbers are assigned to all puppies. Correct by 13 January 2015.

rowid 15544
desc RECORDS: DEALERS AND EXHIBITORS.
web_siteName Pat Crabtree
kind  
Incident hash_id 500f3a48ddd4f801
web_inspectionDate 2015-01-06
code 2.75(a)(1)(6)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 337.0
web_certType Class A - Breeder
pdf_customer_id 16834.0
pdf_customer_name Pat Crabtree
pdf_customer_addr 1525 Rd O Saint Francis, KS 67756
customer_state KS
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/23502574-aphis-inspection-6151728490207
lat  
lng  

Portions of a plastic panel on the northwest corner of the east kennel building has been chewed exposing raw chewed wood beneath it. The bottom portion of a plastic divider panel between two enclosures in the "Sundowner" kennel building has come loose out of its support. This has resulted in a gap between these enclosures. Dogs may get caught in this gap and cause injury. All surfaces must be maintained and kept in good repair to securely contain the dogs and protect them from injury. Correct by 20 Jan. 2015.

rowid 15545
desc HOUSING FACILITIES, GENERAL.
web_siteName Pat Crabtree
kind  
Incident hash_id 500f3a48ddd4f801
web_inspectionDate 2015-01-06
code 3.1(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 337.0
web_certType Class A - Breeder
pdf_customer_id 16834.0
pdf_customer_name Pat Crabtree
pdf_customer_addr 1525 Rd O Saint Francis, KS 67756
customer_state KS
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/23502574-aphis-inspection-6151728490207
lat  
lng  

There is an excessive accumulation of feces in the outdoor portions of two elevated enclosures and in the outdoor portions of three enclosures on the ground. According to the kennel facility representative the feces have not been removed from some of these enclosures for at least three days. Excessive accumulation of feces can contaminate the dogs and lead to an increase in disease transmission. Feces must be removed from the primary enclosures on a daily basis. Correct by 7 Jan. 2015. This routine inspection and exit interview were conducted with a facility representative. Additional Inspectors Shaver Margaret, Veterinary Medical Officer

rowid 15546
desc CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL.
web_siteName Pat Crabtree
kind  
Incident hash_id 500f3a48ddd4f801
web_inspectionDate 2015-01-06
code 3.11(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 337.0
web_certType Class A - Breeder
pdf_customer_id 16834.0
pdf_customer_name Pat Crabtree
pdf_customer_addr 1525 Rd O Saint Francis, KS 67756
customer_state KS
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/23502574-aphis-inspection-6151728490207
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 3332.334ms