home / aphis_reports

Semantic search

citation_inspection

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

3 rows where hash_id = "f672351a4c6f2596"

✎ 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

3.127 - Facilities, outdoor. (b) The north side of the deer enclosure was closed off from the south side by a gate. One Buck and two doe were present in the north side which has few trees and no artificial shelter. Correct by providing these animals access to shelter from inclement weather. The coyote had a large dog house for shelter and was properly bedded with shavings but the dog house did not have a windbreak. A windbreak may be needed in the winter to assure the animal can remain protected from the weather and prevent discomfort. Correct by providing a windbreak. Natural or artificial shelter appropriate to the local climatic conditions for the species concerned shall be provided for all animals kept outdoors to afford them protection and to prevent discomfort to such animals. To be corrected by: 30 October 2015

rowid 12853
desc FACILITIES, OUTDOOR.
web_siteName Union County Sportsmens Club Inc
kind  
Incident hash_id f672351a4c6f2596
web_inspectionDate 2015-10-20
code 3.127(b)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 16.0
web_certType Class C - Exhibitor
pdf_customer_id 9127.0
pdf_customer_name Union County Sportsmens Club Inc
pdf_customer_addr 766 Thomas Dam Rd Millmont, PA 17845
customer_state PA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23497618-aphis-inspection-293151429390839
lat  
lng  

The coyote enclosure has running water that is backing up in front of the shelter entrance. An attempt has been made to limit the water by running a hose to the lower part of the trough but this is ineffective. This backup causes the animal to have to walk thru water to enter its shelter and could lead to discomfort and disease especially as the weather gets colder. The water also effectively reduces the size of the enclosure If the animal tries to avoid it. Correct by preventing the water from covering unintended portions of the shelter floor. A suitable method shall be provided to rapidly eliminate excess water. The method of drainage shall comply with applicable Federal, State, and local laws and regulations relating to pollution control or the protection of the environment. To be corrected by 30 October 2015

rowid 12854
desc FACILITIES, OUTDOOR.
web_siteName Union County Sportsmens Club Inc
kind  
Incident hash_id f672351a4c6f2596
web_inspectionDate 2015-10-20
code 3.127(c)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 16.0
web_certType Class C - Exhibitor
pdf_customer_id 9127.0
pdf_customer_name Union County Sportsmens Club Inc
pdf_customer_addr 766 Thomas Dam Rd Millmont, PA 17845
customer_state PA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23497618-aphis-inspection-293151429390839
lat  
lng  

A wire top had been constructed over the Raccoon Portion of the enclosure that housed raccoon and skunk. This wire top was accessible to the raccoon thru the open door into the uninhabited skunk area. The raccoon has defecated significantly on the top of this wire and there was an accumulation of feces at the time of inspection. Correct by cleaning the feces regularly and/or restricting access to this part of the enclosure. A nesting box for birds was present inside the northern deer enclosure adjacent to the Bear enclosure. The roof of the nesting box was sloped toward the bear enclosure and was covered with feces. This configuration can lead to contamination of the bear enclosure with bird feces during rains and may cause disease in the bear. Correct by changing the location or configuration of the nesting box and routine cleaning. This item was corrected before the exit briefing. Excreta shall be removed from primary enclosures as often as necessary to prevent contamination of the animals contained therein and to minimize disease hazards and to reduce odors. To be corrected by: 26 October 2015 An exit briefing was conducted with the animal caretaker.

rowid 12855
desc SANITATION.
web_siteName Union County Sportsmens Club Inc
kind  
Incident hash_id f672351a4c6f2596
web_inspectionDate 2015-10-20
code 3.131(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 16.0
web_certType Class C - Exhibitor
pdf_customer_id 9127.0
pdf_customer_name Union County Sportsmens Club Inc
pdf_customer_addr 766 Thomas Dam Rd Millmont, PA 17845
customer_state PA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23497618-aphis-inspection-293151429390839
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 4691.489ms