Level Crossings By Type

Eurostat code: rail_if_lvlcros · (2006 - 2023)

@eurostat.rail_if_lvlcros

Table List

2 tables(33.33 KB)

Level Crossings By Type - Raw

Level Crossings By Type - Unpivoted

Level Crossings By Type - Raw

@eurostat.rail_if_lvlcros.raw

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

22.2 KB
84 rows
22 columns

freq Freq	lvlcros Lvlcros	geo Geo	unit Unit	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	Active	Austria	Number		1935	1900	1886	1897	1881	1903	1877	1869	1921	1954	1892	1856	1843	1742
Annual	Active	Belgium	Number		1611	1595	1590	1581	1554	1530	1514	1503	1490	1476	1452	1443	1426	1418
Annual	Active	Bulgaria	Number		669	654	646	648	632	626	622	609	607	607	604	603	597	592
Annual	Active	Switzerland	Number	1309	1345	1377	1355	1375	1389	1402	1403	1403	1401	1396	1401	1403	1402	1403
Annual	Active	Czechia	Number		3818	3735	3735	3743	3749	3892	4023	4146	4205	4251	4272	4337	4360	4349
Annual	Active	Germany	Number		10313	9925	9869	9920	9844	9847	9775	9782	9734	9722	9667	9688	9694	9662
Annual	Active	Denmark	Number		722	865	806	933	924	811	811	941	814	795	741	765	743	745
Annual	Active	Estonia	Number		164	165	165	165	168	166	166	166	166	157	165	176	178	183
Annual	Active	Greece	Number		817	723	806	779	760	749	749	692	695	685	684	685	449	390
Annual	Active	Spain	Number		971	946	928	1187	1181	1165	1168	1153	1143	1138	1126	1081	1066	1004


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

Share link

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