Semantic search
citation_inspection
2 rows where hash_id = "69c1bad9e5cd8df0"
This data as json, CSV (advanced)
Sow #1257 in the North Gestation barn that had a very large abscess approximately 10 inches in diameter on the upper right shoulder/right side of neck area. The skin was dark red and irritated, tight due to the pressure of the puss below the skin where there were scabby portions of skin through the center of the large lump. The abscess on the sow has not been treated and the veterinarian has not been contacted in regards to treatment at this time. It is important that all illnesses, injuries or health issues are identified, treated and communicated to the veterinarian for treatment protocols. The licensee must be vigilant in observing health issues early in order to decrease the level of pain and discomfort to the animal and to keep a minimal issue from becoming a major condition. The licensee must provide immediate care and treatment in conjunction with their veterinarians recommendations as soon as issues have been identified. The licensee drained, cleaned and medicated the sow and the abscess before the end of the inspection.
rowid | 7529 |
desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
web_siteName | EUGENE BURKHOLDER |
kind | |
Incident hash_id | 69c1bad9e5cd8df0 |
web_inspectionDate | 2014-06-17 |
code | 2.40(b)(2) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 2150.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 3867.0 |
pdf_customer_name | Eugene G Burkholder |
pdf_customer_addr | 21434 Oak Hill Road Ewing, IL 62836 |
customer_state | IL |
pdf_site_id | 003 |
doccloud_url | https://www.documentcloud.org/documents/23488290-aphis-inspection-135141228020920 |
lat | 38.1131132 |
lng | -88.76352609999999 |
There was a female sow #1257 that had an extremely large abscess approximately 5 inches long (approx. 10inches in diameter) on the right side of the neck/top front shoulder area under the back of the jaw line. The skin was dark red and pulled tight due to the pressure of the infection, with scab material running the length of the abscess. It took several days for the abscess to get to this size and it had not been observed or treated by the facility until it was identified during this inspection. It is important that all illnesses, injuries or health issues are identified, treated and communicated to the veterinarian in a timely manner in order to prevent prolonged discomfort or pain to the regulated animals and to prevent a treatable issue from becoming a chronic untreatable condition. The licensee must conduct daily observations of all regulated animals and identify health issues in a timely manner and contact the veterinarian for proper diagnosis and treatment of health issues. The abscess had been lanced, cleaned and treated by the manager before the end of this inspection. This sow was put on the treatment records for the facility for proper follow up treatment until the issue is resolved. Inspection and exit interview conducted with facility representative.
rowid | 7530 |
desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
web_siteName | EUGENE BURKHOLDER |
kind | |
Incident hash_id | 69c1bad9e5cd8df0 |
web_inspectionDate | 2014-06-17 |
code | 2.40(b)(3) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 2150.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 3867.0 |
pdf_customer_name | Eugene G Burkholder |
pdf_customer_addr | 21434 Oak Hill Road Ewing, IL 62836 |
customer_state | IL |
pdf_site_id | 003 |
doccloud_url | https://www.documentcloud.org/documents/23488290-aphis-inspection-135141228020920 |
lat | 38.1131132 |
lng | -88.76352609999999 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);