Semantic search

citation_inspection

Table actions

2 rows where hash_id = "1c9450f0a5b065ff"

✎ 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

* An enclosure (approximately three feet from the ground) with four dogs had the outside door unlatched and open. This enclosure did not secure the dogs and could allow the dogs to escape or become injured if they jumped out of the enclosure. Licensee must close and latch the door. Licensee must ensure that all enclosures secure the dogs at all times and to protect them from harm. ** To be corrected: 6/30/15 (Immediately- done at time of inspection)

rowid 27588
desc PRIMARY ENCLOSURES.
web_siteName MENNO ZOOK
kind  
Incident hash_id 1c9450f0a5b065ff
web_inspectionDate 2015-06-30
code 3.6(a)(2)(3)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 93.0
web_certType Class A - Breeder
pdf_customer_id 326426.0
pdf_customer_name Menno Zook
pdf_customer_addr 421 N W Highway C Spickard, MO 64679
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23527641-aphis-inspection-181151044430782
lat  
lng  

* There is one enclosure containing six puppies that has 1in. x 1in. openings in the flooring. These openings are too large and allow the puppies feet and legs to pass through. These openings in the flooring can cause injury to the puppies. Licensee must repair or replace this flooring to ensure that the puppies legs and feet do not pass through them, and ensure that floor openings do not allow the legs and feet of puppies/dogs to pass through at all times to prevent injury. ** To be corrected by: 7/1/15 Inspection and exit interview conducted with facility representative, Stephanie Osborn, ACI and Angela DePoe, ACI. Additional Inspectors Osborne Stephanie, Animal Care Inspector

rowid 27589
desc PRIMARY ENCLOSURES.
web_siteName MENNO ZOOK
kind  
Incident hash_id 1c9450f0a5b065ff
web_inspectionDate 2015-06-30
code 3.6(a)(2)(10)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 93.0
web_certType Class A - Breeder
pdf_customer_id 326426.0
pdf_customer_name Menno Zook
pdf_customer_addr 421 N W Highway C Spickard, MO 64679
customer_state MO
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23527641-aphis-inspection-181151044430782
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);