Semantic search
citation_inspection
1 row where hash_id = "17876d542af4f559"
This data as json, CSV (advanced)
A responsible adult was not available to accompany APHIS Officials during the inspection process at 2:30 p.m. on 01/05/2016. The inspector spoke with a resident who stated the licensee was not home. The inspector called the phone number provided and contacted the licensee. The licensee stated he was not available for an inspection at that time.
| rowid | 9615 |
| desc | ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. |
| web_siteName | JOHN ERIC DANKER |
| kind | |
| Incident hash_id | 17876d542af4f559 |
| web_inspectionDate | 2016-01-05 |
| code | 2.126(b) |
| repeat | 1 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 5407.0 |
| pdf_customer_name | John Eric Danker |
| pdf_customer_addr | 30224 227th Street Bonaparte, IA 52620 |
| customer_state | IA |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23491568-aphis-inspection-5161553500281 |
| 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);