Insurance
16 columns
200 rows
8 formats

Quota Share Reinsurance Treaties

This dataset provides detailed records of quota share reinsurance treaties, including contract terms, participating companies, financial percentages, and commission structures. It enables comprehensive analysis of proportional risk-sharing agreements in the insurance industry, supporting operational management, regulatory compliance, and strategic decision-making.

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 200 rows · all 16 columns

treaty_idstring	line_of_businessstring	profit_commission_percentagefloat	profit_commission_applicableboolean	remarksstring	cedent_company_namestring	reinsurer_company_namestring	treaty_effective_datedate	treaty_expiry_datedate	quota_share_percentagefloat	ceding_commission_percentagefloat	minimum_premiumfloat	maximum_premiumfloat	territorystring	currencystring	statusstring
TREATY-2022-001A	property	blank	false	Standard annual renewal	Liberty Mutual	Swiss Re	2022-01-01	2022-12-31	16.5	12.3	248000	4500000	United States	USD	expired
TREATY-2023-002B	health	24.5	true	High commission outlier	Allianz SE	Munich Re	2023-03-01	2024-02-29	82.6	56.2	725000	7600000	France	EUR	active
TREATY-2022-003C	other	blank	false	Boundary case: min/max values	Ping An Insurance	SCOR	2022-05-15	2023-05-14	0	0	blank	blank	Hong Kong	CNY	expired
TREATY-2025-004D	life	11.8	true	Traditional life segment	Sun Life Financial	RGA	2025-01-01	2025-12-31	61	14.2	850000	9000000	India	INR	pending
TREATY-2023-005E	casualty	9	true	Long-term multi-year agreement	Zurich Insurance	Everest Re	2023-07-01	2024-06-30	27.6	21.2	625000	9000000	Canada	USD	active
TREATY-2024-006F	property	blank	false	Standard annual renewal	AXA XL	PartnerRe	2024-04-01	2025-03-31	25.8	13.1	380000	5500000	Australia	USD	active
TREATY-2022-007G	health	32.3	true	Awaiting regulatory approval	Tokio Marine	Hannover Re	2022-09-01	2023-08-31	92.2	88.3	395000	2100000	Japan	JPY	expired
TREATY-2023-008H	other	99.9	true	High-value edge case	Generali Group	China Re	2023-11-01	2024-10-31	99.9	99.9	9999999.99	99999999.99	Brazil	USD	active
TREATY-2024-009I	life	blank	false	Traditional life segment	Aviva plc	QBE	2024-02-01	2025-01-31	72.1	7.2	1190000	8200000	UK	GBP	active
TREATY-2025-010J	casualty	blank	false	Repeating numbers outlier	Chubb Ltd	TransRe	2025-06-01	2026-05-31	49.4	28.1	1030000	13400000	Switzerland	EUR	pending
TREATY-2023-011K	property	blank	false	blank	AIA Group	General Re	2023-04-01	2024-03-31	18.3	9.2	560000	3900000	Spain	EUR	active
TREATY-2022-012L	health	15	true	Regulatory review pending	Prudential Plc	Berkshire Hathaway	2022-02-15	2023-02-14	65	37.5	340000	2400000	Ireland	GBP	expired
TREATY-2024-013M	life	5.9	true	Expired after standard term	MetLife Inc	Mapfre Re	2024-09-01	2025-08-31	55.7	16.2	780000	7295000	France	EUR	active
TREATY-2022-014N	property	blank	false	blank	ICICI Lombard	Lloyd's	2022-06-01	2023-05-31	10	8	100000	1000000	South Africa	USD	expired
TREATY-2023-015O	other	100	true	Boundary case: min/max values	Sompo Holdings	Aspen Re	2023-10-01	2024-09-30	100	100	1	10	India	INR	active
TREATY-2024-016P	casualty	blank	false	Long-term multi-year agreement	Sampo Group	Axis Re	2024-07-01	2025-06-30	13.8	17.6	1025000	5100000	Singapore	USD	active
TREATY-2025-017Q	health	33.3	true	Awaiting regulatory approval	MAPFRE S.A.	Allied World	2025-03-01	2026-02-28	88.4	29.9	900000	6500000	Italy	EUR	pending
TREATY-2023-018R	property	blank	false	blank	RSA Insurance	Odyssey Re	2023-05-01	2024-04-30	22.1	15.7	360000	3900000	UK	GBP	active
TREATY-2022-019S	life	14.1	true	Expired after standard term	Pacific Life	XL Catlin	2022-03-01	2023-02-28	74.9	21.5	2850000	9000000	India	INR	expired
TREATY-2024-020T	casualty	blank	false	blank	Aegon NV	Argo Group	2024-01-01	2024-12-31	41.1	23.3	512000	14500000	United States	USD	active

