Workers' compensation insurance coverage subscriber information
data.texas.gov | Last Updated 7 Nov 2022The Texas Department of Insurance, Division of Workers’ Compensation (DWC) publishes a quarterly report of employers with active Texas workers’ compensation insurance coverage. Employers with coverage are called “subscribers.” Texas does not require most private employers to have workers' compensation insurance coverage. Insurance carriers report coverage data to DWC using the International Association of Industrial Accident Boards and Commissions’ (IAIABC) <a href="https://www.iaiabc.org/" target="_blank"><u>IAIABC Proof of Coverage (POC) Release 2.1</u></a> electronic data interchange (EDI) standard. The <a href="https://www.ncci.com/pages/default.aspx" target="_blank"><u>National Council on Workers’ Compensation Insurance (NCCI)</u></a> collects the POC data for DWC. POC filings are the source of this data set. Visit the <a href="https://www.tdi.texas.gov/wc/employer/coverage.html#subscribers" target="_blank"><u>DWC Employer Coverage Page</u></a> for more information.
This dataset has the following 19 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Record Type | record_type | text | I = Insured; E = Employer; | E I view top 100 |
| Insured / Employer Name | insured_employer_name | text | THE JONES FINANCIAL CO L. LLP CVS PHARMACY INC LABORATORY CORP OF AMERICA HOLDINGS HELPSIDE LLC WALGREEN CO view top 100 | |
| Insured / Employer Address 1 | insured_employer_address | text | 19001 CRESCENT SPRINGS D NOT AVAILABLE NO BUSINESS LOCATION 1 PARK PL NO SPECIFIC LOCATION view top 100 | |
| Insured / Employer Address 2 | insured_employer_address_1 | text | STE 100 STE 200 STE 300 STE A STE B view top 100 | |
| Insured / Employer City | insured_employer_city | text | HOUSTON AUSTIN DALLAS SAN ANTONIO FORT WORTH view top 100 | |
| Insured / Employer State | insured_employer_state | text | TX CA FL NY IL view top 100 | |
| Insured / Employer Zip | insured_employer_zip | text | 77339 78704 78701 75201 77002 view top 100 | |
| Insured / Employer Zip Extention | insured_employer_zip_extention | text | 3802 0000 0001 7983 1903 view top 100 | |
| Business Market | business_market | number | 1 = Voluntary or 2 = Assigned Risk or 1 & 2 = Both Business Markets | 1 2 view top 100 |
| PEO (Employee Leasing) Policy Indicator | peo_employee_leasing_policy | number | 1 = Non PEO; 2 = Employee Leasing Co and Client Companies; 3 = Employee Leasing Co Only; 4 = Client Co Only; 5 = Leased Workers of Client Co; 6 = Non-Leased Workers of Client Co; 7 = Leased and Non-Leased Workers of Client Co; 8 = Employee Leasing Policy for Leased Workers of Multiple Client Companies; Excludes Employee Leasing Co Non-Leased Workers; | 1 2 5 6 7 view top 100 |
| NCCI Coverage Provider ID | ncci_coverage_provider_id | text | 29939 14397 25437 13579 21075 view top 100 | |
| Policy Effective Date | policy_effective_date | calendar_date | 2024-01-01T00:00:00.000 2023-01-01T00:00:00.000 2023-07-01T00:00:00.000 2023-10-01T00:00:00.000 2022-10-01T00:00:00.000 view top 100 | |
| Policy Expiration Date | policy_expiration_date | calendar_date | 2025-01-01T00:00:00.000 2024-01-01T00:00:00.000 2023-10-01T00:00:00.000 2024-07-01T00:00:00.000 2024-10-01T00:00:00.000 view top 100 | |
| Cancellation Effective Date | cancellation_effective_date | calendar_date | This field will be included for policies that are Cancelled or Non Renewed. Latest CRN Trans ID is 01 (Cancellation) or 03 (Non Renewal) | 2024-01-01T00:00:00.000 2023-01-01T00:00:00.000 2022-07-01T00:00:00.000 2022-10-01T00:00:00.000 2023-07-01T00:00:00.000 view top 100 |
| Endorsement/Reinstatement Effective Date | endorsement_reinstatement | calendar_date | This field will be included for policies that are Reinstated. Latest CRN Trans ID is 02 (Reinstatement) | 2024-04-08T00:00:00.000 2022-12-26T00:00:00.000 2023-03-13T00:00:00.000 2024-01-21T00:00:00.000 2023-03-21T00:00:00.000 view top 100 |
| Governing Class Code | governing_class_code | text | 8810 8832 9079 8742 9015 view top 100 | |
| SIC Code / NAICS Code | sic_code_naics_code | text | 541511 621111 722513 722511 213112 view top 100 | |
| State Standard Premium | state_standard_premium | number | 0 250 150 30154 200 view top 100 | |
| Coverage Provider Name | coverage_provider_name | text | TEXAS MUTUAL INSURANCE CO HARTFORD CASUALTY INS CO INDEMNITY INS CO OF N AMERICA TRAVELERS PROPERTY CASUALTY CO SERVICE LLOYDS INSURANCE CO, A view top 100 |