Baselight

EIOPA - Insurance Statistics - Group Quarterly

European Insurance and Occupational Pensions Authority

@eiopa.eiopa_insurance_statistics_group_quarterly

Premiums, Claims And Expenses
@eiopa.eiopa_insurance_statistics_group_quarterly.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).

  • 16.42 KB
  • 976 rows
  • 8 columns
region

Region

reference_period

Reference Period

item

Item

business_type

Business Type

item_code

Item Code

sum_of_val_eur_mn_sum

SUM Of Val EUR MN Sum

date_of_extraction_yyyymmdd

Date Of Extraction (yyyymmdd)

number_of_submissions_per_reference_date

Number Of Submissions (per Reference Date)

EEA2018 Q2Gross - Direct BusinessNon-LifeR0110223728.3918820241205264
EEA2018 Q2Gross - Proportional reinsurance acceptedNon-LifeR012029269.78228120241205264
EEA2018 Q2Gross - Non-proportional reinsurance acceptedNon-LifeR01307899.96827720241205264
EEA2018 Q2Reinsurers' shareNon-LifeR014027102.90263920241205264
EEA2018 Q2NetNon-LifeR0200233795.239820241205264
EEA2018 Q2Gross - Direct BusinessNon-LifeR0210191119.3213420241205264
EEA2018 Q2Gross - Proportional reinsurance acceptedNon-LifeR022025680.35708220241205264
EEA2018 Q2Gross - Non-proportional reinsurance acceptedNon-LifeR02306589.352496620241205264
EEA2018 Q2Reinsurers' shareNon-LifeR024023056.50112220241205264
EEA2018 Q2NetNon-LifeR0300200332.5297920241205264

CREATE TABLE premiums_claims_and_expenses (
  "region" VARCHAR,
  "reference_period" VARCHAR,
  "item" VARCHAR,
  "business_type" VARCHAR,
  "item_code" VARCHAR,
  "sum_of_val_eur_mn_sum" DOUBLE,
  "date_of_extraction_yyyymmdd" BIGINT,
  "number_of_submissions_per_reference_date" DOUBLE
);

Share link

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