Economic Variables Being Part Of Annex1 To Council Regulation 58/97 (1992-2001)

Eurostat code: sbs_cre_tannex1 · (1992 - 2001)

@eurostat.sbs_cre_tannex1

Table List

2 tables(73.16 KB)

Economic Variables Being Part Of Annex1 To Council Regulation 58/97 (1992-2001) - Raw

Economic Variables Being Part Of Annex1 To Council Regulation 58/97 (1992-2001) - Unpivoted

Economic Variables Being Part Of Annex1 To Council Regulation 58/97 (1992-2001) - Unpivoted

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

34.15 KB
4827 rows
9 columns

freq Freq	annex Annex	indic_sb Indic Sb	priority Priority	unit Unit	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Annex 1	Enterprises - number	Data collection on voluntary basis	Number	Other monetary intermediation	Austria	1992	1023
Annual	Annex 1	Enterprises - number	Data collection on voluntary basis	Number	Other monetary intermediation	Belgium	1992	134
Annual	Annex 1	Enterprises - number	Data collection on voluntary basis	Number	Other monetary intermediation	Switzerland	1992	463
Annual	Annex 1	Enterprises - number	Data collection on voluntary basis	Number	Other monetary intermediation	Germany	1992	3635
Annual	Annex 1	Enterprises - number	Data collection on voluntary basis	Number	Other monetary intermediation	Denmark	1992	221
Annual	Annex 1	Enterprises - number	Data collection on voluntary basis	Number	Other monetary intermediation	Greece	1992	49
Annual	Annex 1	Enterprises - number	Data collection on voluntary basis	Number	Other monetary intermediation	Spain	1992	319
Annual	Annex 1	Enterprises - number	Data collection on voluntary basis	Number	Other monetary intermediation	Ireland	1992	49
Annual	Annex 1	Enterprises - number	Data collection on voluntary basis	Number	Other monetary intermediation	Iceland	1992	117
Annual	Annex 1	Enterprises - number	Data collection on voluntary basis	Number	Other monetary intermediation	Luxembourg	1992	213


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

Share link

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