International and Cross-Border Exposure
This dataset provides comprehensive records of international and cross-border insurance exposures, detailing policy information, foreign operations, admitted and non-admitted placements, currency risks, and regulatory compliance by country. It enables insurers, brokers, and risk managers to analyze global insurance portfolios, monitor regulatory status, and assess currency and operational risks across jurisdictions.
Sample rows
preview · 8 of 400 rows · all 18 columns| exposure_idstring | placement_typestring | exposure_amountfloat | operation_typestring | policy_idstring | insured_entity_namestring | country_of_exposurestring | policy_currencystring | local_currencystring | exchange_rate_to_policy_currencyfloat | regulatory_compliance_statusstring | effective_datedate | expiry_datedate | broker_namestring | insurer_namestring | policy_typestring | regulatory_notesstring | coverage_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EXP0001 | admitted | 1324450.17 | subsidiary | POL10001 | Alpha Manufacturing Ltd. | Germany | EUR | EUR | 1 | compliant | 2022-03-01 | 2023-03-01 | Munich Re Global Brokers | Munich Re | property | blank | Coverage for buildings, machinery, and fixed assets at German subsidiary. |
| EXP0002 | admitted | 1083000.5 | subsidiary | POL10001 | Alpha Manufacturing Ltd. | United Kingdom | GBP | GBP | 1 | pending | 2023-06-15 | 2024-06-15 | Lloyd's Brokers UK | Lloyd's London | property | Awaiting regulatory approval for new warehouse site. | Property insurance for UK office and warehousing infrastructure. |
| EXP0003 | admitted | 2275000 | subsidiary | POL10002 | Beta Foods Group | South Africa | ZAR | ZAR | 1 | compliant | 2022-09-01 | 2023-09-01 | Santam Brokers | Santam Insurance | property | blank | Protection for processing plants, storage, and retail outlets in South Africa. |
| EXP0004 | non-admitted | 750000.75 | branch | POL10003 | Gamma Tech Solutions Inc. | United States | USD | USD | 1 | pending | 2023-01-20 | 2024-01-20 | Marsh USA | AIG | liability | Awaiting surplus lines approval for expansion. | General liability for sales and service operations in California. |
| EXP0005 | non-admitted | 320000 | branch | POL10004 | Delta Logistics LLC | Singapore | USD | SGD | 1.36 | non-compliant | 2022-11-10 | 2023-11-10 | blank | Zurich Insurance | liability | Branch operation in Singapore not fully adhering to local insurance requirements. | Professional liability for regional logistics and transportation office. |
| EXP0006 | admitted | 2550000 | subsidiary | POL10005 | Epsilon Energy Corp. | Australia | AUD | AUD | 1 | compliant | 2022-05-01 | 2023-05-01 | Willis Australia | QBE Insurance | property | blank | Coverage for oil and gas facilities and equipment across Western Australia. |
| EXP0007 | non-admitted | 620000 | branch | POL10006 | Zeta Trading Co. | Brazil | USD | BRL | 5.14 | pending | 2023-03-01 | 2024-03-01 | Bradesco Brokers | Chubb | liability | Branch liability coverage pending local regulatory approval. | General liability for distribution center and sales operations. |
| EXP0008 | admitted | 21000000 | joint venture | POL10007 | Omega Aerospace Group | New Zealand | NZD | NZD | 1 | compliant | 2022-07-01 | 2025-07-01 | Aon New Zealand | Aon | property | blank | Mega-project insurance for aerospace manufacturing and research facility. |
| EXP0009 | admitted | 75 | other | POL10008 | Theta Holdings Cooperative | Kenya | KES | KES | 1 | unknown | 2023-09-01 | 2023-09-15 | blank | Jubilee Insurance | property | blank | Test coverage for micro-insurance pilot program. |
| EXP0010 | non-admitted | 410000 | branch | POL10009 | Lambda Retail Inc. | India | INR | INR | 1 | pending | 2022-12-01 | 2023-12-01 | ICICI Lombard Brokers | ICICI Lombard | liability | Branch awaiting compliance documentation. | Professional liability for retail operations in Mumbai. |
| EXP0011 | non-admitted | 520000 | branch | POL10010 | Sigma Agro Group | Botswana | USD | BWP | 13.45 | non-compliant | 2023-04-01 | 2024-04-01 | blank | Liberty Holdings | liability | Local insurance requirements not met. | General liability for agricultural processing operations. |
| EXP0012 | admitted | 980000 | subsidiary | POL10011 | Pi Technologies LLC | Canada | CAD | CAD | 1 | compliant | 2022-10-01 | 2023-10-01 | Aviva Canada Brokers | Aviva | property | blank | Property insurance for office and laboratory assets in Toronto. |
| EXP0013 | admitted | 12500000 | joint venture | POL10012 | Rho Maritime Corp. | Japan | JPY | JPY | 1 | pending | 2023-02-10 | 2024-02-10 | Tokio Marine Brokers | Tokio Marine | marine | Joint venture awaiting regulatory inspection. | Marine cargo insurance for import/export operations in Yokohama. |
| EXP0014 | admitted | 1400000 | subsidiary | POL10013 | Kappa Construction Group | France | EUR | EUR | 1 | compliant | 2022-11-01 | 2023-11-01 | AXA Brokers France | AXA | property | blank | Coverage for construction equipment and assets. |
| EXP0015 | non-admitted | 55000 | representative office | POL10014 | Tau Holdings Ltd. | Greece | EUR | EUR | 1 | compliant | 2022-06-15 | 2023-06-15 | Ethniki Brokers | Ethniki Insurance | liability | blank | Errors & omissions liability coverage for Athens office. |
| EXP0016 | admitted | 2100000 | subsidiary | POL10015 | Upsilon Financial Group | Switzerland | CHF | CHF | 1 | compliant | 2023-06-01 | 2024-06-01 | Swiss Re Brokers | Zurich Insurance | property | blank | Coverage for banking office and IT assets in Zurich. |
| EXP0017 | admitted | 9200000 | joint venture | POL10016 | Xi Technology Inc. | China | CNY | CNY | 1 | pending | 2023-08-01 | 2024-08-01 | Ping An Brokers | Ping An Insurance | property | Pending final regulatory clearance for joint venture. | Assets and infrastructure coverage for Shanghai tech park. |
| EXP0018 | non-admitted | 375000 | branch | POL10017 | Omicron Holdings LLC | Mexico | USD | MXN | 18.89 | pending | 2023-03-01 | 2024-03-01 | Seguros Monterrey Brokers | Chubb | liability | Awaiting non-admitted placement approval from Mexican regulator. | Liability coverage for sales and fulfillment center in Monterrey. |
| EXP0019 | non-admitted | 82000 | representative office | POL10018 | Phi Consulting LLC | United States | USD | USD | 1 | compliant | 2022-10-01 | 2023-10-01 | Gallagher USA | Gallagher | liability | blank | Cyber liability coverage for pilot consulting office. |
| EXP0020 | admitted | 1150000 | subsidiary | POL10019 | Chi Pharmaceuticals Inc. | Ireland | EUR | EUR | 1 | compliant | 2023-01-01 | 2024-01-01 | Aviva Ireland | Aviva | property | blank | Coverage for pharmaceutical research and production facilities. |
What the 400 rows show
from the 400-row sample- 927,500median exposure_
amount - 3policy types
- 4regulatory compliance statuses
- 59policy currencies
- 64local currencies
- 81country of exposures
Median 927,500, from 22.0 to 215,000,000.
- string 14
- float 2
- date 2
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
exposure_id | string | Unique identifier for each insurance exposure recordunique | EXP0001 |
policy_id | string | Unique identifier for the insurance policy related to the exposure | POL10001 |
insured_entity_name | string | Name of the insured company or individual | Alpha Manufacturing Ltd. |
country_of_exposure | string | Country where the insurance exposure occurs | Germany |
operation_type | string | Type of foreign operation (e.g., subsidiary, branch, joint venture)5 values · optional | subsidiary |
placement_type | string | Indicates if the placement is admitted or non-admittedadmitted · non-admitted | admitted |
policy_currency | string | Currency code in which the policy is issued (ISO 4217 format) | EUR |
local_currency | string | Currency code used in the country of exposure (ISO 4217 format) | EUR |
regulatory_compliance_status | string | Status of compliance with local insurance regulationscompliant · non-compliant · pending · unknown | compliant |
regulatory_notes | string | Additional notes regarding regulatory compliance for the exposureoptional | License review underway. |
broker_name | string | Name of the insurance broker handling the placementoptional | Munich Re Global Brokers |
insurer_name | string | Name of the insurer providing the coverage | Munich Re |
policy_type | string | Type of insurance policy (e.g., property, liability, marine)3 types | property |
coverage_description | string | Detailed description of coverage provided under the policyoptional | Coverage for buildings, m… |
| Numbers 2 columns | |||
exposure_amount | float | Monetary value of the exposure in the policy currency0 or more | 1324450.17 |
exchange_rate_to_policy_currency | float | Exchange rate from local currency to policy currency at the time of exposure0 or more · optional | 1 |
| Dates and times 2 columns | |||
effective_date | date | Date when the insurance exposure becomes effective | 2022-03-01 |
expiry_date | date | Date when the insurance exposure expires | 2023-03-01 |
Use it for
An insurance dashboard
Exposure_
amount by placement_ type and a breakdown of operation_ type. Excel, Power BI or Tableau. What pattern can you find in 400 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 400 rows.
- Exposures400EXP00011324450.17admittedEXP00021083000.5admittedEXP00032275000admitted
A software demo
Believable exposures with policy_
id, insured_ entity_ name and country_ of_ exposure to fill a screen in front of a buyer.
This dataset400 rows18 columns
Yours1,000 rows18 columnscountry_of_exposure: UK only
blueprint · international-and-cross-border-exposure
Behind this dataset
Same schema. As many rows as you need.
These 400 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
- Country of risk
- Admitted vs non-admitted status by country
- Currency of policy (USD, EUR, GBP, etc.)
- Foreign exchange exposure
- Local regulatory requirements
- Fronting arrangements
- Master policy with local certificates
- Difference in conditions (DIC) coverage
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
- international-and-cross-border-exposure