Baselight

EIOPA - Insurance Statistics - Group Annual

European Insurance and Occupational Pensions Authority

@eiopa.eiopa_insurance_statistics_group_annual

Premiums, Claims And Expenses
@eiopa.eiopa_insurance_statistics_group_annual.premiums_claims_and_expenses

The statistics on premiums, claims and expenses provide an extract of key data items from the Solvency II template S.05.01 (please see the annotated reporting templates available here to see the full list of reporting templates).

  • 11.55 KB
  • 587 rows
  • 6 columns
region

Region

reference_period

Reference Period

d_pr_cl_ex_lob_nm

D PR CL EX LOB NM

dpmcode

DPMCODE

val_eur_mn_sum

Val EUR MN Sum

date_of_extraction_yyyymmdd

Date Of Extraction (yyyymmdd)

EEAY2016Gross - Direct BusinessR0110351738.8538520240904
EEAY2017Gross - Direct BusinessR0110375799.4916720240904
EEAY2018Gross - Direct BusinessR0110378565.28120240904
EEAY2019Gross - Direct BusinessR0110425708.0159120240904
EEAY2020Gross - Direct BusinessR0110447132.6777220240904
EEAY2021Gross - Direct BusinessR0110463357.502920240904
EEAY2022Gross - Direct BusinessR0110509946.8379520240904
EEAY2023Gross - Direct BusinessR0110542854.5692120240904
EEAY2016Gross - Proportional reinsurance acceptedR012046022.59647520240904
EEAY2017Gross - Proportional reinsurance acceptedR012046613.14423420240904

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
);

Share link

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