Accidents In Inland Waterway Transport

Eurostat code: iww_ac_nbac · (1995 - 2023)

@eurostat.iww_ac_nbac

Table List

2 tables(27.46 KB)

Accidents In Inland Waterway Transport - Raw

Accidents In Inland Waterway Transport - Unpivoted

Accidents In Inland Waterway Transport - Unpivoted

@eurostat.iww_ac_nbac.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.

5.33 KB
240 rows
6 columns

freq Freq	accident Accident	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Accidents involving transport of dangerous goods	Number	Czechia	1995
Annual	Total	Number	Czechia	1995	32
Annual	Accidents involving transport of dangerous goods	Number	Czechia	1996
Annual	Total	Number	Czechia	1996	12
Annual	Accidents involving transport of dangerous goods	Number	Czechia	1997
Annual	Total	Number	Czechia	1997	27
Annual	Accidents involving transport of dangerous goods	Number	Czechia	1998
Annual	Total	Number	Czechia	1998	16
Annual	Accidents involving transport of dangerous goods	Number	Czechia	1999
Annual	Total	Number	Czechia	1999	17


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

Share link

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