Insurance
18 columns
100 rows
8 formats

Aggregate Excess of Loss Treaties

This dataset provides comprehensive details on aggregate excess of loss (XOL) reinsurance treaties, including coverage terms, financial parameters, claims experience, and involved parties. It enables risk managers, actuaries, and analysts to assess treaty performance, loss aggregation, and frequency of catastrophic events across policy years. Ideal for portfolio management, pricing analysis, and regulatory reporting in the insurance and reinsurance sector.

last updated 2 Nov 2025
by GoMask

The brief that made it

Portfolio-level risk and exposure analysis for insurers and reinsurers

Sample rows

preview · 8 of 100 rows · all 18 columns

treaty_idstring	aggregate_deductible_typestring	attachment_pointfloat	covered_lines_of_businessstring	cedent_namestring	reinsurer_namestring	policy_year_startdate	policy_year_enddate	limitfloat	premiumfloat	currencystring	loss_aggregation_methodstring	claims_reportedinteger	total_losses_incurredfloat	claims_paidfloat	statusstring	broker_namestring	notesstring
TXOL20240101-001	annual	2500000	Property,Casualty	Atlas Insurance Group	Munich Re	2024-01-01	2024-12-31	10000000	850000	USD	incurred losses	42	6300000	4200000	active	Willis Towers Watson	Renewal with increased limit.
TXOL20240101-002	multi-year	5000000	Engineering,Casualty	Zenith Assurance	Swiss Re	2023-07-01	2024-06-30	20000000	1950000	EUR	paid claims	15	11000000	7300000	active	Aon Benfield	Multi-year deductible applies.
TXOL20240101-003	annual	1500000	Property	Everest General	SCOR	2023-01-01	2023-12-31	6500000	520000	GBP	incurred losses	23	3400000	2200000	expired	Lockton Re	Treaty expired; no renewal.
TXOL20240101-004	event-based	800000	Marine,Property	Pacific Shield	Lloyd's	2022-10-01	2023-09-30	4000000	310000	JPY	paid claims	58	1800000	1350000	expired	JLT Re	Earthquake event triggered coverage.
TXOL20240101-005	annual	3500000	Casualty,Engineering	Lumina Mutual	Partner Re	2024-04-01	2025-03-31	15000000	1275000	CHF	incurred losses	19	6800000	4300000	active	Gallagher Re	Coverage extended to engineering risks.
TXOL20240101-006	annual	2500000	Property,Casualty	Horizon Protection	Hannover Re	2023-04-01	2024-03-31	8500000	660000	USD	paid claims	37	5800000	3300000	active	Marsh	Renewed with higher attachment point.
TXOL20240101-007	annual	6000000	Property,Agriculture	Frontier Insurance	Berkshire Hathaway	2023-09-01	2024-08-31	25000000	2950000	CAD	incurred losses	13	8800000	6100000	active	Aon Benfield	Coverage includes crop losses.
TXOL20240101-008	multi-year	1200000	Casualty,Property	Nova Assurance	Swiss Re	2023-05-01	2024-04-30	6500000	550000	USD	paid claims	28	3700000	2500000	active	Gallagher Re	Multi-year deductible introduced.
TXOL20240101-009	annual	900000	Casualty	Summit Insurance	Munich Re	2022-01-01	2022-12-31	5000000	420000	AUD	incurred losses	45	2100000	1700000	expired	Willis Towers Watson	No major cat events.
TXOL20240101-010	event-based	3000000	Property	Pioneer Assurance	Lloyd's	2024-01-01	2024-12-31	12000000	950000	USD	incurred losses	36	7200000	5200000	active	Lockton Re	Windstorm event covered.
TXOL20240101-011	annual	1800000	Casualty,Property	Vanguard Insurance	SCOR	2023-02-01	2024-01-31	9000000	780000	EUR	paid claims	22	4700000	3200000	active	JLT Re	Higher limit than previous year.
TXOL20240101-012	multi-year	4000000	Engineering,Casualty	Prominence Mutual	Partner Re	2023-05-01	2024-04-30	18000000	1400000	USD	incurred losses	10	7300000	5000000	active	Gallagher Re	Engineering losses included.
TXOL20240101-013	annual	2200000	Property,Marine	Orion Insurance	Munich Re	2023-06-01	2024-05-31	9500000	810000	GBP	paid claims	32	5100000	3500000	active	Willis Towers Watson	Marine exposure increased.
TXOL20240101-014	other	1000000	Casualty	Crestview Insurance	Lloyd's	2022-07-01	2023-06-30	5000000	480000	USD	incurred losses	63	2600000	1900000	expired	Lockton Re	Special deductible arrangement.
TXOL20240101-015	annual	2800000	Property,Casualty	Reliance General	SCOR	2024-01-01	2024-12-31	10000000	935000	EUR	paid claims	21	3900000	2600000	active	Gallagher Re	Treaty renewed for 2024.
TXOL20240101-016	event-based	1700000	Casualty,Property	Summit Insurance	Swiss Re	2023-03-01	2024-02-29	8500000	690000	USD	incurred losses	27	4600000	2900000	active	Willis Towers Watson	Flood event covered.
TXOL20240101-017	multi-year	3500000	Property,Engineering	Eastern Shield	Partner Re	2023-11-01	2024-10-31	12000000	1100000	CHF	paid claims	18	5900000	4100000	active	Gallagher Re	Multi-year structure.
TXOL20240101-018	annual	950000	Marine	Nova Assurance	Lloyd's	2022-11-01	2023-10-31	4000000	390000	JPY	incurred losses	61	1500000	1200000	expired	JLT Re	No cat losses.
TXOL20240101-019	annual	1700000	Property,Casualty	Everest General	Munich Re	2023-08-01	2024-07-31	7500000	620000	CAD	paid claims	25	3300000	2100000	active	Aon Benfield	Attachment point unchanged.
TXOL20240101-020	event-based	2450000	Casualty,Engineering	Atlas Insurance Group	SCOR	2024-03-01	2025-02-28	9500000	780000	USD	incurred losses	17	4600000	3200000	pending	Marsh	Awaiting final approval.

