Semantic search

citation_inspection

Table actions

2 rows where hash_id = "6c4a2e93d40d4b13"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: web_inspectionDate (date)

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

There are several areas at the bottom of the cougar enclosure where the weathered wood is damaged. This damaged wood needs to be replaced with wood or other suitable material. Outdoor housing facilities shall be structurally sound and shall be maintained in good repair to protect the animals from injury and to contain the animals. TO BE CORRECTED BY: AUGUST 28, 2015.

rowid 30739
desc FACILITIES, GENERAL.
web_siteName EVERGLADES JACKS L L C
kind  
Incident hash_id 6c4a2e93d40d4b13
web_inspectionDate 2015-08-18
code 3.125(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 10.0
web_certType Class C - Exhibitor
pdf_customer_id 330253.0
pdf_customer_name Everglades Jacks L L C
pdf_customer_addr 17595 S Tamiami Trl Ste 120 Fort Myers, FL 33908
customer_state FL
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23533880-aphis-inspection-233151202110285
lat  
lng  

(1) There were several bags of raw chicken being thawed outdsite out on the ground. I observed numerous ants around the bags of this raw chicken. (2) The temperature gauge on the freezer was a 32F, and when inspecting the freezer the temperature raises to 40F. Although the meat in the freezer is frozen, appliances need to be at the proper temperatures to prevent spoilage. Meats should be refrigerated and thawed at temperatures at or below 40° F (4° C), and the freezer temperature should be 0° F (-18° C). Supplies of food and bedding shall be stored in facilities which adequately protect such supplies against deterioration, molding, or contamination by vermin. Refrigeration shall be provided for supplies of perishable food. TO BE CORRECTED BY: IMMEDIATELY The exit interview was conducted with the care taker of animals.

rowid 30740
desc FACILITIES, GENERAL.
web_siteName EVERGLADES JACKS L L C
kind  
Incident hash_id 6c4a2e93d40d4b13
web_inspectionDate 2015-08-18
code 3.125(c)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 10.0
web_certType Class C - Exhibitor
pdf_customer_id 330253.0
pdf_customer_name Everglades Jacks L L C
pdf_customer_addr 17595 S Tamiami Trl Ste 120 Fort Myers, FL 33908
customer_state FL
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23533880-aphis-inspection-233151202110285
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);