Semantic search
citation_inspection
3 rows where hash_id = "caec72c84f4f47e9"
This data as json, CSV (advanced)
The USDA noted that regulated activity has been conducted from an additional location of this licensee. As stated by an employee the guinea pigs have been housed at the current location for one year, and were housed at a previous site before coming to this location. The previous site was also undeclared to the USDA. The licensee must promptly notify the Animal Care Regional Office of a change in business such as any additional sites within 10 days of such a change. Correct immediately.
| rowid | 12834 |
| desc | NOTIFICATION OF CHANGE OF NAME, ADDRESS, CONTROL, OR OWNERSHIP OF BUSINESS. |
| web_siteName | Elm Hill Labs Inc |
| kind | |
| Incident hash_id | caec72c84f4f47e9 |
| web_inspectionDate | 2014-06-04 |
| code | 2.8(h) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 2400.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 9059.0 |
| pdf_customer_name | Elm Hill Labs Inc |
| pdf_customer_addr | 7 Kidder Road Chelmsford, MA 01824 |
| customer_state | MA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23497572-aphis-inspection-155141614080070 |
| lat | |
| lng |
At the time of inspection, there was a medium sized radio inside one of the animal enclosures that contained breeding females and several young guinea pigs. It was playing fairly loud rock music intended for all of the guinea pigs in the room. A radio placed inside an enclosure playing music at a fairly high volume could potentially cause behavioral stress or physical harm to the animals. The radio was immediately put in a place away from the animals. This item was corrected at the time of inspection.
| rowid | 12835 |
| desc | HANDLING OF ANIMALS. |
| web_siteName | Elm Hill Labs Inc |
| kind | |
| Incident hash_id | caec72c84f4f47e9 |
| web_inspectionDate | 2014-06-04 |
| code | 2.131(b)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 2400.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 9059.0 |
| pdf_customer_name | Elm Hill Labs Inc |
| pdf_customer_addr | 7 Kidder Road Chelmsford, MA 01824 |
| customer_state | MA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23497572-aphis-inspection-155141614080070 |
| lat | |
| lng |
Many of the animals' enclosures had grime accumulation on the lower edges and corners. The primary enclosures need to be cleaned often enough to be kept free of a buildup of excreta for the health and well-being of the animals. Correct by 20 Jun 2014 An exit briefing was conducted with the licensee. This was an inspection of the location in Tyngsboro,MA.
| rowid | 12836 |
| desc | SANITATION. |
| web_siteName | Elm Hill Labs Inc |
| kind | |
| Incident hash_id | caec72c84f4f47e9 |
| web_inspectionDate | 2014-06-04 |
| code | 3.31(a)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 2400.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 9059.0 |
| pdf_customer_name | Elm Hill Labs Inc |
| pdf_customer_addr | 7 Kidder Road Chelmsford, MA 01824 |
| customer_state | MA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23497572-aphis-inspection-155141614080070 |
| 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);