Semantic search
citation_inspection
1 row where hash_id = "ef07b42696d9d0f7"
This data as json, CSV (advanced)
***There were at least 10 cages (primary enclosures) in the puppy room housing dogs that were rusted. These rusted surfaces can not be readily cleaned or sanitized and should be repaired or replaced to ensure the health and well-being of the animals. Primary enclosures for dogs must be constructed and maintained so that they enable all surfaces in contact with the dogs to be readily cleaned and sanitized or be replaceable when worn or soiled. Correct by July 1, 2014. The inspection and exit briefing was conducted with the manager.
| rowid | 30183 |
| desc | PRIMARY ENCLOSURES. |
| web_siteName | BEVELLAS PET SHOP |
| kind | |
| Incident hash_id | ef07b42696d9d0f7 |
| web_inspectionDate | 2014-06-17 |
| code | 3.6(a)(2)(9) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 67.0 |
| web_certType | Class B - Dealer |
| pdf_customer_id | 329664.0 |
| pdf_customer_name | Bevellas Pet Shop |
| pdf_customer_addr | 15468 Traweek Rd Northport, AL 35475 |
| customer_state | AL |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23532674-aphis-inspection-168140908068489 |
| 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);