UDP - Average Duration Of Stay

Joint Research Centre

@ecjrc.e60e51d7_3711_42f0_8c7d_f85ba6ccfbd0

Table List

1 table(7.61 KB)

Table 1

@ecjrc.e60e51d7_3711_42f0_8c7d_f85ba6ccfbd0.table_1

7.61 KB
310 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	3.1
2016	AT	Austria	2020	2020	PC	3.65
2016	AT	Austria	2021	2021	PC	3.38
2016	AT	Austria	2022	2022	PC	3.23
2016	AT	Austria	2023	2023	PC	3.14
2016	BE	Belgium	2019	2019	PC	2.35
2016	BE	Belgium	2020	2020	PC	2.74
2016	BE	Belgium	2021	2021	PC	2.66
2016	BE	Belgium	2022	2022	PC	2.44
2016	BE	Belgium	2023	2023	PC	2.41


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