home / aphis_reports

Semantic search

citation_inspection

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

3 rows where hash_id = "a6f59ec4a7651e8a"

✎ 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

Sec. 3.1 Housing facilities, general. (c) Surfaces--(3) Cleaning. * Several dog doors have an accumulation of brown to black grime or waste on the metal surfaces. These dog doors were located in the Main kennel building in several enclosures housing 10 adult dogs. The top row of enclosures has two enclosures, holding no dogs, with an accumulation of fecal waste on the vinyl wire flooring. These enclosures where located next to enclosures housing dogs. * The outside concrete flooring for the Little Kennel, housing 13 adult dogs, has brown to black grime smeared onto the surface. The lower metal pipe framing for the chain link dividers in these enclosures has an accumulation of brown to black waste smeared onto the surface. The inside enclosures for the Little Kennel building have an accumulation of brown to black waste in the corners of the enclosure boxes and smeared on the surface to the dog door inserts. The mentioned surfaces indicate that daily spot-cleaning is not taking place. Improper cleaning and sanitization can cause an accumulation of waste, attract pests, cause odors and increase disease hazards for the dogs. All surfaces must be spot-cleaned daily and must be sanitized according to Section 3.11(b) (3). Proper cleaning and sanitization will reduce the disease hazards for the dogs. To be corrected by, 27-January-2015.

rowid 16027
desc HOUSING FACILITIES, GENERAL.
web_siteName PETE & SUSIE SWIHART
kind  
Incident hash_id a6f59ec4a7651e8a
web_inspectionDate 2015-01-21
code 3.1(c)(3)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 31.0
web_certType Class A - Breeder
pdf_customer_id 18843.0
pdf_customer_name Pete Swihart
pdf_customer_addr Susie Swihart 55553 221st Street Glenwood, IA 51534
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23503634-aphis-inspection-26152305050901
lat  
lng  

Sec. 3.1 Housing facilities, general. (f) Drainage and waste disposal. * The upper and lower wash-downs for the enclosures of the Main Kennel have an accumulation of fecal waste and fluid waste that has ponded in the wash-down. The wash-downs are concaved in areas that do not let the fluid waste rapidly drain into the drainage system. This accumulation of fecal and fluid waste can cause pest infestations, insects, odors and increase the disease hazards for the 12 adult dogs and six puppies. Facility operators must provide regular and frequent collection of the waste in the wash-downs. The wash-downs must be constructed and allow for rapid elimination of fecal and fluid waste. More regular and rapid elimination of waste will minimize odors, pests, insects and diseases for the dogs. To be corrected by, 30-March-2015.

rowid 16028
desc HOUSING FACILITIES, GENERAL.
web_siteName PETE & SUSIE SWIHART
kind  
Incident hash_id a6f59ec4a7651e8a
web_inspectionDate 2015-01-21
code 3.1(f)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 31.0
web_certType Class A - Breeder
pdf_customer_id 18843.0
pdf_customer_name Pete Swihart
pdf_customer_addr Susie Swihart 55553 221st Street Glenwood, IA 51534
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23503634-aphis-inspection-26152305050901
lat  
lng  

Sec. 3.11 (a) Cleaning of primary enclosures. * The wash-downs for the bottom and top row of enclosures, housing 12 adult dogs and six puppies, have an accumulation of fecal waste and fluid waste. These wash-downs are located on the Main Kennel. The fecal and fluid waste can increase insect infestations, pests, odors and increase disease hazards for the dogs. The fecal and fluid waste must be removed from the wash-downs more often. More frequent removal of the waste will prevent an accumulation of waste and fluid waste. This will reduce pests, insects, odors and reduce the disease hazards for the dogs. This inspection and exit interview was conducted with an facility representative. This inspection report will be sent by e-mail.

rowid 16029
desc CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL.
web_siteName PETE & SUSIE SWIHART
kind  
Incident hash_id a6f59ec4a7651e8a
web_inspectionDate 2015-01-21
code 3.11(a)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 31.0
web_certType Class A - Breeder
pdf_customer_id 18843.0
pdf_customer_name Pete Swihart
pdf_customer_addr Susie Swihart 55553 221st Street Glenwood, IA 51534
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23503634-aphis-inspection-26152305050901
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 3852.613ms