Air Transport Infrastructure: Length Of Paved Runways

Eurostat code: med_air2 · (2005 - 2016)

@eurostat.med_air2

Table List

2 tables(16.31 KB)

Air Transport Infrastructure: Length Of Paved Runways - Raw

Air Transport Infrastructure: Length Of Paved Runways - Unpivoted

Air Transport Infrastructure: Length Of Paved Runways - Unpivoted

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

4.95 KB
67 rows
6 columns

freq Freq	unit Unit	tra_infr Tra Infr	geo Geo	time_period Time Period	value Value
Annual	Metre	Paved airport runways longer than 2 438 metres	Algeria	2005	110895
Annual	Metre	Paved airport runways longer than 2 438 metres	Jordan	2005	13606
Annual	Metre	Paved airport runways longer than 2 438 metres	Lebanon	2005	10445
Annual	Metre	Paved airport runways longer than 2 438 metres	Morocco	2005	40620
Annual	Metre	Paved airport runways longer than 2 438 metres	Palestine*	2005	3076
Annual	Metre	Paved airport runways longer than 2 438 metres	Tunisia	2005	24085
Annual	Metre	Paved airport runways longer than 2 438 metres	Algeria	2006	110895
Annual	Metre	Paved airport runways longer than 2 438 metres	Jordan	2006	13606
Annual	Metre	Paved airport runways longer than 2 438 metres	Lebanon	2006	10445
Annual	Metre	Paved airport runways longer than 2 438 metres	Morocco	2006	40620


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "tra_infr" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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