Semantic search
citation_inspection
3 rows where hash_id = "70f2b6df16a76c73"
This data as json, CSV (advanced)
*** The puppy room was 87.4 degree F according to the handheld kestrel reader. The windows were open but there was no fan running and no method available to sufficiently cool the room down. This needs to be addressed for the health of the animals. Correct by: June 21, 2014
| rowid | 28293 |
| desc | INDOOR HOUSING FACILITIES. |
| web_siteName | Crestwood Acres |
| kind | |
| Incident hash_id | 70f2b6df16a76c73 |
| web_inspectionDate | 2014-06-17 |
| code | 3.2(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 147.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 327313.0 |
| pdf_customer_name | Crestwood Acres |
| pdf_customer_addr | P O Box 198 Lyons, NY 14489 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23528944-aphis-inspection-169141955310473 |
| lat | |
| lng |
The walls in the puppy room have paint that is chipping and flaking off. The wall needs to have a fresh coat of paint to keep the room impervious to moisture and so the room can be effectively cleaned and sanitized. Correct by: July 18, 2014
| rowid | 28294 |
| desc | INDOOR HOUSING FACILITIES. |
| web_siteName | Crestwood Acres |
| kind | |
| Incident hash_id | 70f2b6df16a76c73 |
| web_inspectionDate | 2014-06-17 |
| code | 3.2(d) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 147.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 327313.0 |
| pdf_customer_name | Crestwood Acres |
| pdf_customer_addr | P O Box 198 Lyons, NY 14489 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23528944-aphis-inspection-169141955310473 |
| lat | |
| lng |
*** A few of the whelping boxes had an accumulation of dirt and debris along the walls. These boxes need to be cleaned more often between the routine sanitization cleanings to prevent this accumulation. This needs to be addressed for the health of the dogs. Correct by: June 23, 2014 An exit briefing was done with the licensee at the time of the inspection
| rowid | 28295 |
| desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
| web_siteName | Crestwood Acres |
| kind | |
| Incident hash_id | 70f2b6df16a76c73 |
| web_inspectionDate | 2014-06-17 |
| code | 3.11(b)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 147.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 327313.0 |
| pdf_customer_name | Crestwood Acres |
| pdf_customer_addr | P O Box 198 Lyons, NY 14489 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23528944-aphis-inspection-169141955310473 |
| 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);