Semantic search
citation_inspection
4 rows where hash_id = "302727606eb44cd8"
This data as json, CSV (advanced)
Records were unable to be located and were not inspected. Records should be allowed to be examined by APHIS personnel that are required to be kept by the Act and the regulations. To be corrected from this day forward.
| rowid | 17237 |
| desc | ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. |
| web_siteName | Patricia Bingham |
| kind | |
| Incident hash_id | 302727606eb44cd8 |
| web_inspectionDate | 2014-08-20 |
| code | 2.126(a)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 35.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 25357.0 |
| pdf_customer_name | Patricia Bingham |
| pdf_customer_addr | P. O. Box 1611 Alvin, TX 77512 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23506599-aphis-inspection-233140937500806 |
| lat | |
| lng |
Surfaces In the garage, containing the cat enclosures, there is excessive rust throughout the chain link fencing of the 11 cat enclosures. There is excessive rust at the bottom of the chain link posts and in the bottom corners of each enclosure. All areas that come in contact with the animals must be free of excessive rust that affects the sanitation and structural strength of the surfaces. To be corrected by November 20, 2014
| rowid | 17238 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | Patricia Bingham |
| kind | |
| Incident hash_id | 302727606eb44cd8 |
| web_inspectionDate | 2014-08-20 |
| code | 3.1(c)(1)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 35.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 25357.0 |
| pdf_customer_name | Patricia Bingham |
| pdf_customer_addr | P. O. Box 1611 Alvin, TX 77512 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23506599-aphis-inspection-233140937500806 |
| lat | |
| lng |
Maintenance and replacement of surfaces. In the cattery, inside the house, the enclosure containing the cat named "Chocolate Chunky", the tile flooring has peeled away from the wood surface exposing the wood surface. All surfaces must be maintained on a regular basis or replaced when worn or soiled. The housing facility must be constructed such that it can be readily cleaned and sanitized. To be corrected by September 20, 2014
| rowid | 17239 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | Patricia Bingham |
| kind | |
| Incident hash_id | 302727606eb44cd8 |
| web_inspectionDate | 2014-08-20 |
| code | 3.1(c)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 35.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 25357.0 |
| pdf_customer_name | Patricia Bingham |
| pdf_customer_addr | P. O. Box 1611 Alvin, TX 77512 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23506599-aphis-inspection-233140937500806 |
| lat | |
| lng |
Resting Surfaces In the garage, containing the cat kennels, the paint has chipped away exposing the wood surface to moisture on the top and edges of the resting surface in kennel 5 containing three adult cats. The resting surfaces need to be impervious to moisture and be easily cleaned and sanitized when soiled or worn. To be corrected by November 20, 2014. Inspection and exit interview was conducted by APHIS personnel with facility representative.
| rowid | 17240 |
| desc | PRIMARY ENCLOSURES. |
| web_siteName | Patricia Bingham |
| kind | |
| Incident hash_id | 302727606eb44cd8 |
| web_inspectionDate | 2014-08-20 |
| code | 3.6(b)(4) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 35.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 25357.0 |
| pdf_customer_name | Patricia Bingham |
| pdf_customer_addr | P. O. Box 1611 Alvin, TX 77512 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23506599-aphis-inspection-233140937500806 |
| 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);