What the 200 rows show

from the 200-row sample

Other (line of business) stands out: mean profit_commission_percentage is 100.0, against 24.8 for the rest.

47%profit_commission_applicable = true
21.1median profit_commission_percentage
3statuses
7currencies
18territories
53.0median quota_share_percentage

Mean profit_commission_percentage by line_of_business94 rows

profit_commission_percentage94 rows, in bands of 10

Median 21.1, from 5.0 to 100.0.

remarks125 rows with a value · 75 left blank

Boundary case: min/max values28
Standard annual renewal15
Traditional life segment15
High-value edge case14
Long-term multi-year agreement13
High commission outlier11
Awaiting regulatory approval10
Repeating numbers outlier8
Expired after standard term7
No min/max premium for short-term2

16 columns by typefrom the column list below

string 8
float 5
date 2
boolean 1

Columns

16 columns in four groups

blueprint · 16 columns
column	type	description	example
Text 8 columns
`treaty_id`	string	Unique identifier for the quota share reinsurance treatyunique	TREATY-2022-001A
`cedent_company_name`	string	Name of the insurance company ceding risk under the treaty	Liberty Mutual
`reinsurer_company_name`	string	Name of the reinsurer accepting risk under the treaty	Swiss Re
`line_of_business`	string	Type of insurance covered by the treaty (e.g., property, casualty, life)property · casualty · life · health · other	property
`territory`	string	Geographic region covered by the treatyoptional	United States
`currency`	string	Currency in which treaty transactions are denominated7 values	USD
`status`	string	Current status of the treaty (e.g., active, expired, terminated, pending)active · expired · terminated · pending	expired
`remarks`	string	Additional notes or comments about the treaty12 remarkses · optional	Standard annual renewal
Numbers 5 columns
`quota_share_percentage`	float	Percentage of premiums and losses shared with the reinsurer0 to 100	16.5
`ceding_commission_percentage`	float	Percentage commission paid by reinsurer to cedent for ceding the risk0 to 100	12.3
`profit_commission_percentage`	float	Percentage of profit commission payable to the cedent, if applicable0 to 100 · optional	24.5
`minimum_premium`	float	Minimum premium amount required under the treaty0 or more · optional	248000
`maximum_premium`	float	Maximum premium amount allowed under the treaty0 or more · optional	4500000
Dates and times 2 columns
`treaty_effective_date`	date	Date when the treaty becomes effective	2022-01-01
`treaty_expiry_date`	date	Date when the treaty expires	2022-12-31
True or false 1 column
`profit_commission_applicable`	boolean	Indicates if a profit commission structure is included in the treaty	false

Use it for

An insurance dashboard
The profit_commission_applicable rate, profit_commission_percentage by line_of_business and a breakdown of remarks. Excel, Power BI or Tableau.
Why do the 17 other rows have a mean profit_commission_percentage of 100.0?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Treaties200
TREATY-2022-001Aproperty
TREATY-2023-002B24.5health
TREATY-2025-004D11.8life
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.

This dataset200 rows16 columns

Yours1,000 rows16 columnsterritory: UK only

blueprint · quota-share-reinsurance-treaties

Behind this dataset

Same schema. As many rows as you need.

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

Cession percentage: typically 20%-50%
Reinsurer shares premium and losses at same percentage
Ceding commission compensates for acquisition costs
Profit commission if results are favorable
Sliding scale commission based on loss ratio
Loss corridor: losses retained by cedent in range
Subject premiums: all policies or specific lines
Expense allowance in ceding commission

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: quota-share-reinsurance-treaties

What should your data show?

No signup. No card.

Sample rows

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