Semantic search
citation_inspection
5 rows where hash_id = "94b17435819e7385"
This data as json, CSV (advanced)
Suggested facets: desc
The two conures had a ruffled and unkempt appearance. In addition, the light brown chicken had feather loss, especially on the outer surface of the right wing. An abnormal appearance in birds may indicate poor condition, dietary issues, debility, stress, or a behavior issue. These birds must be examined by a veterinarian to determine an appropriate plan for diagnosis and treatment. The licensee stated the birds were examined by the attending veterinarian on September 15, 2023.
| rowid | 39422 |
| desc | Attending veterinarian and adequate veterinary care (dealers and exhibitors). |
| web_siteName | Bads, LLC |
| kind | |
| Incident hash_id | 94b17435819e7385 |
| web_inspectionDate | 2023-09-14 |
| code | 2.40(b)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 57.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 6010424.0 |
| pdf_customer_name | Bads, LLC |
| pdf_customer_addr | 120 138th St. S., Ste B Tacoma, WA 98444 |
| customer_state | WA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/24040156-aphis-inspection-ins-0000892149 |
| lat | |
| lng |
The records for the facility were not available for review. The facility records are necessary to assess compliance with the regulations and standards, thus helping to ensure animal welfare. The licensee must ensure that all required records are available for review by APHIS officials. Correct by: September 28, 2023
| rowid | 39423 |
| desc | Access and inspection of records and property; submission of itineraries. |
| web_siteName | Bads, LLC |
| kind | |
| Incident hash_id | 94b17435819e7385 |
| web_inspectionDate | 2023-09-14 |
| code | 2.126(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 57.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 6010424.0 |
| pdf_customer_name | Bads, LLC |
| pdf_customer_addr | 120 138th St. S., Ste B Tacoma, WA 98444 |
| customer_state | WA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/24040156-aphis-inspection-ins-0000892149 |
| lat | |
| lng |
The sheep and goats were present in an outdoor pen that did not provide shade for the animals. When sunlight is likely to cause discomfort or overheating, sufficient shade is necessary to allow the animals to protect themselves. The facility must provide shelter from sunlight for the animals. The licensee stated the animals would be moved to a suitable enclosure that same day.
| rowid | 39424 |
| desc | Facilities, outdoor. |
| web_siteName | Bads, LLC |
| kind | |
| Incident hash_id | 94b17435819e7385 |
| web_inspectionDate | 2023-09-14 |
| code | 3.127(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 57.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 6010424.0 |
| pdf_customer_name | Bads, LLC |
| pdf_customer_addr | 120 138th St. S., Ste B Tacoma, WA 98444 |
| customer_state | WA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/24040156-aphis-inspection-ins-0000892149 |
| lat | |
| lng |
Two coatimundi did not have adequate shelter from inclement weather. There was a short overhead section from the roof; however, it would not be sufficient to protect the animals. Shelter must be provided for all animals kept outdoors to afford them protection and to prevent discomfort. The facility shall provide sufficient shelter from inclement weather for the animals. Correct by: September 28, 2023
| rowid | 39425 |
| desc | Facilities, outdoor. |
| web_siteName | Bads, LLC |
| kind | |
| Incident hash_id | 94b17435819e7385 |
| web_inspectionDate | 2023-09-14 |
| code | 3.127(b) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 57.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 6010424.0 |
| pdf_customer_name | Bads, LLC |
| pdf_customer_addr | 120 138th St. S., Ste B Tacoma, WA 98444 |
| customer_state | WA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/24040156-aphis-inspection-ins-0000892149 |
| lat | |
| lng |
The sheep and goats were present in an outdoor pen that did not have adequate space for the animals. Enclosures must provide sufficient space to allow each animal to make normal postural and social adjustments with adequate freedom of movement. Inadequate space may lead to malnutrition, poor condition, debility, stress, or abnormal behavior patterns. The facility must provide the animals with enclosures that provide adequate space. The licensee stated the animals would be moved to a suitable enclosure that same day. This inspection and exit interview were conducted with the licensee. Additional Inspectors: Eduardo Vivas, VETERINARY MEDICAL OFFICER KURT HAMMEL, VETERINARY MEDICAL OFFICER n
| rowid | 39426 |
| desc | Space requirements. |
| web_siteName | Bads, LLC |
| kind | |
| Incident hash_id | 94b17435819e7385 |
| web_inspectionDate | 2023-09-14 |
| code | 3.128 |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 57.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 6010424.0 |
| pdf_customer_name | Bads, LLC |
| pdf_customer_addr | 120 138th St. S., Ste B Tacoma, WA 98444 |
| customer_state | WA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/24040156-aphis-inspection-ins-0000892149 |
| 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);