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).
This dataset has the following 13 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Company Name | company_name | text | Name of enrolled company | Regence BlueShield of Idaho, Inc. PHYSICIANS MUTUAL INSURANCE COMPANY Regence BlueShield Premera Blue Cross PRINCIPAL LIFE INSURANCE COMPANY view top 100 |
| NAIC Code | cocode | text | Five-digit number assigned by the NAIC that uniquely identifies an insurance company | 98205 64513 65080 65129 65676 view top 100 |
| Domicile State | domicile | text | State abbreviation of the company’s legal residence | TX WA NE NY IL view top 100 |
| Business Type | business_type | text | Line of business under which an insurance company is licensed by its State of Domicile. L=Life P=Property/Casualty X=Health | L X P view top 100 |
| Year | year | text | Plan Year represented by the row | 2017 2015 2018 2019 2016 view top 100 |
| Dental Premiums | a_dental_premiums | number | Premiums earned for the year from Dental policies that provide only dental treatment benefits. In U.S. Dollars, rounded to the nearest dollar | 124119 17931432 73 688 958 view top 100 |
| Dental Payments | b_dental_payments | number | Direct costs incurred providing dental treatment benefits excluding administrative costs. In U.S. Dollars, rounded to the nearest dollar | 0 49025 10281038 51738 -8000 view top 100 |
| Dental Members | c_dental_members | number | The total number of lives insured, including dependents, under individual policies and group certificates as of December 31 of the reporting year | 0 399 6888 56 43 view top 100 |
| Dental Member Months | d_dental_member_months | number | The sum of total number of lives insured on a pre-specified day of each month of the reported year | 0 93998 4986 34503 13971 view top 100 |
| Dental Loss Ratio | e_dental_loss_ratio_b_a | number | The loss ratio is Dental Payments divided by Dental Premiums | 66.00 72.00 64.00 65.00 62.00 view top 100 |
| Average Amount of Premiums per Member per Month | f_average_amount_of_premums_per_member_per_month_a_d | number | This figure is Dental Premiums divided by Dental Member Months | 32.00 30.25 29.49 33.37 30.33 view top 100 |
| Previous Year Average Amount of Premiums per Member per Month | g_previous_yearaverage_amount_of_premums_per_member_per_month | number | This figure is Dental Premiums divided by Dental Member Months for the previous year | 0.00 32.00 30.33 33.37 30.25 view top 100 |
| Percentage Change in Average Premium per Member per Month from Previous Year | h_percentage_change_in_average_premum_per_member_per_month_from_previous_year_f_g_g | number | This figure is the percentage change in Average Premium per Member per Month from the previous year | 0.00 0.01 0.02 -0.02 0.03 view top 100 |