Semantic search

citation_inspection

Table actions

2 rows where hash_id = "d138f1de6a0aad5f"

✎ 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

**The last Program of Veterinary Care found appears to have been updated in 2007 and does not include the species of animals on the premises. The exhibitor shall employ an attending veterinarian under formal arrangements, which includes a written Program of Veterinary Care and scheduled visits to the premises. This program and relationship must be established to help ensure provision of an appropriate standard of care for the regulated animals. The program must be complete to include all regulated species, regularly, reviewed, and updated as necessary by the attending veterinarian. Correct by 11/3/2015

rowid 19406
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName A E HOWELL WILDLIFE CONSERVATION CENTER
kind  
Incident hash_id d138f1de6a0aad5f
web_inspectionDate 2015-10-20
code 2.40(a)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 9.0
web_certType Class C - Exhibitor
pdf_customer_id 32088.0
pdf_customer_name A E Howell Wildlife Conservation Ctr
pdf_customer_addr 101 Lycette Road Amity, ME 04471
customer_state ME
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23511383-aphis-inspection-292151147058214
lat  
lng  

**The coyote Cheyenne was observed lying down in her enclosure and appeared unwilling to move. When she arose and began to walk to her den, her gait was very slow, stiff, and unsteady. The Caretaker reported that she had been running around when last observed up, but has been lying down in her den more often as the weather turned colder. It is thought that Cheyenne is 18 years old. Changes in gait and reduced mobility often indicate pain or discomfort in animals. This animal should be evaluated soon by a veterinarian to determine an appropriate method to diagnose and treat her condition. Correct by 10/24/2015. The inspection and exit briefing were conducted with the Caretaker.

rowid 19407
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName A E HOWELL WILDLIFE CONSERVATION CENTER
kind  
Incident hash_id d138f1de6a0aad5f
web_inspectionDate 2015-10-20
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 9.0
web_certType Class C - Exhibitor
pdf_customer_id 32088.0
pdf_customer_name A E Howell Wildlife Conservation Ctr
pdf_customer_addr 101 Lycette Road Amity, ME 04471
customer_state ME
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23511383-aphis-inspection-292151147058214
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);