National Road Freight Transport By Region Of Loading (NUTS 3) And Type Of Goods (t) - Annual Data (from 2008 Onwards)

Eurostat code: road_go_na_rl3g$dv_1581

@eurostat.road_go_na_rl3g_dv_1581

Table List

2 tables(21.18 KB)

National Road Freight Transport By Region Of Loading (NUTS 3) And Type Of Goods (t) - Annual Data (from 2008 Onwards) - Raw

National Road Freight Transport By Region Of Loading (NUTS 3) And Type Of Goods (t) - Annual Data (from 2008 Onwards) - Unpivoted

National Road Freight Transport By Region Of Loading (NUTS 3) And Type Of Goods (t) - Annual Data (from 2008 Onwards) - Unpivoted

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

8.1 KB
460 rows
6 columns

freq Freq	nst07 Nst07	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total transported goods	Thousand tonnes	Kýpros	2013	16099
Annual	Total transported goods	Thousand tonnes	Bornholm	2013	785
Annual	Total transported goods	Thousand tonnes	Lesvos, Limnos	2013	1694
Annual	Total transported goods	Thousand tonnes	Ikaria, Samos	2013	2080
Annual	Total transported goods	Thousand tonnes	Chios	2013	979
Annual	Total transported goods	Thousand tonnes	Kalymnos, Karpathos – Iroiki Nisos Kasos, Kos, Rodos	2013	3985
Annual	Total transported goods	Thousand tonnes	Andros, Thira, Kea, Milos, Mykonos, Naxos, Paros, Syros, Tinos	2013	5129
Annual	Total transported goods	Thousand tonnes	Irakleio	2013	13353
Annual	Total transported goods	Thousand tonnes	Lasithi	2013	1108
Annual	Total transported goods	Thousand tonnes	Rethymni	2013	1888


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

Share link

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