Semantic search
citation_inspection
4 rows where hash_id = "db867b167a8093c6"
This data as json, CSV (advanced)
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
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);