Semantic search
citation_inspection
1 row where hash_id = "f00b65b70eee7fce"
This data as json, CSV (advanced)
***The licensee failed to notify the AC Regional Office of a new site that houses regulated species. The licensee must notify the Eastern Region Office of any change in business or additional site to facilitate enforcement of the Animal Welfare Act. Written notification of the new site housing animals must be sent to the Eastern Regional Office by certified mail. Correct immediately. This inspection was conducted at the new site. An exit briefing was conducted with the licensee.
| rowid | 29431 |
| desc | NOTIFICATION OF CHANGE OF NAME, ADDRESS, CONTROL, OR OWNERSHIP OF BUSINESS. |
| web_siteName | CHELONIA ECO ASSOCIATES LLC |
| kind | |
| Incident hash_id | f00b65b70eee7fce |
| web_inspectionDate | 2014-07-01 |
| code | 2.8(h) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 2.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 328635.0 |
| pdf_customer_name | Eco Adventure |
| pdf_customer_addr | 216 Najoles Road Suite 600 Millersville, MD 21108 |
| customer_state | MD |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23530889-aphis-inspection-183140826010891 |
| 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);