# Liquor License Applications | New Restaurant Leads (`aurelix/liquor-license-applications`) Actor

Extract new liquor license applications and new licenses at $0.90 per 1,000 leads, cheaper per lead than the leading tools. California, Texas, New York, Missouri, Washington and Ontario in one schema, renewals left out, with a daily only-new mode for liquor license leads.

- **URL**: https://apify.com/aurelix/liquor-license-applications.md
- **Developed by:** [Aurelix](https://apify.com/aurelix) (community)
- **Categories:** Lead generation, Business
- **Features:** Limited permissions
- **Stats:** 2 total users, 1 monthly users, 0.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

from $0.70 / 1,000 license leads

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.
Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have.

Learn more: https://docs.apify.com/actors/running/actors-in-store.md#pay-per-event

## What's an Apify Actor?

An Actor is a serverless cloud program that runs on the Apify platform. It has two run modes.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.

Apify vocabulary and the platform model are defined once, in the agent quickstart at https://apify.com/agents.md.

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For examples already wired to this Actor's own input schema, see the [API](#api) section below.

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).

# README

### What is Liquor License Applications?

**Get new liquor license applications and new licenses from 5 US states and Ontario for $0.90 per 1,000 leads, no login.**

For POS sellers, distributors, insurers, equipment and staffing firms. New bars, restaurants and stores before they open, in one schema, with an only-new daily feed. Your first run with the example input costs about $0.03 (30 leads in our test run).

