Annual Enterprise Statistics By Product (1995-2007)
Eurostat code: sbs_ins_5e ยท (1995 - 2007)
@eurostat.sbs_ins_5e
Annual Enterprise Statistics By Product (1995-2007) - Unpivoted
@eurostat.sbs_ins_5e.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.
- 154.84 KB
- 40343 rows
- 7 columns
freqFreq | indic_sbIndic Sb | enterprEnterpr | cpa02Cpa02 | geoGeo | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|
| Annual | Gross premiums written in direct business by (sub) categories of the CPA (5-digit level and subcategories 66.03.21, 66.03.22) - million euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Austria | 1995 | 2864.88 |
| Annual | Gross premiums written in direct business by (sub) categories of the CPA (5-digit level and subcategories 66.03.21, 66.03.22) - million euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Belgium | 1995 | 2266.659 |
| Annual | Gross premiums written in direct business by (sub) categories of the CPA (5-digit level and subcategories 66.03.21, 66.03.22) - million euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | France | 1995 | 770.479 |
| Annual | Gross premiums written in direct business by (sub) categories of the CPA (5-digit level and subcategories 66.03.21, 66.03.22) - million euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Italy | 1995 | 4750.059 |
| Annual | Gross premiums written in direct business by (sub) categories of the CPA (5-digit level and subcategories 66.03.21, 66.03.22) - million euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | Portugal | 1995 | 342.73 |
| Annual | Gross premiums written in direct business by (sub) categories of the CPA (5-digit level and subcategories 66.03.21, 66.03.22) - million euro | Life insurance business of composite insurance enterprises | Non linked life insurance services | United Kingdom | 1995 | 6542.765 |
| Annual | Gross premiums written in direct business by (sub) categories of the CPA (5-digit level and subcategories 66.03.21, 66.03.22) - million euro | Life insurance business of composite insurance enterprises | Linked life insurance services | Austria | 1995 | 4.779 |
| Annual | Gross premiums written in direct business by (sub) categories of the CPA (5-digit level and subcategories 66.03.21, 66.03.22) - million euro | Life insurance business of composite insurance enterprises | Linked life insurance services | Belgium | 1995 | 23.527 |
| Annual | Gross premiums written in direct business by (sub) categories of the CPA (5-digit level and subcategories 66.03.21, 66.03.22) - million euro | Life insurance business of composite insurance enterprises | Linked life insurance services | France | 1995 | 57.9 |
| Annual | Gross premiums written in direct business by (sub) categories of the CPA (5-digit level and subcategories 66.03.21, 66.03.22) - million euro | Life insurance business of composite insurance enterprises | Linked life insurance services | Portugal | 1995 |
CREATE TABLE tidy (
"freq" VARCHAR,
"indic_sb" VARCHAR,
"enterpr" VARCHAR,
"cpa02" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);