New Lorries By Alternative Motor Energy And Load Capacity Of +/- 1500 Kg (until 2012)

Eurostat code: road_eqr_loralt · (2006 - 2012)

@eurostat.road_eqr_loralt

Table List

2 tables(21.58 KB)

New Lorries By Alternative Motor Energy And Load Capacity Of +/- 1500 Kg (until 2012) - Raw

New Lorries By Alternative Motor Energy And Load Capacity Of +/- 1500 Kg (until 2012) - Unpivoted

New Lorries By Alternative Motor Energy And Load Capacity Of +/- 1500 Kg (until 2012) - Unpivoted

@eurostat.road_eqr_loralt.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.23 KB
1525 rows
7 columns

freq Freq	unit Unit	weight Weight	mot_nrg Mot Nrg	geo Geo	time_period Time Period	value Value
Annual	Number	1 500 kg or over	Electricity	Austria	2006
Annual	Number	1 500 kg or over	Electricity	Switzerland	2006
Annual	Number	1 500 kg or over	Electricity	Germany	2006	14
Annual	Number	1 500 kg or over	Electricity	Estonia	2006
Annual	Number	1 500 kg or over	Electricity	Finland	2006
Annual	Number	1 500 kg or over	Electricity	France	2006	2
Annual	Number	1 500 kg or over	Electricity	Hungary	2006
Annual	Number	1 500 kg or over	Electricity	Liechtenstein	2006
Annual	Number	1 500 kg or over	Electricity	Lithuania	2006
Annual	Number	1 500 kg or over	Electricity	Luxembourg	2006


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

Share link

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