Baselight
Sign In

Number Of Loans And Advances To Customers Linked To CPA Categories (1997-2001)

Eurostat code: sbs_cre_ploans ยท (1997 - 2001)

@eurostat.sbs_cre_ploans

Number Of Loans And Advances To Customers Linked To CPA Categories (1997-2001) - Unpivoted
@eurostat.sbs_cre_ploans.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.13 KB
  • 164 rows
  • 11 columns
freq

Freq

annex

Annex

indic_sb

Indic Sb

priority

Priority

cpa02

Cpa02

unit

Unit

nace_r1

Nace R1

partner

Partner

geo

Geo

time_period

Time Period

value

Value

AnnualAnnex 6Loans and advances to customers broken down by (sub)categories of the CPA - numberOptionalConsumer credit granting servicesNumberOther monetary intermediationTotalBelgium19972504269
AnnualAnnex 6Loans and advances to customers broken down by (sub)categories of the CPA - numberOptionalConsumer credit granting servicesNumberOther monetary intermediationTotalSwitzerland1997258312
AnnualAnnex 6Loans and advances to customers broken down by (sub)categories of the CPA - numberOptionalConsumer credit granting servicesNumberTotal credit institutionsTotalBelgium19972504269
AnnualAnnex 6Loans and advances to customers broken down by (sub)categories of the CPA - numberOptionalConsumer credit granting servicesNumberTotal credit institutionsTotalSwitzerland1997375057
AnnualAnnex 6Loans and advances to customers broken down by (sub)categories of the CPA - numberOptionalConsumer credit granting servicesNumberOther credit grantingTotalSwitzerland1997116745
AnnualAnnex 6Loans and advances to customers broken down by (sub)categories of the CPA - numberOptionalOther credit granting services n.e.cNumberOther monetary intermediationTotalSpain199711435936
AnnualAnnex 6Loans and advances to customers broken down by (sub)categories of the CPA - numberOptionalOther credit granting services n.e.cNumberTotal credit institutionsTotalSpain199711573709
AnnualAnnex 6Loans and advances to customers broken down by (sub)categories of the CPA - numberOptionalOther credit granting services n.e.cNumberOther credit grantingTotalSpain1997137773
AnnualAnnex 6Loans and advances to customers broken down by (sub)categories of the CPA - numberOptionalOther monetary intermediation servicesNumberOther monetary intermediationTotalSpain199813375251
AnnualAnnex 6Loans and advances to customers broken down by (sub)categories of the CPA - numberOptionalOther monetary intermediation servicesNumberTotal credit institutionsTotalSpain199813581397

CREATE TABLE tidy (
  "freq" VARCHAR,
  "annex" VARCHAR,
  "indic_sb" VARCHAR,
  "priority" VARCHAR,
  "cpa02" 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.