Baselight
Sign In

Business Written In Non-EEA Countries (1997-2001)

Eurostat code: sbs_cre_gbneea ยท (1997 - 2001)

@eurostat.sbs_cre_gbneea

Business Written In Non-EEA Countries (1997-2001) - Unpivoted
@eurostat.sbs_cre_gbneea.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.

  • 9 KB
  • 319 rows
  • 10 columns
freq

Freq

annex

Annex

indic_sb

Indic Sb

priority

Priority

unit

Unit

nace_r1

Nace R1

partner

Partner

geo

Geo

time_period

Time Period

value

Value

AnnualAnnex 6Geographical breakdown of interest receivable and similar income via branch business (in non-EEA countries) - million euroOptionalMillion euroOther monetary intermediationSwitzerlandSweden1997
AnnualAnnex 6Geographical breakdown of interest receivable and similar income via branch business (in non-EEA countries) - million euroOptionalMillion euroOther monetary intermediationJapanSweden199711.559
AnnualAnnex 6Geographical breakdown of interest receivable and similar income via branch business (in non-EEA countries) - million euroOptionalMillion euroOther monetary intermediationUnited StatesSweden1997398.096
AnnualAnnex 6Geographical breakdown of interest receivable and similar income via branch business (in non-EEA countries) - million euroOptionalMillion euroOther monetary intermediationWorld - not allocatedSweden1997583.736
AnnualAnnex 6Geographical breakdown of interest receivable and similar income via branch business (in non-EEA countries) - million euroOptionalMillion euroTotal credit institutionsSwitzerlandSweden1997
AnnualAnnex 6Geographical breakdown of interest receivable and similar income via branch business (in non-EEA countries) - million euroOptionalMillion euroTotal credit institutionsJapanSweden199711.559
AnnualAnnex 6Geographical breakdown of interest receivable and similar income via branch business (in non-EEA countries) - million euroOptionalMillion euroTotal credit institutionsUnited StatesSweden1997398.096
AnnualAnnex 6Geographical breakdown of interest receivable and similar income via branch business (in non-EEA countries) - million euroOptionalMillion euroTotal credit institutionsWorld - not allocatedSweden1997583.736
AnnualAnnex 6Geographical breakdown of interest receivable and similar income via branch business (in non-EEA countries) - million euroOptionalMillion euroOther credit grantingSwitzerlandSweden1997
AnnualAnnex 6Geographical breakdown of interest receivable and similar income via branch business (in non-EEA countries) - million euroOptionalMillion euroOther credit grantingJapanSweden1997

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

Share link

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