Semantic search
citation_inspection
1 row where hash_id = "6901e62167a7a540"
This data as json, CSV (advanced)
A responsible adult was not available to accompany APHIS Officials during the inspection process at 1330 on 28Aug2023. Email attempts to contact local and regional personnel were not answered within allotted 30 minute wait period. Inspector departed airport at 1415. End Section
| rowid | 37 |
| desc | Access and inspection of records and property; submission of itineraries. |
| web_siteName | General Aviation Terminal |
| kind | |
| Incident hash_id | 6901e62167a7a540 |
| web_inspectionDate | 2023-08-29 |
| code | 2.126(b) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class H - Intermediate Handler |
| pdf_customer_id | 31.0 |
| pdf_customer_name | GENERAL AVIATION TERMINAL INC |
| pdf_customer_addr | 8400 AIRPORT BLVD WEST RAMP RD MOBILE, AL 36608 |
| customer_state | AL |
| pdf_site_id | RDU |
| doccloud_url | https://www.documentcloud.org/documents/24004432-aphis-inspection-ins-0000886975 |
| lat | 30.6800208 |
| lng | -88.24911399999999 |
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);