TX Insurance Agent & Adjuster Licenses - the State's Producer Register

The Texas Department of Insurance publishes its entire agent-license register - every license a producer holds under the state's insurance lines, refreshed daily - as open data. This actor turns that register into a charged-per-record lookup and renewal-pipeline tool.

Built for: insurance-company compliance & producer on-boarding, MGAs & agencies checking a producer's lines before contracting them, renewal-notification pipelines (who has to renew before a given month), and labor-market analysis of the Texas insurance workforce.

What it covers

963,695 licenses - the full register, refreshed ~daily. One row per license, so a producer licensed for both life and property carries two rows:

License type	Records
General Lines Agent	547,244
Adjuster	168,113
Life Agent	132,927
Personal Lines Prop & Cas Agent	50,335
Adjuster - DHS Texas	26,874
Surplus Lines / Escrow / Limited Lines / ...	the long tail

Each record carries the producer's identity and the license's own terms:

• NPN (national producer number) and the TDI license number
• license type (28 exact values) and the finer qualification line - "Life, Accident, Health & HMO" vs "Property and Casualty" vs "Adjuster - All Lines" are separate credentials, not one bucket
• issue date and expiration date - the renewal clock
• city / state / postal code of the holder's address

The register holds more than just Texans: 57% of the rows are out-of-state producers licensed to transact Texas business (Texas itself is 410,551 of the 963,695) - Florida alone carries 96,124, California 43,394, Georgia 29,400. state is a first-class filter.

The register has no status column

TDI doesn't stamp each row Active / Lapsed. The honest split is the expiration date vs today - and that's exactly what this actor does for you. active mode hands you the live slice (925,884 licenses right now, 96% of the file); date filters answer "who has to renew before November".

Typical questions

• "Is this NPN / license number live, and under what lines?"
• "Every Adjuster licensed in Texas - active and lapsed."
• "Who with a Life, Accident, Health & HMO qualification is licensed in Dallas?"
• "All Florida-based producers holding Texas licenses."
• "Renewal pipeline: every license expiring in Q4 2026."
• "Aggregate the register by license type, state, or expiration year."

Inputs

Input	What it does
mode	active (live slice, default) / rows (any license) / aggregate
licenseType	exact: General Lines Agent / Adjuster / Life Agent / ...
qualification	the finer line (fuzzy): 'Life, Accident, Health & HMO', 'Property and Casualty'
name / city / state	holder filters (name & city fuzzy, state exact)
expiresBefore/After	renewal window
issueBefore/After	original-issue window
groupBy	aggregate over licenseType / qualification / state / city / expirationYear
maxResults	cap records (default 200)

Default run = the 200 live licenses expiring soonest (mode defaults to active) - fast for the daily auto-test. For a targeted query add a filter; for a broad view use aggregate (a handful of summary rows, not a 963k-row dump).

Low cost

From $0.0001 per record - billed only for the rows you use, at the low end of the store. Cost scales with what you pull, not with the size of the register - and because each record is metered individually there's no per-run charge cap to hit on a big pull.

TDI's register is a "just download the CSV" dataset that hides real traps: there is no status column (the live/expired split has to be derived from expiration dates, and the naive "current year" read quietly drops the renewals that land in the following January); the same producer carries multiple rows - one per line of authority - so a name search returns every license they hold, which is either exactly right or exactly wrong depending on what you asked; the type vocabulary mixes permanent and temporary lines ("Temp General Lines - LAH Agent", "Life Agt Not Exceeding $25,000") that a substring filter drags together; and the file is a national producer list, so most of it is people outside Texas. Normalizing that into a register where a licenseType / state / expiry query returns exactly the licenses you mean is the actual product. Every pull is integrity-checked against the feed's known shape, so a degraded source fails loudly instead of returning bad rows.

Source

• Texas Open Data: Insurance Agent and Adjuster Licenses - the Texas Dept. of Insurance's published register. Reflects the state's record as of each refresh; not a verification of any producer's current standing.