Semantic search
citation_inspection
1 row where hash_id = "ee4e75b569c7eb4a"
This data as json, CSV (advanced)
* A facility representative was not available on 2/10/15 at 11:00 AM to do a facility inspection. * Inspector knocked on front door to the house of the licensee. Inspector then honked GOV horn and called telephone number given by licensee. Inspector waited required 30 minute time for licensee to show up. * Copy of inspection report was sent by regular mail. Additional Inspectors Shaver Margaret, Veterinary Medical Officer
| rowid | 14352 |
| desc | ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. |
| web_siteName | ROGER & MARLA CAMPBELL |
| kind | |
| Incident hash_id | ee4e75b569c7eb4a |
| web_inspectionDate | 2015-02-10 |
| code | 2.126(b) |
| repeat | 0 |
| pdf_insp_type | ATTEMPTED INSPECTION |
| pdf_animals_total | 0.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 11720.0 |
| pdf_customer_name | Marla Campbell |
| pdf_customer_addr | Roger Campbell 266 90th Newton, KS 67114 |
| customer_state | KS |
| pdf_site_id | 002 |
| doccloud_url | https://www.documentcloud.org/documents/23499722-aphis-inspection-41151552310195 |
| 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);