Semantic search
citation_inspection
1 row where hash_id = "a7e8c1344d25a352"
This data as json, CSV (advanced)
* Documentation of the last regularly scheduled visit for 26 adult cats by the attending veterinarian could not be found at the time of inspection. Regularly scheduled visits are important to determine if all aspects of animal care (nutrition, health, environment, water, and air quality, etc.) are being provided. The licensee must have regularly scheduled visits by the attending veterinarian. Correct by 10/14/23. This inspection and exit interview were conducted with the licensee. n
| rowid | 38251 |
| desc | Attending veterinarian and adequate veterinary care (dealers and exhibitors). |
| web_siteName | Melissa Morris |
| kind | |
| Incident hash_id | a7e8c1344d25a352 |
| web_inspectionDate | 2023-09-14 |
| code | 2.40(a)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 34.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 507415.0 |
| pdf_customer_name | Melissa Morris |
| pdf_customer_addr | 12240 S Moonlight Road Olathe, KS 66061 |
| customer_state | KS |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/24035544-aphis-inspection-ins-0000892209 |
| 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);