Semantic search
citation_inspection
4 rows where hash_id = "624a1c3bc334b835"
This data as json, CSV (advanced)
The metal fence panels or gates that are temporarily placed in the halls and rooms in ADS to guide the pigs to different locations are not stable. The panels are not attached to the walls and are free standing which allows them to easily be knocked down upon contact. Should pigs be present when they fall they may become injured. The structures shall be secured to protect the pigs from injury. Correct by October 22, 2016.
| rowid | 1308 |
| desc | FACILITIES, GENERAL. |
| web_siteName | UNIVERSITY OF GEORGIA |
| kind | |
| Incident hash_id | 624a1c3bc334b835 |
| web_inspectionDate | 2016-09-21 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 531.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 900.0 |
| pdf_customer_name | University Of Georgia |
| pdf_customer_addr | 212 Tucker Hall 310 East Campus Road Athens, GA 30602 |
| customer_state | GA |
| pdf_site_id | 003 |
| doccloud_url | https://www.documentcloud.org/documents/23475918-aphis-inspection-2016082567933208 |
| lat | 33.9426601 |
| lng | -83.3711367 |
The light over the "maze" in ADS is disconnected. There are three lamp stands used in the area. The light provided by the lamp stands is not sufficient to allow routine inspection and cleaning. Adequate light must be provided. Correct by September 30, 2016.
| rowid | 1309 |
| desc | FACILITIES, GENERAL. |
| web_siteName | UNIVERSITY OF GEORGIA |
| kind | |
| Incident hash_id | 624a1c3bc334b835 |
| web_inspectionDate | 2016-09-21 |
| code | 3.125(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 531.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 900.0 |
| pdf_customer_name | University Of Georgia |
| pdf_customer_addr | 212 Tucker Hall 310 East Campus Road Athens, GA 30602 |
| customer_state | GA |
| pdf_site_id | 003 |
| doccloud_url | https://www.documentcloud.org/documents/23475918-aphis-inspection-2016082567933208 |
| lat | 33.9426601 |
| lng | -83.3711367 |
In the pig housing area in ADS there are large metal automatic feeders. The first feeder to the left upon entering the room has caked, discolored feed on upper inside surfaces. Improper cleaning and sanitization of the feeders may result in food contamination and illness. All feeders shall be cleaned and sanitized using appropriate procedures to prevent contamination and protect the well-being of the pigs. There are large plastic/fiberglass feeders in the dairy side of ADS. The lids on the feeders and the front edges have been repaired with plywood. Plywood is porous and will allow material to become embedded in it. Porous material cannot be completely cleaned and sanitized which may allow the growth of bacteria, mold, etc. causing contamination of the feed. The feeders shall be removed, replaced, or properly repaired to prevent contamination of the feed and protect the health and well-being of the animals. Correct by October 22, 2016.
| rowid | 1310 |
| desc | FEEDING. |
| web_siteName | UNIVERSITY OF GEORGIA |
| kind | |
| Incident hash_id | 624a1c3bc334b835 |
| web_inspectionDate | 2016-09-21 |
| code | 3.129(b) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 531.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 900.0 |
| pdf_customer_name | University Of Georgia |
| pdf_customer_addr | 212 Tucker Hall 310 East Campus Road Athens, GA 30602 |
| customer_state | GA |
| pdf_site_id | 003 |
| doccloud_url | https://www.documentcloud.org/documents/23475918-aphis-inspection-2016082567933208 |
| lat | 33.9426601 |
| lng | -83.3711367 |
The rubber mats placed in the "maze" in Rm 156 are not joined leaving gaps that will allow waste material and water to run through. The mats are covering a slatted concrete floor for drainage but any material passing through these gaps can potentially accumulate on the slats.The mats are hosed down regularly but no chemicals or detergents are used for organic material. The mats shall be moved, cleaned and sanitized to prevent buildup of material under them. Correct by October 22, 2016. This inspection and exit interview were conducted with the Associate VP of Research and Compliance, Director of URAR, Director of Animal Care and the Director of Clinical.
| rowid | 1311 |
| desc | SANITATION. |
| web_siteName | UNIVERSITY OF GEORGIA |
| kind | |
| Incident hash_id | 624a1c3bc334b835 |
| web_inspectionDate | 2016-09-21 |
| code | 3.131(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 531.0 |
| web_certType | Class R - Research Facility |
| pdf_customer_id | 900.0 |
| pdf_customer_name | University Of Georgia |
| pdf_customer_addr | 212 Tucker Hall 310 East Campus Road Athens, GA 30602 |
| customer_state | GA |
| pdf_site_id | 003 |
| doccloud_url | https://www.documentcloud.org/documents/23475918-aphis-inspection-2016082567933208 |
| lat | 33.9426601 |
| lng | -83.3711367 |
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);