Semantic search

citation_inspection

Table actions

2 rows where hash_id = "af4f72eb6c4ba985"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: web_inspectionDate (date)

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

Identification. ***There were 8 puppies which were less than 16 weeks of age at the facility that did not have individual identification. There were no cage cards on the enclosures to identify the puppies. Identification is required in order to ensure that each animal's identity can be known with certainty and to facilitate record keeping requirements. The licensee must ensure that all dogs less than 16 weeks of age are identified by an official tag as described in Sec. 2.51, a legible tattoo approved by the Administrator, a microchip, or a cage card (if maintained as a litter with their dam and housed within the same primary enclosure). To be corrected by: June 8, 2014.

rowid 13368
desc TIME AND METHOD OF IDENTIFICATION.
web_siteName David Troyer Esther Troyer
kind  
Incident hash_id af4f72eb6c4ba985
web_inspectionDate 2014-06-04
code 2.50(a)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 84.0
web_certType Class A - Breeder
pdf_customer_id 9818.0
pdf_customer_name David A Troyer
pdf_customer_addr Esther E Troyer 2395 Audrain Rd 154 Clark, MO 65243
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23498366-aphis-inspection-125141556017205
lat  
lng  

(c) Surfaces- (3) Cleaning. ***The sheltered building, along most of the underside of the east and west run of enclosures on the outside, effecting approximately 62 dogs there is a buildup of hair, feces, and grime. Ten dog entry doors had a buildup of a brownish grime covering about 30% - 50% of the doorway. The accumulation of the dirt and grime can cause diseases and attract pests. Cleanliness is important to the health and well-being of the animals. The licensee must ensure animal enclosures, areas inside of housing facility and adjacent areas must be kept clean to ensure the health and well-being of the animals. The licensee must spot clean daily as required. Inspection and exit interview conducted with licensee. Additional Inspectors Heine William, Animal Care Inspector

rowid 13369
desc HOUSING FACILITIES, GENERAL.
web_siteName David Troyer Esther Troyer
kind  
Incident hash_id af4f72eb6c4ba985
web_inspectionDate 2014-06-04
code 3.1(c)(3)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 84.0
web_certType Class A - Breeder
pdf_customer_id 9818.0
pdf_customer_name David A Troyer
pdf_customer_addr Esther E Troyer 2395 Audrain Rd 154 Clark, MO 65243
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23498366-aphis-inspection-125141556017205
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);