Water Pollution In EU Countries
Selection of assessments of the degree of water pollution in European countries
@kaggle.hydramst_water_pollution
Train
@kaggle.hydramst_water_pollution.train
- 57.99 KB
- 2928 rows
- 18 columns
unnamed_0Unnamed: 0 | codeCode | yearYear | periodPeriod | idId | countryCountry | touristsTourists | venueVenue | rateRate | foodFood | glassGlass | metalMetal | otherOther | paperPaper | plasticPlastic | leatherLeather | green_wasteGreen Waste | waste_recyclingWaste Recycling |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | EEA_3161-03-3 | 2009 | 2009-04--2009-10 | FRGR0220 | France | 71176346 | 32 | 10 | 3 | 26 | 20 | 9 | 22.26 | ||||
| 20 | EEA_3161-05-5 | 2009 | 2009-01--2009-12 | FRDR179 | France | 71176346 | 3 | 32 | 10 | 3 | 26 | 20 | 9 | 22.26 | |||
| 27 | EEA_3161-01-1 | 2009 | 2009-01--2009-12 | FRDR174 | France | 71176346 | 3 | 32 | 10 | 3 | 26 | 20 | 9 | 22.26 | |||
| 28 | EEA_3161-05-5 | 2009 | 2009-01--2009-12 | FRDR174 | France | 71176346 | 3 | 32 | 10 | 3 | 26 | 20 | 9 | 22.26 | |||
| 33 | EEA_3161-03-3 | 2009 | 2009-01--2009-12 | FRGR0173 | France | 71176346 | 32 | 10 | 3 | 26 | 20 | 9 | 22.26 | ||||
| 49 | EEA_3161-01-1 | 2009 | 2009-01--2009-12 | FRGR0178A | France | 71176346 | 5 | 32 | 10 | 3 | 26 | 20 | 9 | 22.26 | |||
| 52 | EEA_3161-02-2 | 2009 | 2009-01--2009-12 | FRGR0178A | France | 71176346 | 5 | 32 | 10 | 3 | 26 | 20 | 9 | 22.26 | |||
| 62 | EEA_31615-01-7 | 2009 | 2009-01--2009-12 | FRFR327C | France | 71176346 | 2 | 32 | 10 | 3 | 26 | 20 | 9 | 22.26 | |||
| 78 | EEA_3161-02-2 | 2009 | 2009-01--2009-12 | ES014MSPFES-014-NR-038-000-02-02 | Spain | 50941692 | 4 | 87.15892367892796 | 49 | 8 | 3 | 14 | 15 | 9 | 16.84 | ||
| 85 | EEA_31615-01-7 | 2009 | 2009-01--2009-12 | FRGR0175 | France | 71176346 | 32 | 10 | 3 | 26 | 20 | 9 | 22.26 |
CREATE TABLE train (
"unnamed_0" BIGINT,
"code" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"id" VARCHAR,
"country" VARCHAR,
"tourists" DOUBLE,
"venue" DOUBLE,
"rate" DOUBLE,
"food" DOUBLE,
"glass" DOUBLE,
"metal" DOUBLE,
"other" DOUBLE,
"paper" DOUBLE,
"plastic" DOUBLE,
"leather" DOUBLE,
"green_waste" DOUBLE,
"waste_recycling" DOUBLE
);