# Liquor License New Openings Tracker — Bar & Restaurant Leads (`malonestar/liquor-license-new-openings-tracker`) Actor

Pre-opening bar & restaurant leads from state liquor registries. Pulls NEW licenses + PENDING applications from TX TABC, NY SLA, FL DBPR — normalized business type, address, owner, dates. Delta mode emits only new applications, newly issued licenses, and status changes.

- **URL**: https://apify.com/malonestar/liquor-license-new-openings-tracker.md
- **Developed by:** [Kyle Maloney](https://apify.com/malonestar) (community)
- **Categories:** Lead generation, Agents, Developer tools
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

from $8.25 / 1,000 results

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/platform/actors/running/actors-in-store#pay-per-event

## What's an Apify Actor?

Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases.
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.
Actors are written with capital "A".

## 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.
The best way to integrate Actors is as follows.

In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js/docs.md):

```bash
npm install apify-client
```

In Python projects, use official [Python client library](https://docs.apify.com/api/client/python/docs.md):

```bash
pip install apify-client
```

In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md):

````bash
# MacOS / Linux
curl -fsSL https://apify.com/install-cli.sh | bash
# Windows
irm https://apify.com/install-cli.ps1 | iex
```bash

In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/integrations/mcp.md).

If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md).

For usage examples, see the [API](#api) section below.

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).


# README

## Liquor License New Openings Tracker — TX, NY, FL Pre-Opening Leads

A **multi-state liquor-license lead feed** for hospitality vendors. A liquor-license
**application** is the earliest public signal that a bar, restaurant, or liquor store
is opening — typically **60–90 days before doors open**, before the venue has a
website, a phone number, or a POS contract. This actor pulls **pending applications**
and **newly issued licenses** straight from official state registries and normalizes
them into one clean, sales-ready schema.

- **Texas (TABC)** — active licenses + pending original applications (data.texas.gov)
- **New York (SLA)** — active licenses + pending applications (data.ny.gov)
- **Florida (DBPR ABT)** — licensed-file extract, active licenses (myfloridalicense.com)
- **California (ABC)** — scaffolded for **v1.1** (see FAQ)

All sources are official, keyless open-data endpoints — no scraping, no logins, no keys.

### Who buys these leads (who it's for)

- **Beverage distributors & brand reps** — reach a new bar before the first order is placed.
- **POS, payments & reservation platforms** — new restaurants buy their stack in the pre-opening window.
- **Insurance agents** (liquor liability, GL) — every new license needs coverage, often as a condition of the license.
- **Food-service suppliers, equipment dealers, linen/hood-cleaning services** — pre-opening procurement.
- **Commercial real-estate & market analysts** — track hospitality openings by city/county.
- **AI sales agents** — use it as an MCP tool to keep a CRM topped up with pre-opening leads.

### Example input

```json
{
  "states": ["TX", "NY"],
  "mode": "inventory",
  "feed": "pending",
  "maxResults": 200
}
````

Lead-feed setup: schedule the actor daily with `"mode": "delta"` and `"feed": "all"`.
The first run seeds a baseline (`event_type: "inventory"`); every later run emits **only**
`new_application`, `newly_issued`, and `status_change` events — each one a fresh lead.

Other useful inputs: `"city": "Austin"`, `"county": "Bronx"`, `"sinceDate": "2026-06-01"`.

### Output fields

Each record is one license or application:

| Field | Meaning |
|---|---|
| `state` | TX / NY / FL |
| `feed` | `pending` (application — pre-opening lead) or `active` (issued) |
| `event_type` | `inventory`, `new_application`, `newly_issued`, `status_change` |
| `business_name` | Trade name / DBA (falls back to owner/legal name) |
| `owner_name` | Owner / legal entity |
| `premise_address`, `city`, `county`, `zip` | Licensed premises location |
| `license_number` | License or application id |
| `license_class_raw` / `license_class_label` | State class code + decoded label |
| `business_type` | **Decoded**: `bar`, `restaurant`, `package_store`, `manufacturer`, `wholesaler`, `club`, `other` |
| `status` / `previous_status` | Current status (+ prior status on `status_change` events) |
| `issue_date` / `application_date` | Normalized `YYYY-MM-DD` |
| `source`, `source_url` | Upstream registry provenance |

