Semantic search
citation_inspection
3 rows where hash_id = "5a8febbc64363a84"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
Two pot-bellied pigs named Wilbur (black and white in color) and Cookie (black in color) were found to have overgrown hooves on all four limbs. Wilbur was reluctant to walk around the enclosure or leave the shelter. The facility representative states both Wilbur and Cookie sleep a lot and are reluctant to move often. These pigs were acquired in February and an appointment was made in April for May for hoof trims. The licensee has not contacted the attending veterinarian about the condition of these pigs beyond making the May appointment. Overgrown hooves may cause pain and discomfort and may affect the joint health of the animals. Each exhibitor shall establish and maintain programs of adequate veterinary care that include the use of appropriate methods to prevent, control, diagnose and treat diseases and injuries. Cookie and Wilbur must have their hooves trimmed and be evaluated by a licensed veterinarian. To be corrected by: End of business 5-May-2023 Several medications were found to be expired at the time of inspection. Expired medications do not ensure that the medications are effective at treating disease or illness and the health of the animal may suffer. Each exhibitor shall use appropriate methods to prevent, control, diagnose, and treat diseases and injuries. The facility must ensure all medications are not expired. To be corrected by: This was corrected at the time of inspection
| rowid | 28547 |
| desc | Attending veterinarian and adequate veterinary care (dealers and exhibitors). |
| web_siteName | SCATTER JOY ACRES |
| kind | Direct |
| Incident hash_id | 5a8febbc64363a84 |
| web_inspectionDate | 2023-05-02 |
| code | 2.40(b)(2) |
| repeat | 0 |
| pdf_insp_type | NEW SITE INSPECTION |
| pdf_animals_total | 97.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 327646.0 |
| pdf_customer_name | SCATTER JOY ACRES |
| pdf_customer_addr | 4107 Waverly Road Murray, NE 68409 |
| customer_state | NE |
| pdf_site_id | 004 |
| doccloud_url | https://www.documentcloud.org/documents/23829148-aphis-inspection-ins-0000868227 |
| lat | |
| lng |
The facility has no official identification present on 20 adult cats or placed on the enclosure pen. Official identification is necessary for APHIS officials to positively identify animals for inspection and to properly trace their movements. An exhibitor shall identify all live cats under his or her control or on his or her premises, whether held, purchased, or otherwise acquired by identifying each dog or cat with: An official USDA sequentially numbered tag that is kept on the door of the animal's cage or run; A record book containing each animal's tag number, a written description of each animal, the data required by § 2.75(a), and a clear photograph of each animal; and a duplicate tag that accompanies each dog or cat whenever it leaves the compound or premises. To be corrected by: 12-May-2023.
| rowid | 28548 |
| desc | Time and method of identification. |
| web_siteName | SCATTER JOY ACRES |
| kind | |
| Incident hash_id | 5a8febbc64363a84 |
| web_inspectionDate | 2023-05-02 |
| code | 2.50(c)(2)(i) |
| repeat | 0 |
| pdf_insp_type | NEW SITE INSPECTION |
| pdf_animals_total | 97.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 327646.0 |
| pdf_customer_name | SCATTER JOY ACRES |
| pdf_customer_addr | 4107 Waverly Road Murray, NE 68409 |
| customer_state | NE |
| pdf_site_id | 004 |
| doccloud_url | https://www.documentcloud.org/documents/23829148-aphis-inspection-ins-0000868227 |
| lat | |
| lng |
The enclosure housing 15 adult cats has a tall scratching post that has been heavily scratched and worn. Long strands of carpet threading were hanging from the scratching post. These long strands of threading may cause a cat to become entangled in them and may cause pain and distress. Housing facilities for cats must be designed and constructed so that they are structurally sound. They must be kept in good repair, and they must protect the animals from injury. The facility must repair, replace or discard the scratching post. To be corrected by: 5-May-2023. This inspection was a site approval inspection. This site is not ready for approval to conduct activity covered under your current Animal Welfare Act License. Conducting regulated activities at a non-approved site is a violation of the Animal Welfare Act. Please contact your inspector to schedule your next new site approval inspection. This inspection and exit interview were conducted with a facility representative. n
| rowid | 28549 |
| desc | Housing facilities, general. |
| web_siteName | SCATTER JOY ACRES |
| kind | |
| Incident hash_id | 5a8febbc64363a84 |
| web_inspectionDate | 2023-05-02 |
| code | 3.1(a) |
| repeat | 0 |
| pdf_insp_type | NEW SITE INSPECTION |
| pdf_animals_total | 97.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 327646.0 |
| pdf_customer_name | SCATTER JOY ACRES |
| pdf_customer_addr | 4107 Waverly Road Murray, NE 68409 |
| customer_state | NE |
| pdf_site_id | 004 |
| doccloud_url | https://www.documentcloud.org/documents/23829148-aphis-inspection-ins-0000868227 |
| 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);