Semantic search
citation_inspection
1 row where hash_id = "a7017e38449e2998"
This data as json, CSV (advanced)
Although the licensee has written out the veterinary care she provides her opossum, she has not had it reviewed and approved by an Attending Veterinarian. The written Program of Veterinary Care needs to be completed and approved by the attending veterinarian. This is a pre-use new site inspection for this organization. The above item needs to be corrected and submitted for review by USDA before any licensed activity occurs. Exit briefing conducted with licensee representative.
| rowid | 20670 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | MADISON SIMONS |
| kind | |
| Incident hash_id | a7017e38449e2998 |
| web_inspectionDate | 2016-10-12 |
| code | 2.40(a)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 1.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 36612.0 |
| pdf_customer_name | Wildlife Rehab Of Greenville |
| pdf_customer_addr | 79 Old Mcelhaney Road Greenville, SC 29617 |
| customer_state | SC |
| pdf_site_id | 010 |
| doccloud_url | https://www.documentcloud.org/documents/23514348-aphis-inspection-2016082567957695 |
| 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);