Baselight

Assessing The Presence Of Microplastics In Water

Implications for Human Health and Environmental Sustainability

@kaggle.kirbysasuke_drinking_water

Samples Geocoded
@kaggle.kirbysasuke_drinking_water.samples_geocoded

  • 95.01 KB
  • 607 rows
  • 115 columns
  • Only the first 100 columns are shown
doi

DOI

sample_id

Sample ID

subsample_id

Subsample ID

location

Location

countries

Countries

source

Source

concentration

Concentration

concentration_units

Concentration Units

color_transparent

Color Transparent

color_blue

Color Blue

color_red

Color Red

color_brown

Color Brown

color_green

Color Green

color_orange

Color Orange

color_white

Color White

color_yellow

Color Yellow

color_pink

Color Pink

color_black

Color Black

color_other

Color Other

material_pest

Material PEST

material_pe

Material PE

material_pp

Material PP

material_pa

Material PA

material_pe_ps

Material PE PS

material_ps

Material PS

material_ca

Material CA

material_pvc

Material PVC

material_er

Material ER

material_pam

Material PAM

material_pet

Material PET

material_plasticadditive

Material PlasticAdditive

material_pbt

Material PBT

material_pu

Material PU

material_pet_pest

Material PET PEST

material_pan

Material PAN

material_silicone

Material Silicone

material_acrylic

Material Acrylic

material_vinyl

Material Vinyl

material_vinyon

Material Vinyon

material_other

Material Other

material_pa_er

Material PA ER

material_ptt

Material PTT

material_pe_pp

Material PE PP

material_pps

Material PPS

material_rayon

Material Rayon

material_paa

Material PAA

material_pmps

Material PMPS

material_pi

Material PI

material_olefin

Material Olefin

material_styrene_butadiene

Material Styrene Butadiene

material_pba

Material PBA

material_pmma

Material PMMA

material_cellophane

Material Cellophane

material_san

Material SAN

material_pc

Material PC

material_pdms

Material PDMS

material_pla

Material PLA

material_ptfe

Material PTFE

material_sbr

Material SBR

material_pet_olefin

Material PET Olefin

material_pes

Material PES

material_abs

Material ABS

material_ldpe

Material LDPE

material_peva

Material PEVA

material_ar

Material AR

material_pva

Material PVA

material_ppe

Material PPE

morphology_fragment

Morphology Fragment

morphology_fiber

Morphology Fiber

morphology_nurdle

Morphology Nurdle

morphology_film

Morphology Film

morphology_foam

Morphology Foam

morphology_sphere

Morphology Sphere

morphology_line

Morphology Line

morphology_bead

Morphology Bead

morphology_sheet

Morphology Sheet

morphology_film_fragment

Morphology Film Fragment

morphology_rubbery_fragment

Morphology Rubbery Fragment

size_3000um

Size 3000um

size_2_5mm

Size 2–5mm

size_1_5mm

Size 1–5mm

size_1_2mm

Size 1–2mm

size_0_5_1mm

Size 0.5–1mm

size_less_than_0_5mm

Size Less Than 0.5mm

size_500um

Size 500um

size_300_500um

Size 300–500um

size_125_300um

Size 125–300um

size_100_500um

Size 100–500um

size_greater_than_100um

Size Greater Than 100um

size_50_150um

Size 50–150um

size_50_100um

Size 50–100um

size_50um

Size 50um

size_45_125um

Size 45–125um

size_greater_than_25um

Size Greater Than 25um

size_20um_5mm

Size 20um 5mm

size_20_100um

Size 20–100um

size_20_50um

Size 20–50um

size_10_50um

Size 10–50um

size_10_45um

Size 10–45um

size_10_20um

Size 10–20um

size_greater_than_10um

Size Greater Than 10um

size_8_316um

Size 8–316um

size_5_100um

Size 5–100um

size_5_10um

Size 5–10um

size_4_10um

Size 4–10um

size_1_5_5um

Size 1.5–5um

size_less_than_1_5um

Size Less Than 1.5um

size_1_100um

Size 1–100um

size_1_50um

Size 1–50um

size_1_10um

Size 1–10um

size_1_5um

Size 1–5um

size_110_124nm

Size 110–124nm

size_0_20um

Size 0–20um

approximate_latitude

Approximate Latitude

approximate_longitude

Approximate Longitude

10.1016/j.watres.2017.11.0111|10.1016/j.watres.2017.11.011nanGermanyGermanybottled water14particles/Lnannannannannan0.590.090.010.01nannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan0.02nan0.05nannannannan0.22nannan0.3
10.1016/j.watres.2017.11.0112|10.1016/j.watres.2017.11.011nanGermanyGermanybottled water118particles/Lnannannannannan0.840.050.070.02nannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan0.01nan0.02nannannannan0.12nannan0.29
10.1016/j.watres.2017.11.0113|10.1016/j.watres.2017.11.011nanGermanyGermanybottled water50particles/Lnannannannannan0.410.350.08nannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan0.03nan0.07nannannannan0.14nannan0.32
10.1016/j.watres.2017.11.0114|10.1016/j.watres.2017.11.011nanGermanyGermanybottled water11particles/Lnannannannannan0.320.380.26nannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan0.07nan0.1nannannannan0.16nannan0.28
10.1039/c6ay01184e1|10.1039/c6ay01184enanGermanyGermanybottled water19-Octparticles/0.33 LnannannannannannanPresentnannanPresentPresentPresentnannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannanPresentnannannannannannannannannannannannannannannannannannannannan
10.1039/c6ay01184e2|10.1039/c6ay01184enanGermanyGermanybottled water1particles/0.33 LnannannannannannannannannannannannannannannanPresentnannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannanPresentnannannannannannannannannannannannannannannannannannannannan
10.3389/fchem.2018.00407IB|101119.10.3389/fchem.2018.00407nanJakarta, IndonesiaIndonesiabottled water37.1particles/Lnannannannannan0.060.10.540.16nan0.11nannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan0.650.130.030.140.05nannannannannannannannannannannannannannannannannan
10.3389/fchem.2018.00407BB 311019 08: 11 PSRL6|10.3389/fchem.2018.00407nanBali, IndonesiaIndonesiabottled water705particles/Lnannannannannan0.060.10.540.16nan0.11nannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan0.650.130.030.140.05nannannannannannannannannannannannannannannannannan
10.3389/fchem.2018.00407BB 311019 09: 50 STB1|10.3389/fchem.2018.00407nanMedan, IndonesiaIndonesiabottled water404particles/Lnannannannannan0.060.10.540.16nan0.11nannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan0.650.130.030.140.05nannannannannannannannannannannannannannannannannan
10.3389/fchem.2018.00407Oct0719|10.3389/fchem.2018.00407nannannanbottled water252particles/Lnannannannannan0.060.10.540.16nan0.11nannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannannan0.650.130.030.140.05nannannannannannannannannannannannannannannannannan

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

Share link

Anyone who has the link will be able to view this.