Semantic search
citation_inspection
1 row where hash_id = "4d090bac2db41ae1"
This data as json, CSV (advanced)
*** At the time of inspection a pen in canine building #3 housed six dogs. The pen measured 58 inches by 50 inches for a total of 20.13 sq ft. The six dogs in the pen require 42.6 sq ft. The facility needs to ensure that animals are provided with the proper amount of space under regulation. Correct from this date An exit interview was conducted with facility personnel on 9/10/14. Additional Inspectors Lopinto John, Veterinary Medical Officer Hadjis Tonya, Supervisory Animal Care Specialist
| rowid | 10863 |
| desc | PRIMARY ENCLOSURES. |
| web_siteName | LIBERTY RESEARCH INC |
| kind | |
| Incident hash_id | 4d090bac2db41ae1 |
| web_inspectionDate | 2014-09-09 |
| code | 3.6(c)(1)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 3698.0 |
| web_certType | Class A - Breeder |
| pdf_customer_id | 6799.0 |
| pdf_customer_name | Liberty Research Inc |
| pdf_customer_addr | P O Box 107, 170 State Rte 17 C Waverly, NY 14892 |
| customer_state | NY |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23493930-aphis-inspection-252141543580408 |
| 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);