Semantic search
citation_inspection
4 rows where hash_id = "d7e376b12f0cbb3d"
This data as json, CSV (advanced)
Two adult, female pigs, Petunia and Daisy, had generalized, hair loss including on the sides of their chest and abdomen, neck, and all four limbs. Some areas of their underlying skin appeared mildly thickened and reddened. No open wounds, lacerations, or infected areas were noticed. The inspector did observe an occasional episode of mild to moderate itchiness in which the pigs would scratch with their back feet or rub against objects within the enclosure. These pigs were recently examined by the attending veterinarian on 05/11/2016; however there is no documentation of any skin condition noted on record review. Hair loss may indicate an underlying health issue and may be a source of irritation and discomfort to these animals. These pigs should be examined by a veterinarian to ensure that an accurate diagnosis is obtained and an appropriate treatment plan is developed and followed. The licensee must ensure that all animals receive adequate veterinary care at all times. Correct by 06/20/2016.
rowid | 28658 |
desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
web_siteName | Reptacular Animals Corporation |
kind | |
Incident hash_id | d7e376b12f0cbb3d |
web_inspectionDate | 2016-06-14 |
code | 2.40(b)(2) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 44.0 |
web_certType | Class C - Exhibitor |
pdf_customer_id | 327816.0 |
pdf_customer_name | Reptacular Animals Corporation |
pdf_customer_addr | 8309 Laurel Canyon Blvd #316 Sun Valley, CA 91352 |
customer_state | CA |
pdf_site_id | 002 |
doccloud_url | https://www.documentcloud.org/documents/23529684-aphis-inspection-167161325000935 |
lat | |
lng |
Guinea Pig trailer: An overhead light fixture did not have protective coverings over the bulbs. This fixture was located in an area of the ceiling directly above the guinea pig enclosures. Uncovered, light bulbs could potentially cause injury to the animals in the event of accidental breakage. Housing facilities for guinea pigs must be structurally sound and maintained in good repair in order to protect the animals from injury and to contain them. A system of timely identification, facility repair and maintenance must be in place. Correct by 07/12/2016.
rowid | 28659 |
desc | FACILITIES, GENERAL. |
web_siteName | Reptacular Animals Corporation |
kind | |
Incident hash_id | d7e376b12f0cbb3d |
web_inspectionDate | 2016-06-14 |
code | 3.25(a) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 44.0 |
web_certType | Class C - Exhibitor |
pdf_customer_id | 327816.0 |
pdf_customer_name | Reptacular Animals Corporation |
pdf_customer_addr | 8309 Laurel Canyon Blvd #316 Sun Valley, CA 91352 |
customer_state | CA |
pdf_site_id | 002 |
doccloud_url | https://www.documentcloud.org/documents/23529684-aphis-inspection-167161325000935 |
lat | |
lng |
Guinea Pig trailer: The two rooms in this trailer had a heavy accumulation of old, animal bedding material and dust on the floor and on shelving units. There was a wooden shelving rack system containing a large amount of old, unsealed, pelleted rodent diet which may attract unwanted vermin or pests. Also, a utility sink had a heavy buildup of dirt, grass and debris including discarded plastic bottles within the basin. Premises (buildings and grounds) including all animal areas must be kept clean, free of clutter or discarded materials and in good repair in order to protect the health and well-being of the animals, to prevent the harborage of vermin and pests, and to facilitate the prescribed husbandry practices. A system of maintaining effective cleaning and housekeeping practices must be in place. Correct by 07/12/2016.
rowid | 28660 |
desc | SANITATION. |
web_siteName | Reptacular Animals Corporation |
kind | |
Incident hash_id | d7e376b12f0cbb3d |
web_inspectionDate | 2016-06-14 |
code | 3.31(b) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 44.0 |
web_certType | Class C - Exhibitor |
pdf_customer_id | 327816.0 |
pdf_customer_name | Reptacular Animals Corporation |
pdf_customer_addr | 8309 Laurel Canyon Blvd #316 Sun Valley, CA 91352 |
customer_state | CA |
pdf_site_id | 002 |
doccloud_url | https://www.documentcloud.org/documents/23529684-aphis-inspection-167161325000935 |
lat | |
lng |
Hoofstock pen: Several areas of the wire fencing in this enclosure were in disrepair with gaps, loose wiring and sharp, protruding points within contact of the animals which could cause injury. At time of inspection, APHIS personnel observed that a baby goat was able to escape this pen and an adult goat with horns was able to put his entire head through the wire gaps in one corner. All enclosures must be kept in good repair and free of sharp, protruding points and gaps/openings in order to protect the animals from injury or entrapment and properly contain the animals. A system of timely identification, facility repair and maintenance must be in place. Correct by 07/12/2016. Exit interview was conducted with a facility representative.
rowid | 28661 |
desc | FACILITIES, GENERAL. |
web_siteName | Reptacular Animals Corporation |
kind | |
Incident hash_id | d7e376b12f0cbb3d |
web_inspectionDate | 2016-06-14 |
code | 3.125(a) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 44.0 |
web_certType | Class C - Exhibitor |
pdf_customer_id | 327816.0 |
pdf_customer_name | Reptacular Animals Corporation |
pdf_customer_addr | 8309 Laurel Canyon Blvd #316 Sun Valley, CA 91352 |
customer_state | CA |
pdf_site_id | 002 |
doccloud_url | https://www.documentcloud.org/documents/23529684-aphis-inspection-167161325000935 |
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);