TX Insurance Appointments - Who Is Appointed to Sell What, for Whom

The Texas Department of Insurance publishes its entire appointment register - every appointment between a producer and a carrier, refreshed daily - as open data. This actor turns that register into a charged-per-record carrier-and-producer map.

Built for: carriers and MGAs auditing their appointed-producer force, compliance teams checking whether a producer is actually appointed for the line they sold, agencies mapping which carriers their producers represent, and market analysis of who is appointed across Texas insurance.

What it covers

~4.44M appointments across 1,536 carriers and 12 lines of authority, refreshed daily.

One row is one appointment: a producer (agent NPN) appointed by a carrier for a line of business. That makes the register the carrier-facing counterpart to the license file - the license says what a producer may sell; an appointment says what a carrier has actually engaged them to sell.

Line of authority	Appointments
Life, Accident, Health and HMO	2,303,587
Property and Casualty	1,620,755
Personal Lines Prop & Cas	223,598
Life	220,897
Limited Lines / Pre-Need / County Mutual / Travel / Credit / MGA	the long tail

Each record carries:

• the agent - NPN and name (~500k distinct producers across the file)
• the carrier - company name and NAIC id
• the line of authority the appointment covers
• the appointment date
• the producer's city / state / postal code

The file is Texas-weighted but national: TX carries ~2.47M appointments, ahead of FL (464,566), CA (156,506), GA (83,286) and IL (75,237) - producers everywhere are appointed to transact Texas business.

The register has no termination date

TDI never stamps an appointment "active" or "terminated". The file is the cumulative appointment history - an appointment that ended years ago is still a row. This actor says so rather than guessing: it slices by carrier, line, producer or date, and recent mode gives the live appointment flow (~312k appointments in the last 90 days), which is the honest answer to "what is happening now".

That choice matters in practice. A carrier pulling "everyone appointed for Property & Casualty" gets their full historical force, not the current one - so the actor pairs the cumulative view with the recent-window view instead of pretending a status column exists.

Typical questions

• "Every carrier and line this producer (by NPN) is appointed for."
• "All producers appointed to sell Property and Casualty for a carrier."
• "Superior HealthPlan's appointed-producer force - how many, where."
• "Which carriers hold the most appointed producers in Texas?"
• "The live appointment flow: what was appointed in the last 90 days."
• "Aggregate appointments by carrier, line, state, or year."

Inputs

Input	What it does
mode	rows (default) / recent (last 90 days) / aggregate
appointmentType	the line of authority, e.g. 'Life, Accident, Health and HMO', 'Property and Casualty'
company	carrier name (fuzzy)
agentNpn	exact NPN - every appointment for one producer
agentName / city / state	producer filters (name & city fuzzy, state exact)
appointedFrom/To	appointment-date window
groupBy	aggregate over appointmentType / company / state / appointmentYear
maxResults	cap records (default 50)

Default run = the 50 most recent appointments (mode defaults to rows) - 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 4.4M-row dump).

Example inputs

Every carrier and line one producer is appointed for - agentNpn is the exact National Producer Number.

{ "agentNpn": "20043588", "maxResults": 10 }

One carrier's appointed-producer force - company matches the carrier name fuzzily.

{ "company": "Superior HealthPlan", "maxResults": 10 }

The live appointment flow in one line - mode=recent is the last 90 days, appointmentType the line of authority.

{ "mode": "recent", "appointmentType": "Property and Casualty", "maxResults": 10 }

Which lines carry the register - mode=aggregate returns one count row per group.

{ "mode": "aggregate", "groupBy": "appointmentType" }

Low cost

From $0.00005 per record, down to $0.00003 at Gold - billed only for the rows you use, at the low end of the store. Mapping one producer's appointments costs a fraction of a cent; a whole carrier's force costs pennies.

The register reads like a plain join table until you use it. There is no appointment end date - the file is cumulative, so "who is appointed for this line" silently means "who was ever appointed", and the live picture only comes from a date window this actor gives you. The row is an appointment, not a producer - one producer appears once per carrier per line, so a name search returns a matrix that is either exactly what you want or three hundred rows you did not. The carrier field is free text over 1,536 names ("Health Care Service Corporation, a Mutual Legal Reserve Company" is one carrier) and the line vocabulary mixes permanent and temporary authorities. Normalizing that into a register where a company / appointmentType / npn query returns exactly the appointments 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.

Example output

agentNpn=20043588 - one appointment, naming the producer, the carrier (with its NAIC id), the line of authority and the appointment date:

{
 "platform": "tx-tdi-appointments",
 "source": "texas-insurance-appointments",
 "mode": "rows",
 "groupKey": "",
 "groupCount": "",
 "groupBy": "",
 "agentNpn": "20043588",
 "agentName": "DIEGO NAVA NEGRETTE",
 "companyName": "KS Plan Administrators, LLC",
 "naicId": "12827",
 "appointmentType": "Life, Accident, Health and HMO",
 "appointmentDate": "2026-09-16",
 "city": "FORTH WORTH",
 "state": "TX",
 "zipcode": "76131"
}

mode=aggregate, groupBy=appointmentType - appointments by line of authority:

Life, Accident, Health and HMO   2,303,587
Property and Casualty            1,620,755
Personal Lines Prop & Cas          223,598
Life                               220,897

Source

• Texas Open Data: Insurance agent appointments - the Texas Dept. of Insurance's published appointment register. Reflects the state's record as of each refresh; not a verification of any producer's current appointment status.