Semantic search
citation_inspection
2 rows where hash_id = "abd83017682d7a9f"
This data as json, CSV (advanced)
* Three dogs (Female chihauhau # 0A01485761, male Yorkshire Terrier # 0A01451779, male Maltese # 101-892-341) all had excessively long toenails that curved around or splayed out to the side and did not allow the dog to stand in a normal manner. Licensee must trim these toenails and ensure that a maintenance program is established and adhered to with regard to toenail trimming. ** To be corrected by: 6/20/14
rowid | 15623 |
desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
web_siteName | JOHN MARRIOTT, SR |
kind | Direct |
Incident hash_id | abd83017682d7a9f |
web_inspectionDate | 2014-06-17 |
code | 2.40(b)(2) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 31.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 17226.0 |
pdf_customer_name | John Marriott Sr. |
pdf_customer_addr | 24435 State Hwy J J Clearmont, MO 64431 |
customer_state | MO |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23502820-aphis-inspection-169141506530129 |
lat | |
lng |
(2) Used primary enclosures and food and water receptacles for dogs and cats must be sanitized at least once every 2 weeks using one of the methods prescribed in paragraph (b)(3) of this section, and more often if necessary to prevent an accumulation of dirt, debris, food waste, excreta, and other disease hazards. * All the enclosures in the two buildings, had a build up of dirt/grime, dust, and cobwebs on the walls, doors and surrounding interior edges of the enclosures.This type of build up can harbor disease hazards, cause soiling of the dogs and does not allow for proper sanitization to occur. Licensee must clean these areas as often as necessary to prevent any type of build up and to allow for sanitization to occur at least once every two weeks to minimize disease hazards. ** To be corrected by: 7/1/14 Inspection and exit interview conducted with facility representative.
rowid | 15624 |
desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
web_siteName | JOHN MARRIOTT, SR |
kind | |
Incident hash_id | abd83017682d7a9f |
web_inspectionDate | 2014-06-17 |
code | 3.11(b)(2) |
repeat | 0 |
pdf_insp_type | ROUTINE INSPECTION |
pdf_animals_total | 31.0 |
web_certType | Class A - Breeder |
pdf_customer_id | 17226.0 |
pdf_customer_name | John Marriott Sr. |
pdf_customer_addr | 24435 State Hwy J J Clearmont, MO 64431 |
customer_state | MO |
pdf_site_id | 001 |
doccloud_url | https://www.documentcloud.org/documents/23502820-aphis-inspection-169141506530129 |
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);