Road Traffic Deaths, By Type Of Roads

Eurostat code: sdg_11_40 · (2000 - 2022)

@eurostat.sdg_11_40

Table List

2 tables(61.53 KB)

Road Traffic Deaths, By Type Of Roads - Raw

Road Traffic Deaths, By Type Of Roads - Unpivoted

Road Traffic Deaths, By Type Of Roads - Unpivoted

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

19.79 KB
5612 rows
6 columns

freq Freq	tra_infr Tra Infr	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Motorways	Number	Austria	2000	126
Annual	Motorways	Number	Belgium	2000	236
Annual	Motorways	Number	Czechia	2000	45
Annual	Motorways	Number	Germany	2000	907
Annual	Motorways	Number	Denmark	2000	29
Annual	Motorways	Number	Greece	2000	61
Annual	Motorways	Number	Spain	2000	347
Annual	Motorways	Number	European Union - 27 countries (from 2020)	2000	3456
Annual	Motorways	Number	Finland	2000	13
Annual	Motorways	Number	France	2000	517


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

Share link

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