"This file contains data about estuarine and Great Lakes 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. """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"" " 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. "" COLUMN HEADING DESCRIPTION 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 that does not depend on year sampled or any other factor. Form is NCA_ss_nnnnn where ss state and nnnnn is number that starts at 10001. No missing values allowed. Text WTBDY_TYPE MARINE|GREAT_LAKES "Waterbody type, based on VALXSITE from verification form" 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." SITE_ID NCCA Site ID for the study and year sampled VISIT_NO "Sequential visit in each year, typically 1 or 2." DATE_COL Date samples were collected at the site. Use ACTUAL_DATE column for collection date of individual sample types. PSTL_CODE "State two letter postal code for site sampled. 50 state postal codes plus AS, MP, GU, PR, VI for American Samoa, Commonwealth of Northern Marianas, Guam, Puerto Rico and Virgin Islands. No missing values allowed." LAB Code for laboratory used to analyze sample SAMPLE_TYPE Code identifying sample type MATRIX Material used for analysis ANALYTE Analyte LAB_ANALYTE Analyte name assigned by lab ANALYTE_LBL EPA name for analyte LAB_ANALYTE Analyte name assigned by lab ANAL_CAT "Analyte parameter group--METAL, Pesticide (PEST), PCB, PAH (if measured)" 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 Number identifying the sample LAB_SAMPLE_ID Sample id assigned by lab RESULT Analytical result MDL Method detection limit RL Lab reporting limit RESULT_UNITS Result unit MOISTURE Moisture content of sample (%) DILUTION Dilution factor required to analyze sample HOLDING_TIME Time between sampling and analysis (days) RECOVERY Percent recovery of spike in blank or matrix ARRIVAL_TEMP Temperature upon arrival at lab in degrees C. 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 (for microcystin warm is > 8 deg C); Q = other quality concern not otherwise noted. see comment." DATE_ANALYZED Date sample analyzed by lab METHOD Method used to determine reported result INSTRUMENT Instrument Id for instrument used to analyze sample 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 NARS_COMMENT. NARS_COMMENT "Comment explaining NARS_FLAG or other qualifying information, if applicable." Changelog Date Change 09/17/2024 Initial publication