Transport Of Containers Or Road Vehicles (1982-2002)

Eurostat code: rail_go_contold · (1982 - 2002)

@eurostat.rail_go_contold

Table List

2 tables(71.13 KB)

Transport Of Containers Or Road Vehicles (1982-2002) - Raw

Transport Of Containers Or Road Vehicles (1982-2002) - Unpivoted

Transport Of Containers Or Road Vehicles (1982-2002) - Unpivoted

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

29.01 KB
4282 rows
7 columns

freq Freq	unit Unit	cargo Cargo	tra_cov Tra Cov	geo Geo	time_period Time Period	value Value
Annual	Number	Large containers (excluded swap bodies) - empty	International transport - loaded	Belgium	1982	21220
Annual	Number	Large containers (excluded swap bodies) - empty	International transport - loaded	Germany	1982	38623
Annual	Number	Large containers (excluded swap bodies) - empty	International transport - loaded	Denmark	1982	1910
Annual	Number	Large containers (excluded swap bodies) - empty	International transport - loaded	Greece	1982	755
Annual	Number	Large containers (excluded swap bodies) - empty	International transport - loaded	European Union - 15 countries (1995-2004)	1982	152468
Annual	Number	Large containers (excluded swap bodies) - empty	International transport - loaded	France	1982	18728
Annual	Number	Large containers (excluded swap bodies) - empty	International transport - loaded	Italy	1982	48474
Annual	Number	Large containers (excluded swap bodies) - empty	International transport - loaded	Luxembourg	1982	255
Annual	Number	Large containers (excluded swap bodies) - empty	International transport - loaded	Netherlands	1982	22503
Annual	Number	Large containers (excluded swap bodies) - empty	International transport - unloaded	Belgium	1982	18519


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

Share link

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