Semantic search
citation_inspection
2 rows where hash_id = "dfcab2fa02827e58"
This data as json, CSV (advanced)
The following items are in need of repair or replacement: 1. The wooden trim along the right side of the viewing window has been chewed by the non-human primates. The chewed wooden trim must be replaced to protect the animals from injury and to maintain the window in good repair. 2. One of the fluorescent light fixtures, in the non-human primate enclosure, has detached from the ceiling and is no longer adequately secured. This dangling fixture must be repaired and adequately secured to prevent the fixture from falling and causing injury to the non-human primates housed therein. The above items must be repaired and/or replaced to ensure that the non-human primates are not harmed or injured.
| rowid | 21844 |
| desc | PRIMARY ENCLOSURES. |
| web_siteName | SEAPORT AQUARIUM |
| kind | |
| Incident hash_id | dfcab2fa02827e58 |
| web_inspectionDate | 2014-09-09 |
| code | 3.80(a)(1) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 6.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 40368.0 |
| pdf_customer_name | Seaport Aquarium |
| pdf_customer_addr | 3400 Boardwalk Wildwood, NJ 08260 |
| customer_state | NJ |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23516843-aphis-inspection-252141816400309 |
| lat | |
| lng |
An accumulation of soiled shavings is present on the inside of the clear, plastic cover that protects the dials of an old heating unit. This accumulation must be removed to prevent odors and/or disease hazards within the non-human primate enclosure. ALL OF THE ABOVE ITEMS MUST BE CORRECTED BY: SEPTEMBER 16, 2014 The exit briefing was conducted with the facility representative.
| rowid | 21845 |
| desc | CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. |
| web_siteName | SEAPORT AQUARIUM |
| kind | |
| Incident hash_id | dfcab2fa02827e58 |
| web_inspectionDate | 2014-09-09 |
| code | 3.84(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 6.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 40368.0 |
| pdf_customer_name | Seaport Aquarium |
| pdf_customer_addr | 3400 Boardwalk Wildwood, NJ 08260 |
| customer_state | NJ |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23516843-aphis-inspection-252141816400309 |
| 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);