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

Eurostat code: road_go_na_ru3g$dv_1582

@eurostat.road_go_na_ru3g_dv_1582

Table List

2 tables(21.16 KB)

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

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

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

@eurostat.road_go_na_ru3g_dv_1582.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.08 KB
461 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	776
Annual	Total transported goods	Thousand tonnes	Lesvos, Limnos	2013	1726
Annual	Total transported goods	Thousand tonnes	Ikaria, Samos	2013	2264
Annual	Total transported goods	Thousand tonnes	Chios	2013	1288
Annual	Total transported goods	Thousand tonnes	Kalymnos, Karpathos – Iroiki Nisos Kasos, Kos, Rodos	2013	4069
Annual	Total transported goods	Thousand tonnes	Andros, Thira, Kea, Milos, Mykonos, Naxos, Paros, Syros, Tinos	2013	5268
Annual	Total transported goods	Thousand tonnes	Irakleio	2013	12494
Annual	Total transported goods	Thousand tonnes	Lasithi	2013	1859
Annual	Total transported goods	Thousand tonnes	Rethymni	2013	2203


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.