Semantic search
citation_inspection
1 row where hash_id = "24f15a315729518b"
This data as json, CSV (advanced)
Black Leopard: this geriatric animal has age related health issues, including ataxia and skin problems. Records available at time of inspection indicated the animal was seen by the attending veterinarian in January and April 2014. However, there is no documented evaluation of the animal by the attending veterinarian for the April 2014 visit. Documentation available during inspection is necessary to ensure this geriatric animal is receiving appropriate care for chronic conditions. Correct by 08/06/14 Exit interview was conducted with facility representative. Additional Inspectors Lorang Jeanne, Animal Care Inspector
| rowid | 6720 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | COUGAR HILL RANCH, INC. |
| kind | |
| Incident hash_id | 24f15a315729518b |
| web_inspectionDate | 2014-07-22 |
| code | 2.40(x) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 18.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3517.0 |
| pdf_customer_name | Cougar Hill Ranch Inc. |
| pdf_customer_addr | P.O. Box 132 Littlerock, CA 93543 |
| customer_state | CA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23486670-aphis-inspection-204141317470739 |
| lat | 34.521104 |
| lng | -117.9836793 |
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);