Semantic search
citation_inspection
3 rows where hash_id = "5ca724665beb3e7b"
This data as json, CSV (advanced)
A geriatric lion was found to have a chronic, ulcerated sore on the scrotum. This lion should be evaluated by a veterinarian to assess his health and appropriate treatment. Both lions on site should be checked on a regular basis in order to identify any health problems in a timely manner. To be corrected by 2/15/15
| rowid | 7101 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | PREDATORS IN ACTION, INC. |
| kind | |
| Incident hash_id | 5ca724665beb3e7b |
| web_inspectionDate | 2015-01-21 |
| code | 2.40(x) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 10.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3639.0 |
| pdf_customer_name | Randy Millers Predators In Action Inc. |
| pdf_customer_addr | 4470 W Sunset Blvd #92309 Los Angeles, CA 90027 |
| customer_state | CA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23487519-aphis-inspection-26151625000549 |
| lat | 34.0977718 |
| lng | -118.2871681 |
There are two horizontal support beams across the middle portion of a geriatric lion's enclosure. An area of this support beam has separated resulting in a gap. It is large enough to allow an unauthorized animal to enter the enclosure and/or may lead to continued separation of the beams if not repaired. The gap should be reduced to minimize the risk of injury to the animal. The facility must be constructed of such material and of such strength as appropriate for the animals involved. The indoor and outdoor housing facilities shall be structurally sound and shall be maintained in good repair to protect the animals from injury and to contain the animals. To be corrected by 2/15/15
| rowid | 7102 |
| desc | FACILITIES, GENERAL. |
| web_siteName | PREDATORS IN ACTION, INC. |
| kind | |
| Incident hash_id | 5ca724665beb3e7b |
| web_inspectionDate | 2015-01-21 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 10.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3639.0 |
| pdf_customer_name | Randy Millers Predators In Action Inc. |
| pdf_customer_addr | 4470 W Sunset Blvd #92309 Los Angeles, CA 90027 |
| customer_state | CA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23487519-aphis-inspection-26151625000549 |
| lat | 34.0977718 |
| lng | -118.2871681 |
At least 3 areas of the perimeter fence along the back wall of the animal compound is damaged. The chain link fence has become separated from the top support beam resulting in large holes.These areas should be repaired. The fence must be constructed so that it protects the animals in the facility by restricting animals and unauthorized persons from going through it and having contact with the animals in the facility, and so that it can function as a secondary containment system for the animals in the facility. To be corrected by 2/15/15 An exit briefing was conducted with the Owner. Additional Inspectors Fields Tyler, Veterinary Medical Officer
| rowid | 7103 |
| desc | FACILITIES, OUTDOOR. |
| web_siteName | PREDATORS IN ACTION, INC. |
| kind | |
| Incident hash_id | 5ca724665beb3e7b |
| web_inspectionDate | 2015-01-21 |
| code | 3.127(d) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 10.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 3639.0 |
| pdf_customer_name | Randy Millers Predators In Action Inc. |
| pdf_customer_addr | 4470 W Sunset Blvd #92309 Los Angeles, CA 90027 |
| customer_state | CA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23487519-aphis-inspection-26151625000549 |
| lat | 34.0977718 |
| lng | -118.2871681 |
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);