Semantic search
citation_inspection
1 row where hash_id = "8fc2c6f7e9946c0f"
This data as json, CSV (advanced)
A responsible adult was not available to accompany APHIS Officials during the inspection process at 11:00-11:30am on 11-AUG-21. Upon arriving at the facility, the inspector called all available numbers and left voicemails. The inspector also knocked on the door of the facility multiple times with no answer. After no response from the registrant for 30 minutes, the inspector left. End Section
| rowid | 27 |
| desc | Miscellaneous. |
| web_siteName | EASTERN WYOMING COLLEGE |
| kind | |
| Incident hash_id | 8fc2c6f7e9946c0f |
| web_inspectionDate | 2021-08-11 |
| code | 2.38(b) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 17.0 |
| pdf_customer_name | EASTERN WYOMING COLLEGE |
| pdf_customer_addr | 3200 WEST C STREET TORRINGTON, WY 82240 |
| customer_state | WY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23470216-aphis-inspection-2016090000683976 |
| lat | 42.0801168 |
| lng | -104.1891608 |
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);