Insurance
18 columns
300 rows
8 formats

Excess of Loss Reinsurance Treaties

This dataset provides detailed information on property catastrophe excess of loss reinsurance treaties, including financial terms, coverage limits, reinstatement provisions, territorial scope, and involved parties. It enables comprehensive analysis of catastrophe risk transfer, treaty structuring, and market benchmarking for insurers and reinsurers.

last updated 2 Nov 2025
by GoMask

The brief that made it

Benchmarking reinsurance treaty structures and pricing

Sample rows

preview · 8 of 300 rows · all 18 columns

treaty_idstring	treaty_statusstring	attachment_pointfloat	reinstatement_allowedboolean	broker_namestring	cedent_namestring	reinsurer_namestring	treaty_yearinteger	effective_datedate	expiry_datedate	territorial_scopestring	limitfloat	number_of_reinstatementsinteger	reinstatement_premium_ratefloat	rate_on_linefloat	currencystring	catastrophe_typestring	commentsstring
TRT2021-0001	expired	25.5	true	Guy Carpenter	Pacific General Insurance	Munich Re	2021	2021-01-01	2021-12-31	Asia	120	2	30	4.5	JPY	earthquake	Earthquake cover for Asia region, moderate retention with reinstatement.
TRT2023-0002	active	650	true	Aon	Global Nexus Underwriters	Swiss Re	2023	2023-01-01	2023-12-31	Worldwide	2200	4	44	18.9	USD	multi-peril	Global multi-peril treaty with high limit and extensive reinstatement.
TRT1992-0003	expired	12	false	blank	Empire Assurance	SCOR	1992	1992-03-01	1992-09-30	Europe	60	blank	blank	2.3	EUR	flood	Historic treaty for European flood, no reinstatement allowed.
TRT2022-0004	expired	32	true	Marsh	Coastal Guard Insurance	Everest Re	2022	2022-06-01	2023-05-31	Caribbean	90	3	41.5	9.5	USD	hurricane	Caribbean hurricane layer with high reinstatement, volatile season.
TRT2015-0005	expired	10	false	blank	Northern Shield Mutual	General Re	2015	2015-01-01	2015-12-31	Canada	28	blank	blank	1.2	CAD	snowstorm	Snowstorm protection for Canadian insurer, low layer.
TRT2020-0006	expired	800	true	Aon	Mega Insure Group	Berkshire Hathaway Re	2020	2020-01-01	2020-12-31	Worldwide	2750	5	87	44.5	USD	cyber	Global cyber risk, high retention and multiple reinstatements.
TRT2019-0007	expired	20.5	true	JLT	Midwest Mutual Insurance	Munich Re	2019	2019-02-01	2020-01-31	United States	80	2	35	6.8	USD	tornado	Tornado cover for Midwest US, moderate layer with reinstatement.
TRT2024-0008	active	900	true	blank	NextGen Underwriters	Swiss Re	2024	2024-01-01	2024-12-31	Worldwide	2950	3	63	28.5	USD	multi-peril	High-limit worldwide coverage for emerging risks and multi-peril.
TRT1987-0009	expired	3	false	blank	Old Town Mutual	Lloyd's	1987	1987-05-01	1987-12-31	Middle East	15	blank	blank	0.8	AED	sandstorm	Historic sandstorm treaty for Middle East, low limit.
TRT2017-0010	expired	8	false	Marsh	Dune Insurance	SCOR	2017	2017-12-01	2018-11-30	Africa	25	blank	blank	2.1	ZAR	flood	Flood coverage for African region, low-value treaty.
TRT2022-0011	active	38	true	Guy Carpenter	Coastal Guard Insurance	General Re	2022	2022-06-01	2023-05-31	Australia	95	4	54	9.2	AUD	bushfire	Australian bushfire treaty, high reinstatement for volatile peril.
TRT2018-0012	expired	22	true	JLT	Midwest Mutual Insurance	Munich Re	2018	2018-02-01	2019-01-31	United States	85	2	38	7.2	USD	windstorm	Windstorm layer for Midwest, moderate attachment and limit.
TRT2025-0013	pending	700	true	Aon	Global Nexus Underwriters	Swiss Re	2025	2025-01-01	2025-12-31	Worldwide	2300	5	95	32	USD	multi-peril	Upcoming global multi-peril treaty, high limit, multiple reinstatements.
TRT1950-0014	expired	9	false	blank	Empire Assurance	SCOR	1950	1950-05-01	1951-04-30	Europe	40	blank	blank	1.7	EUR	flood	Flood treaty for Europe, historic contract with limited coverage.
TRT2023-0015	active	29	true	Guy Carpenter	Pacific General Insurance	Munich Re	2023	2023-01-01	2023-12-31	Asia	110	3	33	4.8	JPY	earthquake	Earthquake excess of loss, moderate layer, Asia region.
TRT2011-0016	expired	7	false	blank	Northern Shield Mutual	General Re	2011	2011-01-01	2011-12-31	Canada	22	blank	blank	0.9	CAD	snowstorm	Canadian snowstorm treaty, low value, single season.
TRT2019-0017	expired	13	false	Marsh	Dune Insurance	SCOR	2019	2019-12-01	2020-11-30	Africa	29	blank	blank	3.2	ZAR	flood	Flood treaty for Africa, moderate layer, no reinstatement.
TRT2021-0018	active	780	true	blank	Global Nexus Underwriters	Berkshire Hathaway Re	2021	2021-01-01	2021-12-31	Worldwide	2100	3	72.5	23.5	USD	multi-peril	Global multi-peril cover, high limit, multiple reinstatements.
TRT2004-0019	expired	18	true	JLT	Midwest Mutual Insurance	Munich Re	2004	2004-02-01	2005-01-31	United States	75	1	22	6.2	USD	tornado	Tornado treaty for US Midwest, moderate layer with reinstatement.
TRT2016-0020	expired	26.5	true	Guy Carpenter	Pacific General Insurance	Munich Re	2016	2016-01-01	2016-12-31	Asia	105	2	27	3.9	JPY	earthquake	Asia earthquake layer, moderate retention, reinstatement allowed.

