Semantic search

citation_inspection

Table actions

3 rows where hash_id = "8038e446a2d56c5e"

✎ 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

There currently is no written inventory for animals on hand, acquisitions or dispositions. Records shall be maintained disclosing animals on hand, purchased, sold, births, deaths, etc. The records shall include the name and address of the person from whom the animals were acquired. Correct by July 23, 2021.

rowid 13969
desc Records: Dealers and exhibitors.
web_siteName Terry K Beal
kind  
Incident hash_id 8038e446a2d56c5e
web_inspectionDate 2021-07-07
code 2.75(b)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 57.0
web_certType Class C - Exhibitor
pdf_customer_id 11079.0
pdf_customer_name TERRY K BEAL
pdf_customer_addr 3259 WATER PLANT RD MAIDEN, NC 28650
customer_state NC
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23499281-aphis-inspection-2016090000651507
lat  
lng  

The camel barn and entrance to the barn have excessive accumulation of excreta. Allowing the excreta to accumulate increases the possibility of disease hazards. Excreta shall be removed from the primary enclosure as often as necessary to prevent contamination and minimize disease hazard. Correct by July 10, 2021.

rowid 13970
desc Sanitation.
web_siteName Terry K Beal
kind  
Incident hash_id 8038e446a2d56c5e
web_inspectionDate 2021-07-07
code 3.131
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 57.0
web_certType Class C - Exhibitor
pdf_customer_id 11079.0
pdf_customer_name TERRY K BEAL
pdf_customer_addr 3259 WATER PLANT RD MAIDEN, NC 28650
customer_state NC
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23499281-aphis-inspection-2016090000651507
lat  
lng  

There are old pieces of tin and wood from the barn that was torn down laying in the hoof stock enclosures. These items create an injury hazard for all animals in the enclosure. The materials shall be removed or stored in an area that will prevent the animals from access and protect them from potential injury. Correct by July 30, 2021. This inspection and exit interview were conducted with the Owner. End Section

rowid 13971
desc Sanitation.
web_siteName Terry K Beal
kind  
Incident hash_id 8038e446a2d56c5e
web_inspectionDate 2021-07-07
code 3.131(c)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 57.0
web_certType Class C - Exhibitor
pdf_customer_id 11079.0
pdf_customer_name TERRY K BEAL
pdf_customer_addr 3259 WATER PLANT RD MAIDEN, NC 28650
customer_state NC
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23499281-aphis-inspection-2016090000651507
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);