New Trams

Eurostat code: road_eqr_trams · (2013 - 2023)

@eurostat.road_eqr_trams

Table List

2 tables(14.34 KB)

New Trams - Unpivoted

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

4.41 KB
122 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Number	Bulgaria	2013	5
Annual	Number	Denmark	2013
Annual	Number	Estonia	2013
Annual	Number	Liechtenstein	2013
Annual	Number	Lithuania	2013
Annual	Number	Latvia	2013	3
Annual	Number	Malta	2013
Annual	Number	Poland	2013	337
Annual	Number	Slovenia	2013
Annual	Number	Slovakia	2013


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

Share link

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