Semantic search
citation_inspection
1 row where hash_id = "50a7d5fead3e63d8"
This data as json, CSV (advanced)
Cleaning. * There is an accumulation of grime, dirt, dust and cobwebs on the doors and walls of the enclosures and feeders in the general building housing 19 dogs. These areas of organic matter can harbor disease organisms and cause illness in the dogs. Licensee must ensure that all surfaces of the housing facility are cleaned, sanitized and maintained to satisfy general husbandry standards and for the overall health of the dogs. * To be corrected by: 9/1/15 Inspection and exit interview conducted with facility representative and MDA personnel.
| rowid | 22459 |
| desc | HOUSING FACILITIES, GENERAL. |
| web_siteName | JUDITH A. BOWER |
| kind | |
| Incident hash_id | 50a7d5fead3e63d8 |
| web_inspectionDate | 2015-08-18 |
| code | 3.1(c)(3) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 47.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 42206.0 |
| pdf_customer_name | Judith A Bower |
| pdf_customer_addr | 1181 S E 10th St. Laredo, MO 64652 |
| customer_state | MO |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23518159-aphis-inspection-230151108560416 |
| 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);