Air Transport Traffic: Number Of Aircraft Movements

Eurostat code: med_air4 · (2000 - 2015)

@eurostat.med_air4

Table List

2 tables(20.93 KB)

Air Transport Traffic: Number Of Aircraft Movements - Raw

Air Transport Traffic: Number Of Aircraft Movements - Unpivoted

Air Transport Traffic: Number Of Aircraft Movements - Unpivoted

@eurostat.med_air4.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.

6.14 KB
130 rows
6 columns

freq Freq	unit Unit	tra_meas Tra Meas	geo Geo	time_period Time Period	value Value
Annual	Number	Aircraft movements (passenger, freight and mail, commercial and non-commercial general aviation operations)	Algeria	2000	70410
Annual	Number	Aircraft movements (passenger, freight and mail, commercial and non-commercial general aviation operations)	Egypt	2000	228779
Annual	Number	Aircraft movements (passenger, freight and mail, commercial and non-commercial general aviation operations)	Israel	2000	33363
Annual	Number	Aircraft movements (passenger, freight and mail, commercial and non-commercial general aviation operations)	Jordan	2000	34181
Annual	Number	Aircraft movements (passenger, freight and mail, commercial and non-commercial general aviation operations)	Lebanon	2000	46375
Annual	Number	Aircraft movements (passenger, freight and mail, commercial and non-commercial general aviation operations)	Morocco	2000	118915
Annual	Number	Aircraft movements (passenger, freight and mail, commercial and non-commercial general aviation operations)	Palestine*	2000	2254
Annual	Number	Aircraft movements (passenger, freight and mail, commercial and non-commercial general aviation operations)	Syria	2000	31575
Annual	Number	Aircraft movements (passenger, freight and mail, commercial and non-commercial general aviation operations)	Tunisia	2000	91219
Annual	Number	Aircraft movements (passenger, freight and mail, commercial and non-commercial general aviation operations)	Algeria	2001	145270


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.