home / aphis_reports

Semantic search

citation_inspection

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

3 rows where hash_id = "a73396ca59b061f4"

✎ 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

(b)(2) There was an adult, female Shih Tzu housed in the last adult sheltered housing area. The animal appeared thin, was lethargic and would not stand when prompted. The kennel staff removed her from her enclosure and positioned the dog in a standing position. The dog would not support her weight and sunk to a laying position. Upon palpation the dogs, ribs, vertebrae and hips were protruding and her gums were pale. The licensee stated that they had noticed the dog was underweight and had recently treated the dog for parasites. Abnormal behavior, extreme weight loss and lethargy may be the indication of a serious medical condition. The licensee shall obtain a written diagnosis and treatment plan from a licensed veterinarian. The prescribed treatment should be provided as directed and the treatment should be documented. All documents should be available at the time of the nest inspection. TO BE CORRECTED BY THE CLOSE OF BUSINESS 6/19/14

rowid 27852
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName PATRICIA M. SPERANDIO
kind  
Incident hash_id a73396ca59b061f4
web_inspectionDate 2014-06-17
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 320.0
web_certType Class A - Breeder
pdf_customer_id 326777.0
pdf_customer_name Patricia M. Sperandio
pdf_customer_addr 2247 Farm Road 1140 Verona, MO 65769
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23528147-aphis-inspection-168141818180085
lat  
lng  

(b) Ventilation. The office building also used as an isolation room housing 4 puppies had high ammonia levels. The ammonia burned the inspector(cid:25)s nose and was irritating to the eyes after lengthy exposure. Breathing air with high levels of ammonia can lead to health complications. The licensee shall provide sufficient ventilation to minimize odors and ammonia levels and to provide for the health and well being of the animals. TO BE CORRECTED BY: 6/24/14

rowid 27853
desc INDOOR HOUSING FACILITIES.
web_siteName PATRICIA M. SPERANDIO
kind  
Incident hash_id a73396ca59b061f4
web_inspectionDate 2014-06-17
code 3.2(b)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 320.0
web_certType Class A - Breeder
pdf_customer_id 326777.0
pdf_customer_name Patricia M. Sperandio
pdf_customer_addr 2247 Farm Road 1140 Verona, MO 65769
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23528147-aphis-inspection-168141818180085
lat  
lng  

(d) Pest control. An effective program for the control of insects, external parasites affecting dogs and cats, and birds and mammals that are pests, must be established and maintained so as to promote the health and well-being of the animals and reduce contamination by pests in animal areas. ***** There is an accumulation of flies in the outdoor housing area. Flies can spread bacteria and disease. The licensee shall incorporate an effective pest control program to reduce the flies in the facility. TO BE CORRECTED BY: 6/6/2013 This inspection and exit briefing was conducted with the licensee and kennel staff.

rowid 27854
desc CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL.
web_siteName PATRICIA M. SPERANDIO
kind  
Incident hash_id a73396ca59b061f4
web_inspectionDate 2014-06-17
code 3.11(d)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 320.0
web_certType Class A - Breeder
pdf_customer_id 326777.0
pdf_customer_name Patricia M. Sperandio
pdf_customer_addr 2247 Farm Road 1140 Verona, MO 65769
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23528147-aphis-inspection-168141818180085
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 3362.859ms