Number Of Enterprises And Persons Employed By Category Of Credit Institutions (1997-2012)

Eurostat code: sbs_cre_icat · (1997 - 2012)

@eurostat.sbs_cre_icat

Table List

2 tables(53.49 KB)

Number Of Enterprises And Persons Employed By Category Of Credit Institutions (1997-2012) - Raw

Number Of Enterprises And Persons Employed By Category Of Credit Institutions (1997-2012) - Unpivoted

Number Of Enterprises And Persons Employed By Category Of Credit Institutions (1997-2012) - Unpivoted

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

22.57 KB
6823 rows
7 columns

freq Freq	indic_sb Indic Sb	nace_r1 Nace R1	credinst Credinst	geo Geo	time_period Time Period	value Value
Annual	Number of enterprises broken down by category of credit institutions - number	Other monetary intermediation	Licensed banks	Austria	1997	892
Annual	Number of enterprises broken down by category of credit institutions - number	Other monetary intermediation	Licensed banks	Belgium	1997	109
Annual	Number of enterprises broken down by category of credit institutions - number	Other monetary intermediation	Licensed banks	Switzerland	1997	395
Annual	Number of enterprises broken down by category of credit institutions - number	Other monetary intermediation	Licensed banks	Denmark	1997	196
Annual	Number of enterprises broken down by category of credit institutions - number	Other monetary intermediation	Licensed banks	Greece	1997	39
Annual	Number of enterprises broken down by category of credit institutions - number	Other monetary intermediation	Licensed banks	Spain	1997	307
Annual	Number of enterprises broken down by category of credit institutions - number	Other monetary intermediation	Licensed banks	Finland	1997	343
Annual	Number of enterprises broken down by category of credit institutions - number	Other monetary intermediation	Licensed banks	Italy	1997	931
Annual	Number of enterprises broken down by category of credit institutions - number	Other monetary intermediation	Licensed banks	Luxembourg	1997	215
Annual	Number of enterprises broken down by category of credit institutions - number	Other monetary intermediation	Licensed banks	Netherlands	1997	90


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

Share link

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