New Liquor License Feed: Issued & Pending (6 States) avatar

New Liquor License Feed: Issued & Pending (6 States)

Pricing

from $3.00 / 1,000 license records

Go to Apify Store
New Liquor License Feed: Issued & Pending (6 States)

New Liquor License Feed: Issued & Pending (6 States)

Newly issued and pending liquor licenses from 8 official open-data sources in 6 states (NY SLA, Texas TABC, Colorado, Missouri, Washington LCB, Chicago) in one normalized schema. New bars, restaurants, stores, breweries. Daily delta mode.

Pricing

from $3.00 / 1,000 license records

Rating

0.0

(0)

Developer

Luke Miller

Luke Miller

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

3 days ago

Last modified

Categories

Security

Limited permissions

Share

New Liquor License Feed: Newly Issued & Pending Liquor Licenses (NY, TX, CO, MO, WA, Chicago)

Get new liquor licenses and pending liquor license applications from 8 official government open-data sources in 6 states in one normalized schema: New York State Liquor Authority (SLA), Texas Alcoholic Beverage Commission (TABC), Colorado Liquor Enforcement Division, Missouri Alcohol and Tobacco Control, Washington State Liquor and Cannabis Board (LCB) and the City of Chicago. An Oregon OLCC source is available as an opt-in, but its upstream dataset has published no new applications since June 4, 2026 (see notes). Every record is a new bar, restaurant, hotel, liquor store, grocery, brewery, winery, distillery or distributor, usually weeks before or right as it opens.

Schedule it daily with mode: sinceLastRun and each run delivers only the licenses you have not seen yet.

Why this feed

  • Multi-state, one schema. Other liquor-license tools on the Store cover one state or scrape one website. This one reads 8 active official datasets and maps them to the same fields: business (DBA) name, organization legal name, license type and code, normalized category, status, issue / effective / expiration / application dates, license or application number, premises address, city, county, state, ZIP, latitude/longitude (where published) and a link to the source dataset.
  • Two stages: issued and pending. stage: application records (NY pending applications, TABC pending original applications, WA LCB local-authority notices) are the earliest signal, often weeks before a venue opens. stage: issued records are freshly granted licenses.
  • Leads, not noise. By default it skips temporary/special-event permits (nonprofit event permits, picnics, festivals) and add-on privileges on existing licenses (additional bars, Sunday sales, late hours, food & beverage certificates, premises amendments), so you get new outlets. Turn either back on with one checkbox. Colorado tobacco licenses and Washington cannabis notices are excluded.
  • Normalized category across states: retail-on-premises (bars, restaurants, hotels, clubs), retail-off-premises (liquor, grocery, convenience stores), manufacturer, wholesale-distribution, temporary-event, other.
  • Lag-aware. Each agency refreshes on its own schedule. The lookback window is measured from the newest date each source has posted, so slow portals still return data, and every run reports dataThrough per source.
  • Entity-level only. Individual owner names, applicant lists, birth dates and phone numbers are never copied. Legal names are included only when they are an organization (LLC, Inc, Corp, club, association, ...).
  • Fast and cheap to test. The default input returns about 40 records (5 per source) in roughly 10 seconds.

Who uses it

  • Beverage distributors, wholesalers and brand reps: reach new bars, restaurants and package stores before competitors do.
  • POS, payments, insurance (liquor liability), payroll and staffing sales teams: new hospitality businesses need all of these.
  • Restaurant suppliers, equipment dealers, glassware, linen, security and music licensing: prospect new venues by city.
  • Market research and real estate: track new on-premises and off-premises outlets by state, city and category.
  • AI agents and CRMs: call it via the Apify API or MCP server, e.g. "new mixed beverage permits in Houston this week".

Quick start

  1. Click Start with the default input to see a sample (about 40 records across all sources).
  2. For a daily lead feed, create a Schedule with:
{
"mode": "sinceLastRun",
"stateKey": "my-texas-bars",
"states": ["TX"],
"licenseCategories": ["retail-on-premises"],
"daysBack": 7,
"maxItems": 1000,
"maxItemsPerSource": 500
}

Each schedule should use its own stateKey. The first run looks back daysBack days; later runs only return records not delivered before (a 3-day overlap catches late postings).

Input

FieldMeaning
modewindow (default, stateless) or sinceLastRun (only new records; use for schedules)
daysBackLookback window, default 7 days
sourcesany of ny-sla-new-licenses, ny-sla-pending-applications, tx-tabc-new-licenses, tx-tabc-pending-applications, co-recently-approved, mo-new-liquor-licenses, or-olcc-applications (opt-in, stale; see notes), wa-lcb-license-applications, chicago-new-liquor-licenses
statesNY, TX, CO, MO, WA, IL; OR turns on the opt-in Oregon source
stagesissued, application
licenseCategoriesretail-on-premises, retail-off-premises, manufacturer, wholesale-distribution, temporary-event, other
licenseTypestext match on license type or code, e.g. restaurant, tavern, mixed beverage, MB, grocery, brewer
city, keywordexact city name; free-text match on name, type and address
includeTemporary, includeAddOnsoff by default
maxItems, maxItemsPerSourcecaps per run (also cap your spend). Defaults 40 / 5 for a cheap test; raise them for production
includeRawadds the original agency record (may contain personal names; off by default)
socrataAppTokenoptional free Socrata token to avoid throttling
stateKeysaved-search name for sinceLastRun

