Baselight
Sign In

Interests Receivable And Similar Income By Product (1997-2001)

Eurostat code: sbs_cre_pintrex ยท (1997 - 2001)

@eurostat.sbs_cre_pintrex

Interests Receivable And Similar Income By Product (1997-2001) - Unpivoted
@eurostat.sbs_cre_pintrex.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.

  • 10.17 KB
  • 327 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 6Interest receivable and similar income broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationOther monetary intermediation servicesTotalSweden199712058.947
AnnualAnnex 6Interest receivable and similar income broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationInter-industry credit granting servicesTotalBelgium19979554.489
AnnualAnnex 6Interest receivable and similar income broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationInter-industry credit granting servicesTotalSpain19977543.231
AnnualAnnex 6Interest receivable and similar income broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationInter-industry credit granting servicesTotalFinland1997879.326
AnnualAnnex 6Interest receivable and similar income broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationConsumer credit granting servicesTotalSpain19976407.766
AnnualAnnex 6Interest receivable and similar income broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationMortgage credit granting servicesTotalBelgium19973118.431
AnnualAnnex 6Interest receivable and similar income broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationMortgage credit granting servicesTotalSpain199711253.679
AnnualAnnex 6Interest receivable and similar income broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationMortgage credit granting servicesTotalNorway19972114.332
AnnualAnnex 6Interest receivable and similar income broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationCommercial credit granting servicesTotalSpain19975501.655
AnnualAnnex 6Interest receivable and similar income broken down by (sub)categories of the CPA - million euroOptionalMillion euroOther monetary intermediationOther credit granting services n.e.cTotalSpain199718880.792

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.