Surplus Share Reinsurance Treaties

This dataset provides detailed records of surplus share reinsurance treaties, including terms of risk retention, cession, premium and loss sharing, and treaty status. It enables analysis of reinsurance arrangements between insurers and reinsurers, supporting risk management, regulatory reporting, and treaty portfolio optimization.

  • last updated 2 Nov 2025
  • by GoMask
The brief that made it

Portfolio analysis of reinsurance treaties for risk management

Sample rows

preview · 8 of 150 rows · all 16 columns
treaty_idstringbusiness_classstringloss_sharing_percentagefloatautomatic_acceptancebooleanterritorystringcedent_company_namestringreinsurer_company_namestringtreaty_effective_datedatetreaty_expiry_datedateretention_limitfloatsurplus_linesintegerpremium_sharing_percentagefloatcurrencystringtreaty_statusstringcreated_atdatetimeupdated_atdatetime
TS-00001property62trueUnited StatesUnited Assurance GroupGlobal Re Corp2021-06-012024-06-011200000458USDactive2021-05-01T13:43:12Z2023-12-28T11:02:11Z
TS-00002property49falseUnited KingdomPhoenix Mutual InsuranceSecure Re Ltd2016-01-152023-01-152200000647.5GBPexpired2015-12-10T09:11:22Z2023-02-03T14:18:02Z
TS-00003life15trueGermanyHorizon Insurance CompanyMunich Re2019-03-312027-03-31250000001813EURactive2019-03-01T11:27:54Z2024-02-18T16:44:13Z
TS-00004property68trueAustraliaLiberty General InsurersGlobal Re Corp2022-11-152024-11-15900000362AUDactive2022-10-25T08:55:17Z2023-10-28T17:10:23Z
TS-00005property41falseSwitzerlandAlpine Security PLCSwiss Re2018-07-012023-07-01500000244.5CHFexpired2018-06-13T15:43:49Z2023-07-02T10:48:23Z
TS-00006agriculture53trueMoroccoSahara Reliability GroupAfrica Re2020-05-102025-05-10210000559MADactive2020-04-02T12:03:47Z2023-11-23T21:19:10Z
TS-00007life14trueJapanPacific Crest InsurersTokyo Re2014-09-012022-09-01800000002018JPYexpired2014-07-16T16:44:16Z2022-09-02T09:12:08Z
TS-00008life24trueFranceBaltic Premium InsuranceMunich Re2021-03-122027-03-12370000001321EURactive2021-02-18T10:10:44Z2024-01-23T19:43:55Z

What the 150 rows show

from the 150-row sample

Life (business class) stands out: mean loss_sharing_percentage is 18.9, against 53.8 for the rest.

  • 62%automatic_acceptance = true
  • 52.4median loss_sharing_percentage
  • 3treaty statuses
  • 17currencies
  • 19reinsurer company names
  • 1,275,000median retention_limit
Mean loss_sharing_percentage by business_class150 rows
05010058.7prop…41 ro…69.9mari…21 ro…18.9life20 ro…48.9agri…20 ro…39.9casu…18 ro…46.3ener…15 ro…48.3engi…15 ro…
loss_sharing_percentage150 rows, in bands of 10
02040821962325368014050100loss_sharing_percentage →

Median 52.4, from 0.0 to 100.0.

territory150 rows · top 10 of 20 values
  1. United States22
  2. China14
  3. Australia13
  4. Brazil13
  5. United Kingdom11
  6. Singapore9
  7. France8
  8. Poland8
  9. Sweden7
  10. Morocco6
16 columns by typefrom the column list below
  • string 7
  • integer 1
  • float 3
  • date 2
  • datetime 2
  • boolean 1

Columns

16 columns in four groups
blueprint · 16 columns
columntypedescriptionexample
Text 7 columns
treaty_idstringUnique identifier for the surplus share reinsurance treatyuniqueTS-00001
cedent_company_namestringName of the insurance company ceding the surplus riskUnited Assurance Group
reinsurer_company_namestringName of the reinsurance company accepting the surplus riskGlobal Re Corp
currencystringCurrency in which treaty limits and premiums are denominated (ISO 4217 code)USD
territorystringGeographical territory covered by the treatyUnited States
business_classstringType of insurance business covered (e.g., property, casualty, marine)7 classesproperty
treaty_statusstringCurrent status of the treaty (e.g., active, expired, terminated, pending)active · expired · terminated · pendingactive
Numbers 4 columns
retention_limitfloatMaximum amount or line retained by the cedent per risk (in treaty currency)0 or more1200000
surplus_linesintegerNumber of surplus lines available for cession1 or more4
premium_sharing_percentagefloatPercentage of premium shared with the reinsurer for ceded surplus0 to 10058
loss_sharing_percentagefloatPercentage of losses shared with the reinsurer for ceded surplus0 to 10062
Dates and times 4 columns
treaty_effective_datedateDate when the treaty comes into effect2021-06-01
treaty_expiry_datedateDate when the treaty expires2024-06-01
created_atdatetimeTimestamp when the treaty record was created2021-05-01T13:43:12Z
updated_atdatetimeTimestamp when the treaty record was last updated2023-12-28T11:02:11Z
True or false 1 column
automatic_acceptancebooleanIndicates if surplus cessions are automatically accepted by the reinsurertrue

Use it for

  • automatic acce…62%93 of 150 rowsmean loss sharing per…58.7prop…69.9mari…18.9life48.9agri…

    An insurance dashboard

    The automatic_acceptance rate, loss_sharing_percentage by business_class and a breakdown of territory. Excel, Power BI or Tableau.

  • Why do the 20 life rows have a mean loss_sharing_percentage of 18.9?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable treaties with cedent_company_name, reinsurer_company_name and treaty_effective_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 16 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset150 rows16 columns
Yours1,000 rows16 columnsterritory: UK only

blueprint · surplus-share-reinsurance-treaties

Behind this dataset

Same schema. As many rows as you need.

These 150 rows came out of a blueprint — 16 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Retention: amount cedent keeps on each risk
  • Lines: maximum cession as multiple of retention (e.g., 9 lines)
  • Variable cession percentage per risk
  • Ceding commission structure
  • Larger risks cede higher percentage
  • Smaller risks may be 100% retained
  • Subject to underwriting guidelines
  • Property treaty common application
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
surplus-share-reinsurance-treaties

More in Insurance

Browse all
Also in InsuranceReinsurance Premium and Commission AccountingInsurance Customer Lifetime ValueInsurance Policy Renewal PredictionAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.