For procurement and compliance review
Methodology and limits
How the Liquor License API gets its data, what it means, how records are matched, and what it does not do. Written to be read by someone deciding whether the data is safe to rely on.
1. Data sources and coverage
All data comes from official state agency publications. We do not buy data, scrape behind sign-ins, or infer licenses.
| State | Records |
|---|---|
| Texas | 128,945 |
| California | 128,294 |
| New York | 126,335 |
| Georgia | 98,892 |
| Virginia | 59,500 |
| Florida | 55,249 |
| Michigan | 35,861 |
| Oregon | 22,182 |
| Indiana | 17,086 |
| Colorado | 16,800 |
| Washington | 16,257 |
| Missouri | 15,907 |
| Nebraska | 8,163 |
| Total | 729,471 |
Live count from the API. Data as of November 21, 2026.
Alcohol licenses only. Local permits are not covered. State cannabis licenses are a separate product, the Cannabis License API, and are not in these counts. The live list of sources, with each agency's schedule and our latest fetch, is at GET /v1/sources.
2. What the statuses mean
We keep the agency's own status text (status_raw) and map it to one set: active, expired, suspended,
cancelled, surrendered, pending, revocation_pending, inactive and unknown.
A value we cannot map is unknown, never a guess. California status code R64B is not defined on any ABC page we could read, so it is reported as unknown with the code preserved.
Colorado and Oregon publish no status column. Colorado's active file lists only active licenses, so being listed there is what we report as active, and its other file states Expired or Surrendered; Oregon's file has an expired flag, which we report as expired or active. A Colorado license that was renewed after it expired can appear in both files, and then shows as a conflict for a person to look at.
Georgia publishes a workbook of alcohol accounts marked Active or Closed, which we report as active and inactive. It has no expiration date and no trade name, so those fields are empty for Georgia, never inferred. Georgia posts a new file about every quarter, with no fixed day; its freshness is judged by the age of the file (overdue after 130 days).
Washington publishes retail licensees as separate on-premise and off-premise workbooks, plus distillers and distributors, replaced every few days. A license appears once per privilege, so we keep one record per license and flag it when its rows disagree (for example an issued row beside a pending temporary one). We do not collect Washington's winery lists: they have no status column.
Virginia's workbook is refreshed daily and carries a status and expiration date for each privilege (beer and wine, mixed beverage). We report one status per license: active if any privilege is active, otherwise pending, otherwise inactive, with the latest expiration among the privileges that carry it. Tobacco permits and permits issued to individuals are left out.
Michigan's master list has no expiration date. We report Escrow (a license held out of use) as inactive and Conditional (issued subject to conditions not yet met) as pending, and keep the agency's word in status_raw. Michigan updates its list about monthly.
Missouri's open-data list contains active licenses only, with no status or expiration column, so being listed is what we report as active, as with Colorado.
Indiana's permit database is exported from the Commission's public Tableau view, which carries no publication time, so Indiana's freshness is reported as unknown. Active is reported as active, In Escrow (held out of use) as inactive and Pending Application as pending; the transitional statuses Underlying, Transfer Pending and Pending Auction are reported as unknown, with the agency's word in status_raw.
Nebraska's active roster lists active licenses only, so being listed is what we report as active; a primary license and its secondary licenses (catering, growler) share a number and appear as one record. Dates in the file are Excel day numbers, converted to calendar dates.
Colorado republishes both files monthly (the 6th), so a Colorado answer can be up to a month behind the agency; its freshness block says so. Oregon publishes daily.
A license can be marked active by the agency after its expiration date. We report both (expiration_passed) and do not decide which is right.
Applications (New York pending, California rows marked as applications) are separate records, record_kind: "application", never merged with licenses.
3. Matching
- By identifier: exact match on the agency's identifier. California licenses are
<file number>-<type>because one file number can hold several licenses. - By name and address: candidates are scored by name similarity (token-sorted, ignoring LLC, Inc and similar) and by whether the normalized street address and ZIP match. A probable match needs exactly one candidate with a matching address and a name score of 85 or more. Anything else with candidates is candidates to review.
- Records are never merged because a name or address looks alike. One store can hold several licenses, and one owner can run many businesses at one address (an airport, for example).
- The 85 threshold is a starting value that we tune against real submissions; it is not a verified accuracy figure.
4. Freshness, conflicts and broken downloads
- Three separate freshness checks: we missed a scheduled fetch; the agency missed its expected publication; or this license has not appeared in a recent successful fetch. Each source has its own schedule, time zone, business days and holidays.
- Unchanged is not stale. A license is flagged only when we lack recent evidence that it still appears in its source.
- Disagreements are flagged, not settled. Where two source rows describe the same license and disagree, the answer is
unresolved_conflictwith every observation shown. - Absence is not closure. A license missing from a download is kept and flagged. We do not infer revocation.
- Broken downloads are quarantined. A sharp drop in records, many licenses vanishing at once, spikes in blank license numbers or unknown statuses, a missing column, a login page instead of data, or a repeated page: we keep serving the last validated data and show it as overdue.
5. Refresh and corrections
Every source is read once a day at 14:45 UTC. We do not edit agency data. To correct a record, contact the issuing agency; the source link is on every record. Tell us at support@kixlogic.com if our copy differs from the agency's published data.
6. Security and access
All traffic is HTTPS. Each customer has an API key; every saved item (checks, watches, portfolios, policies) is private to that key. Webhooks are signed with a per-watch secret and sent only to public HTTPS addresses. Cursors are signed and bound to the key that received them. An account can issue team keys with a role (viewer, reviewer, approver or admin), and every change made through the API, and every review step, is written to a hash-chained audit log. Sign-in through an identity provider uses OpenID Connect with PKCE or SAML 2.0 with signed assertions, each checked for signature, audience, expiry and replay; stored provider secrets are encrypted, and sessions last at most eight hours. Your identity provider can provision and deactivate people over SCIM 2.0, using a bearer token we store only as a hash.
7. Customer data and retention
We store what you submit to us: key request details; webhook URLs and secrets; portfolios and the licenses in them; saved checks including the names and addresses you submitted; your policies; team members' names, optional emails and roles; reviews, with the license data as it was when each was opened; the audit log; and alert email addresses you confirm.
Saved checks stay until you delete them (DELETE /v1/checks/{id}); policy versions are immutable. There is no automatic expiry yet. Ask us at support@kixlogic.com to delete anything else.
We do not use your submissions for anything other than serving you.
8. Support and incidents
Support is by email at support@kixlogic.com. Response-time commitments are agreed in contract; none are published yet.
9. Permitted use
For your own internal screening and monitoring. Showing this data to your own end users, embedding it in a product, or reselling it is a separate license. Not for decisions about individuals' employment, housing, credit or insurance.
10. What this is not
It is license-data screening and monitoring. It is not a finding that a business meets every legal obligation, legal advice, a consumer report, or an enforcement history. Your policy result says only whether the data meets your rules, for a stated policy version.