What the 100 rows show

from the 100-row sample

Multi-year (aggregate deductible type) stands out: mean attachment_point is 5,504,167, against 2,526,316 for the rest.

2,750,000median attachment_point
3loss aggregation methods
4statuses
7currencies
19reinsurer names
25broker names

Mean attachment_point by aggregate_deductible_type100 rows

attachment_point100 rows, in bands of 2M

Median 2,750,000, from 500,000 to 12,000,000.

covered_lines_of_business100 rows · top 10 of 26 values

Property,Casualty11
Property, Casualty10
Property9
Casualty, Property9
Casualty,Property7
Engineering,Casualty5
Property, Liability5
Property,Marine4
Property, Casualty, Cyber4
Marine, Casualty4

18 columns by typefrom the column list below

string 10
integer 1
float 5
date 2

Columns

18 columns in three groups

blueprint · 18 columns
column	type	description	example
Text 10 columns
`treaty_id`	string	Unique identifier for the aggregate excess of loss treatyunique	TXOL20240101-001
`cedent_name`	string	Name of the insurance company purchasing the treaty (cedent)	Atlas Insurance Group
`reinsurer_name`	string	Name of the reinsurer providing coverage	Munich Re
`currency`	string	Currency in which the treaty values are denominated (e.g., USD, EUR)8 values	USD
`covered_lines_of_business`	string	Comma-separated list of insurance lines of business covered (e.g., Property, Casualty)	Property,Casualty
`aggregate_deductible_type`	string	Type of aggregate deductible applied (e.g., annual, multi-year, event-based)annual · multi-year · event-based · other	annual
`loss_aggregation_method`	string	Method used to aggregate losses (e.g., sum of paid claims, incurred losses)paid claims · incurred losses · other	incurred losses
`status`	string	Current status of the treaty (e.g., active, expired, terminated, pending)active · expired · terminated · pending	active
`broker_name`	string	Name of the broker or intermediary involved in placing the treatyoptional	Willis Towers Watson
`notes`	string	Additional notes or comments about the treatyoptional	No major cat events.
Numbers 6 columns
`attachment_point`	float	Threshold amount of annual losses at which the treaty coverage begins0 or more	2500000
`limit`	float	Maximum amount of coverage provided by the treaty above the attachment point0 or more	10000000
`premium`	float	Total premium paid by the cedent for the treaty0 or more	850000
`claims_reported`	integer	Total number of claims reported under the treaty for the policy year0 or more · optional	42
`total_losses_incurred`	float	Total amount of losses incurred under the treaty for the policy year0 or more · optional	6300000
`claims_paid`	float	Total amount of claims paid by the reinsurer under the treaty0 or more · optional	4200000
Dates and times 2 columns
`policy_year_start`	date	Start date of the policy year for the treaty	2024-01-01
`policy_year_end`	date	End date of the policy year for the treaty	2024-12-31

Use it for

An insurance dashboard
Attachment_point by aggregate_deductible_type and a breakdown of covered_lines_of_business. Excel, Power BI or Tableau.
Why do the 24 multi-year rows have a mean attachment_point of 5,504,167?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Treaties100
TXOL20240101-0012500000annual
TXOL20240101-0025000000multi-ye…
TXOL20240101-0031500000annual
A software demo
Believable treaties with cedent_name, reinsurer_name and policy_year_start to fill a screen in front of a buyer.

This dataset100 rows18 columns

Yours1,000 rows18 columns

blueprint · aggregate-excess-of-loss-treaties

Behind this dataset

Same schema. As many rows as you need.

These 100 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

Attachment: aggregate loss amount triggering coverage
Typically expressed as loss ratio (e.g., 75% of premium)
Limit: maximum aggregate recovery
Protects against frequency and small claim aggregation
Stop loss alternative name
Annual aggregate period
Premium-based vs dollar attachment
Cat aggregate vs non-cat aggregate

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: aggregate-excess-of-loss-treaties

What should your data show?

No signup. No card.

Sample rows

What the 100 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?