Semantic search
citation_inspection
2 rows where hash_id = "096b77bd2ae15063"
This data as json, CSV (advanced)
Two outdoor kennels housing a total of 4 dogs had exposed wires protruding from the fencing into the kennel at approximately head height to the enclosed animals. Wires and sharp points are a risk of injury to the animals. Licensee must remove or repair all exposed sharp points to help protect the health and welfare of the dogs. Corrected on the spot
| rowid | 32677 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | Lisa D. Fielder |
| kind | |
| Incident hash_id | 096b77bd2ae15063 |
| web_inspectionDate | 2016-01-05 |
| code | 3.1(c)(1)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 76.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 332521.0 |
| pdf_customer_name | Lisa D Fielder |
| pdf_customer_addr | 1236 E Redbud Rd Goldsby, OK 73093 |
| customer_state | OK |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23539141-aphis-inspection-5161500520491 |
| lat | |
| lng |
In the sheltered housing building containing mothers and puppies, the outdoor runs contain a drainage system consisting of a hollow drain pipe covered by metal grating. These pipes are located below the entrances to the interior sheltered areas. In two of the runs, there are gaps present in the metal grating that could potentially lead to injury or entrapment of the animals. The licensee must eliminate these gaps by replacing or repairing the grating, and must maintain these structures to ensure the health and welfare of the regulated animals. Corrected on the spot Inspection and exit interview conducted by Michael Tygart (VMO), Diane Forbes (VMO) and facility representative. Additional Inspectors Forbes Diane, Veterinary Medical Officer
| rowid | 32678 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | Lisa D. Fielder |
| kind | |
| Incident hash_id | 096b77bd2ae15063 |
| web_inspectionDate | 2016-01-05 |
| code | 3.1(f) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 76.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 332521.0 |
| pdf_customer_name | Lisa D Fielder |
| pdf_customer_addr | 1236 E Redbud Rd Goldsby, OK 73093 |
| customer_state | OK |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23539141-aphis-inspection-5161500520491 |
| lat | |
| lng |
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);