Texas Workers' Comp Non-Subscriber & X-Date Lead Monitor avatar

Texas Workers' Comp Non-Subscriber & X-Date Lead Monitor

Pricing

from $14.00 / 1,000 employer coverage & x-date leads

Go to Apify Store
Texas Workers' Comp Non-Subscriber & X-Date Lead Monitor

Texas Workers' Comp Non-Subscriber & X-Date Lead Monitor

Extract Texas Workers' Compensation Non-Subscriber employers (TDI DWC Form-005) with Parent + Multi-Location rollup grouping, upcoming Insurance X-Date expiration filters, recent-filing alerts, city/ZIP targeting, and stateful deduplication for commercial P&C, OccAcc, and ERISA brokers.

Pricing

from $14.00 / 1,000 employer coverage & x-date leads

Rating

0.0

(0)

Developer

Travis Burrows

Travis Burrows

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

2 days ago

Last modified

Features

Limited permissions

Share

Texas Workers' Comp Non-Subscriber & Insurance X-Date Lead Monitor (TDI DWC Form-005)

Extract and enrich Texas Workers' Compensation Non-Subscriber employers directly from official Texas Department of Insurance (TDI) Division of Workers' Compensation (DWC) Form-005 filings (data.texas.gov Socrata API)—purpose-built for commercial P&C insurance brokers, Occupational Accident (OccAcc) & ERISA non-subscriber benefit wholesalers, TPAs, PEOs, and RevOps/Clay outbound teams.

Unlike raw state CSV exports that scatter multi-store corporations across thousands of disconnected rows, this Actor performs Parent + Multi-Location Rollup Grouping: every branch Location record, Texas operating city, 5-digit ZIP code, and subsidiary DBA name is aggregated onto a single clean Parent employer lead alongside Insurance X-Date countdowns (daysUntilExpiration, xDateStatus).

Zero headless browsers. Zero proxy overhead. Native SEEN_FILINGS deduplication for daily/weekly cron pipelines and MCP AI agents.


Why Texas Non-Subscriber & X-Date Intelligence?

Texas is the only US state where private-sector employers can legally opt out of standard statutory Workers' Compensation coverage ("non-subscribers"). Under Texas Labor Code §406.005, every non-subscribing employer must file DWC Form-005 reporting their non-coverage period (start_date to end_date) and covered Texas operating locations.

Commercial Buyer PersonaAutomated Revenue Workflow
Commercial P&C & Workers' Comp BrokersPull multi-location employers (minLocations: 2) whose coverageEndDate (X-Date) expires in 60–90 days (expiringWithinDays: 90) to pitch statutory WC conversion or competitive renewal quotes right before policy decisions.
Occupational Accident (OccAcc), Stop-Loss & ERISA Benefit PlansMonitor newly opted-out employers (filedWithinDays: 14, onlyNew: true) every Monday morning to offer compliant Texas Non-Subscriber employee injury benefit plans & Employer's Liability coverage.
PEOs, TPAs & Workplace Safety ConsultantsTarget high-headcount multi-site retail, logistics, hospitality, construction, and healthcare chains operating across Houston, Dallas-Fort Worth, Austin, and San Antonio.
Clay.com / Make / n8n / AI SDR PipelinesEnrich each Parent employer with companyName, dbaNames, hqAddress, texasCities, and locationCount directly into Apollo/Clay contact discovery and HubSpot/Salesforce sequences.

Key Differentiators

  1. Parent + Multi-Location Rollup Grouping: Aggregates child Location rows onto each Parent filing—surfacing locationCount, isMultiLocation, cities, texasCities, states, zipCodes, and distinct subsidiary dbaNames (while even matching out-of-state corporate headquarters that operate Texas branches!).
  2. Insurance X-Date Expiration Windows (expiringWithinDays): Filter directly on end_date and segment urgency automatically (expiring_30d, expiring_60d, expiring_90d, active_future, expired).
  3. Recent Non-Subscriber Filing Alerts (filedWithinDays): Capture brand-new DWC Form-005 submissions by filing_date_received.
  4. Cross-Location City, ZIP & Keyword Targeting: Searching cities: ["Austin"] or zipCodes: ["78701"] matches employers whether Austin is their Parent HQ or one of their branch locations—then rolls up the entire company.
  5. Stateful SEEN_FILINGS Delta Deduplication (onlyNew: true): Remembers previously delivered filingId + coverageEndDate pairs in persistent Key-Value storage so scheduled runs only emit new or renewed filings.

