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) <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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"texas-gov/workers-compensation-insurance-coverage-subscriber-c4xz-httr\".\"workers_compensation_insurance_coverage_subscriber\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.