Semantic search

citation_inspection

Table actions

3 rows where hash_id = "10225ae8057e42e9"

✎ 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 are several bottles of expired medications ( atropine , oxytocin and vitamins ) stored with non expired medications . Medications that are past their expiration date may no longer be effective in treating diseases and injuries.Supplies of drugs must remain in date to ensure that adequate veterinary care is provided. CORRECTED AT TIME OF INSPECTION ( Note : Expired drugs were discarded )

rowid 15726
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName Wildlife Refuge & Sanctuary Silver Wolf Inc.
kind  
Incident hash_id 10225ae8057e42e9
web_inspectionDate 2016-10-12
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 150.0
web_certType Class C - Exhibitor
pdf_customer_id 17541.0
pdf_customer_name Wildlife Refuge & Sanctuary Silver Wolf Inc.
pdf_customer_addr 600 Doctor S J F Rd. Seguin, TX 78155
customer_state TX
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23502993-aphis-inspection-2016082567958779
lat  
lng  

The frozen meat being thawed for the tigers in the back of the facility was on an outside table which contained tools. a bag of open insecticide and motor oil. The meat was not being thawed under refrigeration. Meat must be thawed in a refrigerator to prevent spoilage . Supplies such as motor oil and insecticide may accidentally contaminate the food . Refrigeration shall be provided for supplies of perishable food and the food stored away from pesticides and other chemicals to prevent contamination . CORRECT BY : 10-13 -16

rowid 15727
desc FACILITIES, GENERAL.
web_siteName Wildlife Refuge & Sanctuary Silver Wolf Inc.
kind  
Incident hash_id 10225ae8057e42e9
web_inspectionDate 2016-10-12
code 3.125(c)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 150.0
web_certType Class C - Exhibitor
pdf_customer_id 17541.0
pdf_customer_name Wildlife Refuge & Sanctuary Silver Wolf Inc.
pdf_customer_addr 600 Doctor S J F Rd. Seguin, TX 78155
customer_state TX
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23502993-aphis-inspection-2016082567958779
lat  
lng  

The water for the younger bear is dark green . Fresh potable water is necessary for good health and must be provided daily. Water containers must be maintained in a clean and sanitary condition . CORRECT BY : 10-13-16 The inspection and exit briefing was conducted with facility employees .

rowid 15728
desc WATERING.
web_siteName Wildlife Refuge & Sanctuary Silver Wolf Inc.
kind  
Incident hash_id 10225ae8057e42e9
web_inspectionDate 2016-10-12
code 3.130
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 150.0
web_certType Class C - Exhibitor
pdf_customer_id 17541.0
pdf_customer_name Wildlife Refuge & Sanctuary Silver Wolf Inc.
pdf_customer_addr 600 Doctor S J F Rd. Seguin, TX 78155
customer_state TX
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23502993-aphis-inspection-2016082567958779
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);