Facultative Reinsurance Placements

This dataset provides detailed records of individual facultative reinsurance placements for large or unusual risks, including ceding and reinsurer details, risk descriptions, coverage terms, premiums, and negotiated conditions. It supports analysis of reinsurance market practices, risk transfer strategies, and regulatory compliance for complex insurance exposures.

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

Reinsurance portfolio analysis and risk aggregation

Sample rows

preview · 8 of 401 rows · all 31 columns
placement_idstringinsured_typestringrate_on_linefloatrisk_location_countrystringceding_companystringceding_company_contact_namestringceding_company_contact_emailstringreinsurerstringreinsurer_contact_namestringreinsurer_contact_emailstringplacement_datedaterisk_location_street_addressstringrisk_location_citystringrisk_location_statestringrisk_location_postal_codestringpolicy_numberstringinsured_namestringcoverage_typestringcoverage_limitfloatcoverage_currencystringattachment_pointfloatpremiumfloatpremium_currencystringplacement_statusstringeffective_datedateexpiry_datedatebroker_namestringbroker_contact_emailstringnotesstringrisk_descriptionstringterms_and_conditionsstring
PL2024US01corporation0.8USAmerican Mutual InsuranceLinda Martinezlmartinez@am-mutual.comSwiss ReMartin Gehrigmgehrig@swissre.com2024-03-15100 N Riverside PlazaChicagoIL60606AM2024-CHI-PRP001Riverside Partners LLCproperty50000000USD5000000400000USDbound2024-04-012025-03-31Aonchicago.property@aon.comblankCommercial office tower in Chicago, 50 floors, fire and windstorm exposure.Excludes flood, terrorism, and earthquake. Deductible USD 250,000.
PL2024UK02corporation0.925GBLondon Assurance GroupEmily Clarkeeclarke@ldnassure.comMunich ReThomas Meyertmeyer@munichre.com2024-01-2023 Bloomsbury StreetLondonENGWC1B3QJLA2024-LON-PRP002Bloomsbury Residences Ltdproperty20000000GBP2000000185000GBPbound2024-02-012025-01-31Marshlondon.property@marsh.comblankCentral London apartment block, 120 units, property damage and liability.Subsidence and earthquake excluded. 10% co-insurance applies.
PL2024CA03corporation0.825CAOntario General InsuranceJacob Turnerjturner@on-gen.caSCORSophie Lambertslambert@scor.com2024-03-025555 Dixie RdMississaugaONL4W1E6OG2024-MIS-PRP003NorthPoint Logistics Inc.property12000000CAD100000099000CADbound2024-04-012025-03-31Locktonontario.warehouse@lockton.comblankDistribution warehouse in Mississauga, sprinklered, wind/hail risks.Windstorm and hail deductible CAD 50,000. Flood excluded.
PL2024SG04government1.486SGAsia Pacific InsuranceWei Zhangwzhang@ap-ins.com.sgHannover ReRichard Limrlim@hannoverre.com2024-04-07blankSingaporeblank048619AP2024-SG-MAR001Port Singapore Authoritymarine35000000SGD5000000520000SGDbound2024-05-012025-04-30Aonsg.marine@aon.comblankSingapore port container terminal, marine cargo and liability exposure.War and piracy excluded, marine liability limited to SGD 10M.
PL2024DE05corporation3DEBerlin Engineering UnderwritersSabine Fischersfischer@bereng.deMunich ReJens Bauerjbauer@munichre.com2024-02-18Am Ostbahnhof 8BerlinBE10243BE2024-BER-ENG001Berlin Infrastructure GmbHengineering18000000EUR2500000540000EURpending2024-04-012026-03-31JLTberlin.eng@jlt.comAwaiting final approval from government authorities.Railway bridge construction project, Berlin, steel and concrete risks.Excludes delays due to labor strikes. Project warranty 2 years post-completion.
PL2024US06individual0.514USMidwest Rural InsurancePaul Sandersonpsanderson@midwestrural.comPartnerReJulia Cranejcrane@partnerre.com2024-02-122418 210th StWebster CityIA50595MR2024-IA-PRP005David & Ellen Petersonproperty350000USD01800USDbound2024-03-012025-02-28Heartland Riskfarm@heartlandrisk.comRural location, moderate value.Family farm, Iowa, crop and livestock coverage.Excludes wildfire and drought losses. Crop depreciation applies.
PL2024JP07government2.857JPNippon Engineering InsuranceTakashi Moritmori@nip-eng.co.jpTokio MarineYuki Satoysato@tokiomarine.com2024-01-252-1-1 MarunouchiTokyo13100-0005NE2024-TYO-ENG009Tokyo Urban Authorityengineering35000000JPY100000001000000JPYpending2024-02-152027-02-14Mitsuitokyo.eng@mitsui.comAwaiting final sign-off on decennial warranty.Tokyo expressway tunnel, construction phase, seismic risk.Earthquake and tsunami excluded, warranty for defects 10 years.
PL2024US08individual0.333USPacific Coast InsuranceSusan Leeslee@pc-ins.comEverest ReCarlos Medinacmedina@everestre.com2024-04-091020 Summit DrBeverly HillsCA90210PC2024-CA-PRP012Evelyn Carterproperty6000000USD25000020000USDbound2024-04-152025-04-14Locktonbh.property@lockton.comblankHigh-value mansion, Beverly Hills, earthquake and fire coverage.Earthquake deductible USD 100,000. Flood excluded.

