Semantic search

citation_inspection

Table actions

1 row where hash_id = "672859a24e185352"

✎ 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

This was a search inspection. The owner of the facility was contacted and stated that there are more than four breeding female dogs on the premises. Records provided to USDA APHIS Animal Care (AC) indicate that a dog was sold by the owner, from this address, to a pet store on February 17, 2014. This constitutes a wholesale transaction and is a regulated activity. Any person operating or intending to operate as a dealer, who are not exempted from the licensing requirements, must have a valid license. The owner shall file a completed application form with the AC Regional Director if she would like to conduct any further regulated activity. The regulations and licensing requirements were discussed and an application packet was provided to the owner. ***NO REGULATED ACTIVITY MAY BE CONDUCTED UNTIL A USDA LICENSE IS OBTAINTED***

rowid 32414
desc REQUIREMENTS AND APPLICATION.
web_siteName MARTHA YODER
kind  
Incident hash_id 672859a24e185352
web_inspectionDate 2014-09-09
code 2.1(a)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 0.0
web_certType  
pdf_customer_id 332153.0
pdf_customer_name Martha Yoder
pdf_customer_addr 2833 Tr 151 Millersburg, OH 44654
customer_state OH
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23538337-aphis-inspection-253140801020716
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);