Insurance Policy Claims Summary
This dataset provides a comprehensive summary of insurance policy claims, including detailed claim information, claimant demographics, policy attributes, and risk indicators. It enables insurers to analyze claim frequency, identify high-risk claimants, detect potential fraud, and streamline claims processing for improved risk management and operational efficiency.
Sample rows
preview · 8 of 85 rows · all 26 columns| claim_idstring | claim_typestring | claim_amountfloat | is_fraud_suspectedboolean | claimant_statestring | policy_idstring | claimant_idstring | claim_datedate | claim_statusstring | approved_amountfloat | settlement_datedate | claim_reasonstring | claimant_namestring | claimant_dobdate | claimant_emailstring | claimant_phonestring | claimant_street_addressstring | claimant_citystring | claimant_postal_codestring | claimant_countrystring | policy_start_datedate | policy_end_datedate | policy_typestring | policy_premiumfloat | number_of_previous_claimsinteger | high_frequency_claimantboolean |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLM00001 | auto | 4200.75 | false | IL | POL10001 | C1001 | 2023-01-12 | approved | 3900 | 2023-01-28 | Rear-end collision at traffic light | Natalie Roberts | 1984-07-15 | natalie.roberts84@ | +1-312-555-0189 | 178 Pine St | Chicago | 60614 | USA | 2022-06-01 | 2023-06-01 | auto | 1180.5 | 1 | false |
| CLM00002 | health | 870 | false | CA | POL10002 | C1002 | 2023-02-20 | under_review | 0 | blank | Emergency room visit | Marcus Chen | 1990-02-28 | marcus.chen90@ | +1-415-555-1207 | 9249 Mission Blvd | San Francisco | 94110 | USA | 2022-09-15 | 2023-09-15 | health | 2495 | 0 | false |
| CLM00003 | home | 13400 | false | MA | POL10003 | C1003 | 2022-12-05 | denied | 0 | 2022-12-20 | Water damage due to faulty plumbing | Sarah O'Neil | 1973-10-22 | soneil1973@ | +1-617-555-7765 | 231 Maple Ave | Boston | 02118 | USA | 2022-01-10 | 2023-01-10 | home | 2100 | 2 | false |
| CLM00004 | travel | 1100.8 | false | FL | POL10004 | C1004 | 2023-03-14 | approved | 950 | 2023-03-29 | Flight cancellation due to weather | Isabel Martinez | 1995-11-08 | isabel_m95@ | +1-305-555-2135 | 657 Ocean Dr | Miami | 33139 | USA | 2023-02-25 | 2023-05-25 | travel | 180 | 0 | false |
| CLM00005 | auto | 3100 | false | IL | POL10005 | C1005 | 2022-11-27 | approved | 3100 | 2022-12-10 | Vandalism - broken windshield | Paul Singh | 1981-03-05 | psingh81@ | +1-708-555-9920 | 1046 Ridgeway Rd | Aurora | 60504 | USA | 2022-04-10 | 2023-04-10 | auto | 950 | 1 | false |
| CLM00006 | other | 250 | false | NY | POL10006 | C1006 | 2023-01-30 | closed | 200 | 2023-02-12 | Lost luggage during move | Jenna Lee | 1988-08-17 | jenna.lee88@ | +1-347-555-0044 | 89-17 34th Ave | Queens | 11372 | USA | 2022-12-20 | 2023-12-20 | other | 400 | 0 | false |
| CLM00007 | life | 80000 | false | NY | POL10007 | C1007 | 2023-04-04 | submitted | 0 | blank | Policy holder deceased | Rebecca Murphy | 1970-12-10 | rmurphy1970@ | +1-917-555-2501 | 255 6th Ave | New York | 10014 | USA | 2018-05-01 | 2028-05-01 | life | 920 | 0 | false |
| CLM00008 | health | 2300 | false | OR | POL10008 | C1008 | 2023-02-11 | approved | 2300 | 2023-02-19 | Knee surgery reimbursement | Lisa Tran | 1992-04-19 | lisatran92@ | +1-503-555-7123 | 4527 Alder St | Portland | 97214 | USA | 2022-03-12 | 2023-03-12 | health | 1980 | 2 | false |
| CLM00009 | auto | 600 | false | TX | POL10009 | C1009 | 2023-03-07 | closed | 600 | 2023-03-20 | Minor fender bender | James Wilson | 1987-09-23 | jameswilson87@ | +1-214-555-9861 | 703 Royal Ln | Dallas | 75229 | USA | 2022-10-20 | 2023-10-20 | auto | 1120 | 0 | false |
| CLM00010 | home | 9600 | false | CO | POL10010 | C1010 | 2022-12-12 | approved | 9000 | 2022-12-27 | Roof damage due to hailstorm | Anjali Patel | 1979-06-11 | anjalipatel79@ | +1-719-555-3475 | 2188 Eastview Dr | Colorado Springs | 80918 | USA | 2021-07-15 | 2023-07-15 | home | 1650 | 1 | false |
| CLM00011 | travel | 450 | false | WA | POL10011 | C1011 | 2023-03-01 | under_review | 0 | blank | Delayed baggage | Oliver Hall | 1985-01-12 | ohall85@ | +1-206-555-3017 | 3201 18th Ave S | Seattle | 98144 | USA | 2023-02-19 | 2023-05-19 | travel | 95 | 0 | false |
| CLM00012 | auto | 1750 | false | TX | POL10012 | C1012 | 2023-01-17 | approved | 1700 | 2023-02-01 | Hit while parked | Gabriel Diaz | 1975-09-09 | gabriel_d75@ | +1-210-555-4008 | 1123 Woodstone Dr | San Antonio | 78230 | USA | 2022-05-10 | 2023-05-10 | auto | 980 | 2 | false |
| CLM00013 | health | 150 | false | CO | POL10013 | C1013 | 2022-11-01 | closed | 140 | 2022-11-14 | Prescription reimbursement | Emily Adams | 1993-08-27 | emily.adams93@ | +1-720-555-8890 | 551 Walnut St | Boulder | 80302 | USA | 2022-03-21 | 2023-03-21 | health | 1760 | 0 | false |
| CLM00014 | auto | 8500 | false | CA | POL10014 | C1014 | 2023-01-22 | approved | 8000 | 2023-02-05 | Major accident at intersection | Christopher Johnson | 1980-05-18 | chris.johnson80@ | +1-818-555-9284 | 8021 Laurel Canyon Blvd | North Hollywood | 91605 | USA | 2022-07-01 | 2023-07-01 | auto | 1325 | 3 | true |
| CLM00015 | other | 650 | false | NV | POL10015 | C1015 | 2023-04-05 | submitted | 0 | blank | Phone theft during event | Alicia Kim | 1997-12-02 | alicia.kim97@ | +1-702-555-3111 | 999 Fremont St | Las Vegas | 89101 | USA | 2023-01-01 | 2024-01-01 | other | 520 | 0 | false |
| CLM00016 | life | 50000 | true | CO | POL10016 | C1016 | 2022-10-18 | denied | 0 | 2022-11-04 | Claim outside covered period | Gregory Smith | 1965-01-08 | gsmith65@ | +1-303-555-4478 | 1202 Magnolia St | Denver | 80220 | USA | 2010-02-01 | 2020-02-01 | life | 760 | 0 | false |
| CLM00017 | health | 590 | false | AZ | POL10017 | C1017 | 2023-03-10 | approved | 590 | 2023-03-16 | Dental procedure | Derek Brown | 1989-03-04 | derek.brown89@ | +1-480-555-6611 | 431 N 2nd Ave | Phoenix | 85003 | USA | 2022-04-07 | 2023-04-07 | health | 1610 | 1 | false |
| CLM00018 | home | 3200 | false | MN | POL10018 | C1018 | 2023-02-09 | closed | 3100 | 2023-02-25 | Kitchen fire damage | Olivia White | 1982-06-21 | olivia.white82@ | +1-612-555-7239 | 57 Summit Ave | St. Paul | 55102 | USA | 2022-07-24 | 2023-07-24 | home | 1885 | 0 | false |
| CLM00019 | auto | 2100 | false | OH | POL10019 | C1019 | 2023-04-07 | submitted | 0 | blank | Side mirror hit by passing car | Benjamin Parker | 1994-02-03 | ben.parker94@ | +1-330-555-9007 | 2101 W Market St | Akron | 44313 | USA | 2022-11-04 | 2023-11-04 | auto | 1010 | 1 | false |
| CLM00020 | travel | 200 | false | NY | POL10020 | C1020 | 2022-12-08 | approved | 200 | 2022-12-12 | Travel delay compensation | Anna Fischer | 1991-11-30 | anna.fischer91@ | +1-646-555-2319 | 1781 Broadway | New York | 10019 | USA | 2022-11-20 | 2023-02-20 | travel | 120 | 0 | false |
What the 85 rows show
from the 85-row sampleLife (claim type) stands out: mean claim_
- 8%is_
fraud_ suspected = true - 2,180median claim_
amount - 5claim statuses
- 6policy types
- 10claimant countries
- 950median approved_
amount
Median 2,180, from 120.0 to 250,000.
- string 15
- integer 1
- float 3
- date 5
- boolean 2
Columns
26 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
claim_id | string | Unique identifier for each insurance claimunique | CLM00001 |
policy_id | string | Unique identifier for the insurance policy associated with the claim | POL10001 |
claimant_id | string | Unique identifier for the individual or entity making the claim | C1001 |
claim_status | string | Current status of the claim (e.g., submitted, under_review, approved, denied, closed)submitted · under_review · approved · denied · closed | approved |
claim_type | string | Type of insurance claim (e.g., auto, home, health, life, travel, other)6 values | auto |
claim_reason | string | Brief description or reason for the claimoptional | Emergency room visit |
claimant_name | string | Full name of the claimant | Natalie Roberts |
claimant_email | string | Email address of the claimantoptional | marcus.chen90@ |
claimant_phone | string | Phone number of the claimantoptional | +1-312-555-0189 |
claimant_street_address | string | Street address of the claimantoptional | 178 Pine St |
claimant_city | string | City of the claimant's addressoptional | Chicago |
claimant_state | string | State or province of the claimant's addressoptional | IL |
claimant_postal_code | string | Postal or ZIP code of the claimant's addressoptional | 60614 |
claimant_country | string | Country of the claimant's address10 countries · optional | USA |
policy_type | string | Type of insurance policy (e.g., auto, home, health, life, travel, other)6 values · optional | auto |
| Numbers 4 columns | |||
claim_amount | float | Total amount claimed by the claimant0 or more | 4200.75 |
approved_amount | float | Amount approved for payout after claim assessment0 or more · optional | 3900 |
policy_premium | float | Annual premium amount for the policy0 or more · optional | 1180.5 |
number_of_previous_claims | integer | Number of previous claims filed by the claimant under this policy0 or more · optional | 1 |
| Dates and times 5 columns | |||
claim_date | date | Date the claim was filed | 2023-01-12 |
settlement_date | date | Date the claim was settled or closedoptional | 2023-01-28 |
claimant_dob | date | Date of birth of the claimantoptional | 1984-07-15 |
policy_start_date | date | Start date of the insurance policyoptional | 2022-06-01 |
policy_end_date | date | End date of the insurance policyoptional | 2023-06-01 |
| True or false 2 columns | |||
is_fraud_suspected | boolean | Indicates whether the claim is suspected of fraudoptional | false |
high_frequency_claimant | boolean | Flag indicating if the claimant is identified as a high-frequency claimantoptional | false |
Use it for
An insurance dashboard
The is_
fraud_ suspected rate, claim_ amount by claim_ type and a breakdown of claimant_ state. Excel, Power BI or Tableau. Why do the 11 life rows have a mean claim_
amount of 97,727? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Claims85CLM000014200.75autoCLM0001650000lifeCLM000261340travel
A software demo
Believable claims with policy_
id, claimant_ id and claim_ date to fill a screen in front of a buyer.
blueprint · insurance-policy-claims-summary
Behind this dataset
Same schema. As many rows as you need.
These 85 rows came out of a blueprint — 26 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.
- Each claim has a unique reference number
- Claims must be associated with an active policy
- Flag repeat claimants within 12 months
- Classify claims by type and amount
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-policy-claims-summary