Semantic search
citation_inspection
1 row where hash_id = "d9e283b077db2409"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
A responsible adult was not available to accompany APHIS Officials during the inspection process at 1230-1300 on 12-Oct-16. The ACI made contact with a relative of the licensee at the licensee's residence who informed the ACI that the licensee was no longer conducting regulated activities. The licensee was unavailable and the ACI left information for the licensee on how to cancel their license if in fact they are no longer conducting regulated activities.
| rowid | 13338 |
| desc | ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. |
| web_siteName | FRANK IMHOFF & LAURA IMHOFF |
| kind | |
| Incident hash_id | d9e283b077db2409 |
| web_inspectionDate | 2016-10-12 |
| code | 2.126(b) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 9681.0 |
| pdf_customer_name | Frank Imhoff |
| pdf_customer_addr | Laura Imhoff 10663 C R 311 Plantersville, TX 77363 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23498325-aphis-inspection-2016082567967556 |
| lat | |
| lng |
Advanced export
JSON shape: default, array, newline-delimited, object
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);