Semantic search

citation_inspection

Table actions

2 rows where hash_id = "b808ffff4053c61f"

✎ 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

An enclosure containing two pigs and an enclosure containing eight pigs had water receptacles containing a layer of green algae scum with algae floating in the water. The enclosure containing a mini-cow and a goat had a water receptacle with a layer of algae scum lining its interior. The water receptacle for an enclosure containing three pigs had a very small amount of water with mud in it. These water receptacles must be cleaned more frequently. Unclean water could be contaminated with fecal material which could lead to internal parasite problems. It may also not be as palatable which could cause the animals not to consume enough for optimal health. Correct by: 7-2-15

rowid 19655
desc WATERING.
web_siteName CAROL WEAVER
kind  
Incident hash_id b808ffff4053c61f
web_inspectionDate 2015-06-30
code 3.130
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 31.0
web_certType Class C - Exhibitor
pdf_customer_id 32769.0
pdf_customer_name Carol Weaver
pdf_customer_addr 6087 Washburn Road Goodrich, MI 48438
customer_state MI
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23511889-aphis-inspection-181151400200741
lat  
lng  

The shelter for the enclosure housing the mini-cow and the sheep and the shelter for the enclosure housing the zebu each contained an excessive buildup of fecal material. When the animals lay down in these shelters their coats can become contaminated with this fecal material. They can then ingest this material while grooming. Ingestion of fecal material can lead to parasite and disease problems. These shelters must be cleaned on a more frequent basis to prevent possible health issues for the animals using them. Correct by: 7-2-15 Inspection and exit interview conducted with the licensee. Additional Inspectors Kirsten Peter, Supervisory Animal Care Specialist

rowid 19656
desc SANITATION.
web_siteName CAROL WEAVER
kind  
Incident hash_id b808ffff4053c61f
web_inspectionDate 2015-06-30
code 3.131(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 31.0
web_certType Class C - Exhibitor
pdf_customer_id 32769.0
pdf_customer_name Carol Weaver
pdf_customer_addr 6087 Washburn Road Goodrich, MI 48438
customer_state MI
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23511889-aphis-inspection-181151400200741
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);