DBHunter
Infinity Member
Golden Member
- Joined
- August 23, 2025
- Messages
- 1,940
- Reaction score
- 3,423
- Points
- 113
- Thread Author
- #1
Hello DNA, today I'm leaking two very interesting Swiss files :
the first one zurich.com.csv contains 4,260,757 complete lines of structured insurance data, each containing all the information for a contract.
It groups the following into a single table:
insurance contracts (policies),
clients (policyholders),
insured vehicles,
intermediaries (agents),
as well as financial and commercial information.
It also includes:
detailed data on coverages and insured amounts,
information specific to certain products (such as home or business insurance),
data for the primary driver and the owner,
and business indicators (status, assistance, customer value).
The second file, lluch20210629.sql, contains a complete set of data related to insurance contracts (policies), primarily focused on vehicles, but with extensions for other types of products (home, business, etc.).
It includes several types of information:
Policy information: contract number, version, product type, structure, and important dates (start, end, effective).
Policyholder (client) data: identity (last name, first name), official document (National Identity Document/Tax Identification Number), contact information (address, phone number, email).
Information on the insured vehicle: registration number, make, model, technical specifications (power, engine type, number of seats, etc.).
Information on the intermediary (agent or broker): identifier, name, and contact information.
Contractual and financial elements: IBAN, receipt status, insured capital, deductibles, and contract terms.
Product-specific data (residential or commercial): property use, type of dwelling, business activity, insured capital, etc.
Information on other individuals linked to the contract: primary driver and vehicle owner.
Business indicators: policy status, customer value, included assistance options (up to 10 types).
Additional information: contract language, insurance company, chosen package or plan.
Sample :
the first one zurich.com.csv contains 4,260,757 complete lines of structured insurance data, each containing all the information for a contract.
It groups the following into a single table:
insurance contracts (policies),
clients (policyholders),
insured vehicles,
intermediaries (agents),
as well as financial and commercial information.
It also includes:
detailed data on coverages and insured amounts,
information specific to certain products (such as home or business insurance),
data for the primary driver and the owner,
and business indicators (status, assistance, customer value).
The second file, lluch20210629.sql, contains a complete set of data related to insurance contracts (policies), primarily focused on vehicles, but with extensions for other types of products (home, business, etc.).
It includes several types of information:
Policy information: contract number, version, product type, structure, and important dates (start, end, effective).
Policyholder (client) data: identity (last name, first name), official document (National Identity Document/Tax Identification Number), contact information (address, phone number, email).
Information on the insured vehicle: registration number, make, model, technical specifications (power, engine type, number of seats, etc.).
Information on the intermediary (agent or broker): identifier, name, and contact information.
Contractual and financial elements: IBAN, receipt status, insured capital, deductibles, and contract terms.
Product-specific data (residential or commercial): property use, type of dwelling, business activity, insured capital, etc.
Information on other individuals linked to the contract: primary driver and vehicle owner.
Business indicators: policy status, customer value, included assistance options (up to 10 types).
Additional information: contract language, insurance company, chosen package or plan.
Sample :
Enjoy your download :
