Semantic search
citation_inspection
4 rows where hash_id = "000d3bd4c60a7e13"
This data as json, CSV (advanced)
*** The store employee could not locate or produce the program of vet care for review. When the facility has a consultant arrangement with a vet there must be a written program of vet care and regularly scheduled visits to the facility to assess the health and overall care of the animals. This documentation needs to be kept at the facility and in a location that is easily accessible for review during the inspection process.
| rowid | 29340 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | Acks Exotic Pets |
| kind | |
| Incident hash_id | 000d3bd4c60a7e13 |
| web_inspectionDate | 2016-01-21 |
| code | 2.40(a) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 105.0 |
| web_certType | Class B - Dealer |
| pdf_customer_id | 328550.0 |
| pdf_customer_name | Acks Exotic Pets |
| pdf_customer_addr | 8107 Route 11 Cicero, NY 13039 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23530705-aphis-inspection-22161352420754 |
| lat | |
| lng |
*** The store employee could not locate the records of animals on hand or the recent acquisition records (mini pigs, hedgehogs) or disposition records for animals that have been sold since last year. These records are an important part of the record keeping requirement to track the movement of the animals. These records need to be maintained in a timely and accurate manner and stored in a location that is easily accessible for review during the inspection process.
| rowid | 29341 |
| desc | RECORDS: OPERATORS OF AUCTION SALES AND BROKERS. |
| web_siteName | Acks Exotic Pets |
| kind | |
| Incident hash_id | 000d3bd4c60a7e13 |
| web_inspectionDate | 2016-01-21 |
| code | 2.76(a) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 105.0 |
| web_certType | Class B - Dealer |
| pdf_customer_id | 328550.0 |
| pdf_customer_name | Acks Exotic Pets |
| pdf_customer_addr | 8107 Route 11 Cicero, NY 13039 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23530705-aphis-inspection-22161352420754 |
| lat | |
| lng |
*** The sugar gliders for sale in the store are being housed in tiered enclosures. Tiered enclosures do not provide sufficient space for adequate freedom of movement to allow the gliders to glide. Gliding is a normal postural adjustment and these animals need to be moved to enclosures that allow this. Correct by: Jan 24, 2016
| rowid | 29342 |
| desc | SPACE REQUIREMENTS. |
| web_siteName | Acks Exotic Pets |
| kind | |
| Incident hash_id | 000d3bd4c60a7e13 |
| web_inspectionDate | 2016-01-21 |
| code | 3.128 |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 105.0 |
| web_certType | Class B - Dealer |
| pdf_customer_id | 328550.0 |
| pdf_customer_name | Acks Exotic Pets |
| pdf_customer_addr | 8107 Route 11 Cicero, NY 13039 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23530705-aphis-inspection-22161352420754 |
| lat | |
| lng |
*** In the main store area, the area around the sugar gliders needs to be cleaned. There are droppings on the shelves below where food is stored and there is an un-used bird cage that is dirty with dust and debris. The area needs to be kept clean to facilitate good husbandry and housekeeping practices. *** The area behind the sugar gliders in the back room needs to be cleaned as well as their exercise wheels. These areas also need to be kept clean for the health of the animals. Correct by: Jan 24, 2016 An exit briefing was conducted with a facility representative at the time of the inspection.
| rowid | 29343 |
| desc | SANITATION. |
| web_siteName | Acks Exotic Pets |
| kind | |
| Incident hash_id | 000d3bd4c60a7e13 |
| web_inspectionDate | 2016-01-21 |
| code | 3.131(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 105.0 |
| web_certType | Class B - Dealer |
| pdf_customer_id | 328550.0 |
| pdf_customer_name | Acks Exotic Pets |
| pdf_customer_addr | 8107 Route 11 Cicero, NY 13039 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23530705-aphis-inspection-22161352420754 |
| 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);