home / aphis_reports

Semantic search

citation_inspection

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

4 rows where hash_id = "db867b167a8093c6"

✎ 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 an expired bottle of Panacur liquid (expiration date of 12-2013). There is a bottle of Spectogard oral solution and a bottle of metronidazole for fish (Fish Zole) with no directions for use in dogs from the attending veterinarian. There is a bag of cephalexin capsules with no directions for use in dogs from the attending veterinarian or expiration date. The licensee mixes together and uses a combination of Flagyl, Albon, propolene glycol, and spectinomycin. There are no directions or approval from the attending veterinarian for the preparation and use of this medication combination for dogs. All of these medication are being stored in the medication cabnet of the whelping building. Lack of proper labeling of medications (including lack of directions for use) can result in medications being used incorrectly, prolonged medical problems, undesired side effects, and the use of expired medication. The licensee must ensure that all medications used in the facility are not expired and are labeled properly in accordance with standard veterinary practices.

rowid 12087
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName Roxanne Castens
kind  
Incident hash_id db867b167a8093c6
web_inspectionDate 2014-07-01
code 2.40(b)(2)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 146.0
web_certType Class A - Breeder
pdf_customer_id 7919.0
pdf_customer_name Roxanne Castens
pdf_customer_addr 12953 Rd 26 Ludell, KS 67744
customer_state KS
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23495856-aphis-inspection-182141309520036
lat  
lng  

The licensee's Record of Acquisition and Dogs on Hand form (APHIS form 7005) is not complete. Some of the entries are missing the dogs official identification number, the complete address of the person from where the dog was obtained, and/or the USDA license number or a driver's license number and vehicle license number of the person from whom a dog was purchased. Complete and accurate records assist in the inspection process and allows dogs to be properly tracked. All records must be completely filled out.

rowid 12088
desc RECORDS: DEALERS AND EXHIBITORS.
web_siteName Roxanne Castens
kind  
Incident hash_id db867b167a8093c6
web_inspectionDate 2014-07-01
code 2.75(a)(1)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 146.0
web_certType Class A - Breeder
pdf_customer_id 7919.0
pdf_customer_name Roxanne Castens
pdf_customer_addr 12953 Rd 26 Ludell, KS 67744
customer_state KS
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23495856-aphis-inspection-182141309520036
lat  
lng  

The lower metal frame of the gates for at least 4 large dog enclosures are rusted to the point that they have jagged edges and/or are not supporting the fence material. Rusted surfaces prevent adequate cleaning and sanitization which can play a role in disease transmission and cannot maintain structural strength. All surfaces must be maintained so that they are free of excessive rust that prevents the required cleaning and sanitization or affects the structural strength.

rowid 12089
desc HOUSING FACILITIES, GENERAL.
web_siteName Roxanne Castens
kind  
Incident hash_id db867b167a8093c6
web_inspectionDate 2014-07-01
code 3.1(c)(1)(1)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 146.0
web_certType Class A - Breeder
pdf_customer_id 7919.0
pdf_customer_name Roxanne Castens
pdf_customer_addr 12953 Rd 26 Ludell, KS 67744
customer_state KS
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23495856-aphis-inspection-182141309520036
lat  
lng  

Owner could not locate the approved exercise plan during the inspection. The program of exercise must be developed in accordance with the attending veterinarian recommendations to ensure the dogs are receiving adequate exercise.The owner must obtain a written exercise plan and have it approved by the attending veterinarian. Correct by 15 July 2014. This routine inspection and exit interview were conducted with the licensee. Additional Inspectors Shaver Margaret, Veterinary Medical Officer

rowid 12090
desc EXERCISE FOR DOGS.
web_siteName Roxanne Castens
kind  
Incident hash_id db867b167a8093c6
web_inspectionDate 2014-07-01
code 3.8
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 146.0
web_certType Class A - Breeder
pdf_customer_id 7919.0
pdf_customer_name Roxanne Castens
pdf_customer_addr 12953 Rd 26 Ludell, KS 67744
customer_state KS
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23495856-aphis-inspection-182141309520036
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 4744.471ms