Baselight
Sign In

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

Eurostat code: rail_ac_catvict ยท (2004 - 2015)

@eurostat.rail_ac_catvict

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

  • 28.45 KB
  • 43680 rows
  • 8 columns
freq

Freq

unit

Unit

accident

Accident

victim

Victim

pers_cat

Pers Cat

geo

Geo

time_period

Time Period

value

Value

AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeInjuredEmployed personsAustria20043
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeInjuredEmployed personsBelgium20044
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeInjuredEmployed personsCzechia20045
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeInjuredEmployed personsGermany200419
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeInjuredEmployed personsDenmark2004
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeInjuredEmployed personsEstonia20041
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeInjuredEmployed personsGreece2004
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeInjuredEmployed personsSpain20043
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeInjuredEmployed personsFinland2004
AnnualNumberCollisions of trains, including collisions with obstacles within the clearance gaugeInjuredEmployed personsFrance20042

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

Share link

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