Baselight
Sign In

Annual Enterprise Statistics By Product (2002-2007)

Eurostat code: sbs_cre_prod ยท (2002 - 2007)

@eurostat.sbs_cre_prod

Annual Enterprise Statistics By Product (2002-2007) - Unpivoted
@eurostat.sbs_cre_prod.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.

  • 27.4 KB
  • 10987 rows
  • 7 columns
freq

Freq

indic_sb

Indic Sb

nace_r1

Nace R1

cpa02

Cpa02

geo

Geo

time_period

Time Period

value

Value

AnnualInterest receivable and similar income broken down by (sub)categories of the CPA - million euroOther monetary intermediationOther monetary intermediation servicesBelgium200256176.5
AnnualInterest receivable and similar income broken down by (sub)categories of the CPA - million euroOther monetary intermediationOther monetary intermediation servicesSpain200251364
AnnualInterest receivable and similar income broken down by (sub)categories of the CPA - million euroOther monetary intermediationOther monetary intermediation servicesHungary20023942.4
AnnualInterest receivable and similar income broken down by (sub)categories of the CPA - million euroOther monetary intermediationOther monetary intermediation servicesLatvia2002338.1
AnnualInterest receivable and similar income broken down by (sub)categories of the CPA - million euroOther monetary intermediationOther monetary intermediation servicesRomania20021815.2
AnnualInterest receivable and similar income broken down by (sub)categories of the CPA - million euroOther monetary intermediationOther monetary intermediation servicesSweden200211286.1
AnnualInterest receivable and similar income broken down by (sub)categories of the CPA - million euroOther monetary intermediationDeposit taking servicesSpain2002
AnnualInterest receivable and similar income broken down by (sub)categories of the CPA - million euroOther monetary intermediationDeposit taking servicesHungary2002
AnnualInterest receivable and similar income broken down by (sub)categories of the CPA - million euroOther monetary intermediationDeposit taking servicesRomania2002339.5
AnnualInterest receivable and similar income broken down by (sub)categories of the CPA - million euroOther monetary intermediationInter-industry deposit taking servicesSpain2002

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

Share link

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