Closed Claim Development Triangles
This dataset provides a detailed view of closed insurance claims over time, segmented by accident year and development period. It includes claim counts, settlement amounts, closure rates, and supporting metrics, enabling robust analysis of closure patterns, average settlements, and operational efficiency for insurers and actuaries.
Sample rows
preview · 8 of 601 rows · all 9 columns| accident_yearinteger | closure_ratefloat | data_sourcestring | development_period_monthsinteger | closed_claim_countinteger | total_settlement_amountfloat | average_settlement_amountfloat | total_reported_claimsinteger | last_updateddatetime |
|---|---|---|---|---|---|---|---|---|
| 1993 | 0.15 | HistoricalArchive | 132 | 3 | 2745.5 | 915.17 | 20 | 2023-11-09T15:32:18Z |
| 1997 | 0 | LegacyDB | 204 | 0 | 0 | blank | 11 | 2024-01-25T10:42:11Z |
| 1908 | blank | MicrofilmConversion | 192 | 2 | 1390 | 695 | blank | 2024-04-02T17:51:05Z |
| 1986 | 0.05 | ManualEntry | 180 | 1 | 1075 | 1075 | 20 | 2023-12-10T22:11:09Z |
| 1998 | 0.32 | HistoricalArchive | 144 | 8 | 8542.5 | 1067.81 | 25 | 2024-01-12T19:14:28Z |
| 2002 | 0.31 | PolicyAdminSystemA | 60 | 77 | 129850 | 1686.36 | 250 | 2024-03-14T08:44:23Z |
| 2006 | 0.34 | BrokerPortal | 24 | 118 | 334590 | 2837.2 | 350 | 2024-05-05T15:19:27Z |
| 2001 | blank | PolicyAdminSystemB | 12 | 41 | 109730 | 2676.1 | blank | 2024-04-22T21:10:18Z |
| 2008 | 0.52 | DataMart | 36 | 92 | 237600 | 2582.61 | 176 | 2024-01-08T12:34:56Z |
| 2012 | 0.81 | BrokerPortal | 54 | 181 | 579300 | 3200.55 | 224 | 2024-04-17T11:59:42Z |
| 2010 | 0.55 | ExternalProviderA | 24 | 110 | 282990 | 2572.64 | 200 | 2024-02-13T10:10:10Z |
| 2013 | 0.67 | ExternalProviderB | 30 | 149 | 418210 | 2806.11 | 222 | 2024-04-14T14:28:31Z |
| 2016 | 0.4 | PolicyAdminSystemA | 18 | 79 | 221210 | 2801.39 | 198 | 2024-03-03T16:09:54Z |
| 2017 | 0.44 | DataMart | 12 | 60 | 164500 | 2741.67 | 135 | 2024-02-26T09:20:01Z |
| 2019 | 0.18 | MobileAppIntake | 6 | 23 | 63000 | 2739.13 | 129 | 2024-04-23T17:45:22Z |
| 2021 | 0 | TelematicsIntegration | 0 | 0 | 0 | blank | 75 | 2024-04-28T12:00:00Z |
| 2023 | 0.025 | MobileAppIntake | 1 | 2 | 900 | 450 | 80 | 2024-04-29T15:03:17Z |
| 2024 | blank | TelematicsIntegration | 0 | 0 | 0 | blank | 20 | 2024-04-30T11:41:52Z |
| 2020 | 0.1 | MobileAppIntake | 3 | 10 | 2950 | 295 | 100 | 2024-04-27T18:19:10Z |
| 2018 | 0.09 | TelematicsIntegration | 5 | 11 | 4500 | 409.09 | 120 | 2024-04-23T23:04:05Z |
What the 601 rows show
from the 601-row sample- 0.74median closure_
rate - 52median development_
period_ months - 81median closed_
claim_ count - 215,000median total_
settlement_ amount - 2,962median average_
settlement_ amount - 133.5median total_
reported_ claims
Median 0.74, from 0.0 to 1.0.
- string 1
- integer 4
- float 3
- datetime 1
Columns
9 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 1 column | |||
data_source | string | Origin or system from which the claim data was extracted (e.g., internal system name, external provider).up to 100 · optional | HistoricalArchive |
| Numbers 7 columns | |||
accident_year | integer | The calendar year in which the insurance claims' underlying accidents occurred.1,900 to 2,100 | 1993 |
development_period_months | integer | Number of months since the accident year, representing the development period for claim closure analysis.0 to 240 | 132 |
closed_claim_count | integer | Number of claims closed during the specified accident year and development period.0 or more | 3 |
total_settlement_amount | float | Aggregate settlement amount paid for all claims closed in the specified accident year and development period.0 or more | 2745.5 |
average_settlement_amount | float | Average settlement amount per closed claim for the specified accident year and development period.0 or more · optional | 915.17 |
closure_rate | float | Proportion of claims closed relative to total reported claims for the accident year at the given development period (0 to 1).0 to 1 · optional | 0.15 |
total_reported_claims | integer | Total number of claims reported for the accident year (used to calculate closure rate).0 or more · optional | 20 |
| Dates and times 1 column | |||
last_updated | datetime | Timestamp when this record was last updated or refreshed.optional | 2023-11-09T15:32:18Z |
Use it for
An insurance dashboard
Closure_
rate and a breakdown of data_ source. Excel, Power BI or Tableau. What pattern can you find in 601 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 601 rows.
- Rows60119930.15199701908
A software demo
Believable rows with development_
period_ months, closed_ claim_ count and total_ settlement_ amount to fill a screen in front of a buyer.
blueprint · closed-claim-development-triangles
Behind this dataset
Same schema. As many rows as you need.
These 601 rows came out of a blueprint — 9 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.
- Closed claim definition: final payment made, no reserves
- Closure rate = Closed claims / Reported claims
- Development of closures over time
- Average closed claim value for benchmarking
- Closure velocity indicates operational efficiency
- Reopened claims affect closure statistics
- Zero-pay closures tracked separately
- Legal vs non-legal closure timelines
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
- closed-claim-development-triangles