home / aphis_reports

Semantic search

citation_inspection

Table actions
  • Semantic search against this table
  • Semantic search against this table

5 rows where hash_id = "6dc6a40ca1299dcb"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

Expired drugs (pain medication expired 10/13) were intermingled with current drugs in the medication refrigerator. Expired drugs must be separated from current medications and clearly labeled to prevent the accidental use on covered species. Correction date 31 July 2015

rowid 28102
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName HOLLYWOOD ANIMALS, INC.
kind  
Incident hash_id 6dc6a40ca1299dcb
web_inspectionDate 2015-06-30
code 2.40(b)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 32.0
web_certType Class C - Exhibitor
pdf_customer_id 327093.0
pdf_customer_name Hollywood Animals Inc.
pdf_customer_addr P.O. Box 2088 Santa Clarita, CA 91386
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23528582-aphis-inspection-182151057400769
lat  
lng  

-One of the cat enclosures did not have any ID tags attached to the outside of the enclosure indicating which 4 cats were in that enclosure. The additional tags and documenting photo, description & ID Tag number for each of the animals was not available for review during inspection. -The dogs did not have any ID tags attached to the outside of the enclosure indicating which dogs were in that enclosure. The additional tags and documenting photo, description & ID Tag number for each of the animals was not available for review during inspection. The system to identify the animals must be maintained. Correction date 31 July 2015

rowid 28103
desc TIME AND METHOD OF IDENTIFICATION.
web_siteName HOLLYWOOD ANIMALS, INC.
kind  
Incident hash_id 6dc6a40ca1299dcb
web_inspectionDate 2015-06-30
code 2.50(c)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 32.0
web_certType Class C - Exhibitor
pdf_customer_id 327093.0
pdf_customer_name Hollywood Animals Inc.
pdf_customer_addr P.O. Box 2088 Santa Clarita, CA 91386
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23528582-aphis-inspection-182151057400769
lat  
lng  

In the Capuchin enclosure, the wire shelf inside the shelter area was missing a supporting bracket and was bowing under the weight of the Capuchins when they landed on it. The wire shelf is no longer structurally sound or in good repair and could potentially break, creating sharp edges that could result in injuries to animals. There must be a system of maintenance in place. Correction date 14 July 2015

rowid 28104
desc PRIMARY ENCLOSURES.
web_siteName HOLLYWOOD ANIMALS, INC.
kind  
Incident hash_id 6dc6a40ca1299dcb
web_inspectionDate 2015-06-30
code 3.80(a)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 32.0
web_certType Class C - Exhibitor
pdf_customer_id 327093.0
pdf_customer_name Hollywood Animals Inc.
pdf_customer_addr P.O. Box 2088 Santa Clarita, CA 91386
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23528582-aphis-inspection-182151057400769
lat  
lng  

In Tiger Town, (Anika & Denali's enclosure) the plywood top of the catch cage was worn and bowing under the weight of the cats in the corner. If the plywood broke, the limb of the cat could be caught in a hole and potentially cause injury. The housing facilities shall be structurally sound and kept in good repair to protect the animal from injury. Correction date 31 July 2015

rowid 28105
desc FACILITIES, GENERAL.
web_siteName HOLLYWOOD ANIMALS, INC.
kind  
Incident hash_id 6dc6a40ca1299dcb
web_inspectionDate 2015-06-30
code 3.125(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 32.0
web_certType Class C - Exhibitor
pdf_customer_id 327093.0
pdf_customer_name Hollywood Animals Inc.
pdf_customer_addr P.O. Box 2088 Santa Clarita, CA 91386
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23528582-aphis-inspection-182151057400769
lat  
lng  

Perimeter fence/Secondary Containment At the gate entering the Lion compound, there was 4-6" of space under the main gate where the road has eroded away, creating a space big enough for a small cat or raccoon to enter. The fence must protect the animals in the facility by restricting animals or unauthorized persons from going through or under it. -In the Lion compound, some of the shade trees adjacent to the perimeter fence have grown to a height and width that could support the weight of a cat and therefore reduces the effective height of the perimeter fence to less than 8 ft. -In the Lion compound, there are fencing materials and bricks stored adjacent to the perimeter fence that reduce the effective height of the fence to less than 8 ft. The perimeter fence must have an effective height of 8 ft or more so that it can function as a secondary containment system for the animals in the facility. Correction date: 31 July 2015 Exit interview conducted with facility personnel. Additional Inspectors Lorang Jeanne, Animal Care Inspector

rowid 28106
desc FACILITIES, OUTDOOR.
web_siteName HOLLYWOOD ANIMALS, INC.
kind  
Incident hash_id 6dc6a40ca1299dcb
web_inspectionDate 2015-06-30
code 3.127(d)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 32.0
web_certType Class C - Exhibitor
pdf_customer_id 327093.0
pdf_customer_name Hollywood Animals Inc.
pdf_customer_addr P.O. Box 2088 Santa Clarita, CA 91386
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23528582-aphis-inspection-182151057400769
lat  
lng  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 5007.246ms