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 - Unpivoted

@eurostat.rail_if_lvlcros.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

11.12 KB
1276 rows
6 columns

freq Freq	lvlcros Lvlcros	geo Geo	unit Unit	time_period Time Period	value Value
Annual	Active	Ireland	Number	2006	217
Annual	Passive	Ireland	Number	2006	954
Annual	Total	Austria	Number	2006	6977
Annual	Total	Czechia	Number	2006	8576
Annual	Total	Germany	Number	2006	20317
Annual	Total	Denmark	Number	2006	1548
Annual	Total	Greece	Number	2006	1270
Annual	Total	Finland	Number	2006	4430
Annual	Total	France	Number	2006	16804
Annual	Total	Hungary	Number	2006	5981


CREATE TABLE tidy (
  "freq" VARCHAR,
  "lvlcros" VARCHAR,
  "geo" VARCHAR,
  "unit" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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