Passenger Railway Vehicles, By Type Of Vehicle

Eurostat code: rail_eq_pa_nty · (1990 - 2023)

@eurostat.rail_eq_pa_nty

Table List

2 tables(64.18 KB)

Passenger Railway Vehicles, By Type Of Vehicle - Raw

Passenger Railway Vehicles, By Type Of Vehicle - Unpivoted

Passenger Railway Vehicles, By Type Of Vehicle - Unpivoted

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

18.92 KB
3728 rows
6 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Number	Coaches and railcar trailers	Belgium	1990	1826
Annual	Number	Coaches and railcar trailers	Bulgaria	1990	1932
Annual	Number	Coaches and railcar trailers	Switzerland	1990	3804
Annual	Number	Coaches and railcar trailers	Germany	1990	11390
Annual	Number	Coaches and railcar trailers	Denmark	1990	734
Annual	Number	Coaches and railcar trailers	Greece	1990	512
Annual	Number	Coaches and railcar trailers	Spain	1990	1864
Annual	Number	Coaches and railcar trailers	Finland	1990	801
Annual	Number	Coaches and railcar trailers	France	1990	9720
Annual	Number	Coaches and railcar trailers	Hungary	1990	4172


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

Share link

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