OrbTop

US State Liquor License Aggregator

LEAD GENERATIONBUSINESS
Try on Apify

US State Liquor License Aggregator

Aggregates active alcoholic beverage control (ABC) / liquor license data from multiple US state open-data portals. Returns standardized records covering license holder, trade name, license type, status, address, and county — across California, Texas, and New York in a single run.

Data Sources

State Agency Source
CA California ABC Daily CSV bulk export (~129k records)
TX Texas TABC Socrata API — data.texas.gov (~77k active records)
NY New York SLA Socrata API — data.ny.gov (~59k active records)

All sources are publicly available open government data. No authentication or proxy is required.

Input

Field Type Default Description
states array ["CA","TX","NY"] State codes to fetch. Supported: CA, TX, NY.
licenseStatus string "active" "active" returns only active/current licenses; "all" includes expired and inactive.
maxItems integer 10 Maximum total records to return across all selected states. 0 = unlimited.

Example Input

{
  "states": ["CA", "TX"],
  "licenseStatus": "active",
  "maxItems": 500
}

Output

Each record contains the following fields:

Field Description
licenseHolderName Legal name of the license holder (individual or entity)
tradeName Trade name / DBA (Doing Business As)
licenseNumber State-assigned license or file number
licenseType License type code (state-specific, e.g. 47 for CA On-Sale General)
licenseClass License class or category description
licenseStatus Current status (Active, Expired, Suspended, etc.)
issuedDate Original issue date (YYYY-MM-DD)
expirationDate Expiration date (YYYY-MM-DD)
address Street address of the licensed premises
city City
state US state code (CA, TX, NY)
zip ZIP code
county County
sourceUrl URL of the source portal or data file
sourceState Two-letter US state code of the data source
scrapedAt ISO 8601 timestamp when the record was scraped

Example Output Record

{
  "licenseHolderName": "SMITH ENTERPRISES LLC",
  "tradeName": "THE DOWNTOWN BAR",
  "licenseNumber": "612345",
  "licenseType": "48",
  "licenseClass": "LIC",
  "licenseStatus": "ACTIVE",
  "issuedDate": "2019-03-15",
  "expirationDate": "2027-03-14",
  "address": "123 MAIN ST",
  "city": "LOS ANGELES",
  "state": "CA",
  "zip": "90001",
  "county": "LOS ANGELES",
  "sourceUrl": "https://www.abc.ca.gov/licensing/licensing-reports/",
  "sourceState": "CA",
  "scrapedAt": "2026-05-10T10:36:12.000Z"
}

Use Cases

  • Distributor prospecting — Identify licensed retailers, bars, and restaurants in target markets
  • Compliance research — Verify license status before executing contracts or shipments
  • POS / ordering system outreach — Build contact lists for B2B alcohol tech sales
  • Market analysis — Map the distribution of license types across counties and cities

Performance & Scale

  • CA: ~7 MB ZIP download, ~129k total records. The actor applies an active-status filter client-side; the CA CSV includes both issued licenses (LIC) and pending applications (APP).
  • TX: Server-side $where=primary_status='Active' filter reduces the dataset to ~77k active records before transfer. Pagination at 5,000 records per request.
  • NY: The NY SLA dataset is pre-filtered to current active licenses only (~59k records). No additional filtering required.

For large full-state runs (maxItems: 0), set the actor timeout to at least 30 minutes and memory to 512 MB.

Pricing

Pay-per-event pricing: $0.10 per run + $0.00125 per record scraped.

Try on Apify