Freight And Mail Air Transport By Aircraft Model, Distance Bands And Transport Coverage

Eurostat code: avia_goodis · (2008 - 2023)

@eurostat.avia_goodis

Table List

2 tables(3.14 MB)

Freight And Mail Air Transport By Aircraft Model, Distance Bands And Transport Coverage - Raw

Freight And Mail Air Transport By Aircraft Model, Distance Bands And Transport Coverage - Unpivoted

Freight And Mail Air Transport By Aircraft Model, Distance Bands And Transport Coverage - Unpivoted

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

1.55 MB
853440 rows
9 columns

freq Freq	tra_cov Tra Cov	tra_meas Tra Meas	aircraft Aircraft	distance Distance	unit Unit	geo Geo	time_period Time Period	value Value
Annual	International transport	Freight and mail commercial air flights	Jumbo jet	From 1 000 to 1 499 km	Number	Austria	2008
Annual	International transport	Freight and mail commercial air flights	Jumbo jet	From 1 000 to 1 499 km	Number	Belgium	2008	1543
Annual	International transport	Freight and mail commercial air flights	Jumbo jet	From 1 000 to 1 499 km	Number	Bulgaria	2008	451
Annual	International transport	Freight and mail commercial air flights	Jumbo jet	From 1 000 to 1 499 km	Number	Switzerland	2008
Annual	International transport	Freight and mail commercial air flights	Jumbo jet	From 1 000 to 1 499 km	Number	Cyprus	2008
Annual	International transport	Freight and mail commercial air flights	Jumbo jet	From 1 000 to 1 499 km	Number	Czechia	2008	1
Annual	International transport	Freight and mail commercial air flights	Jumbo jet	From 1 000 to 1 499 km	Number	Germany	2008	3166
Annual	International transport	Freight and mail commercial air flights	Jumbo jet	From 1 000 to 1 499 km	Number	Denmark	2008
Annual	International transport	Freight and mail commercial air flights	Jumbo jet	From 1 000 to 1 499 km	Number	Estonia	2008
Annual	International transport	Freight and mail commercial air flights	Jumbo jet	From 1 000 to 1 499 km	Number	Greece	2008	16


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

Share link

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