Output example

See the Output tab or sample-output.json.

{
"stage": "issued",
"businessName": "Ilmejung DokDo LLC",
"legalEntityName": "Ilmejung Dokdo LLC",
"licenseType": "Mixed Beverage Permit",
"licenseTypeCode": "MB",
"licenseCategory": "retail-on-premises",
"status": "Active",
"isAddOn": false,
"isTemporary": false,
"licenseNumber": "200211517",
"eventDate": "2026-10-29",
"issueDate": "2026-10-29",
"effectiveDate": "2026-10-29",
"expirationDate": "2028-10-28",
"address": "10017 Long Point Rd",
"city": "Houston", "county": "Harris", "state": "TX", "zip": "77055",
"jurisdiction": "TX",
"source": "tx-tabc-new-licenses",
"sourceDataset": "https://data.texas.gov/d/7hf9-qc9f",
"recordKey": "tx-tabc-new-licenses:200211517"
}

eventDate is the issue date for issued licenses and the received / posted date for applications. state is the premises state (out-of-state shippers and carriers licensed by Texas or Missouri keep their home state); jurisdiction is the issuing state. Every run also writes an OUTPUT summary with per-source counts, dataThrough and any errors. One source failing never blocks the others.

Data sources and terms

JurisdictionDatasetStageTerms
New YorkSLA Current Active Licenses (new originals by original issue date)issuedNY Open Data Terms of Use
New YorkSLA Current Pending LicensesapplicationNY Open Data Terms of Use
TexasTABC License Information (by original issue date)issuedTexas Open Data Portal
TexasTABC Pending Original New Primary and Subordinate License ApplicationsapplicationTexas Open Data Portal
ColoradoRecently Approved Liquor Licenses in ColoradoissuedPublic Domain
MissouriNew Liquor LicensesissuedMissouri Open Data
Oregon (opt-in, stale)OLCC Liquor Applications ReceivedapplicationOregon Open Data
WashingtonLCB Local Authority Letters (liquor only)applicationPublic Domain
Chicago, ILBusiness Licenses (new Tavern, Package Goods, Consumption on Premises, Caterer's Liquor, Special Event Liquor)issuedCity of Chicago Data Terms of Use

Disclaimer (required by the City of Chicago terms for derivative applications): This Actor provides data that has been modified for use from its original sources, including www.cityofchicago.org, the official website of the City of Chicago. The City of Chicago makes no claims as to the content, accuracy, timeliness, or completeness of any of the data provided here. The data is subject to change at any time and is used at your own risk.

This Actor is not affiliated with or endorsed by any agency. Data is as published by each agency. Notes: Colorado refreshes roughly monthly; the Washington LCB dataset is a short rolling list of recent notices; Oregon is opt-in and currently stale: the OLCC 'Liquor Applications Received' dataset has published no New Application rows since June 4, 2026 (only premises-area amendments, which are add-ons), so it is excluded by default and normally returns 0 records. Select or-olcc-applications in sources (or OR in states) to include it anyway; it is labeled in the run's OUTPUT summary. Oregon publishes the premises address as one line, so city is empty there. licenseCategory, isAddOn and isTemporary are best-effort labels from the license type, not official classifications.

Good-citizen behavior

Uses the official Socrata (SODA) APIs only, no scraping. Requests are spaced at least 0.4 seconds apart per host, use a descriptive User-Agent, back off on errors and rate limits, and only the needed date window is requested.

Pricing

Pay per event (Apify takes care of billing; you only pay for what is delivered):

EventPriceCharged
apify-actor-start$0.005once per run
license-record$0.003per liquor license record delivered

A default test run (40 records) costs about $0.125. A TX + NY on-premises daily schedule (~60 new records/day) costs about $0.19/day. maxItems and Apify's max cost per run cap your spend; the Actor stops delivering when your budget is reached, so you are never charged for more than you set. No separate platform-usage charges: compute is included in the event prices.

FAQ

How fresh is the data? New York, Texas, Missouri, Washington and Chicago refresh daily or near-daily; Colorado roughly monthly. Check dataThrough in the OUTPUT record.

Can I get phone numbers or owner names? No. This feed is entity-level by design. Use the business name and premises address to look up public business contact details.

Can you add my state? Open an issue on the Issues tab. States that publish liquor licenses on an open-data API can be added quickly.