home / aphis_reports

Semantic search

citation_inspection

Table actions
  • Semantic search against this table
  • Semantic search against this table

5 rows where hash_id = "a1fa74ccf9819aa2"

✎ 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

A small, underweight (as compared to its littermates) piglet which during inspection was kept in a separate pen away from its littermates exhibited a labored-type breathing pattern while at rest. Licensee stated that the piglet is not currently being treated for any medical condition and has not been seen by the attending veterinarian. Each dealer or exhibitor must establish and maintain programs of adequate veterinary care that include the use of appropriate methods to prevent, control, diagnose, and treat diseases and injuries and the availability of emergency, weekend, and holiday care. Prompt and appropriate veterinary care must be provided to this piglet. The piglet was seen and treated by a veterinarian before close of business on 09-09-14. Followup care as indicated by the veterinarian must be provided and documented. Correct by 09-10-14 to ensure a system is in place to ensure timely veterinary evaluation and treatment for ill animals.

rowid 17779
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName MARIE DICKENSON
kind Direct
Incident hash_id a1fa74ccf9819aa2
web_inspectionDate 2014-09-09
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 94.0
web_certType Class C - Exhibitor
pdf_customer_id 26518.0
pdf_customer_name Marie Dickenson
pdf_customer_addr 8707 Mesquite Road Phelan, CA 92371
customer_state CA
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/23508089-aphis-inspection-261142015220123
lat  
lng  

Four Guinea pigs were housed in outdoor primary enclosures. This climate is not conducive to housing guinea pigs outdoors as the late spring/summer temperatures frequently exceed 100 degrees F. Guinea pigs must not be housed in outdoor facilities unless the climate is appropriate and only with prior approval from the Regional office. Correct by 09-12-14

rowid 17780
desc FACILITIES, OUTDOOR.
web_siteName MARIE DICKENSON
kind  
Incident hash_id a1fa74ccf9819aa2
web_inspectionDate 2014-09-09
code 3.27(b)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 94.0
web_certType Class C - Exhibitor
pdf_customer_id 26518.0
pdf_customer_name Marie Dickenson
pdf_customer_addr 8707 Mesquite Road Phelan, CA 92371
customer_state CA
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/23508089-aphis-inspection-261142015220123
lat  
lng  

Guinea Pig enclosure- A large number of flies were present on the outside of the primary enclosure. Fly traps were in the area however a more effective pest control system must be implemented and maintained to reduce flies. Correct by 09-16-14

rowid 17781
desc SANITATION.
web_siteName MARIE DICKENSON
kind  
Incident hash_id a1fa74ccf9819aa2
web_inspectionDate 2014-09-09
code 3.31(c)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 94.0
web_certType Class C - Exhibitor
pdf_customer_id 26518.0
pdf_customer_name Marie Dickenson
pdf_customer_addr 8707 Mesquite Road Phelan, CA 92371
customer_state CA
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/23508089-aphis-inspection-261142015220123
lat  
lng  

Sheep/goat pen: In the front area of the pen, fencing at the bottom of the sheep/goat pen had protruding wires sticking out in an approximate 2 foot area of fence. Also, a metal stake was placed in the ground approximately 8-10 inches from a gate entrance to the pen. The gap or opening between the stake and the gate creates enough space in which a goat or sheep could become trapped and/or injured. Pig pen: Wire fencing material with approximately 2 inch gaps was placed on the ground directly in front of a water source. The presence of protruding wires from fencing and inappropriately placed wiring and metal stakes may lead to animals being trapped or injured. These areas must be identified, kept in good repair and maintained to protect the animals and prevent injury to limbs and keep them from being entrapped between fence materials. Correct by 09-19-14

rowid 17782
desc FACILITIES, GENERAL.
web_siteName MARIE DICKENSON
kind  
Incident hash_id a1fa74ccf9819aa2
web_inspectionDate 2014-09-09
code 3.125(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 94.0
web_certType Class C - Exhibitor
pdf_customer_id 26518.0
pdf_customer_name Marie Dickenson
pdf_customer_addr 8707 Mesquite Road Phelan, CA 92371
customer_state CA
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/23508089-aphis-inspection-261142015220123
lat  
lng  

Sheep/goat pen: The rear portion of this enclosure had an excessive build up of excreta. Excreta should be removed as often as necessary to prevent contamination of the animals contained and to reduce disease hazards and reduce odors. The cleaning schedule of the sheep/goat pen should be more effective to prevent the buildup of excreta. Correct by 09-12-14 Exit interview conducted with facility representative. Additional Inspectors Lorang Jeanne, Animal Care Inspector

rowid 17783
desc SANITATION.
web_siteName MARIE DICKENSON
kind  
Incident hash_id a1fa74ccf9819aa2
web_inspectionDate 2014-09-09
code 3.131(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 94.0
web_certType Class C - Exhibitor
pdf_customer_id 26518.0
pdf_customer_name Marie Dickenson
pdf_customer_addr 8707 Mesquite Road Phelan, CA 92371
customer_state CA
pdf_site_id 002
doccloud_url https://www.documentcloud.org/documents/23508089-aphis-inspection-261142015220123
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);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 5950.184ms