home / aphis_reports

Semantic search

citation_inspection

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

6 rows where hash_id = "425835441ae40d5c"

✎ 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 documented veterinary visit was March 30, 2012. The licensees state the attending veterinarian has been out to the facility since that date, but they have not evaluated the dog kennel or the kangaroos. There is currently one kangaroo with severe health complications. Veterinary visits are required in order to ensure the proper health and care of the animals. Licensees with a part-time or consultant veterinarian must have formal arrangements with an attending veterinarian to include regularly scheduled visits to the premises at least annually. To be corrected by: February 4, 2015

rowid 4846
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName BRIAN AND BECKY HABERMAN
kind  
Incident hash_id 425835441ae40d5c
web_inspectionDate 2015-01-21
code 2.40(a)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 29.0
web_certType Class B - Dealer
pdf_customer_id 2857.0
pdf_customer_name Becky Haberman
pdf_customer_addr Brian Haberman 1212 Marks Hill Road Northwood, IA 50459
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23484012-aphis-inspection-21151632190156
lat 43.46618549999999
lng -93.27860969999999

One male red kangaroo, approximately 2 years old, is repeatedly circling to the left with a mild head tilt to the left. Both eyes are moderately protruding from the head. There is a light pink soft tissue structure approximately 1cm in size present at the inside corner of both eyes. Failure to seek medical care for animals showing signs of illness or injury can lead to unnecessary pain and discomfort for the animals or further veterinary complications. The animal listed above must be examined by a licensed veterinarian in order to ensure that an accurate diagnosis is obtained and an appropriate treatment plan is developed and followed. This information, including the diagnosis, treatment and resolution of the condition, must be documented and made available to the inspector upon request. This animal must be evaluated by a veterinarian by 5:00 pm on January 23, 2015.

rowid 4847
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName BRIAN AND BECKY HABERMAN
kind Direct
Incident hash_id 425835441ae40d5c
web_inspectionDate 2015-01-21
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 29.0
web_certType Class B - Dealer
pdf_customer_id 2857.0
pdf_customer_name Becky Haberman
pdf_customer_addr Brian Haberman 1212 Marks Hill Road Northwood, IA 50459
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23484012-aphis-inspection-21151632190156
lat 43.46618549999999
lng -93.27860969999999

There are no acquisition records for four camels and one kangaroo. Complete and accurate records must be kept in order to facilitate tracking/tracing of animals. Records must be made, kept and maintained that fully and correctly disclose information concerning all animals purchased or otherwise acquired, owned, held, leased, transported, sold, euthanized or otherwise disposed of and shall include any offspring born while in the licensees possession.

rowid 4848
desc RECORDS: DEALERS AND EXHIBITORS.
web_siteName BRIAN AND BECKY HABERMAN
kind  
Incident hash_id 425835441ae40d5c
web_inspectionDate 2015-01-21
code 2.75(b)(1)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 29.0
web_certType Class B - Dealer
pdf_customer_id 2857.0
pdf_customer_name Becky Haberman
pdf_customer_addr Brian Haberman 1212 Marks Hill Road Northwood, IA 50459
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23484012-aphis-inspection-21151632190156
lat 43.46618549999999
lng -93.27860969999999

There are four outdoor enclosures that have severely rusted cage doors. The rust is pitted and flaking. On each door, the rust has eroded through the metal surface creating large gaps and holes in the bottom rails on the doors. There are four dogs in the affected enclosures. Rust can affect structural strength and prevents the required cleaning and sanitization of surfaces, which can lead to disease hazards for the dogs. All rusted surfaces that come into contact with the dogs must be repaired or replaced so they can be properly cleaned and sanitized and to ensure structural strength. To be corrected by: February 21, 2015

rowid 4849
desc HOUSING FACILITIES, GENERAL.
web_siteName BRIAN AND BECKY HABERMAN
kind  
Incident hash_id 425835441ae40d5c
web_inspectionDate 2015-01-21
code 3.1(c)(1)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 29.0
web_certType Class B - Dealer
pdf_customer_id 2857.0
pdf_customer_name Becky Haberman
pdf_customer_addr Brian Haberman 1212 Marks Hill Road Northwood, IA 50459
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23484012-aphis-inspection-21151632190156
lat 43.46618549999999
lng -93.27860969999999

In the outdoor housing enclosures containing fifteen dogs, the food or water receptacles are made of hard plastic. These receptacles have been chewed and damaged by the dogs and have a buildup of dirt and grime in them. This buildup of dirt and grime, as well as, damage from chewing does not allow for proper sanitization of the food or water receptacle. All food or water receptacles that cannot be readily cleaned and sanitized must be replaced when worn or soiled. To be corrected by: February 5, 2015

rowid 4850
desc HOUSING FACILITIES, GENERAL.
web_siteName BRIAN AND BECKY HABERMAN
kind  
Incident hash_id 425835441ae40d5c
web_inspectionDate 2015-01-21
code 3.1(c)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 29.0
web_certType Class B - Dealer
pdf_customer_id 2857.0
pdf_customer_name Becky Haberman
pdf_customer_addr Brian Haberman 1212 Marks Hill Road Northwood, IA 50459
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23484012-aphis-inspection-21151632190156
lat 43.46618549999999
lng -93.27860969999999

The shelter in one outdoor enclosure, containing two dogs, does not have a wind and rain break at the entrance. Shelters without wind and rain breaks do not provide the dogs with protection from the elements. All shelters must be provided with a wind and rain break at the entrance in order to provide the dogs with protection from the elements. To be corrected by: January 28, 2015 Inspection and exit briefing conducted with the owner. Additional Inspectors Cole Heather, Supervisory Animal Care Specialist

rowid 4851
desc OUTDOOR HOUSING FACILITIES.
web_siteName BRIAN AND BECKY HABERMAN
kind  
Incident hash_id 425835441ae40d5c
web_inspectionDate 2015-01-21
code 3.4(b)(3)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 29.0
web_certType Class B - Dealer
pdf_customer_id 2857.0
pdf_customer_name Becky Haberman
pdf_customer_addr Brian Haberman 1212 Marks Hill Road Northwood, IA 50459
customer_state IA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23484012-aphis-inspection-21151632190156
lat 43.46618549999999
lng -93.27860969999999

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 2895.502ms