Semantic search

citation_inspection

Table actions

1 row where hash_id = "448e078803f6559e"

✎ 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 six metal feeders which have rusted away leaving sharp metal edges at the interior portion that the rabbits eat out of. These feeders need to be replaced so that they are structurally sound and then maintained in good repair to protect the rabbits from injury, to contain them, and to keep predators out. Correct by: 09-13-14. An exit briefing was conducted with the Owner.

rowid 25950
desc PRIMARY ENCLOSURES.
web_siteName LARRY WILSON
kind  
Incident hash_id 448e078803f6559e
web_inspectionDate 2014-09-09
code 3.53(a)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 0.0
web_certType Class B - Dealer
pdf_customer_id 324219.0
pdf_customer_name Larry W Wilson
pdf_customer_addr 5450 Hampton Road Lakeland, FL 33810
customer_state FL
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23524590-aphis-inspection-252141444170156
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);