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

Eurostat code: rail_pa_nbcar · (1979 - 2012)

@eurostat.rail_pa_nbcar

Table List

2 tables(35.43 KB)

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

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

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

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

7.87 KB
548 rows
6 columns

freq Freq	unit Unit	tra_cov Tra Cov	geo Geo	time_period Time Period	value Value
Annual	Number	Total transport	Belgium	1979	25902
Annual	Number	Total transport	France	1979	261240
Annual	Number	Total transport	Italy	1979	57706
Annual	Number	Total transport	Netherlands	1979	12416
Annual	Number	Total transport	United Kingdom	1979	78710
Annual	Number	Total transport	Belgium	1980	25055
Annual	Number	Total transport	France	1980	279190
Annual	Number	Total transport	Italy	1980	58478
Annual	Number	Total transport	Netherlands	1980	15291
Annual	Number	Total transport	United Kingdom	1980	66640


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.