Semantic search
citation_inspection
1 row where hash_id = "0003750fe37eecba"
This data as json, CSV (advanced)
A responsible adult was not available to accompany APHIS Officials during the inspection process at 10:00 AM on 5/23/23. The inspector arrived at 10:00 AM on 5/23/23 to conduct an inspection. The inspector tried to contact the Licensee by phone (no answer) and then rang the doorbell at the front door. The person who was on the premises told the inspector that the Licensee was at a distant off-site location and would not be available for several hours. An AWA compliance inspection could not be conducted because there was no other authorized facility representative available to accompany the inspector. Unannounced inspections are used to evaluate compliance with the AWA Regulations and Standards. This is the FIRST attempted inspection of the Licensee. End Section
| rowid | 31381 |
| desc | Access and inspection of records and property; submission of itineraries. |
| web_siteName | Kathryn Langham |
| kind | |
| Incident hash_id | 0003750fe37eecba |
| web_inspectionDate | 2023-05-23 |
| code | 2.126(b) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 331137.0 |
| pdf_customer_name | KATHRYN LANGHAM |
| pdf_customer_addr | 95 MOODY AVE FAIRFIELD, CT 06825 |
| customer_state | CT |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23856792-aphis-inspection-ins-0000870892 |
| 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);