Semantic search
citation_inspection
1 row where hash_id = "70f64b07d8c2936e"
This data as json, CSV (advanced)
(b) Access and inspection of records and property. The responsible individual was not available on June 17, 2014 at 9:00 AM to show written Program of Veterinary Care and ICUC records necessary to evaluate compliance with the Animal Welfare Act. This report is sent by email and by regular postal mail. Exit interview was conducted by phone on June 18, 2014 with Technician.
| rowid | 31942 |
| desc | MISCELLANEOUS. |
| web_siteName | Novus Biologicals |
| kind | |
| Incident hash_id | 70f64b07d8c2936e |
| web_inspectionDate | 2014-06-17 |
| 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 | 331569.0 |
| pdf_customer_name | Novus Biologicals |
| pdf_customer_addr | 10730 E Briarwood Ave Centennial, CO 80112 |
| customer_state | CO |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23537006-aphis-inspection-170141439480021 |
| 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);