Baselight
Sign In

Railway Accidents By Type Of Accident - Annual Data (2004-2015)

Eurostat code: rail_ac_catnmbr ยท (2004 - 2016)

@eurostat.rail_ac_catnmbr

Railway Accidents By Type Of Accident - Annual Data (2004-2015) - Unpivoted
@eurostat.rail_ac_catnmbr.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.

  • 10.33 KB
  • 3168 rows
  • 6 columns
freq

Freq

unit

Unit

accident

Accident

geo

Geo

time_period

Time Period

value

Value

AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeAustria20045
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeBelgium20043
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeCzechia20045
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeGermany2004400
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeDenmark20041
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeEstonia20045
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeGreece20041
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeSpain20045
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeFinland2004
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeFrance200413

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

Share link

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