Road Accidents: Persons Killed

Eurostat code: med_rd7 · (2005 - 2018)

@eurostat.med_rd7

Table List

2 tables(16.57 KB)

Road Accidents: Persons Killed - Unpivoted

Road Accidents: Persons Killed - Unpivoted

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

4.6 KB
109 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Number	Algeria	2005	3711
Annual	Number	Egypt	2005	6109
Annual	Number	Israel	2005	465
Annual	Number	Jordan	2005	790
Annual	Number	Lebanon	2005	339
Annual	Number	Morocco	2005	3617
Annual	Number	Palestine*	2005	159
Annual	Number	Tunisia	2005	1519
Annual	Number	Algeria	2006	4120
Annual	Number	Egypt	2006	6180


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

Share link

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