Semantic search

citation_inspection

Table actions

1 row where hash_id = "a972375226fdb5f0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: web_inspectionDate (date)

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 was a large number of bees present throughout the facility affecting several animal enclosures. The facility representative stated that a general pest control company has attempted to control the bees but there has been no effect at reducing or eliminating their numbers. Insects such as bees may pose a health risk to the animals through stings or possible allergic reactions. Additionally insects may present health risks by contaminating food sources. Adequate control of insects and other pests is needed to protect the well-being of the animals and to reduce contamination and potential disease hazards. An effective program of pest control must be established and maintained. Correct by 10/10/2016. This inspection and exit interview were conducted with a facility representative.

rowid 6852
desc SANITATION.
web_siteName BIG BEAR ALPINE ZOO
kind  
Incident hash_id a972375226fdb5f0
web_inspectionDate 2016-09-21
code 3.131(d)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 58.0
web_certType Class C - Exhibitor
pdf_customer_id 3553.0
pdf_customer_name Big Bear Alpine Zoo
pdf_customer_addr P.O. Box 2832 Big Bear Lake, CA 92315
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23486961-aphis-inspection-2016082567938328
lat 34.2428813
lng -116.9087014

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