Baselight

Non-autonomous Pension Funds (1997-2007)

Eurostat code: sbs_pen_7e ยท (1997 - 2007)

@eurostat.sbs_pen_7e

Non-autonomous Pension Funds (1997-2007) - Unpivoted
@eurostat.sbs_pen_7e.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.

  • 6.2 KB
  • 414 rows
  • 6 columns
freq

Freq

indic_sb

Indic Sb

nace_r1

Nace R1

geo

Geo

time_period

Time Period

value

Value

AnnualEnterprises with non-autonomous pension funds - numberTotal - all NACE activitiesBelgium1997101
AnnualEnterprises with non-autonomous pension funds - numberTotal - all NACE activitiesSwitzerland1997
AnnualEnterprises with non-autonomous pension funds - numberTotal - all NACE activitiesGermany199739233
AnnualEnterprises with non-autonomous pension funds - numberTotal - all NACE activitiesDenmark1997
AnnualEnterprises with non-autonomous pension funds - numberTotal - all NACE activitiesSpain1997453
AnnualEnterprises with non-autonomous pension funds - numberTotal - all NACE activitiesFinland1997149
AnnualEnterprises with non-autonomous pension funds - numberTotal - all NACE activitiesItaly199741
AnnualEnterprises with non-autonomous pension funds - numberTotal - all NACE activitiesBelgium1998101
AnnualEnterprises with non-autonomous pension funds - numberTotal - all NACE activitiesSpain1998475
AnnualEnterprises with non-autonomous pension funds - numberTotal - all NACE activitiesItaly1998170

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

Share link

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