Policy Term Length and Renewal Timing
This dataset provides detailed information on insurance policy terms, renewal schedules, and expiration patterns, mapped by month and quarter. It enables precise cash flow forecasting, resource allocation, and renewal cycle management by offering granular insights into premium values, policy durations, and customer associations.
Sample rows
preview · 8 of 500 rows · all 12 columns| policy_idstring | policy_typestring | term_length_monthsinteger | currencystring | policy_start_datedate | policy_expiration_datedate | renewal_datedate | renewal_statusstring | expiration_monthinteger | expiration_quarterinteger | premium_amountfloat | customer_idstring |
|---|---|---|---|---|---|---|---|---|---|---|---|
| P-000001 | auto | 12 | USD | 2018-04-24 | 2019-04-24 | 2019-04-25 | renewed | 4 | 2 | 1350.5 | C-10001 |
| P-000002 | home | 240 | EUR | 1998-07-02 | 2018-07-02 | blank | expired | 7 | 3 | 145000 | C-10002 |
| P-000003 | travel | 2 | USD | 2022-10-15 | 2022-12-15 | blank | cancelled | 12 | 4 | 42.3 | C-10003 |
| P-000004 | life | 180 | JPY | 2010-01-01 | 2025-01-01 | blank | pending | 1 | 1 | 98000.75 | C-10004 |
| P-000005 | pet | 18 | GBP | 2017-03-13 | 2018-09-13 | 2018-09-14 | renewed | 9 | 3 | 600 | C-10005 |
| P-000006 | auto | 24 | USD | 2016-11-06 | 2018-11-06 | 2018-11-07 | renewed | 11 | 4 | 1750.1 | C-10006 |
| P-000007 | health | 3 | CAD | 2021-06-01 | 2021-09-01 | blank | cancelled | 9 | 3 | 89.99 | C-10007 |
| P-000008 | renter | 36 | USD | 2015-05-10 | 2018-05-10 | blank | expired | 5 | 2 | 1350 | C-10008 |
| P-000009 | home | 360 | USD | 1994-12-31 | 2024-12-31 | blank | pending | 12 | 4 | 215000 | C-10009 |
| P-000010 | auto | 3 | CAD | 2023-01-05 | 2023-04-05 | blank | expired | 4 | 2 | 95 | C-10010 |
| P-000011 | pet | 24 | GBP | 2019-08-20 | 2021-08-20 | 2021-08-21 | renewed | 8 | 3 | 850 | C-10011 |
| P-000012 | renter | 48 | AUD | 2012-10-11 | 2016-10-11 | blank | expired | 10 | 4 | 1900 | C-10012 |
| P-000013 | health | 1 | USD | 2024-01-03 | 2024-02-03 | blank | cancelled | 2 | 1 | 23.15 | C-10013 |
| P-000014 | life | 240 | EUR | 2004-09-09 | 2024-09-09 | blank | expired | 9 | 3 | 109000 | C-10014 |
| P-000015 | travel | 1 | USD | 2020-07-15 | 2020-08-15 | blank | expired | 8 | 3 | 21.75 | C-10015 |
| P-000016 | auto | 12 | USD | 2011-02-01 | 2012-02-01 | 2012-02-02 | renewed | 2 | 1 | 1200.9 | C-10016 |
| P-000017 | home | 120 | JPY | 2013-06-12 | 2023-06-12 | blank | expired | 6 | 2 | 90000 | C-10017 |
| P-000018 | pet | 36 | USD | 2020-03-27 | 2023-03-27 | 2023-03-28 | renewed | 3 | 1 | 1200 | C-10018 |
| P-000019 | auto | 6 | USD | 2022-09-16 | 2023-03-16 | blank | pending | 3 | 1 | 590.7 | C-10019 |
| P-000020 | life | 360 | USD | 1997-10-10 | 2027-10-10 | blank | pending | 10 | 4 | 250000 | C-10020 |
What the 500 rows show
from the 500-row sampleLife (policy type) stands out: mean term_
- 24median term_
length_ months - 4renewal statuses
- 6median expiration_
month - 2median expiration_
quarter - 1,350median premium_
amount
Median 24, from 1 to 360.
- string 5
- integer 3
- float 1
- date 3
Columns
12 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 5 columns | |||
policy_id | string | Unique identifier for each insurance policyunique | P-000001 |
policy_type | string | Type or category of the insurance policy (e.g., auto, home, life)7 types | auto |
renewal_status | string | Indicates if the policy is renewed, pending, expired, or cancelledrenewed · pending · expired · cancelled | renewed |
currency | string | Currency code for the premium amount (e.g., USD, EUR)6 currencies | USD |
customer_id | string | Unique identifier for the customer holding the policy | C-10001 |
| Numbers 4 columns | |||
term_length_months | integer | Length of the policy term in months1 or more | 12 |
expiration_month | integer | Numeric month (1-12) in which the policy expires1 to 12 | 4 |
expiration_quarter | integer | Quarter (1-4) in which the policy expires1 to 4 | 2 |
premium_amount | float | Total premium amount for the policy term0 or more | 1350.5 |
| Dates and times 3 columns | |||
policy_start_date | date | Date when the policy term begins | 2018-04-24 |
policy_expiration_date | date | Date when the policy term expires | 2019-04-24 |
renewal_date | date | Scheduled date for policy renewaloptional | 2019-04-25 |
Use it for
An insurance dashboard
Term_
length_ months by policy_ type and a breakdown of currency. Excel, Power BI or Tableau. Why do the 68 life rows have a mean term_
length_ months of 236.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Policies500P-00000112autoP-000002240homeP-0000032travel
A software demo
Believable policies with policy_
type, term_ length_ months and policy_ start_ date to fill a screen in front of a buyer.
blueprint · policy-term-length-and-renewal-timing
Behind this dataset
Same schema. As many rows as you need.
These 500 rows came out of a blueprint — 12 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.
- Policy term: 6-month, 12-month, 24-month, 36-month
- Effective date distribution by month
- Expiration date distribution
- Renewal concentration by quarter
- January 1 renewals for commercial
- Seasonality of new business
- Cash flow timing
- Underwriting workload planning
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
- policy-term-length-and-renewal-timing