Length Of Railway Lines By Number Of Tracks And Electrification Of Lines

Eurostat code: rail_if_line_tr · (1990 - 2023)

@eurostat.rail_if_line_tr

Table List

2 tables(127.29 KB)

Length Of Railway Lines By Number Of Tracks And Electrification Of Lines - Raw

Length Of Railway Lines By Number Of Tracks And Electrification Of Lines - Unpivoted

Length Of Railway Lines By Number Of Tracks And Electrification Of Lines - Raw

@eurostat.rail_if_line_tr.raw

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

80.57 KB
360 rows
39 columns

freq Freq	tra_infr Tra Infr	n_tracks N Tracks	unit Unit	geo Geo	n_1990 1990	n_1991 1991	n_1992 1992	n_1993 1993	n_1994 1994	n_1995 1995	n_1996 1996	n_1997 1997	n_1998 1998	n_1999 1999	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	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	Electrified railway lines	1 track	Kilometre	Albania
Annual	Electrified railway lines	1 track	Kilometre	Austria	1586	1570	1567	1587	1602	1618	1634	1650	1666	1682	1698	1714	1730	1585	1518	1478	1475	1475	1477	2002	1832	1794	1793	1796	1796	1794	1792	1798	1793	1810	1824	1835	1849	1869
Annual	Electrified railway lines	1 track	Kilometre	Bosnia and Herzegovina	751	751	751	751	751	663	689	689	688	687	688	686	687	687	654	654	655	679	679	679	678	678	678	679	679	679	655	655	655	655	656	655	655	662
Annual	Electrified railway lines	1 track	Kilometre	Belgium	162	162	159	185	186	185	208	206	306	345	347	340	355	354	357	372	383	383	309	349							333	344	339.366	334.035	334.332	354.532	404	413
Annual	Electrified railway lines	1 track	Kilometre	Bulgaria	1680	1680	1690	1690	1681	1687	1741	1742	1743	1743	1776	1880.1	1880.1	1902	1906.4	1923	1939	1835	1855	1862	1837	1885	1885	1880	1872	1871	1880	1880	1880	1880	1881	2006	2010	2006
Annual	Electrified railway lines	1 track	Kilometre	Switzerland	3215	3211	3210	16204	3197	3179	3172	3116	3075	3340	3248	3234	3229	3216	3155	3158	3260	3259	3254	3267	3203	3210	3215	3087	3222	3195	3179	3211	3203	3203	3210	3198	3176	3179
Annual	Electrified railway lines	1 track	Kilometre	Czechia				999	999	971	1134	1135	1134.1	1130	1130	1232	1227	1255	1274	1272	1291	1294	1262	1345	1376	1368	1363	1363	1346	1346	1344	1340	1294	1286	1284	1279	1244	1285
Annual	Electrified railway lines	1 track	Kilometre	Germany	3134	3152	3220	3406	3822	3871	3844	4049	4147	4093.8	4081.55	4089	4044	4544	4487	4423	4529	4501	4544	4542	4487	4551	4526	4567	4633	4624	4648.588	4558	4478	4764	4803	4955.273	5017.119	4943
Annual	Electrified railway lines	1 track	Kilometre	Denmark	1	25	23	23	23	23	23	100	100	100	104	104	104	104	104	104	104	104	104	104	104	104	104	104	104	104	104	104	104	104	104	104	104	104
Annual	Electrified railway lines	1 track	Kilometre	Estonia	64.3	64.3	64.3	64.3	64.3	64.3	64.3	64	64	64	64	64	64	64	64	64	64	65	63	63	65	65	65	65	56	56	56	56	56	56	56	56	60	53


CREATE TABLE raw (
  "freq" VARCHAR,
  "tra_infr" VARCHAR,
  "n_tracks" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "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
);