Data product

Jurisdiction intelligence,
at the row level.

Every license issued, modified, or revoked across 38 states. The same operational dataset ClearBot runs on, licensed to diligence teams, underwriters, and research firms who need to see the regulatory shape of any market — before they enter it.

Request a sample See delivery options →

17.5k+

Licenses indexed

528

Jurisdictions

15 min

Refresh cadence

The dataset

One canonical schema, across every jurisdiction.

We do the normalization work — every agency's field names, status codes, and license taxonomies mapped to a single, stable schema. Joinable with your CRM, your portfolio database, your cap table.

Stable IDs across renewals
Cross-jurisdiction license taxonomy (1,200+ types)
Live fee schedules per agency
Full mutation history per record

schema · public.licenses12 columns

ColumnTypeNote

license_iduuidStable across renewals
jurisdictiontextFederal · state · county · city
agency_codetextISO-style normalized code
license_typetextCanonical taxonomy, 1,200+ types
issued_atdateFirst-issue date
expires_atdateNext renewal deadline
statusenumactive · pending · revoked · lapsed
fee_usdnumericLive, per-jurisdiction fee schedule
holder_businesstextNormalized legal entity name
holder_dbatextTrade name, when distinct
modified_attimestampLast change observed
source_urltextOriginal agency record

query · production replicaread-only

01SELECT jurisdiction, COUNT(*) AS lapses
02FROM   licenses
03WHERE  status     = 'lapsed'
04  AND  expires_at > now() - interval '30 days'
05GROUP  BY jurisdiction
06ORDER  BY lapses DESC
07LIMIT  6;

Ready

jurisdictionlapses

TX · Harris County412
CA · Los Angeles287
IL · Cook County219
NY · Kings County198
FL · Miami-Dade174
GA · Fulton County138

Query it

Ask the question. Get the answer.

Every customer gets a hosted Postgres replica, refreshed every 15 minutes. Connect from your BI tool of choice — Sigma, Mode, Hex, Tableau — or hit the API directly. No ETL on your side.

Use cases

Built for the people who have to be sure.

Pre-acquisition diligence

Get a license-by-license risk profile of any target before close. Identify lapsed permits, pending revocations, and jurisdictional surprises.

Underwriting & insurance

Live compliance feeds for risk-rated locations. Triggered alerts when a holder's status changes.

Market entry studies

Forecast renewal load and agency lead times before signing leases in a new state.

Competitor monitoring

Track when competitors apply for new locations, expand into new jurisdictions, or let permits lapse.

Delivery

Four ways to consume it.

Quarterly snapshots

Full dataset as CSV or Parquet, delivered to S3 or GCS bucket of your choice.

Live API

REST + GraphQL access to the same data ClearBot operations runs on. Cursor-paginated, OAuth-protected.

Streaming webhooks

Subscribe to license-state changes by jurisdiction, agency, or holder.

Hosted Postgres replica

Read-only mirror of the canonical dataset, refreshed every 15 minutes.

Pricing

Anchored by how you use it.

We don't publish a rate card. These are the pricing anchors we work from — final number depends on volume, refresh frequency, and license breadth.

Private equity diligence teams
Jurisdiction-by-jurisdiction license risk for any target.
$25k / engagement
Insurance underwriters
Live compliance feed for risk-rated locations.
$80k / yr
Multi-state expansion teams
Forecast renewal load and agency lead times before signing leases.
$15k / market study
Compliance research firms
API access to the full agency knowledge base.
Custom

Talk to the data team.

Tell us the question you're trying to answer. We'll send back a sample slice that proves whether the data does what you need.

Request a sample