Texas Real Estate Licenses (TREC) — Official Open Data, ~322k Brokers & Agents Refreshed Daily

Pull the entire Texas real-estate licensee population — every active and inactive broker and sales agent regulated by the Texas Real Estate Commission (TREC) — straight from the state's official open-data feed, normalized into clean JSON. ~321,800 license records (~188,000 active), refreshed daily.

This actor is a polite JSON client for Texas's affirmatively-public open-data portal (data.texas.gov, Socrata dataset s7ft-44qi — "Broker and Sales Agent License Holder Information"). No HTML scraping, no CAPTCHAs, no browser — just the government API, with server-side filtering, paging, exponential backoff, and a descriptive User-Agent. Most competing real-estate-license products on the Store are fragile UI scrapers of licensing-board search forms; this reads the authoritative bulk source directly.

What you get

Every record is one license holder, normalized to a stable schema:

• License: number, type (Sales Agent, Broker Individual, Broker Company) with a friendly label, and status.
• Name: full name plus parsed first / middle / last / suffix and TREC "key name" (Last, First), all normalized.
• Dates (ISO 8601): original license date and license expiration date — TREC's US-format dates are converted to YYYY-MM-DD.
• Sponsoring / related license: for a sales agent, the sponsoring broker (type, license number, name, start date); for a broker company, the designated broker individual.
• Flags & ids: designated-supervisor flag (boolean), TREC agency identifier, and the per-record updated date.
• Provenance: source dataset id and URL on every record.

Example output record

{
  "licenseNumber": "107343-SA",
  "licenseType": "Sales Agent",
  "licenseTypeLabel": "Real Estate Sales Agent",
  "status": "Active",
  "fullName": "DENNIS FRANK BISHOP",
  "firstName": "DENNIS",
  "middleName": "FRANK",
  "lastName": "BISHOP",
  "suffix": "",
  "keyName": "BISHOP, DENNIS FRANK",
  "designatedSupervisor": false,
  "county": "",
  "agencyIdentifier": "880107343",
  "originalLicenseDate": "1988-02-17",
  "licenseExpirationDate": "2028-04-30",
  "relatedLicense": {
    "licenseType": "Broker Company",
    "licenseNumber": "9002301-BB",
    "fullName": "BISHOP REALTOR GROUP, INC",
    "suffix": "",
    "startDate": "2023-03-31"
  },
  "updated": "2026-04-21",
  "sourceDataset": "s7ft-44qi",
  "sourceUrl": "https://data.texas.gov/resource/s7ft-44qi.json"
}

Note on addresses: TREC's public open-data extract intentionally does not publish licensees' street addresses, and the county column is present but empty for every row. This actor returns exactly what the state publishes — names, license details, dates, and sponsoring-broker links — and never fabricates location data.

Filters (inputs)

Input	What it does
nameContains	Substring match on full name / last name / key name (case-insensitive).
licenseType	Exact type: Sales Agent, Broker Individual, or Broker Company.
licenseNumber	Partial match on the TREC license number (e.g. 854981-SA).
status	Substring on status (Active, Inactive, Expired less than 6 months, Revoked, …). Defaults to Active.
includeAllStatuses	Return every status instead of just Active.
expiresFrom / expiresTo	License-expiration date range (ISO) — build renewal-marketing lists.
originalIssuedFrom / originalIssuedTo	Original-license date range (ISO) — find newly-licensed agents.
maxRecords	Cap on records returned (default 5,000; full set ~322k).
socrataAppToken	Optional Socrata app token to raise rate limits (not required).

Name/type/number/status filters are pushed to the API as a SODA $where; the date ranges are applied to the normalized ISO dates.

Who buys this

• Real-estate CRM & lead-gen platforms enriching or building agent databases.
• Title & mortgage marketing teams targeting active agents and brokers.
• Brokerage recruiting — find newly-licensed agents (by original-license date) or agents at competing brokerages (via the sponsoring-broker link).
• Real-estate data vendors needing an authoritative, daily-refreshed TX licensee master to reconcile against.

Data source, freshness & licensing

• Source: Texas Real Estate Commission via data.texas.gov (Socrata), dataset s7ft-44qi, "Broker and Sales Agent License Holder Information".
• Volume (verified 2026-07-22): 321,847 rows; 188,113 Active, plus Inactive, Expired, Revoked, Surrendered, Deceased, and other statuses.
• Freshness: the state refreshes the dataset daily (rowsUpdatedAt 2026-07-22 at run of verification).
• Public data: data.texas.gov is Texas's affirmatively-public open-data portal — the same portal our TABC liquor-license actor reads. This is official government open data, not a scraped private source.

Pricing (pay-per-event)

Event	Price	When
Actor start	$0.005	Once per run — query build + paged, backed-off API calls.
License record	$0.003	Per normalized record pushed to your dataset.

A typical targeted pull (e.g. 5,000 active sales agents in an expiration window) costs about $0.005 + 5,000 × $0.003 ≈ $15. You pay only for records you keep; tight filters keep it cheap. This is dramatically cheaper and more reliable than scraping the TREC license-lookup form record by record.