Claim Count Development Triangles
This dataset provides a comprehensive view of insurance claim count development triangles, tracking reported and IBNR claim counts by accident year and development period across multiple lines of business. It enables frequency analysis, estimation of incurred but not reported claims, and supports actuarial reserving methodologies for insurance portfolios.
Sample rows
preview · 8 of 600 rows · all 9 columns| accident_yearinteger | line_of_businessstring | ibnr_claim_countinteger | data_sourcestring | development_periodinteger | reported_claim_countinteger | total_estimated_claim_countinteger | triangle_typestring | as_of_datedate |
|---|---|---|---|---|---|---|---|---|
| 2023 | property | 900 | PropertySys_North | 12 | 1750 | 2650 | total | 2024-06-30 |
| 2024 | property | 830 | PropertySys_South | 0 | 10 | 840 | total | 2024-06-30 |
| 2022 | property | 315 | PropertySys_Central | 24 | 1200 | 1515 | total | 2024-06-30 |
| 2000 | auto | 0 | ClaimsSys_Archive | 288 | 27 | 27 | reported | 2024-06-30 |
| 1975 | auto | 0 | ClaimsSys_Historical | 588 | 3 | 3 | reported | 2024-06-30 |
| 2020 | workers_comp | 62 | CompStream_A2 | 48 | 8750 | 8812 | total | 2024-06-30 |
| 2021 | workers_comp | 88 | CompStream_Archive | 36 | 4100 | 4188 | total | 2024-06-30 |
| 2010 | auto | 0 | ClaimsSys_Archive | 168 | 14 | 14 | reported | 2024-06-30 |
| 1999 | auto | 0 | ClaimsSys_Historical | 300 | 9 | 9 | reported | 2024-06-30 |
| 2022 | liability | 14 | LiabilityCore_Main | 24 | 0 | 14 | ibnr | 2024-06-30 |
| 2015 | marine | 0 | MarineClaims_DockEast | 108 | 42 | 42 | reported | 2024-06-30 |
| 2014 | marine | 0 | MarineClaims_South | 120 | 38 | 38 | reported | 2024-06-30 |
| 2018 | marine | 8 | MarineClaims_DockEast | 72 | 117 | 125 | total | 2024-06-30 |
| 2016 | marine | 3 | MarineClaims_South | 96 | 78 | 81 | total | 2024-06-30 |
| 2011 | auto | 0 | ClaimsSys_Historical | 156 | 2 | 2 | reported | 2024-06-30 |
| 2020 | liability | 19 | LiabilityCore_South | 48 | 0 | 19 | ibnr | 2024-06-30 |
| 2023 | liability | 17 | LiabilityCore_Main | 12 | 0 | 17 | ibnr | 2024-06-30 |
| 2024 | liability | 6 | LiabilityCore_Archive | 0 | 0 | 6 | ibnr | 2024-06-30 |
| 2019 | marine | 0 | MarineClaims_DockEast | 60 | 65 | 65 | reported | 2024-06-30 |
| 2017 | marine | 2 | MarineClaims_South | 84 | 95 | 97 | total | 2024-06-30 |
What the 600 rows show
from the 600-row sampleProperty (line of business) stands out: mean ibnr_
- 6median ibnr_
claim_ count - 3triangle types
- 72median development_
period - 21median reported_
claim_ count - 22median total_
estimated_ claim_ count
Median 6, from 0 to 1,185.
- string 3
- integer 5
- date 1
Columns
9 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 3 columns | |||
line_of_business | string | Insurance line of business (e.g., auto, property, liability) associated with the claims.up to 100 · 5 businesses · optional | property |
triangle_type | string | Type of triangle (e.g., reported, IBNR, total) represented by the row.reported · ibnr · total · optional | total |
data_source | string | Source system or dataset from which the claim count data was extracted.up to 100 · optional | PropertySys_North |
| Numbers 5 columns | |||
accident_year | integer | Calendar year in which the claims occurred (accident year).1,900 to 2,100 | 2023 |
development_period | integer | Number of months or years since the accident year, representing the claim development period (e.g., 0, 12, 24, etc.).0 or more | 12 |
reported_claim_count | integer | Number of claims reported as of the end of the development period for the given accident year.0 or more | 1750 |
ibnr_claim_count | integer | Number of claims estimated to be incurred but not reported (IBNR) for the accident year and development period.0 or more · optional | 900 |
total_estimated_claim_count | integer | Total estimated claim count for the accident year and development period (reported + IBNR).0 or more · optional | 2650 |
| Dates and times 1 column | |||
as_of_date | date | Date as of which the claim count data is current. | 2024-06-30 |
Use it for
An insurance dashboard
Ibnr_
claim_ count by line_ of_ business and a breakdown of data_ source. Excel, Power BI or Tableau. Why do the 99 property rows have a mean ibnr_
claim_ count of 488.7? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Rows6002023900property2024830property2022315property
A software demo
Believable rows with development_
period, reported_ claim_ count and ibnr_ claim_ count to fill a screen in front of a buyer.
blueprint · claim-count-development-triangles
Behind this dataset
Same schema. As many rows as you need.
These 600 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.
- Count of reported claims (not closed claims)
- Accident year and development period structure
- Ultimate claim count projection
- IBNR claim count = Ultimate count - Reported count
- Frequency trends separate from severity
- Average claim severity = Incurred losses / Claim count
- Frequency-severity method for ultimate losses
- Late reporting patterns for tail lines
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
- claim-count-development-triangles