Baselight
Sign In

Commissions Payable By Product (1997-2001)

Eurostat code: sbs_cre_pcpay ยท (1997 - 2001)

@eurostat.sbs_cre_pcpay

Commissions Payable By Product (1997-2001) - Unpivoted
@eurostat.sbs_cre_pcpay.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.

  • 11.19 KB
  • 575 rows
  • 11 columns
freq

Freq

annex

Annex

indic_sb

Indic Sb

priority

Priority

unit

Unit

nace_r1

Nace R1

cpa02

Cpa02

partner

Partner

geo

Geo

time_period

Time Period

value

Value

AnnualAnnex 6Commissions receivable broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationOther monetary intermediation servicesTotalBelgium1997
AnnualAnnex 6Commissions receivable broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationOther monetary intermediation servicesTotalSweden19972251.025
AnnualAnnex 6Commissions receivable broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationDeposit taking servicesTotalBelgium1997
AnnualAnnex 6Commissions receivable broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationDeposit taking servicesTotalSpain19972872.22
AnnualAnnex 6Commissions receivable broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationDeposit taking servicesTotalFinland1997290.104
AnnualAnnex 6Commissions receivable broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationInter-industry deposit taking servicesTotalBelgium1997
AnnualAnnex 6Commissions receivable broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationStandardised deposit taking servicesTotalBelgium1997
AnnualAnnex 6Commissions receivable broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationNon-standardised deposit taking servicesTotalBelgium1997
AnnualAnnex 6Commissions receivable broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationCredit granting servicesTotalBelgium1997
AnnualAnnex 6Commissions receivable broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationCredit granting servicesTotalSpain1997102.636

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

Share link

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