Retrocessional Reinsurance Programs
This dataset provides detailed information on retrocessional reinsurance programs, including treaty types, financial structures, pricing methodologies, and market capacity. It enables analysis of risk transfer strategies among reinsurers, supports benchmarking, and facilitates regulatory compliance and risk management. The dataset is ideal for actuaries, risk managers, and insurance market analysts seeking to understand retrocession market dynamics.
Sample rows
preview · 8 of 150 rows · all 21 columns| retrocession_program_idstring | broker_namestring | number_of_retrocessionairesinteger | lead_retrocessionairestring | reinsurer_namestring | program_namestring | treaty_typestring | inception_datedate | expiry_datedate | coverage_limitfloat | attachment_pointfloat | premium_amountfloat | currencystring | pricing_methodologystring | market_capacityfloat | risk_typestring | regionstring | statusstring | created_atdatetime | updated_atdatetime | ceded_portfolio_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RP-0001 | Aon | 10 | Munich Re | Allianz Re | Global Property XL 2021 | excess of loss | 2021-01-01 | 2023-01-01 | 400.5 | 180.25 | 28.75 | USD | model-based | 700 | property | Global | expired | 2020-11-15T10:23:41 | 2023-01-02T15:03:18 | Covers global catastrophe losses including earthquake, windstorm, and flood events. |
| RP-0002 | Willis Towers Watson | 3 | PartnerRe | Swiss Re | Europe Casualty Quota Share 2022 | quota share | 2022-06-01 | 2023-06-01 | 55 | 0 | 5.4 | EUR | experience rating | 70 | casualty | Europe | expired | 2022-05-10T09:14:02 | 2023-06-02T17:51:20 | European casualty risks focusing on general liability and pollution. |
| RP-0003 | Guy Carpenter | 5 | SCOR | Hannover Re | Asia-Pacific Life Stop Loss 2023 | stop loss | 2023-01-15 | 2025-01-15 | 62.8 | 20 | 4.7 | JPY | exposure rating | 90 | life | Asia-Pacific | active | 2022-12-10T08:17:12 | 2024-03-01T13:37:10 | Life insurance exposures across Japan and Southeast Asia, including pandemic risk. |
| RP-0004 | blank | 2 | Swiss Re | PartnerRe | Caribbean Specialty Aggregate Q1 2022 | aggregate | 2022-03-01 | 2023-09-01 | 18.2 | 3 | 0.95 | USD | negotiated | 26.5 | specialty | Caribbean | expired | 2022-01-24T11:23:10 | 2023-09-02T16:09:25 | Agriculture and trade credit risks across Caribbean territories. |
| RP-0005 | Aon | 13 | Munich Re | Munich Re | Global Catastrophe Aggregate 2025 | aggregate | 2025-01-01 | 2030-01-01 | 8200 | 4500 | 220 | USD | model-based | 11000 | property | Global | pending | 2024-12-01T14:32:28 | 2024-12-02T09:03:34 | Mega-catastrophe global coverage for earthquake, hurricane, and extreme events. |
| RP-0006 | Willis Towers Watson | 4 | Hannover Re | SCOR | Australia Life Quota Share 2021 | quota share | 2021-04-01 | 2022-04-01 | 35.6 | 0 | 2.8 | AUD | experience rating | 52 | life | Australia | expired | 2021-03-01T09:50:51 | 2022-04-02T15:10:22 | Australian life insurance risks, excess death and pandemic exposures. |
| RP-0007 | China Re | 1 | blank | China Re | China Specialty Facultative 2022 | facultative | 2022-05-01 | 2023-02-01 | 8.4 | 1.2 | 0.44 | CNY | negotiated | 12 | specialty | China | expired | 2022-04-15T10:55:30 | 2023-02-02T14:11:19 | Trade credit and agriculture exposures in China. |
| RP-0008 | Guy Carpenter | 8 | Swiss Re | Berkshire Hathaway | North America Property XL 2022 | excess of loss | 2022-01-01 | 2023-01-01 | 310 | 120 | 19.2 | USD | model-based | 450 | property | North America | expired | 2021-11-20T13:03:11 | 2023-01-02T17:00:05 | North American catastrophe losses, hurricane and earthquake focus. |
| RP-0009 | JLT Re | 2 | PartnerRe | AXA XL | Spain Casualty Quota Share 2023 | quota share | 2023-03-01 | 2024-03-01 | 22.4 | 0 | 2.2 | EUR | experience rating | 32 | casualty | Spain | active | 2023-02-01T08:46:12 | 2024-01-15T10:19:37 | Spanish casualty risks, crop and pollution exposures. |
| RP-0010 | blank | 2 | SCOR | Everest Re | Brazil Specialty Facultative 2023 | facultative | 2023-07-01 | 2024-04-01 | 12.6 | 7.2 | 0.72 | BRL | negotiated | 17.5 | specialty | South America | active | 2023-06-01T14:17:11 | 2024-02-01T12:03:52 | Brazilian offshore energy and agricultural exposures. |
| RP-0011 | Willis Towers Watson | 4 | SCOR | QBE Re | Africa Life Stop Loss 2022 | stop loss | 2022-10-01 | 2024-10-01 | 49.5 | 15 | 3.1 | ZAR | exposure rating | 61 | life | Africa | active | 2022-09-01T10:10:10 | 2023-11-01T11:12:29 | Life insurance and excess death cover for African territories. |
| RP-0012 | blank | 1 | blank | Validus Re | Norway Specialty Aggregate 2022 | aggregate | 2022-02-01 | 2022-11-01 | 6.8 | 2.1 | 0.24 | NOK | model-based | 8.2 | specialty | Norway | expired | 2022-01-01T09:19:22 | 2022-11-02T14:16:01 | Norwegian agriculture and windstorm exposures. |
| RP-0013 | Guy Carpenter | 6 | Munich Re | RenaissanceRe | Asia-Pacific Property XL 2022 | excess of loss | 2022-04-01 | 2023-04-01 | 260 | 108 | 13.5 | USD | model-based | 380 | property | Asia-Pacific | expired | 2022-03-01T11:12:42 | 2023-04-02T16:59:45 | Catastrophe losses across Asia-Pacific, earthquake and typhoon focus. |
| RP-0014 | JLT Re | 4 | Munich Re | Mapfre Re | Spain Property XL 2023 | excess of loss | 2023-02-01 | 2024-02-01 | 77 | 41 | 6.9 | EUR | model-based | 120 | property | Spain | active | 2023-01-01T10:01:31 | 2024-01-14T14:24:11 | Spanish property catastrophe, windstorm, and earthquake cover. |
| RP-0015 | Willis Towers Watson | 5 | SCOR | Sompo Re | Japan Life Quota Share 2024 | quota share | 2024-04-01 | 2027-04-01 | 55.2 | 0 | 4.45 | JPY | model-based | 72 | life | Asia-Pacific | pending | 2023-12-15T08:12:33 | 2024-01-02T09:51:49 | Japanese life insurance, pandemic and excess death coverage. |
| RP-0016 | Lockton | 2 | PartnerRe | Odyssey Re | Canada Casualty Quota Share 2022 | quota share | 2022-03-01 | 2023-03-01 | 18.9 | 0 | 1.6 | CAD | experience rating | 29 | casualty | Canada | expired | 2022-02-10T07:13:05 | 2023-03-02T08:21:31 | Canadian liability and casualty exposures, crop and pollution. |
| RP-0017 | Aon | 11 | Munich Re | General Re | Global Property XL 2020 | excess of loss | 2020-02-01 | 2022-02-01 | 650 | 350 | 44.5 | USD | model-based | 900 | property | Global | expired | 2019-12-01T13:53:43 | 2022-02-15T17:29:55 | Worldwide earthquake and hurricane catastrophe coverage. |
| RP-0018 | Guy Carpenter | 3 | SCOR | Tokio Marine | Asia-Pacific Life Stop Loss 2022 | stop loss | 2022-01-01 | 2023-01-01 | 33 | 8 | 2.2 | JPY | exposure rating | 46 | life | Asia-Pacific | expired | 2021-12-01T08:09:17 | 2023-01-02T10:01:28 | Southeast Asia life insurance, pandemic and excess mortality coverage. |
| RP-0019 | JLT Re | 1 | blank | Transatlantic Re | Caribbean Specialty Facultative 2023 | facultative | 2023-02-01 | 2023-11-01 | 7.7 | 3.3 | 0.38 | USD | negotiated | 11 | specialty | Caribbean | active | 2023-01-01T09:12:16 | 2023-10-02T11:15:33 | Agriculture and trade credit exposures for Caribbean region. |
| RP-0020 | Guy Carpenter | 9 | Swiss Re | Liberty Mutual | North America Property XL 2024 | excess of loss | 2024-01-01 | 2025-01-01 | 420 | 215 | 31 | USD | model-based | 630 | property | North America | pending | 2023-12-01T14:49:27 | 2023-12-15T15:36:22 | North America earthquake, hurricane and windstorm catastrophe coverage. |
What the 150 rows show
from the 150-row sampleAon (broker name) stands out: mean number_
- 4median number_
of_ retrocessionaires - 3statuses
- 4pricing methodologies
- 4risk types
- 5treaty types
- 10currencies
Median 4, from 1 to 15.
- string 12
- integer 1
- float 4
- date 2
- datetime 2
Columns
21 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
retrocession_program_id | string | Unique identifier for each retrocessional reinsurance programunique | RP-0001 |
reinsurer_name | string | Name of the reinsurer purchasing retrocessional coverage | Allianz Re |
program_name | string | Name or title of the retrocession program or treaty | Global Property XL 2021 |
treaty_type | string | Type of retrocession treaty (e.g., quota share, excess of loss, stop loss)6 values | excess of loss |
currency | string | Currency code for financial amounts (e.g., USD, EUR, GBP)10 currencies | USD |
ceded_portfolio_description | string | Description of the underlying portfolio or risks ceded to the retrocession programoptional | Covers global catastrophe… |
pricing_methodology | string | Methodology used for pricing the retrocession program (e.g., experience rating, exposure rating, model-based)5 values · optional | model-based |
broker_name | string | Name of the broker or intermediary involved in placing the retrocession program7 names · optional | Aon |
lead_retrocessionaire | string | Name of the lead retrocessionaire (if applicable)5 retrocessionaires · optional | Munich Re |
risk_type | string | Type of risk covered (e.g., property, casualty, life, specialty)property · casualty · life · specialty · other | property |
region | string | Geographic region or territory covered by the programoptional | Global |
status | string | Current status of the program (e.g., active, expired, pending)active · expired · pending · cancelled | expired |
| Numbers 5 columns | |||
coverage_limit | float | Maximum coverage limit provided by the retrocession program (in millions or specified currency)0 or more | 400.5 |
attachment_point | float | Attachment point or threshold at which coverage begins (in millions or specified currency)0 or more · optional | 180.25 |
premium_amount | float | Premium paid for the retrocession program (in millions or specified currency)0 or more | 28.75 |
number_of_retrocessionaires | integer | Total number of retrocessionaires participating in the program1 or more · optional | 10 |
market_capacity | float | Total market capacity available for the program (in millions or specified currency)0 or more · optional | 700 |
| Dates and times 4 columns | |||
inception_date | date | Start date of the retrocession program | 2021-01-01 |
expiry_date | date | End date of the retrocession program | 2023-01-01 |
created_at | datetime | Timestamp when the record was created | 2020-11-15T10:23:41 |
updated_at | datetime | Timestamp when the record was last updated | 2023-01-02T15:03:18 |
Use it for
An insurance dashboard
Number_
of_ retrocessionaires by broker_ name and a breakdown of lead_ retrocessionaire. Excel, Power BI or Tableau. Why do the 29 Aon rows have a mean number_
of_ retrocessionaires of 12.7? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Retrocession programs150RP-000110AonRP-00023Willis T…RP-00035Guy Carp…
A software demo
Believable retrocession programs with reinsurer_
name, program_ name and treaty_ type to fill a screen in front of a buyer.
This dataset150 rows21 columns
Yours1,000 rows21 columnsregion: UK only
blueprint · retrocessional-reinsurance-programs
Behind this dataset
Same schema. As many rows as you need.
These 150 rows came out of a blueprint — 21 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
- Retrocessional market participants
- Protects reinsurer from catastrophic losses
- Similar structures: XOL, quota share, etc.
- Retro pricing influenced by primary cat exposure
- Spiral effect in large cat events
- Credit risk on retrocessionaires
- Clash cover for multiple cedent losses in one event
- Industry loss warranties (ILW) as alternative
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
- retrocessional-reinsurance-programs