Semantic search
citation_inspection
4 rows where hash_id = "0019a8b0f5b42c51"
This data as json, CSV (advanced)
Suggested facets: desc, repeat, web_inspectionDate (date)
The indoor temperature was 47.3 degrees Fahrenheit inside the holding room housing 52 guinea pigs .There was no heater present in the holding room to prevent the temperature from falling below 60 degrees Fahrenheit. Guinea pigs were huddled in corners in an attempt to keep warm. A propane heater with two gas burners was brought into the holding room and the temperature increased to 61.5 degrees Fahrenheit. A safe and reliable heater must be installed in the guinea pig room to prevent the ambient temperature from falling below 60 degrees Fahrenheit. The heater should have a thermostat to control the temperature and to prevent the temperature from falling below 60 degrees.The ambient temperature must not fall below 60 degrees Fahrenheit when guinea pigs are present to protect the health and well-being of the animals.
rowid | 25890 |
desc | FACILITIES, INDOOR. |
web_siteName | DAVID S GLICK |
kind | Direct |
Incident hash_id | 0019a8b0f5b42c51 |
web_inspectionDate | 2014-02-06 |
code | 3.26(a) |
repeat | 1 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 169.0 |
web_certType | Class B - Dealer |
pdf_customer_id | 324143.0 |
pdf_customer_name | David S Glick |
pdf_customer_addr | 274 Cut Road Gap, PA 17527 |
customer_state | PA |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23524476-aphis-inspection-49141445330165 |
lat | |
lng |
There were 17 excessively dirty and wet enclosures especially by the water nipples in the adult guinea pig room and 4 excessively dirty enclosures in the holding room for sale guinea pigs. Animals standing in fecal material are potentially exposed to parasites and diseases. The licensee must ensure that animals standing in soiled and/or wet enclosures are moved to clean enclosures to ensure the health and comfort of the animals. Correct by February 7, 2014
rowid | 25891 |
desc | SANITATION. |
web_siteName | DAVID S GLICK |
kind | |
Incident hash_id | 0019a8b0f5b42c51 |
web_inspectionDate | 2014-02-06 |
code | 3.31(a)(2) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 169.0 |
web_certType | Class B - Dealer |
pdf_customer_id | 324143.0 |
pdf_customer_name | David S Glick |
pdf_customer_addr | 274 Cut Road Gap, PA 17527 |
customer_state | PA |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23524476-aphis-inspection-49141445330165 |
lat | |
lng |
There were piles of cardboard boxes on the floor of the holding room for guinea pigs. The floor had a buildup of dirt and debris. There were cobwebs on walls, windows, and enclosures housing guinea pigs. Animal faclities must be kept clean to ensure the health and well-being of the animals. Licensee must establish and maintain a program to keep the animal facliites clean. Correct by February 8, 2014.
rowid | 25892 |
desc | SANITATION. |
web_siteName | DAVID S GLICK |
kind | |
Incident hash_id | 0019a8b0f5b42c51 |
web_inspectionDate | 2014-02-06 |
code | 3.31(b) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 169.0 |
web_certType | Class B - Dealer |
pdf_customer_id | 324143.0 |
pdf_customer_name | David S Glick |
pdf_customer_addr | 274 Cut Road Gap, PA 17527 |
customer_state | PA |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23524476-aphis-inspection-49141445330165 |
lat | |
lng |
There were five pigeons loose in the adult guinea pig room. Owner stated that the pigeons belong to his son. The tops of the guinea pig enclosures are open allowing the pigeons to eat the guinea pig feed and defecate on their enclosures. Guinea pigs shall not be housed in the same primary enclosure with any other species of animals. The pigeons can not remain loose inside the animal room to prevent disease and health risks to the guinea pigs. Correct by February 8, 2014 An exit briefing was conducted with licensee.
rowid | 25893 |
desc | CLASSIFICATION AND SEPARATION. |
web_siteName | DAVID S GLICK |
kind | |
Incident hash_id | 0019a8b0f5b42c51 |
web_inspectionDate | 2014-02-06 |
code | 3.33(b) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 169.0 |
web_certType | Class B - Dealer |
pdf_customer_id | 324143.0 |
pdf_customer_name | David S Glick |
pdf_customer_addr | 274 Cut Road Gap, PA 17527 |
customer_state | PA |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23524476-aphis-inspection-49141445330165 |
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);