Semantic search

citation_inspection

Table actions

1 row where hash_id = "4014f4cb792765bf"

✎ 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

c) Construction. **In the outdoor facility there are 2 wooden shelters that have wooden frames around the entry for the dogs. The wooden frame is excessively scratched and chewed all the way around. Some of the scratched areas have slivers of wood poking out. The exposed inner surfaces of the wood frames are not impervious to moisture due to the excessive scratching and chewing. The wood surface cannot be readily cleaned and sanitized because of the rough surface. It can become a place for insects and bacteria to live and grow and be in close contact with the dogs. To ensure a healthy, clean and safe environment for the dogs, the owner must repair, replace or remove the chewed and scratched wooden door frames. Any replacement or repair with wood must also be treated to make it impervious to moisture. A schedule of more frequent maintanance must be done to ensure a safe, healthy environment for the dogs. TO BE CORRECTED BY: 7 JUNE 2014. An exit interview was done with a facility representative.

rowid 23592
desc OUTDOOR HOUSING FACILITIES.
web_siteName RICK & SHELLY KUHN
kind  
Incident hash_id 4014f4cb792765bf
web_inspectionDate 2014-06-04
code 3.4(c)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 49.0
web_certType Class A - Breeder
pdf_customer_id 44913.0
pdf_customer_name Rick Kuhn
pdf_customer_addr Shelly Kuhn 5510 Highway 5 Hartville, MO 65667
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23520288-aphis-inspection-155142006100053
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);