Semantic search
citation_inspection
2 rows where hash_id = "3e3b2e18d4268616"
This data as json, CSV (advanced)
The registrant is no longer located at the address on file and has not provided notification of change of address. During the attempted inspection, it was noted that the facility appeared vacant. The neighbor was contacted and confirmed that the registrant no longer lived at that address but did not have a forwarding address. Multiple previous attempts to contact the licensee by phone and text have gone unanswered. It is important that address and other contact information is kept up to date to facilitate timely contact and inspections by USDA. Correct by 9/15/23
| rowid | 38662 |
| desc | Notification of change of operation. |
| web_siteName | Kristal Chamberlain |
| kind | |
| Incident hash_id | 3e3b2e18d4268616 |
| web_inspectionDate | 2023-09-14 |
| code | 2.27(a) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class T - Carrier |
| pdf_customer_id | 600179.0 |
| pdf_customer_name | Kristal Chamberlain |
| pdf_customer_addr | 1002 Convair St. Bentonville, AR 72712 |
| customer_state | AR |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/24028867-aphis-inspection-ins-0000892129 |
| lat | |
| lng |
A responsible adult was not available to accompany APHIS Officials during the inspection process at 12:30 on 9/14/23. Additional Inspectors: Jennifer Walker, VETERINARY MEDICAL OFFICEREnd Section
| rowid | 38663 |
| desc | Access and inspection of records and property; submission of itineraries. |
| web_siteName | Kristal Chamberlain |
| kind | |
| Incident hash_id | 3e3b2e18d4268616 |
| web_inspectionDate | 2023-09-14 |
| code | 2.126(b) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class T - Carrier |
| pdf_customer_id | 600179.0 |
| pdf_customer_name | Kristal Chamberlain |
| pdf_customer_addr | 1002 Convair St. Bentonville, AR 72712 |
| customer_state | AR |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/24028867-aphis-inspection-ins-0000892129 |
| 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);