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.

  • last updated 21 Jul 2025
  • by GoMask
The brief that made it

Risk assessment and segmentation of policyholders

Sample rows

preview · 8 of 85 rows · all 26 columns
claim_idstringclaim_typestringclaim_amountfloatis_fraud_suspectedbooleanclaimant_statestringpolicy_idstringclaimant_idstringclaim_datedateclaim_statusstringapproved_amountfloatsettlement_datedateclaim_reasonstringclaimant_namestringclaimant_dobdateclaimant_emailstringclaimant_phonestringclaimant_street_addressstringclaimant_citystringclaimant_postal_codestringclaimant_countrystringpolicy_start_datedatepolicy_end_datedatepolicy_typestringpolicy_premiumfloatnumber_of_previous_claimsintegerhigh_frequency_claimantboolean
CLM00001auto4200.75falseILPOL10001C10012023-01-12approved39002023-01-28Rear-end collision at traffic lightNatalie Roberts1984-07-15natalie.roberts84@gmail.com+1-312-555-0189178 Pine StChicago60614USA2022-06-012023-06-01auto1180.51false
CLM00002health870falseCAPOL10002C10022023-02-20under_review0blankEmergency room visitMarcus Chen1990-02-28marcus.chen90@yahoo.com+1-415-555-12079249 Mission BlvdSan Francisco94110USA2022-09-152023-09-15health24950false
CLM00003home13400falseMAPOL10003C10032022-12-05denied02022-12-20Water damage due to faulty plumbingSarah O'Neil1973-10-22soneil1973@hotmail.com+1-617-555-7765231 Maple AveBoston02118USA2022-01-102023-01-10home21002false
CLM00004travel1100.8falseFLPOL10004C10042023-03-14approved9502023-03-29Flight cancellation due to weatherIsabel Martinez1995-11-08isabel_m95@outlook.com+1-305-555-2135657 Ocean DrMiami33139USA2023-02-252023-05-25travel1800false
CLM00005auto3100falseILPOL10005C10052022-11-27approved31002022-12-10Vandalism - broken windshieldPaul Singh1981-03-05psingh81@gmail.com+1-708-555-99201046 Ridgeway RdAurora60504USA2022-04-102023-04-10auto9501false
CLM00006other250falseNYPOL10006C10062023-01-30closed2002023-02-12Lost luggage during moveJenna Lee1988-08-17jenna.lee88@aol.com+1-347-555-004489-17 34th AveQueens11372USA2022-12-202023-12-20other4000false
CLM00007life80000falseNYPOL10007C10072023-04-04submitted0blankPolicy holder deceasedRebecca Murphy1970-12-10rmurphy1970@protonmail.com+1-917-555-2501255 6th AveNew York10014USA2018-05-012028-05-01life9200false
CLM00008health2300falseORPOL10008C10082023-02-11approved23002023-02-19Knee surgery reimbursementLisa Tran1992-04-19lisatran92@gmail.com+1-503-555-71234527 Alder StPortland97214USA2022-03-122023-03-12health19802false

What the 85 rows show

from the 85-row sample

Life (claim type) stands out: mean claim_amount is 97,727, against 3,883 for the rest.

  • 8%is_fraud_suspected = true
  • 2,180median claim_amount
  • 5claim statuses
  • 6policy types
  • 10claimant countries
  • 950median approved_amount
Mean claim_amount by claim_type85 rows
050k100k3,399auto24 rows12,274home14 rows756.2health17 rows97,727life11 rows1,009travel10 rows1,222other9 rows
claim_amount85 rows, in bands of 25k
04080740424000010125k250kclaim_amount →

Median 2,180, from 120.0 to 250,000.

claimant_state85 rows · top 10 of 33 values
  1. CA10
  2. NY7
  3. TX7
  4. IL6
  5. CO5
  6. MA4
  7. MN4
  8. FL3
  9. OR3
  10. WA3
26 columns by typefrom the column list below
  • string 15
  • integer 1
  • float 3
  • date 5
  • boolean 2

Columns

26 columns in four groups
blueprint · 26 columns
columntypedescriptionexample
Text 15 columns
claim_idstringUnique identifier for each insurance claimuniqueCLM00001
policy_idstringUnique identifier for the insurance policy associated with the claimPOL10001
claimant_idstringUnique identifier for the individual or entity making the claimC1001
claim_statusstringCurrent status of the claim (e.g., submitted, under_review, approved, denied, closed)submitted · under_review · approved · denied · closedapproved
claim_typestringType of insurance claim (e.g., auto, home, health, life, travel, other)6 valuesauto
claim_reasonstringBrief description or reason for the claimoptionalEmergency room visit
claimant_namestringFull name of the claimantNatalie Roberts
claimant_emailstringEmail address of the claimantoptionalmarcus.chen90@yahoo.com
claimant_phonestringPhone number of the claimantoptional+1-312-555-0189
claimant_street_addressstringStreet address of the claimantoptional178 Pine St
claimant_citystringCity of the claimant's addressoptionalChicago
claimant_statestringState or province of the claimant's addressoptionalIL
claimant_postal_codestringPostal or ZIP code of the claimant's addressoptional60614
claimant_countrystringCountry of the claimant's address10 countries · optionalUSA
policy_typestringType of insurance policy (e.g., auto, home, health, life, travel, other)6 values · optionalauto
Numbers 4 columns
claim_amountfloatTotal amount claimed by the claimant0 or more4200.75
approved_amountfloatAmount approved for payout after claim assessment0 or more · optional3900
policy_premiumfloatAnnual premium amount for the policy0 or more · optional1180.5
number_of_previous_claimsintegerNumber of previous claims filed by the claimant under this policy0 or more · optional1
Dates and times 5 columns
claim_datedateDate the claim was filed2023-01-12
settlement_datedateDate the claim was settled or closedoptional2023-01-28
claimant_dobdateDate of birth of the claimantoptional1984-07-15
policy_start_datedateStart date of the insurance policyoptional2022-06-01
policy_end_datedateEnd date of the insurance policyoptional2023-06-01
True or false 2 columns
is_fraud_suspectedbooleanIndicates whether the claim is suspected of fraudoptionalfalse
high_frequency_claimantbooleanFlag indicating if the claimant is identified as a high-frequency claimantoptionalfalse

Use it for

  • is fraud suspe…8%7 of 85 rowsmean claim amount by …3.4kauto12.3khome756.2heal…97.7klife

    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.

  • A software demo

    Believable claims with policy_id, claimant_id and claim_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 26 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 dataset85 rows26 columns
Yours1,000 rows26 columnsclaimant_street_address: UK only

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.

Rules it was built with
  • 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
Rows
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-policy-claims-summary

What should your data show?

Preview 20 rows free
No signup. No card.