home / aphis_reports

Semantic search

citation_inspection

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

5 rows where hash_id = "e232a1c44d26352c"

✎ 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

An adult female Bulldog named Bonnie (m/c# OAO1782940) was missing a significant amount of hair from her back and sides and had scabs and reddened areas over much of her back and sides. She was scratching, chewing, and licking at the areas during the inspection. The licensee stated that the problem started about 2 weeks earlier and that she had not consulted a veterinarian about the problem. Skin problems can be painful, can lead to other medical conditions, and can be contagious to other animals. The licensee must have this dog examined and treated by a licensed veterinarian. She must maintain medical records concerning this condition and make them available to the inspector upon request. TO BE CORRECTED BY AUGUST 18th, 2014.

rowid 8413
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName KAREN CRUME
kind Direct
Incident hash_id e232a1c44d26352c
web_inspectionDate 2014-08-14
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 34.0
web_certType Class A - Breeder
pdf_customer_id 4447.0
pdf_customer_name Karen Crume
pdf_customer_addr 784 Old Miller Rd Galena, MO 65656
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23489680-aphis-inspection-226141458160795
lat 36.8254707
lng -93.4822895

d) Interior surfaces. The floor of a primary enclosure housing an adult female Bulldog and her three nursing puppies was not impervious to moisture. Part of the floor was covered by linoleum, but a large area of the linoleum had been torn away, exposing the bare wood beneath it. Floors that are not impervious to moisture can not be cleaned and sanitized properly. The licensee must ensure that flooring is impervious to moisture. TO BE CORRECTED BY AUGUST 18, 2014.

rowid 8414
desc INDOOR HOUSING FACILITIES.
web_siteName KAREN CRUME
kind  
Incident hash_id e232a1c44d26352c
web_inspectionDate 2014-08-14
code 3.2(d)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 34.0
web_certType Class A - Breeder
pdf_customer_id 4447.0
pdf_customer_name Karen Crume
pdf_customer_addr 784 Old Miller Rd Galena, MO 65656
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23489680-aphis-inspection-226141458160795
lat 36.8254707
lng -93.4822895

An adult female Bulldog and her three 4-week-old puppies were being housed in a primary enclosure within the licensee's home. The puppies had been whelped in this enclosure which had the door propped open at all times, allowing the female Bulldog to leave the enclosure at will and allowing the two house dogs the ability to enter the primary enclosure and contact the puppies. Contact with dogs other than the dam can result in injury to the puppies. The licensee must ensure that primary enclosures are constructed and maintained so that they keep other animals from entering the enclosure. TO BE CORRECTED BY AUGUST 15, 2014.

rowid 8415
desc PRIMARY ENCLOSURES.
web_siteName KAREN CRUME
kind  
Incident hash_id e232a1c44d26352c
web_inspectionDate 2014-08-14
code 3.6(a)(2)(4)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 34.0
web_certType Class A - Breeder
pdf_customer_id 4447.0
pdf_customer_name Karen Crume
pdf_customer_addr 784 Old Miller Rd Galena, MO 65656
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23489680-aphis-inspection-226141458160795
lat 36.8254707
lng -93.4822895

Two food receptacles, being used by a total of 4 dogs, had an excessive amount of dirt and grime on the outside and inside of the receptacles. Dirty food receptacles can harbor diseases that can affect the health of the dogs and can contaminate the food. The licensee must ensure that food receptacles are properly cleaned and sanitized. TO BE CORRECTED BY AUGUST 20, 2014.

rowid 8416
desc FEEDING.
web_siteName KAREN CRUME
kind  
Incident hash_id e232a1c44d26352c
web_inspectionDate 2014-08-14
code 3.9(b)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 34.0
web_certType Class A - Breeder
pdf_customer_id 4447.0
pdf_customer_name Karen Crume
pdf_customer_addr 784 Old Miller Rd Galena, MO 65656
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23489680-aphis-inspection-226141458160795
lat 36.8254707
lng -93.4822895

c) Housekeeping for premises. Excessive weeds and tall grass were growing adjacent to an outdoor enclosure housing two Beagles. A large vine was climbing up the side of the enclosure to the roofline. Excessive weeds and grass can harbor pests such rodents, snakes, and external parasites. The licensee must maintain an area around all enclosures that is free of excessive weeds, grass, and brush. TO BE CORRECTED BY AUGUST 20, 2014. The inspection and the exit briefing were conducted with the licensee. An inspector from the Missouri Department of Agriculture was also present.

rowid 8417
desc CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL.
web_siteName KAREN CRUME
kind  
Incident hash_id e232a1c44d26352c
web_inspectionDate 2014-08-14
code 3.11(c)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 34.0
web_certType Class A - Breeder
pdf_customer_id 4447.0
pdf_customer_name Karen Crume
pdf_customer_addr 784 Old Miller Rd Galena, MO 65656
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23489680-aphis-inspection-226141458160795
lat 36.8254707
lng -93.4822895

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 6016.172ms