This file contains mercury in fish fillet plug tissue sample results for sites that were sampled for the National Coastal Condition Assessment in 2020, 2021 & 2022. Data have been thoroughly reviewed, however they are not considered final until the NCCA Report is published. Data may be updated at any time. The changelog for the associated file may be found below the column name definitions. End-users are responsible for reviewing the suitability of these data for their purposes. """Please bring any questions about the data to the attention of Hugh Sullivan, NCCA Lead at sullivan.hugh@epa.gov. "" " """For information about NCCA protocols, please check the NCCA 2020 Field Operations Manual, Site Evaluation Guidelines; Lab Operations Manual, and Quality Assurance Project Plan on the NCCA Website: https://www.epa.gov/national-aquatic-resource-surveys/manuals-used-national-aquatic-resource-surveys#National%20Coastal%20Condition%20Assessment"" " COLUMN_HEADING DESCRIPTION PUBLICATION_DATE Date the dataset was published by NARS IM UNIQUE_ID Unique site ID based on location. Does not depend on year sampled or any other factor. Follows a unique site through multiple survey designs. Form is NCA_ss_nnnnn where ss is state/territory and nnnnn is number that starts at 10001. No missing values allowed. Text UID Unique identifier for a single sampling event at a site/visit. Use the UID to associate data in the NCCA site info files with information included in this file. SITE_ID "NCCA Site ID for the study and year sampled. Preferred form is NCAnn_MM-xxxxx where nn is survey cycle year (05, 10, 15, 20, etc), MM is two letter state code, and xxxxx is between 10001 and 99999. No missing values allowed. No missing values allowed." VISIT_NO Visit: 1/2 DATE_COL Date Collected mm/dd/yyyy ACTUAL_DATE Actulal date that fish were collected if different from date the rest of the samples were collected. PSTL_CODE "State two letter postal code for site sampled. 50 state postal codes plus (if applicable) AS, MP, GU, PR, VI for American Samoa, Commonwealth of Northern Marianas, Guam, Puerto Rico and Virgin Islands. No missing values allowed." WTBDY_TYPE Marine or Great Lakes NCCA_REG "National Coastal Condition Assessment Region. Northeast includes states ME, NH, MA, RI, CT, NY, NJ, MD, DE, and VA. Southeast includes NC, SC, GA, and east coast of FL. No missing values allowed." LAB Lab that conducted analysis SAMPLE_TYPE Code identifying sample type MATRIX """Material used for analysis (WATER, SEDIMENT, or TISSUE)" ANALYTE Analyte name (Mercury) SAM_CODE ample code (Regular/Lab duplicate/Lab split) CAS_NO Chemical Abstract Service Registry Number for analyte. BATCH_ID Laboratory batch number SAMPLE_ID NCCA Sample ID LAB_SAMPLE_ID Sample id assigned by lab RESULT Analytical result RESULT_UNITS Result unit MDL Method Detection limit RL Laboratory reporting limit HOLDING_TIME Time between sampling and analysis (days). See Laboratory operations manual for required holding time for each analyte. DILUTION Dilution factor if sample needed to be diluted for analysis ARRIVAL_TEMP Temperature upon arrival at lab CONDITION_CODE "Condition of sample upon arrival at lab; Legal values are: OK = Sample is in good condition, C = Sample container is cracked, L = Sample container is leaking, ML = Sample Label is missing, NF = Sample is not frozen (for samples shipped frozen), W = Sample is warm (fish plug samples analyzed for mercury are considered warm if they are > 8 ?C upon arrival); Q = other quality concern not otherwise noted. See comment." DATE_ANALYZED mm/dd/yyyy Date sample analyzed by lab METHOD Method used to determine reported result. INSTRUMENT Instrument Id for instrument used to analyze sample CONDITION_COMMENT "Comment explaining NARS_FLAG or other qualifying information, if applicable." FROM_FTIS ish fillet plug sample was collected from specimen submitted for the whole fish contaminant indicator. NAME_SCI Genus and species of fish specimen from which the fish fillet plug sample was submitted for analysis. For a list of target species please see the NCCA 2020 Field Operations Manual: https://www.epa.gov/national-aquatic-resource-surveys/national-coastal-condition-assessment-2020-manuals LENGTH_1 """Length (in mm) of first fish specimen from which a fish fillet plug sample was collected. Length is measured from the anterior-most part of the fish to the tip of the longest caudal fin ray (when the lobes of the caudal fin are depressed dorsoventrally). If only one target fish was collected, one plug is take from each side of the fish and a second fish is not recorded.""" LENGTH_2 """Length (in mm) of second fish (if applicable) from which first fish fillet plug sample was collected. Length is measured from the anterior-most part of the fish to the tip of the longest caudal fin ray (when the lobes of the caudal fin are depressed dorsoventrally). If only one target fish was collected, one plug is take from each side of the fish and a second fish is not recorded.""" WEIGHT_1 """Mass (in grams ) first fish specimen from which a fish fillet plug sample was collected. If only one target fish was collected, one plug is take from each side of the fish and a second fish is not recorded.""" WEIGHT_2 """Mass (in grams ) of second fish specimen from which a fish fillet plug sample was collected. If only one target fish was collected, one plug is take from each side of the fish and a second fish is not recorded" NARS_FLAG NARS flag. ND = Nondetect; H = holding time issue (holding times for each analyte may be found in the Laboratory Operation Manual https://www.epa.gov/national-aquatic-resource-surveys/national-coastal-condition-assessment-2020-manuals); S = shipping issue; L = Less than reporting limit but above MDL; Q = other quality issue. See comment. NARS_COMMENT """Comment explaining NARS_FLAG or other qualifying information, if applicable.""" Changelog Publication Date Of Most recent File Posted to NARS Data Page Change 5/3/2024 Complete republication of data. Supercedes all previous copies. 5/9/2024 Rev_1 Insert LAT_DD and LON_DD 11/26/2024 file refresh to update values for multiple variables. removed LAT_DD and LON_DD coordinates