Multi Yearly Statistics By NUTS 2 Region (NUTS 2006) (1999-2004)

Eurostat code: sbs_r_3f_my · (1999 - 2004)

@eurostat.sbs_r_3f_my

Table List

2 tables(109.53 KB)

Multi Yearly Statistics By NUTS 2 Region (NUTS 2006) (1999-2004) - Raw

Multi Yearly Statistics By NUTS 2 Region (NUTS 2006) (1999-2004) - Unpivoted

Multi Yearly Statistics By NUTS 2 Region (NUTS 2006) (1999-2004) - Unpivoted

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

53.38 KB
8059 rows
6 columns

freq Freq	nace_r1 Nace R1	indic_sb Indic Sb	geo Geo	time_period Time Period	value Value
Annual	Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel	Turnover or gross premiums written - million euro	Germany	1999	146548.5
Annual	Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel	Turnover or gross premiums written - million euro	Baden-Württemberg	1999	18261.8
Annual	Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel	Turnover or gross premiums written - million euro	Stuttgart	1999	8251.7
Annual	Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel	Turnover or gross premiums written - million euro	Karlsruhe	1999	4246.6
Annual	Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel	Turnover or gross premiums written - million euro	Freiburg	1999	3158.2
Annual	Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel	Turnover or gross premiums written - million euro	Tübingen	1999	2605.3
Annual	Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel	Turnover or gross premiums written - million euro	Bayern	1999	25080.7
Annual	Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel	Turnover or gross premiums written - million euro	Oberbayern	1999	9465
Annual	Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel	Turnover or gross premiums written - million euro	Niederbayern	1999	2145.2
Annual	Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel	Turnover or gross premiums written - million euro	Oberpfalz	1999	2272.2


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

Share link

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