"This file contains whole fish contaminant data for samples collected at estuarine and Great Lakes sites that were sampled for the National Coastal Condition Assessment in 2020, 2021 and 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 note: Station information (sampling coordinates, site depth, etc.) may be imported from the Site Information files." """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_NAME Legal Values Description PUBLICATION_DATE Date the dataset was published by NARS IM 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. 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. 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 |1|2 "Sequential visit in each year, typically 1 or 2." DATE_COL mm/dd/yyyy Date Collected mm/dd/yyyy ACTUAL_DATE mm/dd/yyyy Actual date of fish sample collection if different from waer and sediment collection date. 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 Northeast|Southeast|Gulf|West|Great Lakes|Pacific "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 Code for name of laboratory that anayzed the sample MATRIX Material used for analysis ANALYTE Analyte LAB_ANALYTE Analyte name assigned by lab; may be blank ANALYTE_LBL EPA name for analyte ANAL_CAT "Analyte parameter group--METAL, Pesticide (PEST), PCB, PAH (if measured)" CAS_NO CAS Registry Number NCCA_TRG "Is analyte targeted for EPA analysis? Y = yes, N or = No" SAM_CODE "Sample code (Regular or QA sample type). Posted data include only regular sample results. For access to QAQC sample results, please contact the NCCA Lead." BATCH_ID Laboratory batch number SAMPLE_ID Number identifying the sample LAB_SAMPLE_ID Sample id assigned by lab (may be blank) MOISTURE Moisture content of sample (%) LIPIDS Percent lipids in sample (%) RESULT Analytical result MDL Method detection limit RL Lab reporting limit RESULT_UNITS Result unit NAME_SCI Scientific name of fish MIN_FISH_LEN Length of shortest fish in the composite (mm) MAX_FISH_LEN Length of longest fish in the composite (mm) DILUTION Dilution factor (if required to analyze sample) HOLDING_TIME Time between sampling and analysis (days) HOLDING_TIME_UNITS Units of holding time (DAYS) ARRIVAL_TEMP Temperature upon arrival at lab in degrees C DATE_PREPARED "Date sampled prepared for analysis, if different from DATE_ANALYZED" 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; Q = other quality concern not otherwise noted. See comment." DATE_ANALYZED Date sample analyzed by lab METHOD Analytical method used to derive result INSTRUMENT Instrument Id for instrument used to analyze sample FISH_CODE Code used to describe composite sample upon arrival at lab. SP = not all specimens are of the same species; LE = Nat all specimen lengths are within 75% of longest fish; NS = Specimen number is fewer than minimum of 5 or great than maximum of 20; WT = Mass of all specimens combined does not meet minimum of 500 grams; LL = Longest fish exceeds 400 mm Maximum length; LS = shortest fish is below 100 mm minimum length; Q = other fish composite quality concern not identified above. NUMBER_FISH Number of fish in composite SAMPLE_CLASS Routine or non-routine; see FISH_CODES for descriptions of any non-routine composites SAMPLE_WT Total mass of all specimens in composite used for analysis NARS_FLAG NARS flag. ND = Nondetect; H = holding time issue; S = shipping issue; L = Less than reporting limit but above MDL; Q = other quality issue; NR = Result not reported for analyte by lab. See comment. NARS_COMMENT Comment explaining NARS_FLAG or LAB_COMMENT if necessary Changelog Publication Date Of Most recent File Posted to NARS Data Page Change 5/9/2024 Initial publication 10/25/2024 Data file refresh to update values for multiple variables