About this Dataset

Washington State Insurers Dental Loss Ratios

This dataset serves as a dental insurance summary database. The dataset provides annual loss ratios for insurers that operate in Washington state. Loss ratios track payments to premiums and are an indicator of fiscal health. This data is cumulative at the company level as reported to the National Association of Insurance Commissioners (NAIC).
Organization: State of Washington
Last updated: 2020-11-10T17:20:40.114658
Tags: annual-report, dental, dentist, health, insurance, life, members, payments, premiums, property

Tables

Table 1

@usgov.state_of_washington_2016_2019_dental_loss_ratios.table_1

52.13 kB
874 rows
13 columns

CREATE TABLE table_1 (
  "company_name" VARCHAR,
  "naic_code" BIGINT,
  "domicile_state" VARCHAR,
  "business_type" VARCHAR,
  "year" BIGINT,
  "dental_premiums" DOUBLE,
  "dental_payments" DOUBLE,
  "dental_members" BIGINT,
  "dental_member_months" BIGINT,
  "dental_loss_ratio" BIGINT,
  "average_amount_of_premiums_per_member_per_month" DOUBLE,
  "previous_year_average_amount_of_premiums_per_member_per_month" DOUBLE,
  "percentage_change_in_average_premium_per_member_per_mo_424ca35d" DOUBLE  -- Percentage Change In Average Premium Per Member Per Month From Previous Year
);