Semantic search
citation_inspection
3 rows where hash_id = "edfccd5883989f11"
This data as json, CSV (advanced)
One rabbit with grey marrkings on the legs was obeserved to be holding its right rear leg in an abnormal position . The leg was extended out from the body in a splayed manner. The animal was observed to move with the leg in the same position . This animal was acquired on 7/18/14 and there is no record of an injury to the leg.The caretaker was unaware that the animal had a problem.This rabbit must be examined by a veterinarian to determine the correct treatment for the issue with the leg. CORRECT BY : 8-21-14
| rowid | 22003 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | Bioo Scientific Corporation |
| kind | Direct |
| Incident hash_id | edfccd5883989f11 |
| web_inspectionDate | 2014-08-20 |
| code | 2.40(b)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 65.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 41027.0 |
| pdf_customer_name | Bioo Scientific Corporation |
| pdf_customer_addr | 7050 Burleson Road Austin, TX 78744 |
| customer_state | TX |
| pdf_site_id | 003 |
| doccloud_url | https://www.documentcloud.org/documents/23517278-aphis-inspection-232141232510303 |
| lat | |
| lng |
The screen on an outside door to the rabbit room was broken and had been repaired with tape. There is a hole in the screen that may allow insects or other pests to enter the room. The damaged screen had been reported but had not yet been repaired. The facility must be kept in good repair to prevent entrance of other animals into the room. CORRECT BY : 8-28-14
| rowid | 22004 |
| desc | FACILITIES, GENERAL. |
| web_siteName | Bioo Scientific Corporation |
| kind | |
| Incident hash_id | edfccd5883989f11 |
| web_inspectionDate | 2014-08-20 |
| code | 3.50(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 65.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 41027.0 |
| pdf_customer_name | Bioo Scientific Corporation |
| pdf_customer_addr | 7050 Burleson Road Austin, TX 78744 |
| customer_state | TX |
| pdf_site_id | 003 |
| doccloud_url | https://www.documentcloud.org/documents/23517278-aphis-inspection-232141232510303 |
| lat | |
| lng |
A strong odor of ammonia was noted upon entry into the rabbit room . The odor caused irritation to eye/nose of both USDA inspectors and may cause the same irritation to the animals airways.There is concern that the ventilation system may not be adequate for the number of animals ( 65 rabbits ) and the size of the room . A method must be developed to prevent a build up of ammonia to provide for the health and comfort of the animals. CORRECT BY : 8-28-14 The inspection and exit briefing was conducted with VP for Research Additional Inspectors Tomlinson Simone, Veterinary Medical Officer
| rowid | 22005 |
| desc | FACILITIES, INDOOR. |
| web_siteName | Bioo Scientific Corporation |
| kind | |
| Incident hash_id | edfccd5883989f11 |
| web_inspectionDate | 2014-08-20 |
| code | 3.51(b) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 65.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 41027.0 |
| pdf_customer_name | Bioo Scientific Corporation |
| pdf_customer_addr | 7050 Burleson Road Austin, TX 78744 |
| customer_state | TX |
| pdf_site_id | 003 |
| doccloud_url | https://www.documentcloud.org/documents/23517278-aphis-inspection-232141232510303 |
| 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);