What the 300 rows show

from the 300-row sample

Pending (treaty status) stands out: mean attachment_point is 694.7, against 104.1 for the rest.

57%reinstatement_allowed = true
21.3median attachment_point
9currencies
10territorial scopes
10catastrophe types
17reinsurer names

Mean attachment_point by treaty_status300 rows

attachment_point300 rows, in bands of 100

Median 21.3, from 2.0 to 1,000.

broker_name174 rows with a value · 126 left blank

Aon59
Guy Carpenter46
Marsh34
JLT23
Aon Benfield8
JLT Re4

18 columns by typefrom the column list below

string 9
integer 2
float 4
date 2
boolean 1

Columns

18 columns in four groups

blueprint · 18 columns
column	type	description	example
Text 9 columns
`treaty_id`	string	Unique identifier for the reinsurance treatyunique	TRT2021-0001
`cedent_name`	string	Name of the insurance company purchasing the reinsurance	Empire Assurance
`reinsurer_name`	string	Name of the reinsurer providing coverage	Munich Re
`territorial_scope`	string	Geographical area covered by the treaty (e.g., North America, Europe, Worldwide)10 scopes	Asia
`currency`	string	Currency in which the treaty is denominated (e.g., USD, EUR, GBP)9 currencies	JPY
`catastrophe_type`	string	Type of catastrophe covered (e.g., windstorm, earthquake, flood, multi-peril)10 types	earthquake
`broker_name`	string	Name of the reinsurance broker (if applicable)6 names · optional	Guy Carpenter
`treaty_status`	string	Current status of the treaty (e.g., active, expired, terminated, pending)active · expired · terminated · pending	expired
`comments`	string	Additional notes or comments about the treatyoptional	Earthquake cover for Asia…
Numbers 6 columns
`treaty_year`	integer	Year the treaty is effective1,900 to 2,100	2021
`attachment_point`	float	Monetary threshold (in millions) above which the treaty attaches0 or more	25.5
`limit`	float	Maximum amount (in millions) covered by the treaty above the attachment point0 or more	120
`number_of_reinstatements`	integer	Maximum number of reinstatements permitted (if any)0 or more · optional	2
`reinstatement_premium_rate`	float	Premium rate (percentage) charged for each reinstatement0 to 100 · optional	30
`rate_on_line`	float	Premium rate as a percentage of the treaty limit0 to 100	4.5
Dates and times 2 columns
`effective_date`	date	Date when the treaty coverage begins	2021-01-01
`expiry_date`	date	Date when the treaty coverage ends	2021-12-31
True or false 1 column
`reinstatement_allowed`	boolean	Indicates if reinstatement provisions are allowed under the treaty	true

Use it for

An insurance dashboard
The reinstatement_allowed rate, attachment_point by treaty_status and a breakdown of broker_name. Excel, Power BI or Tableau.
Why do the 56 pending rows have a mean attachment_point of 694.7?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Treaties300
TRT2021-000125.5expired
TRT2023-0002650active
TRT1992-000312expired
A software demo
Believable treaties with cedent_name, reinsurer_name and treaty_year to fill a screen in front of a buyer.

This dataset300 rows18 columns

Yours1,000 rows18 columns

blueprint · excess-of-loss-reinsurance-treaties

Behind this dataset

Same schema. As many rows as you need.

These 300 rows came out of a blueprint — 18 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

Treaty type: property catastrophe XOL
Attachment point: loss level where reinsurance begins
Limit: maximum reinsurance recovery per occurrence
Layers: multiple layers of coverage (e.g., $50M xs $50M)
Rate on line (ROL): premium / limit percentage
Reinstatement: number and premium (pro-rata or free)
Covered perils: named perils or all-risk
Territorial scope: US, global, specific regions

Rows1,000 rows10,000 rows100,000 rows1,000,000 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: excess-of-loss-reinsurance-treaties

What should your data show?

No signup. No card.

Sample rows

What the 300 rows show

Columns

Use it for

An insurance dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Insurance

What should your data show?