Semantic search

citation_inspection

Table actions

2 rows where hash_id = "aeffad5b7cc54662"

✎ 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

Throughout the animal compound and in animal areas there is various debris laying on the ground. Items such as old fencing material, plastic bottles and baling twine needs to be picked up and disposed of properly Leaving these items where the animals could ingest them or get tangled up in them could cause harm to the animal. Provision shall be made for the removal and disposal of trash and debris. Correct by: 08-21-14.

rowid 24690
desc FACILITIES, GENERAL.
web_siteName YUSLEIDY TARRERO
kind  
Incident hash_id aeffad5b7cc54662
web_inspectionDate 2014-08-20
code 3.125(d)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 8.0
web_certType Class C - Exhibitor
pdf_customer_id 322194.0
pdf_customer_name Yusleidy Tarrero
pdf_customer_addr 15828 Keylime Blvd Loxahatchee, FL 33470
customer_state FL
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23522509-aphis-inspection-232141335300615
lat  
lng  

The two pigs have a sheet of wood that affords them protection from the sun but no other shelter to protect them from driving rain or cooler temperatures. A shelter needs to be provided for the pigs. Shelter shall be provided for all animals kept outdoors to afford them protection and to prevent discomfort to such animals The wire mesh roof of the pig enclosure is weighed down by tree debris and one corner has broken loose from the support post. The debris needs to be removed and the roof made structurally sound to protect the pigs from limbs and twigs falling into the shelter and possibly on them. Correct by: 08-22-14. An exit briefing was conducted with the Owner.

rowid 24691
desc FACILITIES, OUTDOOR.
web_siteName YUSLEIDY TARRERO
kind  
Incident hash_id aeffad5b7cc54662
web_inspectionDate 2014-08-20
code 3.127(b)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 8.0
web_certType Class C - Exhibitor
pdf_customer_id 322194.0
pdf_customer_name Yusleidy Tarrero
pdf_customer_addr 15828 Keylime Blvd Loxahatchee, FL 33470
customer_state FL
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23522509-aphis-inspection-232141335300615
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);