Freight And Mail Air Transport Routes Between Partner Airports And Main Airports In Portugal

Eurostat code: avia_gor_pt · (1993 - 2024-Q3)

@eurostat.avia_gor_pt

Table List

2 tables(1.48 MB)

Freight And Mail Air Transport Routes Between Partner Airports And Main Airports In Portugal - Raw

Freight And Mail Air Transport Routes Between Partner Airports And Main Airports In Portugal - Unpivoted

Freight And Mail Air Transport Routes Between Partner Airports And Main Airports In Portugal - Unpivoted

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

504.53 KB
235358 rows
6 columns

freq Freq	unit Unit	tra_meas Tra Meas	airp_pr Airp Pr	time_period Time Period	value Value
Annual	Tonne	Freight and mail loaded	FARO airport - FRANKFURT/MAIN airport	1993	13
Annual	Tonne	Freight and mail loaded	FARO airport - LONDON HEATHROW airport	1993	1297
Annual	Tonne	Freight and mail loaded	PONTA DELGADA airport - BOSTON/GENERAL EDWARD LAWRENCE LOGAN INTERNATIONAL, MA. airport	1993	45
Annual	Tonne	Freight and mail loaded	PORTO airport - LUANDA/4 DE FEVEREIRO airport	1993	264
Annual	Tonne	Freight and mail loaded	PORTO airport - BRUSSELS airport	1993	252
Annual	Tonne	Freight and mail loaded	PORTO airport - RIO DE JANEIRO/GALEAO-ANTONIO CARLOS JOBIM, RJ airport	1993	167
Annual	Tonne	Freight and mail loaded	PORTO airport - SAO PAULO/GUARULHOS, GOVERNADOR ANDRE FRANCO MONTORO, SP airport	1993	314
Annual	Tonne	Freight and mail loaded	PORTO airport - GENEVA airport	1993	177
Annual	Tonne	Freight and mail loaded	PORTO airport - ZURICH airport	1993	52
Annual	Tonne	Freight and mail loaded	PORTO airport - FRANKFURT/MAIN airport	1993	1869


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

Share link

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