Arrivals Of Tourists At The Border

Eurostat code: enps_tour_border · (2005 - 2022)

@eurostat.enps_tour_border

Table List

2 tables(19.36 KB)

Arrivals Of Tourists At The Border - Raw

Arrivals Of Tourists At The Border - Unpivoted

Arrivals Of Tourists At The Border - Raw

@eurostat.enps_tour_border.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

14.59 KB
7 rows
21 columns

freq Freq	unit Unit	geo Geo	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022
Annual	Thousand	Algeria	1443.1	1637.6	1743.1	1771.7	1911.5	2070.5	2394.9	2634.1	2732.7	2301.4	1710	2039.4	2450.8	2657.1	2371.1	591
Annual	Thousand	Egypt	8608	9083	11091	12835	12536	14731	9845	11532	9464	9878	9328	5399	8292	11346	13026	3677	7997
Annual	Thousand	Israel	1902.7	1825.2	2067.8	2572.3	2321.4	2803.1	2820.2	2885.9	2961.7	2926.4	2799.4	2900	3613.2	4120.9	4551.8	831.5	396.5	2675
Annual	Thousand	Jordan	5817	6713	6529	7100	7085	8078	6812	6314	5389	5327	4236	4565	4565	4922	5361	1240
Annual	Thousand	Lebanon	3593.8	3088.9	3145.4	4072.6	5344.8	6346	5660.9	5613.8	5928.2	5064.7	3562.6	3584.2	4338	4756.7	4460.7	995.7	1392.3	1871
Annual	Thousand	Libya	81.3	125.5	106	42.1	35.7	32	32	30	29	20	75	82	89	100	100	100	125	250
Annual	Thousand	Tunisia	6378	6549	6762	6549	6901.4	6902.7	4785.1	5990.5	6268.6	6068.6	4202	4525.8	5742.6	6921.2	7984.5	1431.9	1600.3


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE
);

Share link

Anyone who has the link will be able to view this.