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,421,319 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 (500,073 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,465,364 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 (312,685 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 200)

Default run = the 200 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).

Low cost

From $0.0001 per record - 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.

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.