Annual Enterprise Statistics By Geographical Breakdown And Products (2004-2007)
Eurostat code: sbs_ins_5ffp04 ยท (2004 - 2007)
@eurostat.sbs_ins_5ffp04
Annual Enterprise Statistics By Geographical Breakdown And Products (2004-2007) - Unpivoted
@eurostat.sbs_ins_5ffp04.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.
- 97.06 KB
- 125267 rows
- 8 columns
freqFreq | indic_sbIndic Sb | enterprEnterpr | cpa02Cpa02 | partnerPartner | geoGeo | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|---|
| Annual | Gross 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 euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Austria | Belgium | 2004 | |
| Annual | Gross 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 euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Austria | Estonia | 2004 | |
| Annual | Gross 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 euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Austria | Spain | 2004 | |
| Annual | Gross 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 euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Austria | Italy | 2004 | |
| Annual | Gross 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 euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Austria | Lithuania | 2004 | |
| Annual | Gross 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 euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Austria | Luxembourg | 2004 | |
| Annual | Gross 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 euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Austria | Portugal | 2004 | |
| Annual | Gross 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 euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Belgium | Belgium | 2004 | |
| Annual | Gross 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 euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Belgium | Estonia | 2004 | |
| Annual | Gross 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 euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Belgium | Spain | 2004 |
CREATE TABLE tidy (
"freq" VARCHAR,
"indic_sb" VARCHAR,
"enterpr" VARCHAR,
"cpa02" VARCHAR,
"partner" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);