Semantic search

citation_inspection

Table actions

1 row where hash_id = "8cf2cd0f8ca44da0"

✎ 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

** A five year old, female, fawn pug, micro-chip #4841732E05. The left eye had an opaque iris, with a raised spot in the middle of the iris and visible blood vessels in the white of the eye leading to the raised area. This can be a sign of disease or injury. The dog must be evaluated by a veterinarian. To be corrected by: 01-09-15. ** A seven year old, female, fawn pug, micro-chip #4C18202443. Both eyes are dull, dry and the surface of the eyes have a rough appearance. The right eye had a brown raised spot on the surface of the eye. Both eyes had crusting around the eyes. This can be a sign of disease or injury. The dog must be evaluated by a veterinarian. To be corrected by: 01-09-15. ** A eight year old, female, fawn pug, micro-chip #4831305F3C. Both eyes are dull, dry and the surface of the eyes have a rough appearance. The left eye has yellowish matter on the surface of the eye. This can be a sign of disease or injury. The dog must be evaluated by a veterinarian. To be corrected by: 01-09-15. All dealers must use appropriate methods to prevent, control, diagnose and treat diseases or injury. This inspection and exit briefing conducted with the owner. End of report.

rowid 12231
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName THERESA & JEFF COLEY
kind Direct
Incident hash_id 8cf2cd0f8ca44da0
web_inspectionDate 2015-01-06
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 83.0
web_certType Class A - Breeder
pdf_customer_id 8078.0
pdf_customer_name Jeff Coley
pdf_customer_addr Theresa Coley P.O. Box 1832 Waldron, AR 72958
customer_state AR
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23496130-aphis-inspection-6151431520356
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);