This file contains provisional whole fish composite data for sites that were sampled for the National Coastal Condition Assessment in 2020 and 2021. "Preliminary quality reviews of these data have been completed. However, they are not considered to be final until the National Coastal Condition Assessment 2020 & 21 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. " Station location information may be obtained from the Provisional NCCA 2020 SITEINFO File. The UID column may be used to merge NCCA 2020 data files with the SITEINFO file. This file does not include information used to determine the statistical weight for each site. Future updates of this file will include site weights. "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 DEFINITION PUBLICATION_DATE Date the dataset was published to the NARS site UID Unique identifier for the site/visit 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 state and nnnnn is number that starts at 10001. No missing values allowed. Text SITE_ID Site id VISIT_NO |1|2 Visit: 1/2 DATE_COL Date collected ACTUAL_DATE "Date this sample/measurement was taken if different from DATE_COL. If blank, does not apply to this record." PSTL_CODE State (US) or Province (Canada) abbreviation DESIGN_YR Year for which sample draw was designed to occur. NCCA_REG Northeast|Southeast|Gulf|West|Great Lakes| "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. Gulf of Mexico includes the west coast of Florida, Alabama, Mississippi, Louisiana and Texas. West Coast includes Washington, Oregon and California. Great Lakes includes the US shore of all Great Lakes. No missing values allowed." STUDY Study name LAB Lab that conducted analysis MATRIX Material used for analysis ANALYTE "Analyte: for a list of the analytes for this indicator, please see the Laboratory Operation Manual" LAB_ANALYTE Analyte name assigned by lab ANALYTE_LBL EPA name for analyte ANAL_CAT "Analyte parameter group--METAL, Pesticide (PEST), PCB" CAS_NO Chemical Abstract Service Registry Number for analyte NCCA_TRG "Is analyte targeted for EPA analysis? Y = yes, N or = No" SAM_CODE Sample code (Regular/Lab duplicate/Lab split) BATCH_ID Laboratory batch number SAMPLE_ID Sample ID LAB_SAMPLE_ID Sample id assigned by lab PERCENT_MOISTURE Moisture contect of sample (%) PERCENT_LIPID Lipid content (%) RESULT Analytical result MDL Method detection limit RL Lab reporting limit RESULT_UNITS Result unit SPECIES Scientific name (genus and species) of fish specimens 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 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 (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 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 composiste 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. See comment. NARS_COMMENT Comment explaining NARS_FLAG or LAB_COMMENT if necessary CHANGE LOG PROVISIONAL_NCCA20_21_ECOFISH_CONTAMINANT_DATA DATE ACTION 6/17/2022 Initial publication of provisional data to the National Aquatic Resource Surveys Data page.