EIOPA - Insurance Statistics - Group Annual
European Insurance and Occupational Pensions Authority
@eiopa.eiopa_insurance_statistics_group_annual
European Insurance and Occupational Pensions Authority
@eiopa.eiopa_insurance_statistics_group_annual
CREATE TABLE balance_sheet (
"region" VARCHAR,
"reference_period" VARCHAR,
"d_balance_sheet_assets_or_liabilities_name" VARCHAR,
"dpmcode" VARCHAR,
"sum_of_s2val_eur_mn_sum" DOUBLE,
"date_of_extraction_yyyymmdd" BIGINT
);
CREATE TABLE premiums_claims_and_expenses (
"region" VARCHAR,
"reference_period" VARCHAR,
"d_pr_cl_ex_lob_nm" VARCHAR,
"dpmcode" VARCHAR,
"val_eur_mn_sum" DOUBLE,
"date_of_extraction_yyyymmdd" BIGINT
);
CREATE TABLE own_funds (
"region" VARCHAR,
"reference_period" VARCHAR,
"l_own_funds_name" VARCHAR,
"dpmcode" VARCHAR,
"output_value_sum" DOUBLE,
"date_of_extraction_yyyymmdd" BIGINT
);
Anyone who has the link will be able to view this.