home / aphis_reports

Semantic search

citation_inspection

Table actions
  • Semantic search against this table
  • Semantic search against this table

4 rows where hash_id = "0019a8b0f5b42c51"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

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

CSV options:

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);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 4674.255ms