Road Accidents By NUTS 3 Region

Eurostat code: tran_sf_roadnu · (1999 - 2022)

@eurostat.tran_sf_roadnu

Table List

2 tables(420.19 KB)

Road Accidents By NUTS 3 Region - Unpivoted

Road Accidents By NUTS 3 Region - Unpivoted

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

162.69 KB
46764 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Number	Austria	1999	42348
Annual	Number	Ostösterreich	1999	13498
Annual	Number	Burgenland	1999	987
Annual	Number	Mittelburgenland	1999	127
Annual	Number	Nordburgenland	1999	505
Annual	Number	Südburgenland	1999	355
Annual	Number	Niederösterreich	1999	7617
Annual	Number	Mostviertel-Eisenwurzen	1999	1235
Annual	Number	Niederösterreich-Süd	1999	1589
Annual	Number	Sankt Pölten	1999	733


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.