CA Real Estate Licenses - California DRE Salesperson, Broker & Corporate Register

The California Dept. of Real Estate (DRE) publishes its entire current license register as open data - every licensed salesperson, broker, and the corporations / responsible officers behind them - refreshed daily and served as the state's own public CSV. This actor turns that register into a charged-per-record lookup and screening tool.

Built for: real-estate due diligence - verifying that an agent actually holds a current California license, screening agents / brokers / brokers-of-record, corporate-officer research, mortgage & title-industry onboarding checks, and state / county market sizing.

What it covers

429,753 license rows (current register, daily refresh):

Type	What it is	Rows
Salesperson	licensed real-estate salesperson	290,375
Broker	licensed broker	90,933
Corporation	licensed corporate entity	24,219
Officer	a broker's responsible-officer registration for a corporation	24,226

Every row carries the person's / company's name, license number, status, original-issue / effective / expiration dates, mailing address, city, county, ZIP, state, a restricted-license flag and the DRE's own officer cross-links. Dates come through as clean ISO (YYYY-MM-DD).

How the register is structured - a license number identifies a person, not a single license. A broker who is also the responsible officer of several companies has several rows under that one number: their own Broker row plus one Officer row per company, with each corporate entity's row carrying a relatedLicenseNumber pointing back at the person. That cross-link is what makes one lookup return a full licensee profile - an agent's own licenses and the companies they act for.

Status is Licensed or Licensed NBA (no business address). This is the state's current-register export - a license that lapses or is revoked drops off the list rather than flipping to an "expired" status.

Typical questions

• "Is this salesperson's license current in California, and who is their employing broker?"
• "Look up a license number and see the full licensee - their own broker / officer rows plus the companies they act for."
• "Show every broker in Orange County."
• "Which brokers of record are licensed under this corporate name?"
• "How many salespersons vs. brokers by county, across the state?"
• "Find licensed agents with a restricted license (restricted_flag Y)."
• "Screen a name across the whole register - person and company."

Inputs

Input	What it does
licenseNumber	exact number -> full licensee profile (their own rows + the corporate entities they act for)
name	last / first name substring, case-insensitive (entity rows match on the company name)
licenseType	Salesperson / Broker / Corporation / Officer
county / city	location filters (county is populated on ~100% of rows)
status	Licensed / Licensed NBA (blank = both)
restricted	Y = restricted license only (blank = both)
aggregate / groupBy	one summary row per group with a count - license type / county / status / restricted
maxResults	cap records (default 200)

Default run = a tiny aggregate (license-type mix) - fast and safe for the daily auto-test, never a surprise full dump. For records, add a name / licenseType / county filter or a licenseNumber profile.

Low cost

From $0.001 per record - billed only for the rows you use, with a per-run charge cap so a broad query can't surprise-bill.

The state's register is a 72 MB flat CSV with no query server behind it - there is no way to ask the source for "just Orange County brokers". Rather than make every lookup pay for a full-register download, the register is mirrored daily and diffed, and each run queries the mirror in a single pass. That mirror is what lets a 429,753-row register behave like a live lookup at per-record pricing. Every pull is integrity-checked against the register's known shape (total count, per-type floors, the exact status vocabulary, key-column coverage), so a degraded or schema-changed source fails loudly instead of returning bad rows.

Source

• DRE License Data Files - the official daily public data file this actor reads.
• License data is DRE's own published register; it reflects the state's record as of the daily refresh.