Train Traffic On The Rail Network - Bulgaria (2020)

Eurostat code: rail_tf_ns20_bg · (2020 - 2020)

@eurostat.rail_tf_ns20_bg

Table List

2 tables(12.29 KB)

Train Traffic On The Rail Network - Bulgaria (2020) - Raw

Train Traffic On The Rail Network - Bulgaria (2020) - Unpivoted

Train Traffic On The Rail Network - Bulgaria (2020) - Unpivoted

@eurostat.rail_tf_ns20_bg.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.43 KB
192 rows
6 columns

freq Freq	net_seg20 Net Seg20	train Train	unit Unit	time_period Time Period	value Value
Annual	Dragoman - Sofia	Goods trains	Number	2020	4500
Annual	Dragoman - Sofia	Other trains	Number	2020	2180
Annual	Dragoman - Sofia	Passenger trains	Number	2020	5031
Annual	Septemvri - Sofia	Goods trains	Number	2020	3300
Annual	Septemvri - Sofia	Other trains	Number	2020	978
Annual	Septemvri - Sofia	Passenger trains	Number	2020	7140
Annual	Septemvri - Plovdiv	Goods trains	Number	2020	3820
Annual	Septemvri - Plovdiv	Other trains	Number	2020	562
Annual	Septemvri - Plovdiv	Passenger trains	Number	2020	7375
Annual	Plovdiv - Dimitrovgrad	Goods trains	Number	2020	3396


CREATE TABLE tidy (
  "freq" VARCHAR,
  "net_seg20" VARCHAR,
  "train" VARCHAR,
  "unit" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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