Semantic search

citations

3 rows where hash_id = "caec72c84f4f47e9"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
12834 caec72c84f4f47e9 2.8(h)   0 NOTIFICATION OF CHANGE OF NAME, ADDRESS, CONTROL, OR OWNERSHIP OF BUSINESS. 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.
12835 caec72c84f4f47e9 2.131(b)(1)   0 HANDLING OF ANIMALS. 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.
12836 caec72c84f4f47e9 3.31(a)(1)   0 SANITATION. 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.

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "citations" (
   [rowid] INTEGER PRIMARY KEY,
   [hash_id] TEXT REFERENCES [inspections]([hash_id]),
   [code] TEXT,
   [kind] TEXT,
   [repeat] INTEGER,
   [desc] TEXT,
   [narrative] TEXT
);