About this Dataset

Microplastics In Drinking Water

Alpha Version Data (has undergone several rounds of internal review from the Moore Institute and is ready for external review)

This dataset is part of the Microplastics Data Portal. It was created by reviewing peer-reviewed studies on microplastics in drinking water for bottled water and tap water. This data is tidied in a way that we think it is most actionable but raw data is also available on Github. Data was validated with the rules file provided in combination with the Data Validation Portal.
Organization: State of California
Last updated: 2023-07-15T22:13:21.198841
Tags: alpha, microplastics, peer-reviewed

Tables

Microplastics Sample Data (wide)

@usgov.ca_gov_microplastics_in_drinking_water.microplastics_sample_data_wide

94.24 KB
607 rows
115 columns


CREATE TABLE microplastics_sample_data_wide (
  "doi" VARCHAR,
  "sample_id" VARCHAR,
  "subsample_id" VARCHAR,
  "location" VARCHAR,
  "countries" VARCHAR,
  "source" VARCHAR,
  "concentration" VARCHAR,
  "concentration_units" VARCHAR,
  "color_transparent" VARCHAR,
  "color_blue" VARCHAR,
  "color_red" VARCHAR,
  "color_brown" VARCHAR,
  "color_green" VARCHAR,
  "color_orange" VARCHAR,
  "color_white" VARCHAR,
  "color_yellow" VARCHAR,
  "color_pink" VARCHAR,
  "color_black" VARCHAR,
  "color_other" VARCHAR,
  "material_pest" VARCHAR,
  "material_pe" VARCHAR,
  "material_pp" VARCHAR,
  "material_pa" VARCHAR,
  "material_pe_ps" VARCHAR,
  "material_ps" VARCHAR,
  "material_ca" VARCHAR,
  "material_pvc" VARCHAR,
  "material_er" VARCHAR,
  "material_pam" VARCHAR,
  "material_pet" VARCHAR,
  "material_plasticadditive" VARCHAR,
  "material_pbt" VARCHAR,
  "material_pu" VARCHAR,
  "material_pet_pest" VARCHAR,
  "material_pan" VARCHAR,
  "material_silicone" VARCHAR,
  "material_acrylic" VARCHAR,
  "material_vinyl" VARCHAR,
  "material_vinyon" VARCHAR,
  "material_other" VARCHAR,
  "material_pa_er" VARCHAR,
  "material_ptt" VARCHAR,
  "material_pe_pp" VARCHAR,
  "material_pps" VARCHAR,
  "material_rayon" VARCHAR,
  "material_paa" VARCHAR,
  "material_pmps" VARCHAR,
  "material_pi" VARCHAR,
  "material_olefin" VARCHAR,
  "material_styrene_butadiene" VARCHAR,
  "material_pba" VARCHAR,
  "material_pmma" VARCHAR,
  "material_cellophane" VARCHAR,
  "material_san" VARCHAR,
  "material_pc" VARCHAR,
  "material_pdms" VARCHAR,
  "material_pla" VARCHAR,
  "material_ptfe" VARCHAR,
  "material_sbr" VARCHAR,
  "material_pet_olefin" VARCHAR,
  "material_pes" VARCHAR,
  "material_abs" VARCHAR,
  "material_ldpe" VARCHAR,
  "material_peva" VARCHAR,
  "material_ar" VARCHAR,
  "material_pva" VARCHAR,
  "material_ppe" VARCHAR,
  "morphology_fragment" VARCHAR,
  "morphology_fiber" VARCHAR,
  "morphology_nurdle" VARCHAR,
  "morphology_film" VARCHAR,
  "morphology_foam" VARCHAR,
  "morphology_sphere" VARCHAR,
  "morphology_line" VARCHAR,
  "morphology_bead" VARCHAR,
  "morphology_sheet" VARCHAR,
  "morphology_film_fragment" VARCHAR,
  "morphology_rubbery_fragment" VARCHAR,
  "size_3000um" VARCHAR,
  "size_2_5mm" VARCHAR,
  "size_1_5mm" VARCHAR,
  "size_1_2mm" VARCHAR,
  "size_0_5_1mm" VARCHAR,
  "size_less_than_0_5mm" VARCHAR,
  "size_500um" VARCHAR,
  "size_300_500um" VARCHAR,
  "size_125_300um" VARCHAR,
  "size_100_500um" VARCHAR,
  "size_greater_than_100um" VARCHAR,
  "size_50_150um" VARCHAR,
  "size_50_100um" VARCHAR,
  "size_50um" VARCHAR,
  "size_45_125um" VARCHAR,
  "size_greater_than_25um" VARCHAR,
  "size_20um_5mm" VARCHAR,
  "size_20_100um" VARCHAR,
  "size_20_50um" VARCHAR,
  "size_10_50um" VARCHAR,
  "size_10_45um" VARCHAR,
  "size_10_20um" VARCHAR
);

Sample Methodology

@usgov.ca_gov_microplastics_in_drinking_water.sample_methodology

10.95 KB
46 rows
8 columns


CREATE TABLE sample_methodology (
  "doi" VARCHAR,
  "sample_device_and_deployment_methods" VARCHAR,
  "digestion" VARCHAR,
  "filtration" VARCHAR,
  "filter_size" VARCHAR,
  "microplastic_identification_method" VARCHAR,
  "spectral_analysis" VARCHAR,
  "controls" VARCHAR
);

Validation Rules (Methodology Data)

@usgov.ca_gov_microplastics_in_drinking_water.validation_rules_methodology_data

4.55 KB
8 rows
4 columns


CREATE TABLE validation_rules_methodology_data (
  "name" VARCHAR,
  "description" VARCHAR,
  "severity" VARCHAR,
  "rule" VARCHAR
);