About this Dataset

Workers' Compensation Insurance Coverage Subscriber Information

The 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) IAIABC Proof of Coverage (POC) Release 2.1 electronic data interchange (EDI) standard. The National Council on Workers’ Compensation Insurance (NCCI) collects the POC data for DWC. POC filings are the source of this data set. Visit the DWC Employer Coverage Page for more information.
Organization: City of Austin
Last updated: 2023-08-25T22:35:12.006454
Tags: coverage, iaiabc-poc, ncci, poc, proof-of-coverage, subscriber, workers-compensation

Tables

Table 1

@usgov.city_of_austin_workers_compensation_insurance_coverage_3c185d9b.table_1

64.18 MB
2,078,082 rows
19 columns

CREATE TABLE table_1 (
  "record_type" VARCHAR,
  "insured_employer_name" VARCHAR  -- Insured / Employer Name,
  "insured_employer_address_1" VARCHAR  -- Insured / Employer Address 1,
  "insured_employer_address_2" VARCHAR  -- Insured / Employer Address 2,
  "insured_employer_city" VARCHAR  -- Insured / Employer City,
  "insured_employer_state" VARCHAR  -- Insured / Employer State,
  "insured_employer_zip" VARCHAR  -- Insured / Employer Zip,
  "insured_employer_zip_extention" VARCHAR  -- Insured / Employer Zip Extention,
  "business_market" BIGINT,
  "peo_employee_leasing_policy_indicator" BIGINT  -- PEO (Employee Leasing) Policy Indicator,
  "ncci_coverage_provider_id" BIGINT,
  "policy_effective_date" TIMESTAMP,
  "policy_expiration_date" TIMESTAMP,
  "cancellation_effective_date" TIMESTAMP,
  "endorsement_reinstatement_effective_date" TIMESTAMP,
  "governing_class_code" DOUBLE,
  "sic_code_naics_code" VARCHAR  -- SIC Code / NAICS Code,
  "state_standard_premium" DOUBLE,
  "coverage_provider_name" VARCHAR
);