### Use as an MCP tool

This actor is callable by AI agents (Claude, Cursor, etc.) via **mcp.apify.com** — the
input and output schemas are fully described at field level, so an agent can query
"new bar applications in San Antonio since June" and pipe the leads into a CRM without
custom glue code.

### FAQ

**How early are pending-application leads?**
States require the license before alcohol service, and applications are filed while
the venue is in build-out — typically 60–90 days pre-opening (varies by state and class).

**Which feed should I use for lead generation?**
`feed: "pending"` for the earliest signal; `feed: "all"` + `mode: "delta"` on a daily
schedule to also catch the moment a license is actually issued (`newly_issued`).

**Is California included?**
Not yet — CA ABC publishes daily issued/new-application/status-change exports at a
stable URL, but as a ZIP bundle whose layout couldn't be verified reliably at build
time. The CA adapter is scaffolded and disabled; it ships in v1.1. Requesting `"CA"`
today logs a warning and is skipped (never an error).

**What does Florida cover?**
The FL leg reads the DBPR ABT licensed-file extract `bd4006lic.csv` (active beverage
licenses; the sample profession file). Sibling extracts (bd4005/bd4002 — additional
beverage series) and a pending signal are planned for v1.1. FL contributes to the
`active` feed only.

**How is `business_type` decoded?**
Per-state maps: TX TABC permit codes (MB→bar, RM→restaurant, P/Q→package\_store,
W/X→wholesaler, N→club, BB/BW/G→manufacturer…), NY SLA class descriptions
(Restaurant, Tavern, Grocery/Liquor Store, Wholesale, Farm/Winery…), FL series
patterns (…COP→bar, …SRX→restaurant, …APS/PS→package\_store, 11xx→club). Unknown
codes are kept raw and typed `other` — nothing is dropped.

**Does an empty result cost anything?**
Pricing is per result record. A delta run where nothing changed emits 0 records and
costs only the platform's minimal run overhead.

**Is this legal to use?**
All data comes from official state open-data portals published for public reuse.
Verify license details with the issuing authority before relying on them for
compliance decisions; this is a lead-generation and monitoring tool, not legal advice.

# Actor input Schema

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

Which state liquor-license registries to query. Available: TX (TABC active + pending), NY (SLA active + pending), FL (DBPR licensed extract, active only). California (ABC) ships in v1.1.

## `feed` (type: `string`):

Which feed to pull. "pending" = new license APPLICATIONS (the earliest opening signal — a bar/restaurant typically opens 60-90 days later). "active" = recently ISSUED licenses (sorted newest first). "all" = both. Note: FL only has an active feed.

## `mode` (type: `string`):

"inventory" (default) returns a bounded roster slice, newest first — no state kept between runs. "delta" tracks licenses in the actor's key-value store: the first delta run seeds a baseline (emitted as event\_type=inventory); every later run emits ONLY changes — new\_application, newly\_issued, or status\_change. Schedule delta runs daily/weekly for a true lead feed.

## `city` (type: `string`):

Optional case-insensitive city substring filter (e.g. "Austin", "Brooklyn", "Miami"). Applied server-side on Socrata sources and client-side on the FL CSV.

## `county` (type: `string`):

Optional case-insensitive county substring filter (e.g. "Bexar", "Bronx").

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

Optional YYYY-MM-DD floor. Pending feeds: applications submitted/received on or after this date. Active feeds: licenses issued on or after this date.

## `maxResults` (type: `integer`):

Total cap on records emitted across all selected states and feeds (each record is one billable result). The cap is split evenly across source legs.

## Actor input object example

```json
{
  "states": [
    "TX",
    "NY"
  ],
  "feed": "pending",
  "mode": "inventory",
  "maxResults": 200
}
```

