Texas Workers' Comp Non-Subscriber & X-Date Lead Monitor
Pricing
from $14.00 / 1,000 employer coverage & x-date leads
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
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
2 days ago
Last modified
Categories
Features
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 Persona | Automated Revenue Workflow |
|---|---|
| Commercial P&C & Workers' Comp Brokers | Pull 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 Plans | Monitor 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 Consultants | Target 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 Pipelines | Enrich each Parent employer with companyName, dbaNames, hqAddress, texasCities, and locationCount directly into Apollo/Clay contact discovery and HubSpot/Salesforce sequences. |
Key Differentiators
- Parent + Multi-Location Rollup Grouping: Aggregates child
Locationrows onto eachParentfiling—surfacinglocationCount,isMultiLocation,cities,texasCities,states,zipCodes, and distinct subsidiarydbaNames(while even matching out-of-state corporate headquarters that operate Texas branches!). - Insurance X-Date Expiration Windows (
expiringWithinDays): Filter directly onend_dateand segment urgency automatically (expiring_30d,expiring_60d,expiring_90d,active_future,expired). - Recent Non-Subscriber Filing Alerts (
filedWithinDays): Capture brand-new DWC Form-005 submissions byfiling_date_received. - Cross-Location City, ZIP & Keyword Targeting: Searching
cities: ["Austin"]orzipCodes: ["78701"]matches employers whether Austin is their Parent HQ or one of their branch locations—then rolls up the entire company. - Stateful
SEEN_FILINGSDelta Deduplication (onlyNew: true): Remembers previously deliveredfilingId+coverageEndDatepairs 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 Name | Trigger | Suggested Store Price |
|---|---|---|
actor-start | Charged once when the Actor run initializes | $0.05 / run |
employer-lead | Charged 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)
- Save an Actor Task with
expiringWithinDays: 90(orfiledWithinDays: 7) andonlyNew: true. - Attach an Apify Schedule (
0 7 * * 1— Mondays at 7:00 AM CT) and connect your Clay webhook, Make/n8n scenario, or Slack channel. - Inspect
RUN_SUMMARYin the Default Key-Value Store after every run for exact audit counts (candidateFilingsEvaluated,employersEmitted,skippedDuplicateCount, andppeEventsCharged).
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:
| Event | One-Time? | Free Plan | Bronze | Silver | Gold / Enterprise |
|---|---|---|---|---|---|
actor-start | Yes | $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.