Semantic search
citation_inspection
4 rows where hash_id = "d7c8816cd12001f1"
This data as json, CSV (advanced)
*** There were two open bags of food being stored on the ground in the sheltered building. Per this regulation, all open supplies of food must be kept in leak proof container with tightly fitting lids to prevent contamination and spoilage. This needs to be addressed for the health of the dogs. Correct by: Jan 24, 2015
| rowid | 28691 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | Classy Creations |
| kind | |
| Incident hash_id | d7c8816cd12001f1 |
| web_inspectionDate | 2015-01-21 |
| code | 3.1(e) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 281.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 327879.0 |
| pdf_customer_name | Classy Creations |
| pdf_customer_addr | Po Box 194 Lyons, NY 14489 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23529752-aphis-inspection-22151411290988 |
| lat | |
| lng |
*** There was an accumulation of feces on the wire mesh that is not falling through in the outside runs of the sheltered building. The licensee's have not been cleaning the area due to cold weather. This area needs to be cleaned on a daily basis to prevent the dogs from becoming soiled. In addition the area underneath the mesh had an accumulation of feces and a very strong odor was all around the area. Correct by: Jan 23, 2015
| rowid | 28692 |
| desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
| web_siteName | Classy Creations |
| kind | |
| Incident hash_id | d7c8816cd12001f1 |
| web_inspectionDate | 2015-01-21 |
| code | 3.11(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 281.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 327879.0 |
| pdf_customer_name | Classy Creations |
| pdf_customer_addr | Po Box 194 Lyons, NY 14489 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23529752-aphis-inspection-22151411290988 |
| lat | |
| lng |
*** Many of the feeders had a layer of grime and debris underneath the lip of the feeder and a layer of dust on top of the feeders. The feeders were last cleaned 3 weeks ago according to records. Per these regulations, the feeders need to be cleaned at least once every two 2 weeks to prevent this buildup of grime for the health of the dogs.
| rowid | 28693 |
| desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
| web_siteName | Classy Creations |
| kind | |
| Incident hash_id | d7c8816cd12001f1 |
| web_inspectionDate | 2015-01-21 |
| code | 3.11(b)(2) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 281.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 327879.0 |
| pdf_customer_name | Classy Creations |
| pdf_customer_addr | Po Box 194 Lyons, NY 14489 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23529752-aphis-inspection-22151411290988 |
| lat | |
| lng |
*** There was a lot of clutter in the sheltered building with nails and dust on the window ledges, there were excess bags and items in and around the sink area and excess items in empty enclosures. These items need to be discarded and the building kept clean to promote good housekeeping practices. An exit briefing was conducted with the licensee at the time of the inspection.
| rowid | 28694 |
| desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
| web_siteName | Classy Creations |
| kind | |
| Incident hash_id | d7c8816cd12001f1 |
| web_inspectionDate | 2015-01-21 |
| code | 3.11(c) |
| repeat | 1 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 281.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 327879.0 |
| pdf_customer_name | Classy Creations |
| pdf_customer_addr | Po Box 194 Lyons, NY 14489 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23529752-aphis-inspection-22151411290988 |
| 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);