Trainsets And Capacity By Type Of Speed

Eurostat code: rail_eq_trset · (2008 - 2023)

@eurostat.rail_eq_trset

Table List

2 tables(26.12 KB)

Trainsets And Capacity By Type Of Speed - Raw

Trainsets And Capacity By Type Of Speed - Unpivoted

Trainsets And Capacity By Type Of Speed - Raw

@eurostat.rail_eq_trset.raw

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

17.68 KB
170 rows
20 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	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	n_2023 2023
Annual	Number	Total	Albania
Annual	Number	Total	Austria					58	58	58	58	67	60	92	84	84	89	517	609
Annual	Number	Total	Bosnia and Herzegovina										17	17	17	17	17	17	17
Annual	Number	Total	Denmark	514	576	607	647	666	685	702	722	596	544	544	530	518	524	501	491
Annual	Number	Total	Estonia							38	38	38	38	38	38	38	38	38	38
Annual	Number	Total	Greece	727			727	727		132	132	132	132	70	70	70	70	68	68
Annual	Number	Total	Spain		1074							1306	294	308	1551	1739	1729	1802	1443
Annual	Number	Total	Finland	148	165	168	174	183	187	194	194	217	234	234
Annual	Number	Total	Georgia											37	37	37	37	37	37
Annual	Number	Total	Croatia	146	140	140	138	162	162	162	178	183	178	173	176	253	269	306	357


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "vehicle" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "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.