Insurance tables for WC System Report
This dataset has the following 36 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Year | year | calendar_date | Calendar year | 2010-01-01T00:00:00.000 2011-01-01T00:00:00.000 2012-01-01T00:00:00.000 2013-01-01T00:00:00.000 2014-01-01T00:00:00.000 view top 100 |
| SAIF DPW | saif_dpw | number | Direct Premiums Written (DPW) for SAIF in the calendar year | 521964312 399848517 538913585 436159631 498522071 view top 100 |
| Private DPW | private_dpw | number | Direct Premiums Written (DPW) for private insurers in the calendar year | 187662477 206315346 213162765 209222427 212013922 view top 100 |
| Private LDPC | total_private_ldpc | number | Large Deductible Premium Credits (LDPC) are credits on workers' compensation premium. Participating employers repay insurers their claim costs up to the deductible amounts | 97019581 63575062 79546975 107022675 102191571 view top 100 |
| Self-Insured Premiums | self_insured_premiums | number | Self-insured employer simulated premium that is calculated for each self-insured employer to set its workers' compensation premium assessment | 127559562 137233260 117157175 134259054 138198994 view top 100 |
| Total System Written Premiums | total_system_dpw | number | The combined total of SAIF DPW, Private DPW, LDPCs, and self-insured simulated premiums. | 907574728 930443280 847177582 729087427 998608626.35 view top 100 |
| SAIF Market Share | saif_market_share | number | SAIF percentage share of Total System Written Premiums. | 44.900 54.700 53.700 54.00 53.600 view top 100 |
| Private Market Share | private_market_share | number | Combined private DPW and LDPC percentage share of Total System Written Premiums. | 32.200 33.300 30.900 35.900 34.800 view top 100 |
| Self-Insured Market Share | self_insured_market_share | number | Self-insured percentage share of Total System Written Premiums. | 13.100 12.500 15.700 16.200 13.800 view top 100 |
| SAIF LCM | saif_lcm | number | Loss Cost Multiplier (LCM) for SAIF used to cover operating expenses, taxes, profit, and contingencies. | 1.379 1.265 1.387 1.213 1.451 view top 100 |
| Private LCM | private_lcm | number | Average Loss Cost Multiplier (LCM) for private insurers used to cover operating expenses, taxes, profit, and contingencies. | 1.381 1.377 1.402 1.363 1.452 view top 100 |
| Private & SAIF LCM | private_saif_lcm | number | Combined Loss Cost Multiplier (LCM) for SAIF and private insurers | 1.255 1.29638273145089 1.451 1.34096925950574 1.314 view top 100 |
| SAIF DPE | saif_dpe | number | SAIF Direct Earned Premium (DPE) during the calendar year. | 500011644 388327852 331673858 529899645 464891852 view top 100 |
| Private DPE | private_dpe | number | Private insurer Direct Earned Premium (DPE) during the calendar year. | 210282758 206584565 180200865 204301822 219314885 view top 100 |
| Private & SAIF DPE | private_saif | number | SAIF and private insurer Direct Earned Premium (DPE) during the calendar year. | 736484210 550988743 671725902 618467068 699671675 view top 100 |
| SAIF Dividends | saif_div | number | SAIF dividends paid to policyholders during the calendar year. | 74995368 159938850 99993093 164949513 149935045 view top 100 |
| Private Dividends | private_div | number | Private insurer dividends paid to policyholders during the calendar year. | 611980 1421905 1198070 646891 1068037 view top 100 |
| Private & SAIF Dividends | private_saif_div | number | SAIF and private insurer dividends paid to policyholders during the calendar year. | 78338235 150547025 161515964 129693172 165596404 view top 100 |
| SAIF DLP | saif_dlp | number | SAIF Direct Losses Paid (DLP) on claims during the calendar year. | 330590219 304525356 264263330 264907289 306166674 view top 100 |
| Private DLP | private_dlp | number | Private Direct Losses Paid (DLP) on claims during the calendar year. | 117740882 173418192 112630472 157265925 177662436 view top 100 |
| Private & SAIF DLP | private_saif_dlp | number | SAIF and private insurer Direct Losses Paid (DLP) on claims during the calendar year. | 455916285 408894195 432998065 433316466 419654010 view top 100 |
| SAIF DLI | saif_dli | number | SAIF Direct Losses Incurred (DLI) on claims during the calendar year. This includes estimated "Incurred But Not Reported" losses (IBNR) on those same claims. | 157544882 204847529 256702629 257901166 133557324 view top 100 |
| Private DLI | private_dli | number | SAIF Direct Losses Incurred (DLI) on claims during the calendar year. This includes estimated "Incurred But Not Reported" losses (IBNR) on those same claims. | 108111563 106935194 149885387 88250169 141227831 view top 100 |
| Private & SAIF DLI | private_saif_dli | number | SAIF and private insurer Direct Losses Incurred (DLI) on claims during the calendar year. This includes estimated "Incurred But Not Reported" (IBNR) costs on those same claims. | 343555754 364184133 346151335 566474626 393503597 view top 100 |
| SAIF DLU | saif_dlu | number | SAIF Direct Losses Unpaid (DLU) during the calendar year. This is the sum of Direct Losses Incurred minus the sum of Direct Losses Paid. | 2773743347 2743326471 2095411762 2392490776 2110629357 view top 100 |
| Private DLU | private_dlu | number | Private insurers Direct Losses Unpaid (DLU) during the calendar year. This is the sum of Direct Losses Incurred minus the sum of Direct Losses Paid. | 1057162701 1186161909 980582869 1160632127 990723374 view top 100 |
| Private & SAIF DLU | private_saif_dlu | number | SAIF and private insurers Direct Losses Unpaid (DLU) during the calendar year. This is the sum of Direct Losses Incurred minus the sum of Direct Losses Paid. | 3779202061 3068557579 3576295494 3014550769 3959905256 view top 100 |
| SAIF Loss Ratio | saif_loss_ratio | number | SAIF's ratio of the direct losses incurred to the direct premiums earned, multiplied by 100. | 98.6 26.795122710057 55 60.9415070231282 32.1772872657499 view top 100 |
| Private Loss Ratio | private_loss_ratio | number | Private insurers' ratio of the direct losses incurred to the direct premiums earned, multiplied by 100. | 51.2 50.1906586843611 67.6827066714918 66.9191772325929 50.9 view top 100 |
| Private & SAIF Loss Ratio | private_saif_loss_ratio | number | SAIF and private insurers' ratio of the direct losses incurred to the direct premiums earned, multiplied by 100. | 45.1841221113162 51.1452294718866 60.4 57.8829538880273 43.1 view top 100 |
| ARP Total Net Premiums | arp_total_net_premium | number | The total written premium for employers in the Assigned Risk Pool. | 44593035 44679892 43119281 31392893 46043116 view top 100 |
| ARP Number of Employers | arp_number_of_employers | number | The number of employers in the Assigned Risk Pool. | 6698 9383 6158 8567 9402 view top 100 |
| Self-Insurer Covered Payroll | self_insurer_covered_payroll | number | The total payroll for the year of all self-insured employers and members of self-insured employer groups. | 13853690875 17153432489.96 16754634660.14 15253836081 19198094979.79 view top 100 |
| Self-Insurer Net Premiums | self_insurer_net_premium | number | The premiums paid by self-insured employers and members of self-insured employer groups. | 137299074.39 122533307.73 137233260 117157175 134259054 view top 100 |
| Self-Insurer Net Premium Rates | average_self_insurer_net_premium_rates_per_100_of_payroll | number | Net premium divided by covered payroll, per $100 of payroll. | 0.9 0.71 0.816369829130385 0.95 0.94 view top 100 |
| Pure Premium Rate Changes | pure_premium_rate_changes | number | Percentage change in pure premium rates recommended by NCCI and approved by DCBS. | -5.3 1.9 -5.8 -1.3 -1.8 view top 100 |