UDP - Excellent Bathing Water

Joint Research Centre

@ecjrc.n_6a7a5402_0b08_488e_85db_68a5645cb164

Table List

1 table(7.68 KB)

Table 1

@ecjrc.n_6a7a5402_0b08_488e_85db_68a5645cb164.table_1

7.68 KB
290 rows
8 columns

versions VERSIONS	territory_id TERRITORY ID	name_html NAME HTML	year YEAR	date DATE	unit UNIT	value VALUE
2016	AT	Austria	2019	2019	PERC	98.84
2016	AT	Austria	2020	2020	PERC	98.07
2016	AT	Austria	2021	2021	PERC	98.07
2016	AT	Austria	2022	2022	PERC	97.3
2016	AT	Austria	2023	2023	PERC	96.92
2016	BE	Belgium	2019	2019	PERC	86.49
2016	BE	Belgium	2020	2020	PERC	84.07
2016	BE	Belgium	2021	2021	PERC	79.17
2016	BE	Belgium	2022	2022	PERC	77.17
2016	BE	Belgium	2023	2023	PERC	67.69


CREATE TABLE table_1 (
  "versions" BIGINT,
  "level_id" BIGINT,
  "territory_id" VARCHAR,
  "name_html" VARCHAR,
  "year" BIGINT,
  "date" BIGINT,
  "unit" VARCHAR,
  "value" DOUBLE
);