Railway Enterprises By Type Of Enterprise

Eurostat code: rail_ec_ent · (1970 - 2023)

@eurostat.rail_ec_ent

Table List

2 tables(50.7 KB)

Railway Enterprises By Type Of Enterprise - Raw

Railway Enterprises By Type Of Enterprise - Unpivoted

Railway Enterprises By Type Of Enterprise - Raw

@eurostat.rail_ec_ent.raw

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

42.37 KB
134 rows
58 columns

freq Freq	unit Unit	enterpr Enterpr	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	Infrastructure manager	Albania
Annual	Number	Infrastructure manager	Austria				5	5	5	5	5	4	9	9	9	9	9	9	9
Annual	Number	Infrastructure manager	Bulgaria						1	1	1	1	1	1	1	1	1	1	1
Annual	Number	Infrastructure manager	Switzerland	9	9	9	8	8	10	8	9	9	9	9	9	9	9	9	9
Annual	Number	Infrastructure manager	Czechia	1	1	1	1	2	2	2	3	3	4	5	5	5	2	2	2
Annual	Number	Infrastructure manager	Germany	257	282		267	200	207	199
Annual	Number	Infrastructure manager	Denmark														2	2	2
Annual	Number	Infrastructure manager	Estonia															2	2
Annual	Number	Infrastructure manager	Greece	1	1			1	1	2	2	2	2	2	2	2	2	2	2
Annual	Number	Infrastructure manager	Spain		1	1	1	1	1	1	1	1	1	1	1	2	2	2	2


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "enterpr" VARCHAR,
  "geo" VARCHAR,
  "n_1970" DOUBLE,
  "n_1971" DOUBLE,
  "n_1972" DOUBLE,
  "n_1973" DOUBLE,
  "n_1974" DOUBLE,
  "n_1975" DOUBLE,
  "n_1976" DOUBLE,
  "n_1977" DOUBLE,
  "n_1978" DOUBLE,
  "n_1979" DOUBLE,
  "n_1980" DOUBLE,
  "n_1981" DOUBLE,
  "n_1982" DOUBLE,
  "n_1983" DOUBLE,
  "n_1984" DOUBLE,
  "n_1985" DOUBLE,
  "n_1986" DOUBLE,
  "n_1987" DOUBLE,
  "n_1988" DOUBLE,
  "n_1989" DOUBLE,
  "n_1990" DOUBLE,
  "n_1991" DOUBLE,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "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
);