Transparent Pay-Per-Event (PPE) Pricing

This Actor uses Apify's Pay-Per-Event billing model—you only pay for rolled-up Parent employer leads actually emitted (duplicates skipped via onlyNew: true are never charged):

Event NameTriggerSuggested Store Price
actor-startCharged once when the Actor run initializes$0.05 / run
employer-leadCharged per rolled-up Parent employer lead pushed to the dataset$0.02 / employer lead

Input Configuration Guide

1. Upcoming 90-Day X-Date Renewal Pipeline (Multi-Location Accounts)

{
"expiringWithinDays": 90,
"filedWithinDays": 0,
"cities": ["Houston", "Dallas", "Austin", "San Antonio"],
"minLocations": 2,
"onlyNew": true,
"maxItems": 200
}

2. Weekly Newly Filed Non-Subscriber Alerts

{
"expiringWithinDays": 0,
"filedWithinDays": 14,
"onlyNew": true,
"maxItems": 100
}

Realistic Sample Output Record

{
"filingId": "13445",
"companyName": "Sk Wireless Group Inc",
"hqAddress": "5309 Middleton Dr",
"hqCity": "Parker",
"hqState": "TX",
"hqZipCode": "75002-3727",
"hqZip5": "75002",
"filingDateReceived": "2025-11-19",
"coverageStartDate": "2025-11-19",
"coverageEndDate": "2026-11-18",
"daysUntilExpiration": 4,
"daysSinceFiled": 360,
"xDateStatus": "expiring_30d",
"locationCount": 7,
"reportedLocationRecords": 7,
"isMultiLocation": true,
"cities": ["Parker", "San Antonio"],
"texasCities": ["Parker", "San Antonio"],
"states": ["TX"],
"zipCodes": ["75002", "78218", "78237"],
"dbaNames": [],
"locations": [
{
"companyName": "Sk Wireless Group Inc",
"address": "131 Historic Old Hwy 90",
"city": "San Antonio",
"state": "TX",
"zipCode": "78237-1529",
"startDate": "2025-11-19",
"endDate": "2026-11-18"
}
],
"locationsTruncated": false,
"sourceDatasetUrl": "https://data.texas.gov/resource/azae-8krr.json?filing_id=13445",
"scrapedAt": "2026-11-14T04:25:00.000Z"
}

Automated Daily / Weekly Scheduling (Clay, Make, n8n & MCP)

  1. Save an Actor Task with expiringWithinDays: 90 (or filedWithinDays: 7) and onlyNew: true.
  2. Attach an Apify Schedule (0 7 * * 1 — Mondays at 7:00 AM CT) and connect your Clay webhook, Make/n8n scenario, or Slack channel.
  3. Inspect RUN_SUMMARY in the Default Key-Value Store after every run for exact audit counts (candidateFilingsEvaluated, employersEmitted, skippedDuplicateCount, and ppeEventsCharged).

How Much Does It Cost? (Tiered Pay-Per-Event Pricing)

Skipped duplicate filings in onlyNew: true mode cost $0. Paid Apify tiers automatically unlock lower per-employer lead rates:

EventOne-Time?Free PlanBronzeSilverGold / Enterprise
actor-startYes$0.05$0.05$0.05$0.05
employer-lead (Primary)No$0.02$0.018$0.016$0.014

Clay, Make, n8n & AI Agent (mcp.apify.com) Chaining

  • Clay.com Commercial P&C & PEO Outbound: Pipe rolled-up Texas parent employers, location counts, NAICS codes, and upcoming 30/60/90-day Form-005 X-Dates into Clay to enrich CFO/HR contacts automatically.
  • AI Agents & MCP (mcp.apify.com): Query live Texas TDI DWC non-subscriber filings by city, ZIP, or expiration window directly from MCP-compatible insurance workflows.