Synthesis of Environmental Mercury Loads in New York State (1969-2017): Biotic Samples
data.ny.gov | Last Updated 1 Jul 2024This dataset includes information from a statewide synthesis effort, involving the compilation, analysis, and synthesis of existing data on environmental mercury (Hg) concentrations and loads in New York State, with an emphasis on Hg data collected during recent NYSERDA-sponsored monitoring and research efforts. Compiling existing mercury data is a vital step to understanding the broad spatial and temporal patterns of mercury across the landscape. This dataset includes information about biotic samples used as part of this analysis and is one of eight datasets from the statewide synthesis database. The New York State Energy Research and Development Authority (NYSERDA) offers objective information and analysis, innovative programs, technical expertise, and support to help New Yorkers increase energy efficiency, save money, use renewable energy, and accelerate economic growth. reduce reliance on fossil fuels. To learn more about NYSERDA’s programs, visit nyserda.ny.gov or follow us on X, Facebook, YouTube, or Instagram.
This dataset has the following 43 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| SAMPLE_ID | sample_id | text | Unique sample identifier | NY019-NY076-NYT275-40.84072-72.56262-2010-C0465-WhlTHgww NY002-NY-RAMAPO RIVER-41.28988-74.141168-2001-C14531-MusTHg NY002-NY-FERRIS LAKE-43.306546-74.631649-2003-C02958-MusTHg NY001-050684NYT463-43.97657-74.22887-06262017-C6699-TlFeTHg NY002-NY-Blue Mtn Lake-43.867714-74.458259-2005-C00983-MusTHg view top 100 |
| Capture_Event | capture_event | text | Unique spatial and temporal collection point identifier | NY007-LAKE ONTARIO-43.24284-77.57426-1970 NY002-NY-LAKE CHAMPLAIN-43.857543-73.382017-1970 NY002-NY-ONONDAGA LAKE-43.114868-76.243313-1985 NY007-LAKE ONTARIO-43.36773-78.19168-1970 NY008-LAKE ONTARIO-43.32030-78.83030-1994 view top 100 |
| Capture_Loc | capture_loc | text | Unique spatial collection point identifier | NY002-NY-ONONDAGA LAKE-43.096508-76.203633 NY002-NY-ONONDAGA LAKE-43.092593-76.207685 NY020-ONONDAGA LAKE IN GENERAL-43.09259-76.20769 NY002-NY-SALMON RIVER H-43.509907-75.995517 NY002-NY-ONONDAGA LAKE-43.114868-76.243313 view top 100 |
| Latitude | latitude | number | Latitude of data collection point. Blank cells represent data that were not required or are not currently available. | 43.096508 43.092593 43.09259 43.509907 43.114868 view top 100 |
| Longitude | longitude | number | Longitude of data collection point. Blank cells represent data that were not required or are not currently available. | -76.203633 -76.207685 -76.20769 -75.995517 -76.243313 view top 100 |
| Project_ID | project_id | text | Unique project identifier | NY002 NY020 NY001 NY007 NY005 view top 100 |
| Waterbody_Type | waterbody_type | text | Type of water body data was collected from (ex. Canal, river, lake etc.). Blank cells represent data that were not required or are not currently available. | Lake Stream Reservoir River Land view top 100 |
| BDate | bdate | calendar_date | Date of sample collection | 2009-09-30T00:00:00.000 1970-08-18T00:00:00.000 2009-09-29T00:00:00.000 1998-06-17T00:00:00.000 1998-06-01T00:00:00.000 view top 100 |
| Subject | subject | text | Subject of the sample. Either Amphibian, Bird, Bivalve, Crustacean, Fish, Invertebrate (Invert), Mammal, Mollusk, Reptile, or Unknown. | Fish Bird Invert Mammal Crustacean view top 100 |
| N | n | number | Number of samples collected | 1 view top 100 |
| Org_Spp_Code | org_spp_code | text | Code for common name of organism sampled as originally reported by the researcher. Blank cells represent data that were not required or are not currently available. | SMB YP LMB LT WEYE view top 100 |
| Org_Spp_Common | org_spp_common | text | Common name of organism sampled as originally reported by the researcher. Blank cells represent data that were not required or are not currently available. | Yellow perch Smallmouth bass Largemouth bass Lake trout Walleye view top 100 |
| TSN | tsn | text | Taxonomic Serial Number as reported in the Integrated Taxonomic Information System. | 168469 550562 168160 162002 650173 view top 100 |
| Superclass | superclass | text | Superclass of organism sampled as reported in the Integrated Taxonomic Information System; either Actinopterygii or Tetrapoda. Blank cells represent data that were not required or are not currently available. | Actinopterygii Tetrapoda view top 100 |
| Class | class | text | Class of organism sampled as reported in the Integrated Taxonomic Information System. Blank cells represent data that were not required or are not currently available. | Teleostei Aves Mammalia Arachnida Insecta view top 100 |
| Subclass | subclass | text | Subclass of organism sampled as reported in the Integrated Taxonomic Information System. Blank cells represent data that were not required or are not currently available. | Theria Pterygota Eumalacostraca Pteriomorphia Heterodonta view top 100 |
| Order | order | text | Order of organism sampled as reported in the Integrated Taxonomic Information System. Blank cells represent data that were not required or are not currently available. | Perciformes Passeriformes Salmoniformes Cypriniformes Siluriformes view top 100 |
| Family | family | text | Family of organism sampled as reported in the Integrated Taxonomic Information System. Blank cells represent data that were not required or are not currently available. | Centrarchidae Percidae Salmonidae Emberizidae Cyprinidae view top 100 |
| Genus | genus | text | Genus of organism sampled as reported in the Integrated Taxonomic Information System. Blank cells represent data that were not required or are not currently available. | Micropterus Perca Salvelinus Morone Sander view top 100 |
| Species | species | text | Scientific name of organism sampled as reported in the Integrated Taxonomic Information System. Blank cells represent data that were not required or are not currently available. | Perca flavescens Micropterus dolomieu Micropterus salmoides Salvelinus namaycush Sander vitreus view top 100 |
| DistinctCommonName | distinctcommonname | text | Distinct common name of organism sampled as reported in the Integrated Taxonomic Information System. Blank cells represent data that were not required or are not currently available. | Yellow perch Smallmouth bass Largemouth bass Lake trout Walleye view top 100 |
| Assign_HabitatType | assign_habitattype | text | Habitat type of the organism sampled; either Aquatic or Terrestrial. Blank cells represent data that were not required or are not currently available. | Aquatic Terrestrial view top 100 |
| Assign_Foraging_Guide | assign_foraging_guide | text | Diet type of organism sampled; either Carnivore, Herbivore, Invertivore, Invertivore-Piscivore, Omnivore, Piscivore or Planktivore. Blank cells represent data that were not required or are not currently available. | Invertivore-Piscivore Invertivore Piscivore Omnivore Planktivore view top 100 |
| Band_Num | band_num | text | The unique code at the time of sample collection used to mark and identify an individual organism (e.g., band identification number from USFWS band, matching band-lab/BANDIT records). | 2511-30981 0649-08806 1781-91396 2670-35566 0938-61789 view top 100 |
| Orig_Band_Num | orig_band_num | text | The unique code originally assigned to an individual in the event the band needed to be changed. Blank cells represent data that were not required or are not currently available. | 0649-08826 0938-15313 0898-09114 1871-11475 COLOMA16009 view top 100 |
| YearBand.Changed | yearband_changed | text | Year in which the band number changed; either 2013, 2014, or 2017. Blank cells represent data that were not required or are not currently available. | 2013 2014 2017 view top 100 |
| Recap | recap | text | If a unique individual has been captured previously, either Yes or No. Blank cells represent data that were not required or are not currently available. | No Yes view top 100 |
| Age | age | text | Age of organism sampled; either age in numbers, A (Adult), AD (Adult), Adult, AFY (After First Year), AHY (After Hatch Year), ASY (After Second Year), ATY (After Third Year), HY (Hatch Year), SY (Second Year), TY (Third Year), Imm (Immature), Immature, ), J (Juvenile), juvenile, L (Local: young bird incapable of sustained flight, Sub-Adult, U (Unknown), Unknown, or Yearling. Blank cells represent data that were not required or are not currently available. | AHY 4 5 3 ASY view top 100 |
| Sex | sex | text | Sex of organism sampled; either F (Female), IM (Immature), M (Male) or U (Unknown). Blank cells represent data that were not required or are not currently available. | U M F IM f view top 100 |
| Mass (g) | mass_g | number | Mass of organism from which the sample was collected, measured in grams. Blank cells represent data that were not required or are not currently available. | 10 18 20 200 160 view top 100 |
| Length (cm) | length_cm | text | Length of organism in which the sample was collected from, measured in centimeters. Blank cells represent data that were not required or are not currently available. | 24 25 22 16 26 view top 100 |
| Length_Method | length_method | text | Method used to measure length of organism; either Forearm Length (cm), Length, TL (Total Length). Blank cells represent data that were not required or are not currently available. | TL Forearm Length (cm) Length view top 100 |
| Composite_yes_no | composite_yes_no | text | Whether a composite sample was collected; either Yes or No. | No no yes Yes view top 100 |
| Composite_Size | composite_size | number | Overall size of composite sample analyzed. Blank cells represent data that were not required or are not currently available | 10 1 5 2 3 view top 100 |
| Comp_MinWt (g) | comp_minwt_g | number | Minimum weight of organisms included as part of the composite sample analyzed measured in grams. Blank cells represent data that were not required or are not currently available | 100 0.3 1.7 1 0.8 view top 100 |
| Comp_MaxWt (g) | comp_maxwt_g | number | Maximum weight of organisms included as part of the composite sample analyzed measured in grams. Blank cells represent data that were not required or are not currently available | 1.9 0.9 2.3 1.4 2.2 view top 100 |
| Comp_AvgWt (g) | comp_avgwt_g | number | Average weight of organisms included as part of the composite sample analyzed, measured in grams. Blank cells represent data that were not required or are not currently available | 2 1 3 0.7 1.2 view top 100 |
| Comp_MinLen (cm) | comp_minlen_cm | number | Minimum length of organisms included as part of the composite sample analyzed, measured in centimeters. Blank cells represent data that were not required or are not currently available | 6 5.2 5.3 4.8 5.7 view top 100 |
| Comp_MaxLen (cm) | comp_maxlen_cm | number | Maximum length of organisms included as part of the composite sample analyzed, measured in centimeters. Blank cells represent data that were not required or are not currently available | 6 5.3 5.6 6.3 5.2 view top 100 |
| Comp_AvgLen (cm) | comp_avglen_cm | number | Average length of organisms included as part of the composite sample analyzed, measured in centimeters. Blank cells represent data that were not required or are not currently available | 14 16 6.1 5.5 5.7 view top 100 |
| TissueCollected | tissuecollected | text | Type of tissue collected from organisms (ex. Muscle, Egg, Fat, Skin, etc.). | Muscle Whole Blood Feather Liver view top 100 |
| Analysis_Tissue | analysis_tissue | text | Type of tissue analyzed | fillet skin on scaleless Standard Fillet Blood Muscle Tail Feather view top 100 |
| Sample_Comments | sample_comments | text | Relevant comments related to the organism collected and sampled. Blank cells represent data that were not required or are not currently available | Hydro Cond: Stable, normal stage; Routine sample Specimen Unknown Hydro Cond: Not applicable; Not applicable Detailed location information available in excel file.; view top 100 |