New Trams

Eurostat code: road_eqr_trams · (2013 - 2023)

@eurostat.road_eqr_trams

Table List

2 tables(14.34 KB)

New Trams - Raw

New Trams - Unpivoted

New Trams - Raw

@eurostat.road_eqr_trams.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

9.94 KB
24 rows
14 columns

freq Freq	unit Unit	geo Geo	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022
Annual	Number	Albania
Annual	Number	Austria
Annual	Number	Bosnia and Herzegovina									61
Annual	Number	Bulgaria	5	20		6	31	7	12	15	11
Annual	Number	Switzerland
Annual	Number	Cyprus
Annual	Number	Czechia
Annual	Number	Denmark						17	4			16
Annual	Number	Estonia		1	17	3
Annual	Number	Spain


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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