Insurance Claims Severity Analysis
This dataset provides detailed records of insurance claims, including severity ratings, claim amounts, incident types, policy details, and customer demographics. It is ideal for risk modeling, severity analysis, fraud detection, and insurance pricing optimization, supporting both operational and analytical needs in the insurance industry.
Sample rows
preview · 8 of 200 rows · all 18 columns| claim_idstring | severity_levelstring | customer_ageinteger | fraud_suspectedboolean | incident_typestring | policy_idstring | customer_idstring | claim_datedate | incident_datedate | claim_statusstring | claim_amountfloat | approved_amountfloat | policy_typestring | customer_genderstring | customer_postal_codestring | policy_start_datedate | policy_end_datedate | adjuster_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLM-2024-AUTO-001 | medium | 28 | false | accident | P-2021-AUTO-001 | C-9011-M28 | 2024-03-18 | 2024-03-17 | open | 5420.75 | blank | auto | male | 94105 | 2021-03-01 | 2025-03-01 | Customer reported collision at intersection, minor injuries, awaiting police report. |
| CLM-2023-HEALTH-002 | medium | 44 | false | liability | P-2022-HEALTH-010 | C-9022-F44 | 2023-10-05 | 2023-10-03 | pending | 3080.25 | blank | health | female | 10001 | 2022-06-01 | 2024-06-01 | Medical reimbursement claim for workplace injury, awaiting employer verification. |
| CLM-2022-HOME-003 | high | 64 | false | fire | P-2019-HOME-005 | C-7991-F64 | 2022-07-21 | 2022-07-15 | closed | 125000 | 120000 | home | female | V5K3Z1 | 2019-04-10 | 2024-04-10 | Kitchen fire caused by stove malfunction, repair estimates verified, approved payout. |
| CLM-2021-LIFE-004 | high | 59 | false | other | P-2010-LIFE-021 | C-8993-M59 | 2021-02-10 | 2021-01-30 | closed | 80000 | 80000 | life | male | 75001 | 2010-02-01 | 2021-02-01 | Life insurance claim, required death certificate submitted, payout processed. |
| CLM-2024-BUSINESS-005 | critical | 61 | false | natural_disaster | P-2020-BUSINESS-009 | C-8822-F61 | 2024-01-25 | 2024-01-20 | under_review | 450000 | blank | business | female | W1A0AX | 2020-08-13 | 2030-08-13 | Flooding damaged warehouse, awaiting structural engineer's report. |
| CLM-2023-AUTO-006 | medium | 34 | false | accident | P-2022-AUTO-012 | C-8015-F34 | 2023-05-14 | 2023-05-13 | open | 6190 | blank | auto | female | 90210 | 2022-05-12 | 2025-05-12 | Rear-end collision, vehicle at repair shop, photos and police report pending. |
| CLM-2022-HEALTH-007 | low | 18 | false | accident | P-2021-HEALTH-024 | C-7733-M18 | 2022-11-04 | 2022-11-02 | closed | 2150.5 | 2100 | health | male | A1A1A1 | 2021-01-01 | 2023-01-01 | Minor injury from sports activity, doctor’s note submitted, reimbursement approved. |
| CLM-2023-BUSINESS-008 | high | blank | true | fire | P-2018-BUSINESS-011 | C-8888-PNT | 2023-08-29 | 2023-08-28 | denied | 120000 | 0 | business | prefer_not_to_say | 00100 | 2018-06-01 | 2028-06-01 | Claim denied due to insufficient fire safety compliance documentation. |
| CLM-2021-OTHER-009 | low | 0 | true | other | P-2020-OTHER-002 | C-8000-O0 | 2021-07-07 | 2021-07-05 | pending | 150 | blank | other | other | blank | 2020-03-01 | 2023-03-01 | Claim for lost property, minimal documentation, flagged for review. |
| CLM-2022-HOME-010 | critical | 61 | false | natural_disaster | P-2017-HOME-022 | C-7321-M61 | 2022-09-05 | 2022-09-04 | closed | 400000 | 380000 | home | male | 75001 | 2017-09-01 | 2027-09-01 | Tornado damage to roof and siding, adjuster verified extent, payout processed. |
| CLM-2024-LIFE-011 | high | 57 | false | other | P-2012-LIFE-031 | C-8992-F57 | 2024-05-01 | 2024-04-22 | pending | 90000 | blank | life | female | V5K3Z1 | 2012-05-01 | 2027-05-01 | Awaiting documentation for life event verification, claim under consideration. |
| CLM-2021-AUTO-012 | medium | 25 | false | accident | P-2021-AUTO-019 | C-9012-M25 | 2021-02-28 | 2021-02-28 | closed | 3200.5 | 3200.5 | auto | male | 94105 | 2021-01-01 | 2025-01-01 | Single vehicle crash, verified with dashcam footage, payout approved. |
| CLM-2023-HEALTH-013 | medium | 37 | false | accident | P-2022-HEALTH-013 | C-9013-F37 | 2023-11-13 | 2023-11-12 | open | 3995 | blank | health | female | 10001 | 2022-11-10 | 2024-11-10 | Claim for minor surgery, awaiting hospital invoice for review. |
| CLM-2022-BUSINESS-014 | critical | 61 | false | natural_disaster | P-2015-BUSINESS-021 | C-8777-M61 | 2022-03-17 | 2022-03-15 | closed | 900000 | 900000 | business | male | 75001 | 2015-03-01 | 2025-03-01 | Earthquake damage to office building, payout matched assessed loss. |
| CLM-2024-OTHER-015 | critical | 120 | true | other | P-2023-OTHER-011 | C-8001-N120 | 2024-06-30 | 2024-06-30 | denied | 9999999 | 0 | other | other | 99999 | 2023-01-01 | 2025-01-01 | Claim for highly unusual event, flagged and denied after fraud screening. |
| CLM-2022-AUTO-016 | medium | 41 | false | accident | P-2022-AUTO-015 | C-9016-F41 | 2022-12-05 | 2022-12-03 | open | 6100 | blank | auto | female | 94105 | 2022-05-01 | 2026-05-01 | Minor two-car collision, claims documents pending. |
| CLM-2023-HEALTH-017 | medium | 39 | false | liability | P-2021-HEALTH-019 | C-9017-M39 | 2023-02-12 | 2023-02-11 | closed | 4300 | 4200 | health | male | 10001 | 2021-02-01 | 2024-02-01 | Slip and fall in public space, medical bills verified, payout processed. |
| CLM-2021-HOME-018 | high | 64 | false | fire | P-2016-HOME-019 | C-9001-F64 | 2021-03-10 | 2021-03-09 | closed | 135000 | 130000 | home | female | V5K3Z1 | 2016-01-01 | 2026-01-01 | Fire caused by electrical fault, damage confirmed by fire department. |
| CLM-2022-LIFE-019 | high | blank | false | other | P-2005-LIFE-012 | C-8999-PNT | 2022-06-15 | 2022-06-01 | pending | 75000 | blank | life | prefer_not_to_say | W1A0AX | 2005-01-01 | 2025-01-01 | Policyholder death, documents incomplete, follow-up in progress. |
| CLM-2024-BUSINESS-020 | critical | 59 | false | natural_disaster | P-2020-BUSINESS-003 | C-8700-F59 | 2024-01-02 | 2023-12-31 | open | 320000 | blank | business | female | 75001 | 2020-01-01 | 2030-01-01 | Storm caused roof collapse, awaiting engineer’s assessment. |
What the 200 rows show
from the 200-row sampleLow (severity level) stands out: mean customer_
- 16%fraud_
suspected = true - 44median customer_
age - 4customer genders
- 5claim statuses
- 6policy types
- 48customer postal codes
Median 44, from 0 to 120.
- string 10
- integer 1
- float 2
- date 4
- boolean 1
Columns
18 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
claim_id | string | Unique identifier for each insurance claimunique | CLM-2024-AUTO-001 |
policy_id | string | Unique identifier for the insurance policy associated with the claim | P-2021-AUTO-001 |
customer_id | string | Unique identifier for the customer making the claim | C-9011-M28 |
incident_type | string | Type of incident leading to the claim (e.g., theft, accident, fire)6 values | accident |
claim_status | string | Current status of the claim (e.g., open, closed, pending, denied)open · closed · pending · denied · under_review | open |
severity_level | string | Severity rating of the claim for risk modelinglow · medium · high · critical | medium |
policy_type | string | Type of insurance policy (e.g., auto, home, life, health)6 values | auto |
customer_gender | string | Gender of the customermale · female · other · prefer_not_to_say · optional | male |
customer_postal_code | string | Postal code of the customer's addressoptional | 94105 |
adjuster_notes | string | Free-text notes from the claim adjusteroptional | Customer reported collisi… |
| Numbers 3 columns | |||
claim_amount | float | Total monetary amount claimed by the customer0 or more | 5420.75 |
approved_amount | float | Amount approved by the insurer for payout0 or more · optional | 120000 |
customer_age | integer | Age of the customer at the time of claim0 to 120 · optional | 28 |
| Dates and times 4 columns | |||
claim_date | date | Date when the claim was filed | 2024-03-18 |
incident_date | date | Date when the incident occurred | 2024-03-17 |
policy_start_date | date | Start date of the insurance policyoptional | 2021-03-01 |
policy_end_date | date | End date of the insurance policyoptional | 2025-03-01 |
| True or false 1 column | |||
fraud_suspected | boolean | Indicates if the claim is suspected to be fraudulentoptional | false |
Use it for
An insurance dashboard
The fraud_
suspected rate, customer_ age by severity_ level and a breakdown of incident_ type. Excel, Power BI or Tableau. Why do the 23 low rows have a mean customer_
age of 8.3? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Claims200CLM-2024-AUTO-00128mediumCLM-2023-BUSINESS-008highCLM-2021-OTHER-0090low
A software demo
Believable claims with policy_
id, customer_ id and claim_ date to fill a screen in front of a buyer.
This dataset200 rows18 columns
Yours1,000 rows18 columnscustomer_postal_code: UK only
blueprint · insurance-claims-severity-analysis
Behind this dataset
Same schema. As many rows as you need.
These 200 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
- Claim incident type categorized
- Severity rated on scale
- Claim value provided
- Settlement timeline recorded
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
- insurance-claims-severity-analysis