What the 401 rows show

from the 401-row sample

Government (insured type) stands out: mean rate_on_line is 3.5, against 1.2 for the rest.

  • 0.94median rate_on_line
  • 5placement statuses
  • 6coverage types
  • 13coverage currencies
  • 13premium currencies
  • 49reinsurers
Mean rate_on_line by insured_type401 rows
0240.43individu…68 rows1.5corporat…249 rows3.5governme…52 rows0.0other32 rows
rate_on_line401 rows, in bands of 1
0110220212832657203036rate_on_line →

Median 0.94, from 0.0 to 5.3.

risk_location_country394 rows with a value · 7 left blank
  1. US176
  2. CA32
  3. IN26
  4. SG21
  5. DE19
  6. JP17
  7. FR17
  8. AU17
  9. UK16
  10. GB15
31 columns by typefrom the column list below
  • string 24
  • float 4
  • date 3

Columns

31 columns in three groups
blueprint · 31 columns
columntypedescriptionexample
Text 24 columns
placement_idstringUnique identifier for each facultative reinsurance placementuniquePL2024US01
ceding_companystringName of the insurance company ceding the riskLondon Assurance Group
ceding_company_contact_namestringPrimary contact person at the ceding companyoptionalLinda Martinez
ceding_company_contact_emailstringEmail address of the ceding company contactoptionallmartinez@am-mutual.com
reinsurerstringName of the reinsurer accepting the riskSwiss Re
reinsurer_contact_namestringPrimary contact person at the reinsureroptionalMartin Gehrig
reinsurer_contact_emailstringEmail address of the reinsurer contactoptionalmgehrig@swissre.com
risk_descriptionstringDetailed description of the risk/exposure being cededCommercial office tower i…
risk_location_street_addressstringStreet address of the risk locationoptional100 N Riverside Plaza
risk_location_citystringCity where the risk is locatedoptionalChicago
risk_location_statestringState or province of the risk locationoptionalIL
risk_location_postal_codestringPostal code of the risk locationoptional60606
risk_location_countrystringCountry of the risk locationoptionalUS
policy_numberstringOriginal insurance policy number associated with the riskoptionalAM2024-CHI-PRP001
insured_namestringName of the insured partyoptionalRiverside Partners LLC
insured_typestringType of insured (e.g., individual, corporation, government)individual · corporation · government · other · optionalcorporation
coverage_typestringType of coverage provided (e.g., property, liability, engineering)6 valuesproperty
coverage_currencystringCurrency code for the coverage limit (ISO 4217 format)USD
premium_currencystringCurrency code for the premium (ISO 4217 format)USD
placement_statusstringCurrent status of the placementbound · declined · pending · expired · cancelledbound
terms_and_conditionsstringNegotiated terms and conditions for the placementoptionalExcludes flood losses.
broker_namestringName of the broker facilitating the placementoptionalAon
broker_contact_emailstringEmail address of the broker contactoptionalchicago.property@aon.com
notesstringAdditional notes or comments about the placementoptionalMarine hull coverage.
Numbers 4 columns
coverage_limitfloatMaximum coverage limit provided by the reinsurer (in policy currency)0 or more50000000
attachment_pointfloatAmount above which the reinsurance coverage attaches (in policy currency)0 or more · optional5000000
premiumfloatPremium charged for the placement (in policy currency)0 or more400000
rate_on_linefloatRate on line (premium divided by coverage limit, expressed as a percentage)0 to 100 · optional0.8
Dates and times 3 columns
placement_datedateDate when the facultative placement was finalized2024-03-15
effective_datedateDate when the coverage becomes effective2024-04-01
expiry_datedateDate when the coverage expires2025-03-31

Use it for

  • median rate on…0.94401 rowsmean rate on line by …0.43indi…1.5corp…3.5gove…0.0other

    An insurance dashboard

    Rate_on_line by insured_type and a breakdown of risk_location_country. Excel, Power BI or Tableau.

  • Why do the 52 government rows have a mean rate_on_line of 3.5?

    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 placements with ceding_company, ceding_company_contact_name and ceding_company_contact_email to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 31 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 dataset401 rows31 columns
Yours1,000 rows31 columnsrisk_location_street_address: UK only

blueprint · facultative-reinsurance-placements

Behind this dataset

Same schema. As many rows as you need.

These 401 rows came out of a blueprint — 31 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
  • Individual risk submission to reinsurers
  • Quote and acceptance for each risk
  • Proportional or excess of loss structure
  • Used for large risks exceeding treaty capacity
  • Used for risks outside treaty terms
  • Premium ceded based on negotiated rate
  • Follows fortunes: reinsurer follows cedent decisions
  • Cut-through clause for direct payment to insured
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
facultative-reinsurance-placements

More in Insurance

Browse all
Also in InsuranceAggregate Excess of Loss TreatiesClaims Fraud Detection DatasetMedical Claims Fraud DetectionAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.