Policy Cancellations and Reinstatements

This dataset provides detailed records of insurance policy cancellation and reinstatement transactions, including financial calculations, notice requirements, and policyholder information. It enables comprehensive analysis of cancellation trends, compliance with regulatory requirements, and customer retention strategies. Ideal for insurers seeking to optimize operational processes and improve customer experience.

  • last updated 1 Nov 2025
  • by GoMask
The brief that made it

Analyze cancellation and reinstatement patterns for risk management

Sample rows

preview · 8 of 800 rows · all 23 columns
transaction_idstringtransaction_typestringearned_premiumfloatreinstatement_requestedbooleanpolicy_idstringtransaction_datedatetimeeffective_datedatecancellation_reasonstringreturn_premiumfloatnotice_requiredbooleannotice_sent_datedatereinstatement_conditionsstringreinstatement_approvedbooleanreinstatement_approval_datedatepolicyholder_idstringpolicyholder_namestringpolicyholder_emailstringpolicyholder_phonestringpolicyholder_street_addressstringpolicyholder_citystringpolicyholder_statestringpolicyholder_postal_codestringpolicyholder_countrystring
TXN000001cancellation54218.18falsePOL0000012024-04-03T09:17:342024-04-10Non-payment of premium2200.23true2024-04-04blankblankblankPH001Maria Gonzalezmaria.gonzalez2@example.com+1-315-555-1036461 Pine LaneDallasTX75201USA
TXN000002cancellation12800.35truePOL0000022024-03-28T15:49:212024-04-03Requested by insured800falseblankProof of updated address requiredtrue2024-04-09PH002John C. Millerjohn.miller5@outlook.com+44-20-7946-001522 Abbey RoadLondonLondonNW8 9AYUK
TXN000003reinstatementblanktruePOL0000032024-04-15T10:22:132024-04-16blankblankfalseblankLate fee payment requiredtrue2024-04-16PH003Sophie Chensophie.c.chen@gmail.com+86-21-5555-987688 Nanjing RdShanghaiShanghai200001China
TXN000004cancellation0falsePOL0000042024-02-13T13:14:562024-02-20Fraudulent activity detected0true2024-02-13blankblankblankPH004Brian Patelb.patel@company.com+1-914-555-710231 Maple AveWhite PlainsNY10601USA
TXN000005cancellation98456.02falsePOL0000052024-05-05T11:02:162024-05-10Policyholder deceased25000falseblankblankblankblankPH005Henrietta Leblanchenrietta.leblanc@wanadoo.fr+33-1-555-202715 Rue des LilasParisÎle-de-France75019France
TXN000006cancellation32405.11truePOL0000062024-01-20T14:47:082024-01-27Non-renewal requested by insured350.65true2024-01-21New application and medical examfalseblankPH006David Okaford.okafor@gmail.com+234-803-555-471244 Ajose StLagosLagos101001Nigeria
TXN000007reinstatementblanktruePOL0000072024-02-01T16:08:492024-02-02blankblankfalseblankOutstanding balance clearedtrue2024-02-03PH007Lars Kristensenlars.kristensen@live.dk+45-555-12349 NyhavnCopenhagenCapital Region1051Denmark
TXN000008reinstatementblanktruePOL0000082024-03-19T10:37:222024-03-20blankblankfalseblankPayment of missed premiumfalseblankPH008Priya Desaipriyadesai1984@yahoo.in+91-22-5555-775577 Colaba CausewayMumbaiMaharashtra400005India

What the 800 rows show

from the 800-row sample

Reinstatement (transaction type) stands out: 299 of its 305 rows have reinstatement_requested = true, against 89 of 495 for the rest.

  • 49%reinstatement_requested = true
  • 11,400median earned_premium
  • 61policyholder countries
  • 62cancellation reasons
  • 182policyholder cities
  • 198policyholder states
Reinstatement requested rate by transaction_typereinstatement_requested = true
0%50%100%18%cancellation89 of 49598%reinstatement299 of 305
earned_premium495 rows, in bands of 20k
01853703618431116011080k160kearned_premium →

Median 11,400, from 0.0 to 142,301.

23 columns by typefrom the column list below
  • string 14
  • float 2
  • date 3
  • datetime 1
  • boolean 3

Columns

23 columns in four groups
blueprint · 23 columns
columntypedescriptionexample
Text 14 columns
transaction_idstringUnique identifier for each policy cancellation or reinstatement transactionuniqueTXN000001
policy_idstringUnique identifier for the insurance policyPOL000001
transaction_typestringType of transaction: cancellation or reinstatementcancellation · reinstatementcancellation
cancellation_reasonstringReason for policy cancellation (if applicable)optionalNon-payment of premium
reinstatement_conditionsstringConditions required for reinstatement of the policy (if applicable)optionalMedical exam passed
policyholder_idstringUnique identifier for the policyholderPH001
policyholder_namestringFull name of the policyholderMaria Gonzalez
policyholder_emailstringEmail address of the policyholderoptionaljohn.miller5@outlook.com
policyholder_phonestringPhone number of the policyholderoptional+1-315-555-1036
policyholder_street_addressstringStreet address of the policyholderoptional461 Pine Lane
policyholder_citystringCity of the policyholderoptionalDallas
policyholder_statestringState or province of the policyholderoptionalTX
policyholder_postal_codestringPostal code of the policyholderoptional75201
policyholder_countrystringCountry of the policyholderoptionalUSA
Numbers 2 columns
earned_premiumfloatAmount of premium earned up to the cancellation date0 or more · optional54218.18
return_premiumfloatAmount of premium to be returned to the policyholder after cancellation0 or more · optional2200.23
Dates and times 4 columns
transaction_datedatetimeDate and time when the transaction was processed2024-04-03T09:17:34
effective_datedateEffective date of cancellation or reinstatement2024-04-10
notice_sent_datedateDate when cancellation notice was sent (if applicable)optional2024-04-04
reinstatement_approval_datedateDate when the reinstatement was approved (if applicable)optional2024-04-09
True or false 3 columns
notice_requiredbooleanIndicates if notice was required before cancellationtrue
reinstatement_requestedbooleanIndicates if reinstatement was requested after cancellationfalse
reinstatement_approvedbooleanIndicates if the reinstatement request was approvedoptionaltrue

Use it for

  • reinstatement …49%388 of 800 rowsreinstatement request…18%cancel…98%reinst…

    An insurance dashboard

    The reinstatement_requested rate and earned_premium by transaction_type. Excel, Power BI or Tableau.

  • Why do 388 of 800 rows have reinstatement_requested = true?

    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 transactions with policy_id, transaction_type and transaction_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 23 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 dataset800 rows23 columns
Yours1,000 rows23 columnspolicyholder_street_address: UK only

blueprint · policy-cancellations-and-reinstatements

Behind this dataset

Same schema. As many rows as you need.

These 800 rows came out of a blueprint — 23 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
  • Cancellation type: insured request, non-payment, underwriting
  • Cancellation effective date
  • Notice period required by state (10-30 days typically)
  • Pro-rata refund for insured-initiated cancellation
  • Short-rate penalty for early cancellation by insured
  • Flat cancellation if cancelled before inception
  • Earned premium calculation method
  • Return premium processing
Rows
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
policy-cancellations-and-reinstatements

More in Insurance

Browse all
Also in InsuranceCoinsurance and Deductible Trends by MarketInsurance Policyholder Churn InsightsClaims Fraud Detection DatasetAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.