Freight And Mail Air Transport (including National Transport)

Eurostat code: enps_avia_fr · (2005 - 2022)

@eurostat.enps_avia_fr

Table List

2 tables(23.25 KB)

Freight And Mail Air Transport (including National Transport) - Raw

Freight And Mail Air Transport (including National Transport) - Unpivoted

Freight And Mail Air Transport (including National Transport) - Unpivoted

@eurostat.enps_avia_fr.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.59 KB
318 rows
6 columns

freq Freq	unit Unit	tra_meas Tra Meas	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes	Freight and mail on board	Algeria	2005	28.2
Annual	Thousand tonnes	Freight and mail on board	Egypt	2005	235
Annual	Thousand tonnes	Freight and mail on board	Israel	2005	322
Annual	Thousand tonnes	Freight and mail on board	Jordan	2005	106
Annual	Thousand tonnes	Freight and mail on board	Morocco	2005	56.7
Annual	Thousand tonnes	Freight and mail on board	Tunisia	2005	20.1
Annual	Thousand tonnes	Freight and mail on board (arrivals)	Algeria	2005	21.7
Annual	Thousand tonnes	Freight and mail on board (arrivals)	Egypt	2005	85
Annual	Thousand tonnes	Freight and mail on board (arrivals)	Israel	2005	140
Annual	Thousand tonnes	Freight and mail on board (arrivals)	Jordan	2005	51


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.