Name: Assessing The Presence Of Microplastics In Water
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Assessing The Presence Of Microplastics In 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.

Tables

Sample Methodology

@kaggle.kirbysasuke_drinking_water.sample_methodology

10.67 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
);

Samples Geocoded

@kaggle.kirbysasuke_drinking_water.samples_geocoded

97.29 kB
607 rows
115 columns

CREATE TABLE samples_geocoded (
  "doi" VARCHAR,
  "sample_id" VARCHAR,
  "subsample_id" VARCHAR,
  "location" VARCHAR,
  "countries" VARCHAR,
  "source" VARCHAR,
  "concentration" VARCHAR,
  "concentration_units" VARCHAR,
  "color_transparent" DOUBLE,
  "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" DOUBLE,
  "color_other" DOUBLE,
  "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" DOUBLE,
  "material_vinyon" DOUBLE,
  "material_other" VARCHAR,
  "material_pa_er" DOUBLE,
  "material_ptt" VARCHAR,
  "material_pe_pp" DOUBLE,
  "material_pps" DOUBLE,
  "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" DOUBLE,
  "material_pes" VARCHAR,
  "material_abs" VARCHAR,
  "material_ldpe" VARCHAR,
  "material_peva" VARCHAR,
  "material_ar" VARCHAR,
  "material_pva" VARCHAR,
  "material_ppe" DOUBLE,
  "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" DOUBLE,
  "size_1_5mm" DOUBLE,
  "size_1_2mm" DOUBLE,
  "size_0_5_1mm" VARCHAR,
  "size_less_than_0_5mm" DOUBLE,
  "size_500um" VARCHAR,
  "size_300_500um" VARCHAR,
  "size_125_300um" VARCHAR,
  "size_100_500um" DOUBLE,
  "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" DOUBLE,
  "size_10_50um" VARCHAR,
  "size_10_45um" VARCHAR,
  "size_10_20um" DOUBLE
);

Validation Rules Samples Merged

@kaggle.kirbysasuke_drinking_water.validation_rules_samples_merged

8.04 kB
116 rows
4 columns

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

Validation Rules Samples Methodology

@kaggle.kirbysasuke_drinking_water.validation_rules_samples_methodology

4.51 kB
8 rows
4 columns

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