[![Liquor License Applications: 75-second demo video](https://api.apify.com/v2/key-value-stores/twkCCtTWzsi8fVbx5/records/liquor-license-applications-demo-thumb-v1.png)](https://api.apify.com/v2/key-value-stores/twkCCtTWzsi8fVbx5/records/liquor-license-applications-demo-v1.mp4)

**[▶ Watch the 75-second demo](https://api.apify.com/v2/key-value-stores/twkCCtTWzsi8fVbx5/records/liquor-license-applications-demo-v1.mp4)**

| | |
|---|---|
| **Regulators** | California ABC, Texas TABC, New York SLA, Missouri ATC, Washington LCB, Ontario AGCO |
| **Filters** | States, status (applied, pending, issued), new or transfer, license type, city, last N days or since date (up to 90) |
| **Output** | 29 fields per lead; JSON, CSV, Excel, API |
| **Automate** | Schedules, webhooks, Slack digest, Zapier, Make, n8n, Google Sheets, MCP for AI agents |
| **Price** | $0.90 per 1,000 leads ($0.70 per 1,000 leads on paid Apify plans) |
| **Free to try** | Runs on Apify's free plan: the $5 monthly credit covers about 5,500 leads |
| **Login needed** | No |

### Daily monitor: only what's new, every morning

Set it once, get only the new leads every morning. With **Only new since last run** on, the first run returns everything that matches; each later run returns only applications and licenses it has not returned before. If a run stops at 'Max results per state', the rest arrive on the next runs.

```json
{
  "states": [
    "CA",
    "TX"
  ],
  "daysBack": 7,
  "statuses": [
    "applied",
    "pending"
  ],
  "applicationTypes": [
    "new"
  ],
  "incremental": true,
  "stateKey": "ca-tx-daily"
}
```

1. Paste this input into the **Input** tab (JSON view) and click **Save as a new task**; it appears under **Saved tasks**.
2. Open the task from **Saved tasks** and click **Schedule**.
3. Choose **Daily**, pick the hour, and save.

**Cost example:** California and Texas, about 25 new applications a day ≈ $0.77/month on the free plan ($0.62 on paid plans): one run a day for 30 days, start fee included. The first run returns everything that matches, so it costs more.

Add a Slack incoming-webhook URL in `slackWebhookUrl` (or any URL in `webhookUrl`) to get a short digest of each run's new leads; nothing is sent when a run finds nothing.

### Why Liquor License Applications users pick this one

- **Six regulators, one schema.** California, Texas, New York, Missouri, Washington and Ontario.
- **Cheaper per lead.** $0.90 per 1,000 leads, $0.70 on paid plans.
- **Leads before opening day.** Applications as filed, plus new licenses, not renewals.
- **Only new, every day.** Each application or license comes back once.
- **No personal data.** Owners' names, phones and home addresses left out.

### Get started in 3 steps

1. Pick the states (California, Texas, New York, Missouri, Washington, Ontario) and how many days back; the defaults return the last 7 days of applications and new licenses from all six, up to 2,000 per state.
2. Optionally narrow it: status (applied, pending, issued), new or transfer, license type words such as 'eating place' or 'mixed beverage', and cities; turn on 'Only new since last run' for a daily feed.
3. Click Start, then download JSON, CSV or Excel, or schedule the run and send new leads to Google Sheets, a CRM, Slack, Zapier, Make or n8n.

**[▶ Try it with the example input](https://apify.com/aurelix/liquor-license-applications)**

The form opens with an example input already filled in: that run costs about $0.03 on the free plan.

### How much does it cost to get liquor license applications?

Pay per event: you pay only for what the run returns, plus a small start fee. Bronze, Silver, Gold and higher Apify plans pay less per result.

| Leads | Free plan | Paid plans (Bronze, Silver, Gold) |
|---|---|---|
| 100 | $0.093 | $0.073 |
| 1,000 | $0.90 | $0.70 |
| 10,000 | $9.00 | $7.00 |

Totals include the $0.003 start fee per run, rounded to the cent (amounts under $0.10 to four decimals). Apify's free plan includes $5 of credit a month, enough for about 5,500 leads.

States whose regulators had nothing new cost nothing; the start fee covers reading the sources when your filters match nothing. No proxy is used.

#### Billing events

| Event | Free plan | Paid plans (Bronze, Silver, Gold) |
|---|---|---|
| `license-lead` | $0.90 per 1,000 leads | $0.70 per 1,000 leads |
| `apify-actor-start` | $0.003 per run | $0.003 per run |

### Benchmarks: how we compare

| Test | Input | Result | Run time |
|---|---|---|---|
| First run (prefilled input) | California, New York and Texas, 10 per state | 30 leads for $0.030 in total | 4 s |
| All six regulators | 7 days back, default filters | 1,048 leads (CA 200, TX 296, NY 301, MO 146, WA 11, ON 94) | 17 s (local) |
| Daily monitor repeat | the same input again with only-new on | 0 new leads, no lead returned twice, only the start fee | 36 s |
| Nothing matches | all regulators, 90 days back, every status, a city that does not exist | 0 leads, only the start fee | 36 s |
| Regulators down | California not answering, default input | 848 leads from the other five; the status names California as down; nothing charged for it | local |
| Field accuracy | 20 random records checked against the regulators' source rows | 20 of 20 matched |  |
| Completeness | one week, every dataset with a count | TX 155/155 and 141/141, NY 134/134, MO 146/146, Ontario applications 68/68 |  |
| New licenses only | New York and Ontario licenses issued in one week | 167 of 444 New York and 26 of 83 Ontario rows are first issues; renewals and re-issues are left out |  |
| Privacy | 16,224 records over 90 days checked against the full source rows | 0 owner, applicant, signee or contact names, phones, emails, PO boxes or mailing addresses in the output |  |

Apify cloud runs at the default 256 MB with no proxy unless marked (local): those were measured on our server against the live regulators with the same code. Accuracy, completeness and privacy come from our release checks. Run times depend mostly on how fast each regulator answers.

### What data you get

**Liquor License Applications** collects new liquor license applications and new (first-issue) liquor licenses from the regulators' own public data: California ABC (daily new-applications report), Texas TABC, New York State Liquor Authority, Missouri ATC, Washington LCB and Ontario AGCO. Renewals and re-issues of existing licenses are left out. Each lead comes in one 29-field schema: trade name, legal entity (organisations only), license type and code, normalised status (applied, pending, issued), new, transfer or change of location, application and issue dates, premises address, city, county and ZIP, and a source link. Filter by state, status, application type, license type, city and date, and switch on the only-new mode for a daily lead feed of bars, restaurants and stores about to open.

- Trade name (doing business as) and legal entity (companies and organisations only)
- License type in words and the regulator's code; license, application or file number
- Status normalised to applied, pending, issued or inactive, plus the status as published
- Application type: new, transfer to a new owner, change of location or amendment, plus the type as published
- Application date, issue date and (Ontario) the public-notice deadline, all YYYY-MM-DD
- Premises street address, city, county, state or province and ZIP or postal code; latitude and longitude in New York and Washington (where published)
- Licensing state, regulator, source dataset and a source link (the license page in California)

| state | status | date | dba | business_name | license_type | city | application_type |
|---|---|---|---|---|---|---|---|
| CA | applied | 2026-11-13 | THE OLD GERMAN DELICATESSEN | WADE HOSPITALITY GROUP | On-Sale Beer | Big Bear Lake | transfer |
| TX | pending | 2026-11-13 | Salon Monte Carlo | Salon Monte Carlo LLC | Food and Beverage Certificate | Garland | new |
| NY | applied | 2026-11-13 | TRINITY OPULENCE | TRINITY PROVINCE LLC | Catering Establishment | Hempstead | new |
| NY | issued | 2026-11-13 | OTANI ASIAN FOOD | OTANI ASIAN FOOD INC. | Temporary retail | Binghamton | new |
| ON | issued | 2026-11-13 | LEGENDS TAPHOUSE AND GRILL | 2269223 Ontario Incorporated | Liquor Sales Licence | PARIS | new |

One full lead record, exactly as a real run returned it (long text and lists shortened here). From a real run:

```json
{
  "id": "ca-applications:684294|41",
  "state": "CA",
  "state_name": "California",
  "country": "US",
  "source": "ca-applications",
  "regulator": "California Department of Alcoholic Beverage Control",
  "status": "applied",
  "status_raw": "PEND",
  "application_type": "new",
  "application_type_raw": "ORI",
  "date": "2026-11-13",
  "application_date": "2026-11-13",
  "issue_date": null,
  "notice_deadline": null,
  "license_type": "On-Sale Beer and Wine - Eating Place",
  "license_type_code": "41",
  "license_number": "684294",
  "application_number": "684294",
  "business_name": "COMMUNAL CO LLC",
  "dba": "COMMUNAL COFFEE",
  "address": "329 S. HIGHWAY 101, STE. 120",
  "city": "Solana Beach",
  "county": null,
  "premises_state": "CA",
  "zip": "92075",
  "latitude": null,
  "longitude": null,
  "source_url": "https://www.abc.ca.gov/licensing/license-lookup/single-license/?RPTTYPE=12&LICENSE=684294",
  "scraped_at": "2026-11-14T14:27:41Z"
}
```

### Use cases

- POS, payments and restaurant software sellers reaching bars and restaurants before they open
- Beer, wine and spirits distributors and suppliers finding new on-premise and off-premise accounts
- Insurance brokers quoting liquor liability for new licensees
- Restaurant equipment, staffing, cleaning, signage and security firms building a weekly prospect list
- Analysts tracking new bar, restaurant and liquor store openings by state and city

### Use-case recipes

#### New restaurant leads every morning

For POS, payments and restaurant-software sellers. Pick your states, keep applied and pending applications of type 'new', and add license-type words for restaurants ('eating place', 'mixed beverage', 'restaurant'). Turn on 'Only new since last run' and schedule it daily; send `dba`, `address`, `city` and `license_type` to your CRM.

```json
{
  "states": [
    "CA",
    "TX",
    "NY"
  ],
  "daysBack": 7,
  "statuses": [
    "applied",
    "pending"
  ],
  "applicationTypes": [
    "new"
  ],
  "licenseTypes": [
    "eating place",
    "mixed beverage",
    "restaurant"
  ],
  "incremental": true,
  "stateKey": "restaurant-leads"
}
```

#### New accounts for distributors

For beer, wine and spirits distributors. Keep issued licenses of every type in your territory's cities, weekly, with the only-new mode: each new license holder comes once.

```json
{
  "states": [
    "TX",
    "MO",
    "NY"
  ],
  "daysBack": 7,
  "statuses": [
    "issued"
  ],
  "cities": [
    "Houston",
    "Kansas City",
    "Saint Louis",
    "Brooklyn"
  ],
  "incremental": true,
  "stateKey": "distributor-accounts"
}
```

### Input

| Field | Type | What it does | Default |
|---|---|---|---|
| `states` (States and provinces) | array | Which regulators to read: 'CA' (California ABC daily new-applications report), 'TX' (TABC pending original applications and newly issued licenses), 'NY'... | \["CA", "TX", "NY", "MO", "WA", "ON"] |
| `maxResultsPerState` (Max results per state) | integer | Upper limit of results per state or province after filters, newest first. 0 = no limit. | 2000 |
| `daysBack` (Filed or issued in the last N days) | integer | Keep applications filed and licenses issued on or after today minus this many days (UTC). | 7 |
| `statuses` (Statuses) | array | Keep these normalised statuses: 'applied' (application received or filed), 'pending' (under review or on public notice), 'issued' (license granted), 'inactive'... | \["applied", "pending", "issued"] |
| `applicationTypes` (Application types) | array | Keep these kinds of application: 'new' (new license or original application), 'transfer' (new owner of an existing license), 'change_of_location', 'amendment'... |  |
| `licenseTypes` (License types) | array | Keep records whose license type or code contains one of these (case-insensitive), e.g. \['eating place', 'mixed beverage', 'restaurant', 'off-sale', 'brew']. |  |

All 12 fields, with examples: see the **Input** tab.

### Use with AI agents (MCP)

MCP (Model Context Protocol) is the open standard that lets AI assistants such as Claude, ChatGPT and Cursor call outside tools. Apify's hosted MCP server at `https://mcp.apify.com/?tools=aurelix/liquor-license-applications` gives your assistant this Actor only: it fills in the input from your request, runs it and reads the leads back, at the same per-result price as a run started by hand.

#### Example prompts

- "List new liquor license applications for restaurants in Los Angeles and Houston filed in the last 7 days, with trade name, license type and address"
- "Which bars and restaurants in New York City got a new liquor license this week? Give me a table of trade name, legal entity and address"
- "Find new off-premise liquor license applications in Texas and California this month and count them by city"

#### Claude Desktop and claude.ai

**Settings > Connectors > Add custom connector**, name it Apify, paste `https://mcp.apify.com/?tools=aurelix/liquor-license-applications`, keep the detected OAuth settings, select **Add** and sign in to Apify.

#### Claude Code

```bash
claude mcp add --transport http apify "https://mcp.apify.com/?tools=aurelix/liquor-license-applications"
```

#### Cursor and VS Code

Add this to `~/.cursor/mcp.json` (Cursor); in VS Code's `.vscode/mcp.json` put the same entry under `"servers"` with `"type": "http"`. Sign in to Apify when asked.

```json
{
  "mcpServers": {
    "apify": {
      "url": "https://mcp.apify.com/?tools=aurelix/liquor-license-applications"
    }
  }
}
```

#### ChatGPT

Turn on **Developer mode**, open **Settings > Apps & Connectors > Create**, paste the URL above as the MCP server URL, choose **OAuth** and authorize Apify.

Clients without sign-in send `Authorization: Bearer <YOUR_APIFY_TOKEN>` instead. No Apify account? This Actor supports Apify's agentic payments: an agent can pay per run with a prepaid, spend-capped token, bought with x402 stablecoin payments.

#### n8n AI agent

Give an **AI Agent** node an **MCP Client Tool** with the endpoint `https://mcp.apify.com/?tools=aurelix/liquor-license-applications` and a Bearer credential holding your Apify token.

### Use it from AI agents (MCP), the API or no-code

#### Copy this to your AI assistant

```text
Use the Apify Actor aurelix/liquor-license-applications (Liquor License Applications) through Apify's MCP server or API. Main input: states (States and provinces); maxResultsPerState (Max results per state). Example input: {"states": ["CA", "TX"], "daysBack": 7, "statuses": ["applied", "pending"], "applicationTypes": ["new"], "licenseTypes": ["eating place", "mixed beverage"], "incremental": true, "stateKey": "ca-tx-new-restaurants"}. Each result is one lead with fields such as id, state, state_name, country, source, regulator, status, status_raw. It costs $0.90 per 1,000 leads on Apify's free plan plus a $0.003 start fee per run, and needs no login.
```

MCP server URL for this Actor: `https://mcp.apify.com/?tools=aurelix/liquor-license-applications` (setup for each client in the section above).

#### API

Start a run and read the dataset with Apify's REST API or the Python and JavaScript clients:

```python
from apify_client import ApifyClient

client = ApifyClient("<YOUR_APIFY_TOKEN>")
run = client.actor("aurelix/liquor-license-applications").call(run_input={'states': ['CA', 'TX'], 'daysBack': 7, 'statuses': ['applied', 'pending'], 'applicationTypes': ['new'], 'licenseTypes': ['eating place', 'mixed beverage'], 'incremental': True, 'stateKey': 'ca-tx-new-restaurants'})
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)
```

#### No-code: schedule it in 3 clicks

Send the results to Google Sheets, Zapier, Make, n8n, Slack or any webhook URL.

1. Fill in the input, then click **Save as a new task**.
2. In the task, click **Schedule** and pick daily or weekly (Apify Schedules).
3. Turn on **Only new since last run** so each run returns only what is new, and paste a Slack or webhook URL into **Slack webhook URL** / **Webhook URL** to get a digest of the new items (count plus the top 10) after every run.

Prefer n8n or Make? Ask in the **Issues** tab and we will share a ready-made workflow for it.

### FAQ

#### Can I get liquor license applications without login?

Yes. It never logs in, so you need no regulator account, password or cookies; only a free Apify account to run it.

#### Is there a liquor license applications API?

You can use this Actor as one. Start it with Apify's REST API or the Python and JavaScript clients and read the results as JSON (see the code above), or call it from an AI agent through MCP.

#### How much does it cost to get liquor license applications?

About $0.90 for 1,000 leads on Apify's free plan and $0.70 on paid plans, start fee included. The free $5 monthly credit covers about 5,500 leads.

#### Can I export liquor license applications to Excel or Google Sheets?

Yes. Download the results as Excel, CSV, JSON, XML or HTML from the run's **Storage** tab, or send them to Google Sheets with Apify's Google Sheets integration or the API.

#### Is it legal to use liquor license application data?

It reads only public data any logged-out visitor can see: the regulators' open-data APIs, California's published daily report and Ontario's open data files. It goes at a polite pace, never logs in and never solves CAPTCHAs. It returns license and premises fields and keeps a legal entity only when it is a company or organisation; owners', applicants' and signees' personal names, phone numbers and mailing addresses are not returned. People can ask for removal by opening an issue on this Actor's Issues tab; if a regulator formally asks us to stop, this Actor will stop. You are responsible for using the data lawfully, incl. anti-spam and privacy laws; this is not legal advice.

#### Is there a cheaper liquor license leads tool on Apify?

This Actor costs $0.90 per 1,000 leads ($0.70 on paid plans) plus $0.003 per run, cheaper per lead than the leading tools, and covers six regulators in one run with an only-new mode.

#### Can I send new liquor license leads to Google Sheets, n8n or an AI agent?

Yes. Schedule it daily with 'Only new since last run' on and send the dataset to Google Sheets, a webhook (Zapier, Make, n8n) or Slack, or call it from an AI agent through MCP.

#### Where does the data come from?

From each regulator's own public data: California ABC's Daily Report of New Applications (abc.ca.gov, public domain under the State's conditions of use), Texas TABC's Pending Original License Applications and License Information datasets (data.texas.gov), the New York State Liquor Authority's Current Pending and Active Licenses datasets (data.ny.gov, OPEN-NY terms), Missouri New Liquor Licenses (data.mo.gov), Washington LCB Local Authority Letters (data.wa.gov, public domain) and the Ontario AGCO's open liquor datasets (Open Government Licence – Ontario). Every record names its source dataset and links to it.

#### Does it include the owner's name, phone or email?

No. The legal entity is returned only when it is clearly a company or organisation (LLC, Inc, numbered company, club, association and similar); a person's name is left empty, and a trade name that repeats that person's name or reads like a person's name is left empty too. Applicants, signees, contacts (including 'ATTN' and 'C/O' lines), phone numbers, emails, PO boxes and mailing addresses are never returned. The premises (business) address is returned.

#### How fresh is it?

California posts a report each business day; Texas, New York, Missouri, Washington and Ontario update their datasets daily. Washington publishes only its newest notices (about the last day or two), so schedule Washington daily to catch every one.

#### Which license types are included?

Every type the regulator publishes: on-premise (restaurants, bars, taverns, clubs, hotels), off-premise (liquor, grocery and convenience stores), manufacturers (breweries, wineries, distilleries), caterers and event permits, wholesalers and others. Filter with 'License types' using words from the type, e.g. 'eating place' (California), 'mixed beverage' (Texas), 'restaurant' (New York) or 'brewery'.

#### What is the difference between applied, pending and issued?

Applied: the application was just received or filed (California's daily report, Texas 'Received', New York 'Intake complete', Washington notices). Pending: under review or on public notice (Texas 'Pending – In Review', New York 'Under review' or 'Conditionally approved', Ontario applications on public notice). Issued: a new license was granted (Texas, New York, Missouri and Ontario first issues; renewals and re-issues are left out). Inactive: withdrawn, cancelled, denied or closed. The status as published is kept in status_raw.

#### How does 'Only new since last run' work?

The Actor remembers every lead it returned for the same states and filters (or for the state name you set) and returns only leads it has not returned before. Memory lasts 120 days. A state whose source was down is retried in full on the next run.

#### Why do some leads have no business name?

When the license holder is a person rather than a company, the name is withheld, and so is a trade name that contains that person's name. Contact lines such as 'ATTN ...' or 'C/O ...' are removed from names and addresses. Some sources publish no legal entity (Ontario's pending list has only the premises name).

### Lawful use

- B2B use only: use the data for business purposes such as trade leads or market research.
- No spam: contact businesses only with relevant, individual business messages, identify yourself, and honour every opt-out at once.
- You are responsible for complying with the anti-spam and privacy laws that apply to you, including Canada's CASL, the US CAN-SPAM Act and the EU/UK GDPR.
- Removal requests: open an issue on this Actor's Issues tab naming the business or person to remove. It is added to our suppression list and honoured within 7 days.
- Legal entities are returned only when they are companies or organisations; owners', applicants' and signees' personal names, contact lines ('ATTN', 'C/O'), phone numbers, emails, PO boxes and mailing addresses are never returned, and trade names that contain or read like a person's name are withheld. Premises (business) addresses are returned. People can ask for removal by opening an issue on this Actor's Issues tab.

### Limits (stated honestly)

- Five US states (California, Texas, New York, Missouri, Washington) and Ontario, Canada. Other states' regulators do not publish new applications as open data that is updated at least weekly; open an issue to ask for one.
- California: new applications only (no separate issued feed); one record per license type applied for. Missouri: new licenses only. Washington: applications only. Texas and New York: pending applications and new licenses. New York and Ontario renewals and re-issues are left out, so a license re-issued to an existing venue is not a lead here.
- Ontario's pending list has no application date: every application on public notice (usually about 30 days) is returned regardless of the date filter, and the only-new mode returns each one once.
- Washington publishes only its newest notices (about one or two days), so a weekly run sees only the latest; schedule it daily.
- Legal entities that are persons, and trade names that repeat or read like a person's name, are left empty, so a few legitimate trade names (for example a restaurant named after its owner) are withheld too.
- Missouri data has been modified for use from its original source, which is the State of Missouri. The State of Missouri makes no representations or warranty as to the completeness, accuracy, timeliness or content of any data made available through this site; use is at your own risk.
- Up to 90 days back per run; no phone numbers or emails (the regulators either do not publish them or they belong to individuals).
- Ontario records contain information licensed under the Open Government Licence – Ontario.
- In 'Only new since last run' mode, leads cut off by 'Max results per state' are not marked as seen, so they arrive (and are charged) on the following runs; raise the cap for a long first run.
- Missouri's 'New Liquor Licenses' dataset is used as published: it lists licenses by their original date, and we could not confirm from the data alone that it never includes a re-issued license.

### Works great with

- **Then: [Google Maps Phone Scraper](https://apify.com/aurelix/google-maps-scraper)**: search each lead's `dba` and `city` there to get the venue's phone, website and whether it is open yet
- **Then: [Contact Page Scraper](https://apify.com/aurelix/contact-details-scraper)**: pass the venue or company websites found on Google Maps to get published business emails and contact pages

### Related Aurelix tools

Public Aurelix Actors, grouped by the data they collect. All are pay-per-result and need no login.

#### Leads and company data

- **[Companies House Scraper](https://apify.com/aurelix/companies-house-scraper)**: Newly incorporated UK companies from Companies House: SIC codes, region, registered office, directors with roles.
- **[Contact Page Scraper](https://apify.com/aurelix/contact-details-scraper)**: Published company emails, phones, addresses, social pages and team members from a list of company websites.
- **[Decision Maker Finder](https://apify.com/aurelix/decision-maker-finder)**: Founders, CEOs, VPs and department heads from company team pages, with title, seniority and function.
- **[FMCSA API](https://apify.com/aurelix/fmcsa-carrier-api)**: FMCSA carriers by DOT, MC or name, plus daily new-authority leads: contacts, fleet, cargo, insurance, out of service.
- **[Newly Funded Companies Hiring](https://apify.com/aurelix/funded-companies-hiring)**: Companies that just raised money (SEC Form D), with their open roles and business contacts, as a new-only monitor.
- **[Google Maps Phone Scraper](https://apify.com/aurelix/google-maps-scraper)**: Local business lists from Google Maps: phones, websites, ratings, hours, coordinates; optional website emails and socials.
- **[New Business Licenses Scraper](https://apify.com/aurelix/new-business-licenses)**: Newly licensed businesses from 11 US and Canadian city open-data portals in one schema, with category, issue date and address.
- **[Recently Funded Companies API](https://apify.com/aurelix/recently-funded-companies)**: US companies that just filed an SEC Form D: amount raised, industry, state, executives, confirmed website.
- **[Tech Stack API](https://apify.com/aurelix/tech-stack-detector)**: CMS, e-commerce platform, analytics, ad pixels, chat, CDN and email provider for each domain you enter.
- **[Yellow Pages Canada Scraper](https://apify.com/aurelix/yellow-pages-canada-scraper)**: YellowPages.ca businesses by search term and city: phone, website, address, postal code, hours and rating.

#### Jobs and hiring data

- **[Job Bank Canada Scraper API](https://apify.com/aurelix/job-bank-canada-scraper)**: Official Job Bank Canada postings by month: NOC and NAICS codes, wages, hours and location.
- **[Greenhouse Jobs Scraper](https://apify.com/aurelix/greenhouse-jobs-scraper)**: Live jobs from a company's Greenhouse, Lever, Ashby or SmartRecruiters board, with salary and Canadian province tags.
- **[Career Page Monitor](https://apify.com/aurelix/hiring-signal-monitor)**: New, removed and reposted roles plus hiring velocity per company, from seven job-board systems including Workday.
- **[LinkedIn Jobs Country Filter Scraper](https://apify.com/aurelix/linkedin-jobs)**: Public LinkedIn job postings by keyword and country: title, company, location, seniority, job type, salary text, description.
- **[Multiple Job Boards Scraper](https://apify.com/aurelix/multi-job-board-scraper)**: LinkedIn, about 50 company career sites, Remote OK and We Work Remotely jobs in one deduplicated list.
- **[Remote Job Board Scraper API](https://apify.com/aurelix/remote-jobs-scraper)**: Remote OK and We Work Remotely jobs in one deduplicated list with salary, regions and tags.
- **[Wellfound Jobs API & Scraper](https://apify.com/aurelix/wellfound-jobs-scraper)**: Wellfound startup jobs with salary and equity ranges, company stage and size, $0.50 per 1,000.
- **[Workday Job Postings Scraper](https://apify.com/aurelix/workday-jobs-scraper)**: Jobs from any Workday career site by link or company name, with full descriptions and Canadian province tags.

#### E-commerce and product data

- **[AliExpress Scraper API](https://apify.com/aurelix/aliexpress-product-search)**: AliExpress search results by keyword: price, discount, rating, units sold, ship-from country and sponsored flag.
- **[Amazon Best Sellers & Amazon New Releases](https://apify.com/aurelix/amazon-best-sellers)**: Amazon Best Sellers and New Releases top 100 on 10 marketplaces: rank, ASIN, price, rating, rank change.
- **[Best Buy Canada Scraper API](https://apify.com/aurelix/best-buy-canada-scraper)**: Best Buy Canada search results: CAD price, sale savings, rating, reviews and seller, plus optional UPC and specs.
- **[Shopify App Store Scraper](https://apify.com/aurelix/shopify-app-store-scraper)**: Shopify App Store apps with pricing plans, ratings, category ranks and reviews; new-app and new-review watch.
- **[Shopify Product Export Scraper](https://apify.com/aurelix/shopify-products-scraper)**: Every public product of any Shopify store with variants, SKUs, prices, barcodes, stock counts and collections.
- **[Shopify Best Sellers Tracker](https://apify.com/aurelix/shopify-best-sellers-tracker)**: Competitor Shopify stores' best-sellers, new products, price changes, stock-outs and restocks since your last run, plus catalogue summary.

#### Ad intelligence

- **[Competitor Watch](https://apify.com/aurelix/competitor-watch)**: One report per competitor with only what is new: Meta and TikTok ads, page changes, Shopify products and prices, jobs.
- **[Facebook Ad Library Search & API](https://apify.com/aurelix/facebook-ad-library-scraper)**: Facebook and Instagram business ads from the Meta Ad Library: copy, creatives, landing pages, dates, optional EU reach.
- **[TikTok Ads Library API](https://apify.com/aurelix/tiktok-ads-library-scraper)**: TikTok Ads Library ads for Europe, UK, Switzerland and Turkey with targeting, reach, ad text and landing pages.

#### Canada and government data

- **[Canada Building Permits](https://apify.com/aurelix/canada-building-permits-scraper)**: Building permits and development applications from 7 Canadian cities: address, type, status, dates, value, applicant, contractor and Toronto planner contact.
- **[Government Tenders Scraper](https://apify.com/aurelix/government-tenders-scraper)**: Open tenders from SAM.gov, CanadaBuys and EU TED in one table: buyer, codes, value, deadline, contact and link.
- **[New York Building Permits Scraper](https://apify.com/aurelix/building-permits-scraper)**: Building permits from 12 US city open-data portals in one schema, with value, status, contractor, owner and applicant.
- **[USPTO Trademark API](https://apify.com/aurelix/uspto-trademark-search)**: US trademark search and watch from USPTO: mark, owner or number lookups, new filings, owner, attorney, goods.

#### AI, content and SEO

- **[Google Maps Rank Tracker](https://apify.com/aurelix/google-maps-rank-tracker)**: Extract Google Maps local rankings on a geo-grid at $1.00 per 1,000 grid points on the free plan: your rank...
- **[Google Trends by Region](https://apify.com/aurelix/google-trends-scraper)**: Google Trends interest over time, by region and rising queries for any number of keywords, plus trending searches.
- **[Google Autocomplete API](https://apify.com/aurelix/google-autocomplete-scraper)**: Expands seed keywords into hundreds of real Google and YouTube autocomplete phrases, tagged by search intent.
- **[PDF Table Extraction & PDF to Markdown OCR](https://apify.com/aurelix/pdf-to-markdown)**: Turns linked PDF and Word files into Markdown per page, with tables as JSON rows, RAG chunks and OCR.
- **[Website to Knowledge Base Sync](https://apify.com/aurelix/rag-site-sync)**: Turns a website into knowledge base chunks with stable IDs, then returns only chunks to upsert or delete.
- **[Broken Link Crawler & SEO Audit](https://apify.com/aurelix/seo-audit-crawler)**: Audits a whole site: one row per page with SEO checks and broken links, plus a ranked issues summary.
- **[Bulk TikTok Transcripts Scraper](https://apify.com/aurelix/tiktok-transcript-scraper)**: Returns TikTok video transcripts as text, timed segments and SRT, from video links or @profiles' latest videos.
- **[Website Change Tracker](https://apify.com/aurelix/website-change-monitor)**: Re-checks a site and returns only added, changed and deleted pages, with chunks to upsert and IDs to delete.
- **[Bulk Website Screenshot Tool](https://apify.com/aurelix/website-screenshot)**: Full-page screenshots or PDFs of a list of URLs, cookie banners hidden, lazy images loaded, a public link per image.
- **[Website to Markdown API](https://apify.com/aurelix/website-to-markdown)**: Crawls a site and returns one row of clean main-content Markdown per page, with title, headings and links.
- **[YouTube Transcript Scraper](https://apify.com/aurelix/youtube-transcript-scraper)**: Returns YouTube video transcripts as text, timed segments and AI chunks, from videos, channels, playlists or searches.
- **[YouTube Video Scraper API](https://apify.com/aurelix/youtube-video-scraper)**: Full details for every YouTube video in a search, channel or playlist: views, likes, comments, tags, publish time.

#### More data tools

- **[Agoda API (Unofficial)](https://apify.com/aurelix/agoda-reviews-scraper)**: Scrape Agoda guest reviews at $0.50 per 1,000 with this unofficial Agoda API, cheaper than the leading tools: Agoda and...
- **[Merge CSV Files & Datasets: Remove Duplicates, Excel, JSON](https://apify.com/aurelix/dataset-merge-dedup)**: Merges datasets, CSV, JSON and Excel files and removes duplicates with careful URL, email and number matching.
- **[Polymarket Odds Tracker](https://apify.com/aurelix/polymarket-odds-tracker)**: Polymarket outcomes with implied probability, bid/ask, volume and results, plus price history and price-move alerts.
- **[Tennis Betting Odds Scraper](https://apify.com/aurelix/tennis-odds-scraper)**: Tennis results and upcoming matches with opening and closing odds per bookmaker and implied probabilities.

### Recent changes

- **0.1**: First release: California, Texas, New York, Missouri, Washington and Ontario; applications and new licenses in one schema (New York and Ontario renewals left out); only-new mode; owners' personal names and contact lines withheld.

The full history is on the **Changelog** tab.

### Tested daily

An automated health check runs this Actor every day on a fixed input and checks that at least 15 leads come back with `id`, `state`, `state_name`, `country`, `source`, `regulator` filled in; a failed check alerts the maintainer straight away.

### Was this useful?

- **Something went wrong?** [Open an issue](https://apify.com/aurelix/liquor-license-applications/issues) and tell us what you ran: we answer fast and aim to reply within a day.
- **It worked?** [Leave a review](https://apify.com/aurelix/liquor-license-applications/reviews): it takes a minute and helps other people find this tool.

# Changelog

This Actor's version history is a separate document: https://apify.com/aurelix/liquor-license-applications/changelog.md

# Actor input Schema

## `states` (type: `array`):

Which regulators to read: 'CA' (California ABC daily new-applications report), 'TX' (TABC pending original applications and newly issued licenses), 'NY' (State Liquor Authority pending applications and first-issue licenses; renewals and re-issues left out), 'MO' (new Missouri liquor licenses), 'WA' (Liquor and Cannabis Board notices of new applications), 'ON' (Ontario AGCO applications on public notice and new licences; re-issues of older licences left out). Example: \['CA', 'TX'].

## `daysBack` (type: `integer`):

Keep applications filed and licenses issued on or after today minus this many days (UTC). Example: 1 for a daily feed, 7 for a weekly one. At most 90. Ignored when 'Since date' is set.

## `sinceDate` (type: `string`):

Keep records dated on or after this day instead of 'last N days', e.g. 2026-01-31 (YYYY-MM-DD, at most 90 days back).

## `statuses` (type: `array`):

Keep these normalised statuses: 'applied' (application received or filed), 'pending' (under review or on public notice), 'issued' (license granted), 'inactive' (withdrawn, cancelled, denied or closed). Empty = all.

## `applicationTypes` (type: `array`):

Keep these kinds of application: 'new' (new license or original application), 'transfer' (new owner of an existing license), 'change_of_location', 'amendment' (change to an existing license). Empty = all.

## `licenseTypes` (type: `array`):

Keep records whose license type or code contains one of these (case-insensitive), e.g. \['eating place', 'mixed beverage', 'restaurant', 'off-sale', 'brew']. Empty = all.

## `cities` (type: `array`):

Keep records whose premises city is one of these (case-insensitive, exact), e.g. \['Houston', 'Los Angeles', 'Brooklyn']. Empty = all.

## `maxResultsPerState` (type: `integer`):

Upper limit of results per state or province after filters, newest first. 0 = no limit.

## `incremental` (type: `boolean`):

Return only leads not returned by a previous run with the same states and filters. Use with a daily schedule for a new-leads feed.

## `stateKey` (type: `string`):

Name for the 'only new since last run' memory. Leave empty to derive it from the states and filters; set it to keep separate feeds apart, e.g. 'tx-restaurants'.

## `slackWebhookUrl` (type: `string`):

After each run, post a short digest to Slack: how many results were saved (new ones only when 'Only new since last run' is on) and the top 10 with links, e.g. https://hooks.slack.com/services/T000/B000/XXXX. Nothing is posted when the run saved nothing. Leave empty to skip.

## `webhookUrl` (type: `string`):

After each run, POST the same digest as JSON (actor, newOnly, count, items = top 10 results, runUrl, text) to any URL, e.g. a Zapier, Make or n8n webhook. Nothing is sent when the run saved nothing. Leave empty to skip.

## Actor input object example

```json
{
  "states": [
    "CA",
    "NY",
    "TX"
  ],
  "daysBack": 7,
  "statuses": [
    "applied",
    "pending",
    "issued"
  ],
  "applicationTypes": [],
  "licenseTypes": [],
  "cities": [],
  "maxResultsPerState": 10,
  "incremental": false
}
```

# Actor output Schema

## `leads` (type: `string`):

All new liquor license applications and newly issued licenses found in this run, one item per application or license.

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {
    "states": [
        "CA",
        "NY",
        "TX"
    ],
    "maxResultsPerState": 10
};

// Run the Actor and wait for it to finish
const run = await client.actor("aurelix/liquor-license-applications").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {
    "states": [
        "CA",
        "NY",
        "TX",
    ],
    "maxResultsPerState": 10,
}

# Run the Actor and wait for it to finish
run = client.actor("aurelix/liquor-license-applications").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
for item in client.dataset(run.default_dataset_id).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{
  "states": [
    "CA",
    "NY",
    "TX"
  ],
  "maxResultsPerState": 10
}' |
apify call aurelix/liquor-license-applications --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "type": "http",
            "url": "https://mcp.apify.com/?tools=fetch-actor-details,aurelix/liquor-license-applications"
        }
    }
}
```

The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer <APIFY_API_TOKEN>` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations).

## OpenAPI specification

Download the OpenAPI definition: https://api.apify.com/v2/actors/ZIqcRDWxP1QIaLlCT/builds/tyzf9kczcOkunEe5P/openapi.json