Air Passenger Transport

Eurostat code: enps_avia_pa · (2005 - 2022)

@eurostat.enps_avia_pa

Table List

2 tables(24.75 KB)

Air Passenger Transport - Unpivoted

@eurostat.enps_avia_pa.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

7.44 KB
421 rows
6 columns

freq Freq	unit Unit	tra_meas Tra Meas	geo Geo	time_period Time Period	value Value
Annual	Thousand	Passengers carried	Algeria	2005	6624.8
Annual	Thousand	Passengers carried	Israel	2005	8586
Annual	Thousand	Passengers carried	Jordan	2005	3467
Annual	Thousand	Passengers carried	Morocco	2005	8939.1
Annual	Thousand	Passengers carried	Palestine*	2005	5.3
Annual	Thousand	Passengers carried	Tunisia	2005	10398.8
Annual	Thousand	Passengers carried (arrival)	Algeria	2005	3290.1
Annual	Thousand	Passengers carried (arrival)	Egypt	2005	12287
Annual	Thousand	Passengers carried (arrival)	Israel	2005	4286
Annual	Thousand	Passengers carried (arrival)	Jordan	2005	1719


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "tra_meas" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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