Semantic search

citation_inspection

Table actions

2 rows where hash_id = "6698f0d68b52169e"

✎ 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

The kennel facility consists of a outdoor housing area and a sheltered building. In the outdoor portion of the kennel there are six adults that do not have any form of identification. All class ``A'' dealer (breeder) shall identify all live dogs on the premises at all times to insure accountability of all animals. The dealer must use an approved form of identification on all animals at all times. Affects six adults. Correct by September 14, 2014.

rowid 26773
desc TIME AND METHOD OF IDENTIFICATION.
web_siteName LEON HOSTETLER
kind  
Incident hash_id 6698f0d68b52169e
web_inspectionDate 2014-09-09
code 2.50(y)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 44.0
web_certType Class A - Breeder
pdf_customer_id 325393.0
pdf_customer_name Leon Hostetler
pdf_customer_addr 1315 Hilltop Road Hartman, AR 72840
customer_state AR
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23526238-aphis-inspection-252141642440416
lat  
lng  

The kennel consists of a outdoor housing area and a sheltered building. In the outdoor housing area there is one enclosure which contains five adults. In this enclosure there is only one shelter structure for the contained animals. The shelter does not provide room for all five animals to enter at the same time and make normal movements. Outdoor facilities for dogs must include one or more shelter structures that are accessible to each animal in each outdoor facility, and that are large enough to allow each animal in the shelter structure to sit, stand, and lie in a normal manner, and to turn about freely. An additional shelter structure must be provide for the animals to protect them from the elements, allow them to stay clean and dry and protect their health and welfare. Affects five adults Correct by September 9, 2014 The inspection and exit briefing was conducted with the facility representative. Additional Inspectors Cooper Natalie, Veterinary Medical Officer

rowid 26774
desc OUTDOOR HOUSING FACILITIES.
web_siteName LEON HOSTETLER
kind  
Incident hash_id 6698f0d68b52169e
web_inspectionDate 2014-09-09
code 3.4(b)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 44.0
web_certType Class A - Breeder
pdf_customer_id 325393.0
pdf_customer_name Leon Hostetler
pdf_customer_addr 1315 Hilltop Road Hartman, AR 72840
customer_state AR
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23526238-aphis-inspection-252141642440416
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);