Share Of Buses And Trains In Inland Passenger Transport

Eurostat code: sdg_09_50 · (2000 - 2022)

@eurostat.sdg_09_50

Table List

2 tables(38.76 KB)

Share Of Buses And Trains In Inland Passenger Transport - Raw

Share Of Buses And Trains In Inland Passenger Transport - Unpivoted

Share Of Buses And Trains In Inland Passenger Transport - Unpivoted

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

9.72 KB
2406 rows
6 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Percentage	Motor coaches, buses and trolley buses	Austria	2000	11
Annual	Percentage	Motor coaches, buses and trolley buses	Belgium	2000	10.8
Annual	Percentage	Motor coaches, buses and trolley buses	Bulgaria	2000	31.4
Annual	Percentage	Motor coaches, buses and trolley buses	Switzerland	2000	5.2
Annual	Percentage	Motor coaches, buses and trolley buses	Cyprus	2000	22.3
Annual	Percentage	Motor coaches, buses and trolley buses	Czechia	2000	18.6
Annual	Percentage	Motor coaches, buses and trolley buses	Germany	2000	7.1
Annual	Percentage	Motor coaches, buses and trolley buses	Denmark	2000	12.4
Annual	Percentage	Motor coaches, buses and trolley buses	Estonia	2000	27.5
Annual	Percentage	Motor coaches, buses and trolley buses	Greece	2000	25.1


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.