Semantic search

citation_inspection

Table actions

1 row where hash_id = "d5f99943f12c4741"

✎ 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

Records reviewed did not support the use of appropriate methods to prevent, control, diagnose, and treat diseases and injuries. Five out of twelve animal records reviewed at this inspection indicated that treatment was delayed in animals identified to veterinary personnel for evaluation. Treatments, if directed, were not recorded as having been performed. Appropriate and prompt treatment must be initiated and recorded to assure the best outcome for the animals. Additional preventive measures may also be indicated. Correct: This point forward An exit briefing was conducted with the facility veterinarian. Additional Inspectors Mcfadden Gloria, Veterinary Medical Officer

rowid 83
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName The Johns Hopkins University
kind  
Incident hash_id d5f99943f12c4741
web_inspectionDate 2014-08-20
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 390.0
web_certType Class A - Breeder
pdf_customer_id 81.0
pdf_customer_name The Johns Hopkins University
pdf_customer_addr 265 Garland Hall 3400 N Charles Street Baltimore, MD 21218
customer_state MD
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470570-aphis-inspection-232141312450418
lat 39.3273434
lng -76.62155039999999

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);