Semantic search
citation_inspection
2 rows where hash_id = "b0c2da223753f77b"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
*** The facility had recently acquired several puppies from other licensed facilities. The plastic collar on a few litters only listed the breed of puppy. The collars did not list the required info in 2.51 including the licensed facility number where the dogs originated from, sex of the dog or individual identifying number. This information is an important part of the identification and recordkeeping requirement and needs to be addressed to track the movement of puppies. Correct by: Feb 14, 2015
| rowid | 19610 |
| desc | TIME AND METHOD OF IDENTIFICATION. |
| web_siteName | WAYNE SENSENIG |
| kind | |
| Incident hash_id | b0c2da223753f77b |
| web_inspectionDate | 2015-02-10 |
| code | 2.50(b)(3)(3) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 94.0 |
| web_certType | Class B - Dealer |
| pdf_customer_id | 32718.0 |
| pdf_customer_name | Wayne Sensenig |
| pdf_customer_addr | 1714 Porters Corners Rd Dundee, NY 14837 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23511843-aphis-inspection-43151357450061 |
| lat | |
| lng |
*** A few of the shelter boxes had feces in the boxes that were not being checked and removed daily. Fecal and food waste must be removed daily from primary enclosures to prevent the dogs from becoming soiled. This needs to be addressed and the boxes spot cleaned daily for the health of the dogs. Corrected at the time of inspection and from this day forward. An exit briefing was conducted with the licensee at the time of the inspection.
| rowid | 19611 |
| desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
| web_siteName | WAYNE SENSENIG |
| kind | |
| Incident hash_id | b0c2da223753f77b |
| web_inspectionDate | 2015-02-10 |
| code | 3.11(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 94.0 |
| web_certType | Class B - Dealer |
| pdf_customer_id | 32718.0 |
| pdf_customer_name | Wayne Sensenig |
| pdf_customer_addr | 1714 Porters Corners Rd Dundee, NY 14837 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23511843-aphis-inspection-43151357450061 |
| 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);