About this Dataset

Supporting Information For Per- And Polyfluoroalkyl Substances - Non-Targeted Analysis Interlaboratory Study Final Report

Supporting information for the NIST Internal Report entitled: Per- and Polyfluoroalkyl Substances - Non-Targeted Analysis Interlaboratory Study Final Report. The files include four comma-separated value (CSV) text files, three of the CSV text files contain summary tables of all per and polyfluoroalkyl substances (PFAS) detected in the three test samples from the interlaboratory report (sample_a_table.csv, sample_b_table.csv, sample_c_table.csv) including the individual laboratory reported identities and their associated identification confidence levels. The final CSV text file, all_pfas_table.csv, contains a summary of all PFAS detected in all of the samples and the highest level of confidence reported in each of the three test samples. These files are meant to supplement the abbreviated tables presented in the Final Report that reported the top 20 PFAS in each of the three test samples. These tables were produced through the analysis of the individual laboratory results and aggregation of the results by the reported PFAS identity.The Microsoft Excel file, PFASNTAILS_Reporting Form.xlsx, is the example form that was used by all participating laboratories to report their results. It is provided to provide readers of the interlaboratory report with context to the information that was provided by each laboratory.
Organization: National Institute of Standards and Technology
Last updated: 2025-03-14T15:21:03.389472
Tags: analytical-chemistry, interlaboratory-study, mass-spectrometry, non-targeted-analysis, per-and-polyfluoroalkyl-substances-pfas

Tables

All Pfas Table

@usgov.national_institute_of_standard_supporting_information__99c264fe.all_pfas_table

27.25 kB
871 rows
5 columns

CREATE TABLE all_pfas_table (
  "pfasid" VARCHAR,
  "compound_name" VARCHAR,
  "sample_a" VARCHAR,
  "sample_b" VARCHAR,
  "sample_c" VARCHAR
);

Sample A Table

@usgov.national_institute_of_standard_supporting_information__99c264fe.sample_a_table

23.18 kB
133 rows
31 columns

CREATE TABLE sample_a_table (
  "compound_name" VARCHAR,
  "dim001" VARCHAR,
  "dim002" VARCHAR,
  "dim003" VARCHAR,
  "dim004" VARCHAR,
  "dim005" VARCHAR,
  "dim006" VARCHAR,
  "dim011" VARCHAR,
  "dim014" VARCHAR,
  "dim017" VARCHAR,
  "dim018" VARCHAR,
  "dim020" VARCHAR,
  "dim021" VARCHAR,
  "dim023" VARCHAR,
  "dim027" VARCHAR,
  "dim029" VARCHAR,
  "dim032" VARCHAR,
  "dim033" VARCHAR,
  "dim035" VARCHAR,
  "dim037" VARCHAR,
  "dim038" VARCHAR,
  "dim040" VARCHAR,
  "dim043" VARCHAR,
  "dim044" VARCHAR,
  "dim045" VARCHAR,
  "dim047" VARCHAR,
  "dim048" VARCHAR,
  "dim049" VARCHAR,
  "maximum_confidence_id" VARCHAR,
  "number_of_identifications" BIGINT,
  "identification_rate" VARCHAR  -- Identification Rate (%)
);

Sample C Table

@usgov.national_institute_of_standard_supporting_information__99c264fe.sample_c_table

27.25 kB
237 rows
31 columns

CREATE TABLE sample_c_table (
  "compound_me" VARCHAR,
  "dim001" VARCHAR,
  "dim002" VARCHAR,
  "dim003" VARCHAR,
  "dim004" VARCHAR,
  "dim005" VARCHAR,
  "dim006" VARCHAR,
  "dim011" VARCHAR,
  "dim014" VARCHAR,
  "dim017" VARCHAR,
  "dim018" VARCHAR,
  "dim020" VARCHAR,
  "dim021" VARCHAR,
  "dim023" VARCHAR,
  "dim027" VARCHAR,
  "dim029" VARCHAR,
  "dim032" VARCHAR,
  "dim033" VARCHAR,
  "dim035" VARCHAR,
  "dim037" VARCHAR,
  "dim038" VARCHAR,
  "dim040" VARCHAR,
  "dim043" VARCHAR,
  "dim044" VARCHAR,
  "dim045" VARCHAR,
  "dim047" VARCHAR,
  "dim048" VARCHAR,
  "dim049" VARCHAR,
  "maximum_confidence_id" VARCHAR,
  "number_of_identifications" BIGINT,
  "identification_rate" VARCHAR  -- Identification Rate (%)
);