Wagons And Their Load Capacity By Type Of Wagons

Eurostat code: rail_eq_wagon · (1970 - 2023)

@eurostat.rail_eq_wagon

Table List

2 tables(125.39 KB)

Wagons And Their Load Capacity By Type Of Wagons - Raw

Wagons And Their Load Capacity By Type Of Wagons - Unpivoted

Wagons And Their Load Capacity By Type Of Wagons - Unpivoted

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

42.31 KB
7264 rows
6 columns

freq Freq	vehicle Vehicle	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Wagons	Number	Belgium	1970	48912
Annual	Wagons	Number	Germany	1970	321046
Annual	Wagons	Number	Denmark	1970	10265
Annual	Wagons	Number	Greece	1970	11452
Annual	Wagons	Number	Spain	1970	39030
Annual	Wagons	Number	France	1970	302440
Annual	Wagons	Number	Italy	1970	125919
Annual	Wagons	Number	Luxembourg	1970	4230
Annual	Wagons	Number	Netherlands	1970	19151
Annual	Wagons	Number	Portugal	1970	6894


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

Share link

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