UDP - Share Of Protected/designated Land

Joint Research Centre

@ecjrc.n_011dfa14_f4ed_4683_aac8_211a6cff80ff

Table List

1 table(7.22 KB)

Table 1

@ecjrc.n_011dfa14_f4ed_4683_aac8_211a6cff80ff.table_1

7.22 KB
246 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	PC	15.36
2016	AT	Austria	2020	2020	PC	15.36
2016	AT	Austria	2021	2021	PC	15.36
2016	AT	Austria	2022	2022	PC	15.36
2016	BE	Belgium	2019	2019	PC	12.71
2016	BE	Belgium	2020	2020	PC	12.72
2016	BE	Belgium	2021	2021	PC	12.72
2016	BE	Belgium	2022	2022	PC	12.72
2016	BG	Bulgaria	2019	2019	PC	34.88
2016	BG	Bulgaria	2020	2020	PC	34.88


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