Air Transport Traffic: Freight And Passengers

Eurostat code: med_air5 · (2005 - 2018)

@eurostat.med_air5

Table List

2 tables(22.22 KB)

Air Transport Traffic: Freight And Passengers - Raw

Air Transport Traffic: Freight And Passengers - Unpivoted

Air Transport Traffic: Freight And Passengers - Unpivoted

@eurostat.med_air5.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.4 KB
437 rows
6 columns

freq Freq	unit Unit	tra_meas Tra Meas	geo Geo	time_period Time Period	value Value
Annual	Thousand	Freight and mail on board (arrivals)	Algeria	2005	30.7
Annual	Thousand	Freight and mail on board (arrivals)	Egypt	2005	85
Annual	Thousand	Freight and mail on board (arrivals)	Israel	2005	140
Annual	Thousand	Freight and mail on board (arrivals)	Jordan	2005	51
Annual	Thousand	Freight and mail on board (arrivals)	Lebanon	2005	35.8
Annual	Thousand	Freight and mail on board (arrivals)	Morocco	2005	26.8
Annual	Thousand	Freight and mail on board (arrivals)	Tunisia	2005	9.6
Annual	Thousand	Freight and mail on board (departures)	Algeria	2005
Annual	Thousand	Freight and mail on board (departures)	Egypt	2005	150
Annual	Thousand	Freight and mail on board (departures)	Israel	2005	182


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.