# Actor output Schema

## `results` (type: `string`):

The default dataset of lead records.

# 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": [
        "TX",
        "NY"
    ],
    "feed": "pending",
    "mode": "inventory",
    "maxResults": 200
};

// Run the Actor and wait for it to finish
const run = await client.actor("malonestar/liquor-license-new-openings-tracker").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": [
        "TX",
        "NY",
    ],
    "feed": "pending",
    "mode": "inventory",
    "maxResults": 200,
}

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

# Fetch and print Actor results from the run's dataset (if there are any)
print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
for item in client.dataset(run["defaultDatasetId"]).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": [
    "TX",
    "NY"
  ],
  "feed": "pending",
  "mode": "inventory",
  "maxResults": 200
}' |
apify call malonestar/liquor-license-new-openings-tracker --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "command": "npx",
            "args": [
                "mcp-remote",
                "https://mcp.apify.com/?tools=malonestar/liquor-license-new-openings-tracker",
                "--header",
                "Authorization: Bearer <YOUR_API_TOKEN>"
            ]
        }
    }
}

```

## OpenAPI specification

```json
{
    "openapi": "3.0.1",
    "info": {
        "title": "Liquor License New Openings Tracker — Bar & Restaurant Leads",
        "description": "Pre-opening bar & restaurant leads from state liquor registries. Pulls NEW licenses + PENDING applications from TX TABC, NY SLA, FL DBPR — normalized business type, address, owner, dates. Delta mode emits only new applications, newly issued licenses, and status changes.",
        "version": "1.0",
        "x-build-id": "QBwOMCRZmG4w1Rmq7"
    },
    "servers": [
        {
            "url": "https://api.apify.com/v2"
        }
    ],
    "paths": {
        "/acts/malonestar~liquor-license-new-openings-tracker/run-sync-get-dataset-items": {
            "post": {
                "operationId": "run-sync-get-dataset-items-malonestar-liquor-license-new-openings-tracker",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK"
                    }
                }
            }
        },
        "/acts/malonestar~liquor-license-new-openings-tracker/runs": {
            "post": {
                "operationId": "runs-sync-malonestar-liquor-license-new-openings-tracker",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor and returns information about the initiated run in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK",
                        "content": {
                            "application/json": {
                                "schema": {
                                    "$ref": "#/components/schemas/runsResponseSchema"
                                }
                            }
                        }
                    }
                }
            }
        },
        "/acts/malonestar~liquor-license-new-openings-tracker/run-sync": {
            "post": {
                "operationId": "run-sync-malonestar-liquor-license-new-openings-tracker",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK"
                    }
                }
            }
        }
    },
    "components": {
        "schemas": {
            "inputSchema": {
                "type": "object",
                "properties": {
                    "states": {
                        "title": "States",
                        "type": "array",
                        "description": "Which state liquor-license registries to query. Available: TX (TABC active + pending), NY (SLA active + pending), FL (DBPR licensed extract, active only). California (ABC) ships in v1.1.",
                        "items": {
                            "type": "string",
                            "enum": [
                                "TX",
                                "NY",
                                "FL"
                            ],
                            "enumTitles": [
                                "Texas (TABC)",
                                "New York (SLA)",
                                "Florida (DBPR ABT)"
                            ]
                        }
                    },
                    "feed": {
                        "title": "Feed",
                        "enum": [
                            "pending",
                            "active",
                            "all"
                        ],
                        "type": "string",
                        "description": "Which feed to pull. \"pending\" = new license APPLICATIONS (the earliest opening signal — a bar/restaurant typically opens 60-90 days later). \"active\" = recently ISSUED licenses (sorted newest first). \"all\" = both. Note: FL only has an active feed.",
                        "default": "pending"
                    },
                    "mode": {
                        "title": "Mode",
                        "enum": [
                            "inventory",
                            "delta"
                        ],
                        "type": "string",
                        "description": "\"inventory\" (default) returns a bounded roster slice, newest first — no state kept between runs. \"delta\" tracks licenses in the actor's key-value store: the first delta run seeds a baseline (emitted as event_type=inventory); every later run emits ONLY changes — new_application, newly_issued, or status_change. Schedule delta runs daily/weekly for a true lead feed.",
                        "default": "inventory"
                    },
                    "city": {
                        "title": "City filter",
                        "type": "string",
                        "description": "Optional case-insensitive city substring filter (e.g. \"Austin\", \"Brooklyn\", \"Miami\"). Applied server-side on Socrata sources and client-side on the FL CSV."
                    },
                    "county": {
                        "title": "County filter",
                        "type": "string",
                        "description": "Optional case-insensitive county substring filter (e.g. \"Bexar\", \"Bronx\")."
                    },
                    "sinceDate": {
                        "title": "Since date",
                        "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
                        "type": "string",
                        "description": "Optional YYYY-MM-DD floor. Pending feeds: applications submitted/received on or after this date. Active feeds: licenses issued on or after this date."
                    },
                    "maxResults": {
                        "title": "Max results",
                        "minimum": 1,
                        "maximum": 50000,
                        "type": "integer",
                        "description": "Total cap on records emitted across all selected states and feeds (each record is one billable result). The cap is split evenly across source legs.",
                        "default": 200
                    }
                }
            },
            "runsResponseSchema": {
                "type": "object",
                "properties": {
                    "data": {
                        "type": "object",
                        "properties": {
                            "id": {
                                "type": "string"
                            },
                            "actId": {
                                "type": "string"
                            },
                            "userId": {
                                "type": "string"
                            },
                            "startedAt": {
                                "type": "string",
                                "format": "date-time",
                                "example": "2025-01-08T00:00:00.000Z"
                            },
                            "finishedAt": {
                                "type": "string",
                                "format": "date-time",
                                "example": "2025-01-08T00:00:00.000Z"
                            },
                            "status": {
                                "type": "string",
                                "example": "READY"
                            },
                            "meta": {
                                "type": "object",
                                "properties": {
                                    "origin": {
                                        "type": "string",
                                        "example": "API"
                                    },
                                    "userAgent": {
                                        "type": "string"
                                    }
                                }
                            },
                            "stats": {
                                "type": "object",
                                "properties": {
                                    "inputBodyLen": {
                                        "type": "integer",
                                        "example": 2000
                                    },
                                    "rebootCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "restartCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "resurrectCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "computeUnits": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            },
                            "options": {
                                "type": "object",
                                "properties": {
                                    "build": {
                                        "type": "string",
                                        "example": "latest"
                                    },
                                    "timeoutSecs": {
                                        "type": "integer",
                                        "example": 300
                                    },
                                    "memoryMbytes": {
                                        "type": "integer",
                                        "example": 1024
                                    },
                                    "diskMbytes": {
                                        "type": "integer",
                                        "example": 2048
                                    }
                                }
                            },
                            "buildId": {
                                "type": "string"
                            },
                            "defaultKeyValueStoreId": {
                                "type": "string"
                            },
                            "defaultDatasetId": {
                                "type": "string"
                            },
                            "defaultRequestQueueId": {
                                "type": "string"
                            },
                            "buildNumber": {
                                "type": "string",
                                "example": "1.0.0"
                            },
                            "containerUrl": {
                                "type": "string"
                            },
                            "usage": {
                                "type": "object",
                                "properties": {
                                    "ACTOR_COMPUTE_UNITS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_WRITES": {
                                        "type": "integer",
                                        "example": 1
                                    },
                                    "KEY_VALUE_STORE_LISTS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_INTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_EXTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_SERPS": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            },
                            "usageTotalUsd": {
                                "type": "number",
                                "example": 0.00005
                            },
                            "usageUsd": {
                                "type": "object",
                                "properties": {
                                    "ACTOR_COMPUTE_UNITS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_WRITES": {
                                        "type": "number",
                                        "example": 0.00005
                                    },
                                    "KEY_VALUE_STORE_LISTS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_INTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_EXTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_SERPS": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}
```