Passenger Railway Vehicles By Category Of Vehicle (until 2012)

Eurostat code: rail_eq_pa_nca · (1970 - 2012)

@eurostat.rail_eq_pa_nca

Table List

2 tables(58.66 KB)

Passenger Railway Vehicles By Category Of Vehicle (until 2012) - Raw

Passenger Railway Vehicles By Category Of Vehicle (until 2012) - Unpivoted

Passenger Railway Vehicles By Category Of Vehicle (until 2012) - Unpivoted

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

14.87 KB
2318 rows
6 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Number	Couchette coaches, sleeping cars	Sweden	1970	240
Annual	Number	Dining cars	Sweden	1970	48
Annual	Number	Total	Belgium	1970	2567
Annual	Number	Total	Germany	1970	17943
Annual	Number	Total	Denmark	1970	1150
Annual	Number	Total	Greece	1970	574
Annual	Number	Total	Spain	1970	2636
Annual	Number	Total	France	1970	11687
Annual	Number	Total	Italy	1970	9372
Annual	Number	Total	Luxembourg	1970	78


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.