Semantic search
citation_inspection
4 rows where hash_id = "e82dcaf4bfc58515"
This data as json, CSV (advanced)
The program of veterinary care form that was reviewed today will need to be updated. All the animals on the premise were not documented on this form. The document does not include the use of appropriate methods to prevent, control, diagnose, and treat diseases and injuries, and the availability of emergency, weekend, and holiday care. To ensure that the animals are provided appropriate veterinary care this document needs to be updated. ***To Be Corrected By: October 10, 2016
| rowid | 30066 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | JASON WHITMORE |
| kind | |
| Incident hash_id | e82dcaf4bfc58515 |
| web_inspectionDate | 2016-09-21 |
| code | 2.40(a)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 58.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 329543.0 |
| pdf_customer_name | Jason Whitmore |
| pdf_customer_addr | 35 Daniel Shays Hwy Orange, MA 01364 |
| customer_state | MA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23532420-aphis-inspection-2016082567934063 |
| lat | |
| lng |
While reviewing the records during this inspection, it was noted that they were inaccurate. Eighteen goats were on the premise during inspection, however 19 goats were in the records. Thirteen rabbits were on the premise but only 11 rabbits were noted in the records. All records need to current and accurate. Records will need to be maintained fully and correctly, including records of acquisition, disposition, euthanized or sold. ***To Be Corrected By: October 5, 2016
| rowid | 30067 |
| desc | RECORDS: DEALERS AND EXHIBITORS. |
| web_siteName | JASON WHITMORE |
| kind | |
| Incident hash_id | e82dcaf4bfc58515 |
| web_inspectionDate | 2016-09-21 |
| code | 2.75(a)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 58.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 329543.0 |
| pdf_customer_name | Jason Whitmore |
| pdf_customer_addr | 35 Daniel Shays Hwy Orange, MA 01364 |
| customer_state | MA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23532420-aphis-inspection-2016082567934063 |
| lat | |
| lng |
The chain link fenced gate of the sheep, goats, calf and alpaca primary enclosure was in need of repair. The chain link gate had metal support poles on all four sides. However, the chain link was detaching from the bottom support posts. This is allowing for an approximate 6 inch gap. To ensure that the animals are not injured on the gate and fencing, it should be properly secured. ***To Be Corrected By: September 22, 2016
| rowid | 30068 |
| desc | FACILITIES, GENERAL. |
| web_siteName | JASON WHITMORE |
| kind | |
| Incident hash_id | e82dcaf4bfc58515 |
| web_inspectionDate | 2016-09-21 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 58.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 329543.0 |
| pdf_customer_name | Jason Whitmore |
| pdf_customer_addr | 35 Daniel Shays Hwy Orange, MA 01364 |
| customer_state | MA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23532420-aphis-inspection-2016082567934063 |
| lat | |
| lng |
The refrigerator located in the rabbit and grain storage barn was in need of thorough cleaning. Brown debris and grime were present on interior door and shelves. Due to the fact that medications were being stored in this refrigerator, it is imperative that it be cleaned on a regular basis. ***To Be Corrected By: September 23, 2016 The inspection and exit interview were conducted with the licensee. Additional Inspectors Gowins Jessica, Veterinary Medical Officer
| rowid | 30069 |
| desc | SANITATION. |
| web_siteName | JASON WHITMORE |
| kind | |
| Incident hash_id | e82dcaf4bfc58515 |
| web_inspectionDate | 2016-09-21 |
| code | 3.131(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 58.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 329543.0 |
| pdf_customer_name | Jason Whitmore |
| pdf_customer_addr | 35 Daniel Shays Hwy Orange, MA 01364 |
| customer_state | MA |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23532420-aphis-inspection-2016082567934063 |
| 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);