Semantic search
citation_inspection
1 row where hash_id = "a5448f2bc379a7cf"
This data as json, CSV (advanced)
A responsible adult was not available to accompany APHIS Officials during the inspection process at 2pm on July 7th 2021. Licensee was contacted and she was running errands and wouldn't be home. End Section
| rowid | 19484 |
| desc | Access and inspection of records and property; submission of itineraries. |
| web_siteName | ELIZABETH ANN ROHRS |
| kind | |
| Incident hash_id | a5448f2bc379a7cf |
| web_inspectionDate | 2021-07-07 |
| code | 2.126(b) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 32403.0 |
| pdf_customer_name | ELIZABETH ROHRS |
| pdf_customer_addr | 1738 Washington P O Box 294 LAMONT, OK 74643 |
| customer_state | OK |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23511567-aphis-inspection-2016090000652540 |
| 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);