Passengers In Accompanied Passenger Car Railway Transport, By Type Of Transport

Eurostat code: rail_pa_nbpass · (1979 - 2012)

@eurostat.rail_pa_nbpass

Table List

2 tables(32.45 KB)

Passengers In Accompanied Passenger Car Railway Transport, By Type Of Transport - Raw

Passengers In Accompanied Passenger Car Railway Transport, By Type Of Transport - Unpivoted

Passengers In Accompanied Passenger Car Railway Transport, By Type Of Transport - Unpivoted

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

6.41 KB
335 rows
6 columns

freq Freq	unit Unit	tra_cov Tra Cov	geo Geo	time_period Time Period	value Value
Annual	Passenger	International transport	Belgium	1979	84000
Annual	Passenger	International transport	France	1979	205000
Annual	Passenger	International transport	Italy	1979	54000
Annual	Passenger	International transport	Netherlands	1979	40000
Annual	Passenger	International transport	United Kingdom	1979	2000
Annual	Passenger	Total transport	Belgium	1979	84000
Annual	Passenger	Total transport	Greece	1979	1788000
Annual	Passenger	Total transport	France	1979	625000
Annual	Passenger	Total transport	Italy	1979	166000
Annual	Passenger	Total transport	Netherlands	1979	40000


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

Share link

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