home / aphis_reports

Semantic search

citation_inspection

Table actions
  • Semantic search against this table
  • Semantic search against this table

2 rows where hash_id = "3b9ca4df4492bf35"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

Water quality records for the AASC pools 1 and 2 housing whales Jetta (Pool 1) and Havana (Pool 2) were reviewed. Both of these whales are under veterinary care. There were multiple instances of consecutive days in December 2021 when the coliform bacteria count of water samples of the pools far exceeded 1,000 MPN. In Pool 1 from 11/30/21 to 12/25/21 (26 days) there were only 6 days where the coliforms were measured under 1000 MPN (3 of those values were in the 900’s) and 5 days of coliform values over 10,000 MPN. In Pool 2 from 11/30/21 until 12/30/21 (31 days) there were 16 days of high coliform counts with values on 4 of those days over 19,000 MPN and only 4 days where the coliform levels were under 1000 MPN During this same time period, there are entries in Havana’s medical record documenting instances of keratitis, blepharospasm, inappetence, GI discomfort, and rubbing the skin of her fluke and rostrum on the sides of the pool. The entry in her medical record for 12/8/21 after consultation with an ophthalmologist, states that “coliform changes may have contributed to keratopathy, so plan to work with the LSS/WQ team (life support system/water quality) to mitigate even small fluctuations”. Per this Section of the Regulations the primary enclosure shall not contain water which would be detrimental to the health of the marine mammal contained therein. Elevated levels of coliforms and other indicators of water quality, such as oxidants in the water, are harmful to marine mammals and may cause irritation to eyes, skin, and the respiratory system.

rowid 70
desc Water quality.
web_siteName Mystic Life Aquarium
kind  
Incident hash_id 3b9ca4df4492bf35
web_inspectionDate 2022-01-10
code 3.106(a)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 31.0
web_certType Class C - Exhibitor
pdf_customer_id 56.0
pdf_customer_name Sea Research Foundation Inc
pdf_customer_addr 55 Coogan Blvd. Mystic, CT 06355
customer_state CT
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470415-aphis-inspection-2016090000775355
lat 41.3732621
lng -71.9535228

**Water quality records for the two AASC pools were reviewed. There were two instances in December 2021 when the coliform bacteria count of water samples for both pools exceeded 1,000 MPN and the next water sample recorded was more than 48 hrs later. The coliform count exceeded 1,000 MPN on 12/16/21 and the next recorded coliform count was 96 hrs later on 12/20/21, and the coliform count exceeded 1,000 MPN on 12/21/21 and the next recorded coliform count was 72 hrs later on 12/24/21. **Coliform tests for AASC Pool 1 conducted on 10/2/21 and 12/5/21, and the coliform test for AASC Pool 2 conducted on 12/4/21 had values of “>24,196” MPN. These results do not reflect the actual coliform bacteria counts because there is a “>” (greater than) sign in front of the number which indicates that the result exceeded the limit of the testing method used. No other testing was done on these dates to determine the actual coliform count. Per this Section of the Regulations, the coliform bacteria count of the primary enclosure pool shall not exceed 1,000 MPN (most probable number) per 100 ml. of water. Should a coliform bacterial count exceed 1,000 MPN, two subsequent samples may be taken at 48-hour intervals and averaged with the first sample. If such average count does not fall below 1,000 MPN, then the water in the pool shall be deemed unsatisfactory, and the condition must be corrected immediately. Correct from this date 1/14/22 forward. This inspection was conducted with facility representatives on 1/10/22. The exit briefing was held 1/14/22 with facility representatives. *END OF REPORT* Additional Inspectors: Tonya Hadjis, Supervisory Animal Care SpecialistEnd Section

rowid 71
desc Water quality.
web_siteName Mystic Life Aquarium
kind  
Incident hash_id 3b9ca4df4492bf35
web_inspectionDate 2022-01-10
code 3.106(b)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 31.0
web_certType Class C - Exhibitor
pdf_customer_id 56.0
pdf_customer_name Sea Research Foundation Inc
pdf_customer_addr 55 Coogan Blvd. Mystic, CT 06355
customer_state CT
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470415-aphis-inspection-2016090000775355
lat 41.3732621
lng -71.9535228

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 3864.142ms