Semantic search
citation_inspection
1 row where hash_id = "96d5379ab8832e43"
This data as json, CSV (advanced)
No contact with registrant or business was achieved either in person at listed address or by phone or email. Discovered owner is deceased and apparently business has ceased to operate. No notification of change in status or cancellation request has been received. Registrants are required to notify Animal Care of changes in operation or to request cancellation of registration. To be corrected by 11/1/2023. n
| rowid | 39415 |
| desc | Registration. |
| web_siteName | United Bio-Research Inc. |
| kind | |
| Incident hash_id | 96d5379ab8832e43 |
| web_inspectionDate | 2023-09-14 |
| code | 2.30(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 6010389.0 |
| pdf_customer_name | United Bio-Research Inc. |
| pdf_customer_addr | 670 E 3900 S Suite I-202 Salt Lake City, UT 84107 |
| customer_state | UT |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/24037479-aphis-inspection-ins-0000892249 |
| 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);