UDP - Presence Of Blue Flags

Joint Research Centre

@ecjrc.n_336eb078_91f6_4c0c_b536_88355df6c0fd

Table List

1 table(7.6 KB)

Table 1

@ecjrc.n_336eb078_91f6_4c0c_b536_88355df6c0fd.table_1

7.6 KB
372 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	N
2016	AT	Austria	2020	2020	N
2016	AT	Austria	2021	2021	N
2016	AT	Austria	2022	2022	N
2016	AT	Austria	2023	2023	N
2016	AT	Austria	2024	2024	N
2016	BE	Belgium	2019	2019	N	41
2016	BE	Belgium	2020	2020	N	46
2016	BE	Belgium	2021	2021	N	39
2016	BE	Belgium	2022	2022	N	45


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