Synthesis Of Environmental Mercury Loads In New York State (1969-2017): Chemical Data by US Government | Environmental and Climate Sciences

About this Dataset

Synthesis Of Environmental Mercury Loads In New York State (1969-2017): Chemical Data

This 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 the chemical results from both biotic and abiotic 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.
Organization: State of New York
Last updated: 2021-08-06T14:59:56.010040
Tags: atmospheric-deposition, bird, fish, hg, mercury, mercury-synthesis

Tables

Table 1

@usgov.state_of_new_york_synthesis_of_environmental_mercury_l_d133c3a2.table_1

3.34 MB
70529 rows
34 columns


CREATE TABLE table_1 (
  "sample_id" VARCHAR,
  "org_id" VARCHAR,
  "capture_event" VARCHAR,
  "capture_loc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "site_id" VARCHAR,
  "project_id" VARCHAR,
  "org_hg_id" VARCHAR,
  "bdate" TIMESTAMP,
  "year" DOUBLE,
  "band_number" VARCHAR,
  "tissuecollected" VARCHAR,
  "analysis_tissue" VARCHAR,
  "analysis_tissue_wgt_g" DOUBLE,
  "analysis_tissue_moist" DOUBLE,
  "chem_value" DOUBLE,
  "chem_units" VARCHAR,
  "chemical_type" VARCHAR,
  "ww_dw_fw" VARCHAR,
  "convert_chem_value_fishadj" DOUBLE,
  "final_chem_standardized" DOUBLE,
  "final_convertedtissue" VARCHAR,
  "steps_reasonnotconverted" VARCHAR,
  "pcode" VARCHAR,
  "rmk" VARCHAR,
  "rmk_desc" VARCHAR,
  "limit" DOUBLE,
  "limit_desc" VARCHAR,
  "method" VARCHAR,
  "lab_code" VARCHAR,
  "lab_abbrev" VARCHAR,
  "duplicate1" DOUBLE,
  "hg_comments" VARCHAR
);