About this Dataset

Workers' Compensation Insurance Data

Oregon workers' compensation data about insurers and self-insured employers. The data is presented in the Department of Consumer and Business Services report at https://www.oregon.gov/dcbs/reports/compensation/Pages/index.aspx. The attached pdf provides definitions of the data.
Organization: State of Oregon
Last updated: 2020-11-10T17:22:23.416697
Tags: assigned-risk-pool, premiums, saif, workers-compensation-insurance

Tables

Table 1

@usgov.state_of_oregon_workers_compensation_insurance_data.table_1

38.25 kB
58 rows
36 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "saif_dpw" DOUBLE,
  "private_dpw" DOUBLE,
  "private_ldpc" DOUBLE,
  "self_insured_premiums" DOUBLE,
  "total_system_written_premiums" DOUBLE,
  "saif_market_share" DOUBLE,
  "private_market_share" DOUBLE,
  "self_insured_market_share" DOUBLE,
  "saif_lcm" DOUBLE,
  "private_lcm" DOUBLE,
  "private_saif_lcm" DOUBLE  -- Private & SAIF LCM,
  "saif_dpe" DOUBLE,
  "private_dpe" DOUBLE,
  "private_saif_dpe" DOUBLE  -- Private & SAIF DPE,
  "saif_dividends" DOUBLE,
  "private_dividends" DOUBLE,
  "private_saif_dividends" DOUBLE  -- Private & SAIF Dividends,
  "saif_dlp" DOUBLE,
  "private_dlp" DOUBLE,
  "private_saif_dlp" DOUBLE  -- Private & SAIF DLP,
  "saif_dli" DOUBLE,
  "private_dli" DOUBLE,
  "private_saif_dli" DOUBLE  -- Private & SAIF DLI,
  "saif_dlu" DOUBLE,
  "private_dlu" DOUBLE,
  "private_saif_dlu" DOUBLE  -- Private & SAIF DLU,
  "saif_loss_ratio" DOUBLE,
  "private_loss_ratio" DOUBLE,
  "private_saif_loss_ratio" DOUBLE  -- Private & SAIF Loss Ratio,
  "arp_total_net_premiums" DOUBLE,
  "arp_number_of_employers" DOUBLE,
  "self_insurer_covered_payroll" DOUBLE,
  "self_insurer_net_premiums" DOUBLE,
  "self_insurer_net_premium_rates" DOUBLE,
  "pure_premium_rate_changes" DOUBLE
);