Semantic search

citation_inspection

Table actions

1 row where hash_id = "064ea9c56aaffe62"

✎ 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 male liver and white schnauzer (“Baxter”, microchip 496 578 191E) has a heavy buildup of brown tartar on the cheek teeth on the right side of the mouth. The tartar on the upper right cheek teeth is entirely encasing the surface of the teeth and the individual shape of the teeth is no longer identifiable. Nearly half the surface of the upper right canine tooth is encased in tartar with the thickest buildup located along the gum line. The cheek teeth on the left side of the mouth also have a buildup of tartar. The gums have become moderately reddened. Poor dental health could cause pain and discomfort to the dog and could possibly lead to further health issues. This dog must be evaluated by a licensed veterinarian for a proper diagnosis and to develop an effective treatment plan. The diagnosis and treatment plan must be documented in writing and available to the inspector upon request. The licensee must ensure that all dogs receive adequate veterinary care at all times. To be corrected by: September 28, 2016 Inspection and exit interview conducted with Kelly Maxwell, ACI and the facility representative.

rowid 19404
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName SHARON AMBROSE
kind  
Incident hash_id 064ea9c56aaffe62
web_inspectionDate 2016-09-21
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 24.0
web_certType Class A - Breeder
pdf_customer_id 32069.0
pdf_customer_name Sharon Ambrose
pdf_customer_addr 2478 State Hwy 25 Lenox, IA 50851
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23511381-aphis-inspection-2016082567936774
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);