Baselight

Annual Enterprise Statistics By Geographical Breakdown And Products (1995-2003)

Eurostat code: sbs_ins_5ffp96 ยท (1995 - 2003)

@eurostat.sbs_ins_5ffp96

Annual Enterprise Statistics By Geographical Breakdown And Products (1995-2003) - Unpivoted
@eurostat.sbs_ins_5ffp96.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.

  • 86.23 KB
  • 62528 rows
  • 8 columns
freq

Freq

indic_sb

Indic Sb

enterpr

Enterpr

cpa02

Cpa02

partner

Partner

geo

Geo

time_period

Time Period

value

Value

AnnualGross direct premiums written by CPA category (5-digit level) and by Member State, geographical breakdown of the business written under the right of establishment - million euroLife insurance business of composite insurance enterprisesNon linked life insurance servicesSpainItaly199538.5
AnnualGross direct premiums written by CPA category (5-digit level) and by Member State, geographical breakdown of the business written under the right of establishment - million euroLife insurance business of composite insurance enterprisesNon linked life insurance servicesUnited KingdomItaly199541.3
AnnualGross direct premiums written by CPA category (5-digit level) and by Member State, geographical breakdown of the business written under the right of establishment - million euroLife insurance business of composite insurance enterprisesTotalAustriaItaly1995
AnnualGross direct premiums written by CPA category (5-digit level) and by Member State, geographical breakdown of the business written under the right of establishment - million euroLife insurance business of composite insurance enterprisesTotalAustriaPortugal1995
AnnualGross direct premiums written by CPA category (5-digit level) and by Member State, geographical breakdown of the business written under the right of establishment - million euroLife insurance business of composite insurance enterprisesTotalBelgiumItaly1995
AnnualGross direct premiums written by CPA category (5-digit level) and by Member State, geographical breakdown of the business written under the right of establishment - million euroLife insurance business of composite insurance enterprisesTotalBelgiumPortugal1995
AnnualGross direct premiums written by CPA category (5-digit level) and by Member State, geographical breakdown of the business written under the right of establishment - million euroLife insurance business of composite insurance enterprisesTotalGermanyAustria19950.076
AnnualGross direct premiums written by CPA category (5-digit level) and by Member State, geographical breakdown of the business written under the right of establishment - million euroLife insurance business of composite insurance enterprisesTotalGermanyBelgium19950.104
AnnualGross direct premiums written by CPA category (5-digit level) and by Member State, geographical breakdown of the business written under the right of establishment - million euroLife insurance business of composite insurance enterprisesTotalGermanyItaly1995
AnnualGross direct premiums written by CPA category (5-digit level) and by Member State, geographical breakdown of the business written under the right of establishment - million euroLife insurance business of composite insurance enterprisesTotalGermanyPortugal1995

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