# New Liquor License Leads β€” TX & CA (Restaurant/Bar Openings) (`rook-data-tools/new-liquor-license-leads`) Actor Fresh pre-opening restaurant & bar leads from official state liquor-license data (Texas TABC + California ABC). Pending applications + newly issued licenses, deduped between runs. Public government data only. - **URL**: https://apify.com/rook-data-tools/new-liquor-license-leads.md - **Developed by:** [Rook DataTools](https://apify.com/rook-data-tools) (community) - **Categories:** Lead generation, Business - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing Pay per event This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. 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 ## New Liquor License Leads β€” TX & CA (Restaurant & Bar Openings) **Fresh pre-opening restaurant and bar leads, straight from official state liquor-license records.** A new liquor-license application means a bar, restaurant, or store is opening in the next ~30–90 days β€” the perfect moment to reach them, before your competitors do. Built for sales teams that sell TO food-service businesses: - 🍽️ Restaurant suppliers & equipment dealers - πŸ’³ POS and merchant-services reps - 🍺 Beverage distributors - πŸ“‹ Insurance brokers & payroll providers - 🏒 Commercial real-estate and signage/build-out services ### Why this Actor is reliable It reads **official government sources**, not third-party directories: | State | Source | Freshness | |---|---|---| | Texas | Official TABC records β€” pending applications **and** newly issued licenses | Updated daily by the state | | California | Official ABC new-application records | Published every business day | Because the data comes straight from the state, there's nothing to block and nothing to break on a website redesign. Volume: Texas alone produced ~390 leads in a 7-day window (measured 2026-07-16). ### Two lead types - **`pending_application`** β€” license applied for; the business is in build-out/opening mode. Earliest signal. (TX + CA) - **`newly_issued`** β€” license granted; opening is imminent or just happened. Confirmed signal. (TX) ### Delta mode: only what's new Turn on **Only new since last run** and schedule the Actor daily or weekly: every run returns *only leads you haven't seen before*. Deduplication is per license number, so a business filing several subordinate permits at once (e.g. mixed-beverage + late-hours) shows up as **one** lead, not three. Pipe it straight into your CRM, a Google Sheet, Slack, or an n8n/Make/Zapier workflow via the Apify integrations. ### Output example ```json { "leadType": "pending_application", "state": "TX", "licenseNumber": "200200469", "applicationId": "623452", "licenseType": "BQ", "licenseTypeDescription": "Wine and Malt Beverage Retailer's Off-Premise Permit", "status": "Received", "businessName": "El Gato Drive Thru and BBQ", "ownerName": "El Gato Drive Thru and BBQ LLC", "address": "1104 N Garcia St STE A", "city": "Roma", "county": "Starr", "zip": "785845592", "eventDate": "2026-07-16", "source": "Texas Alcoholic Beverage Commission open data (pending applications)", "sourceUrl": "https://…official TABC record…", "scrapedAt": "2026-07-16T21:20:21.874Z" } ```` Filter by **county** (e.g. only Harris + Dallas) and by **license type code** (e.g. only `MB` mixed-beverage = full bars) right in the input. ### Notes & honest limits - License-type descriptions are decoded for the common codes (TX: MB, P, Q, BG, BQ, BW, BP, W, G, N, NT, FB, LH β€” CA: 20, 21, 40, 41, 42, 47, 48, 51, 57, 58). Rare codes pass through raw with `licenseTypeDescription: null` β€” never guessed. - CA rows carry the ABC action code in `status` (e.g. `PEND / ORI` = original application, `PER` = person-to-person transfer, `PRM` = premises transfer). Transfers are leads too β€” a location changing hands buys new services. - CA `businessName` comes from the report's `DBA:` line when present. - Trade names (`businessName`) come straight from the state records β€” filled on ~85% of TX rows (some filings list only the owning entity). A field the state left empty is simply omitted from that row, never emitted as a null column. - Coverage today: **TX + CA** β€” the two biggest restaurant markets. More states are planned; ask for yours in the Issues tab and it moves up the list. - All data comes from openly public government pages/APIs. No logins, no CAPTCHA bypassing, nothing gated. ### Scheduling recipe (recommended) 1. Set **Only new since last run** = on. 2. Create a Schedule: daily at 9am (or Mon/Thu for weekly digests). 3. Add an integration: Google Sheets append, Slack message, webhook, or Make/n8n/Zapier. Each run then delivers a clean drop of brand-new openings in your territory. # Actor input Schema ## `states` (type: `array`): Which states to pull leads from. TX uses the official TABC open-data API (most reliable). CA parses the ABC daily New Applications report. ## `leadTypes` (type: `array`): pending\_application = license applied for, business opening soon (earliest signal). newly\_issued = license granted, opening imminent/open (confirmed signal). CA source provides pending applications only. ## `sinceDays` (type: `integer`): How many days back to search (by application/issue date). For CA this is capped at 14 report days per run to stay polite to the state site. ## `counties` (type: `array`): Optional. Only return leads in these counties (case-insensitive, e.g. "Harris", "Los Angeles"). ## `licenseTypes` (type: `array`): Optional. Only return these raw license-type codes (e.g. TX: MB, BG, P β€” CA: 41, 47, 48). Leave empty for all. ## `onlyNewSinceLastRun` (type: `boolean`): When on, leads already returned by previous runs of this actor (per license/application number) are skipped β€” ideal for scheduled runs feeding a CRM. The first run returns everything in the window. ## `maxResults` (type: `integer`): Stop after this many leads (across all states). ## `socrataAppToken` (type: `string`): Optional data.texas.gov app token for higher rate limits. Works fine without one at normal volumes. ## Actor input object example ```json { "states": [ "TX", "CA" ], "leadTypes": [ "pending_application", "newly_issued" ], "sinceDays": 14, "onlyNewSinceLastRun": true, "maxResults": 1000 } ``` # 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 '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "states": [ "TX", "CA" ], "leadTypes": [ "pending_application", "newly_issued" ] }; // Run the Actor and wait for it to finish const run = await client.actor("rook-data-tools/new-liquor-license-leads").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 '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "states": [ "TX", "CA", ], "leadTypes": [ "pending_application", "newly_issued", ], } # Run the Actor and wait for it to finish run = client.actor("rook-data-tools/new-liquor-license-leads").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", "CA" ], "leadTypes": [ "pending_application", "newly_issued" ] }' | apify call rook-data-tools/new-liquor-license-leads --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=rook-data-tools/new-liquor-license-leads", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "New Liquor License Leads β€” TX & CA (Restaurant/Bar Openings)", "description": "Fresh pre-opening restaurant & bar leads from official state liquor-license data (Texas TABC + California ABC). Pending applications + newly issued licenses, deduped between runs. Public government data only.", "version": "1.0", "x-build-id": "ok6hCRIESE0dMbDwj" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/rook-data-tools~new-liquor-license-leads/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-rook-data-tools-new-liquor-license-leads", "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/rook-data-tools~new-liquor-license-leads/runs": { "post": { "operationId": "runs-sync-rook-data-tools-new-liquor-license-leads", "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/rook-data-tools~new-liquor-license-leads/run-sync": { "post": { "operationId": "run-sync-rook-data-tools-new-liquor-license-leads", "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", "uniqueItems": true, "type": "array", "description": "Which states to pull leads from. TX uses the official TABC open-data API (most reliable). CA parses the ABC daily New Applications report.", "items": { "type": "string", "enum": [ "TX", "CA" ], "enumTitles": [ "Texas (TABC open data)", "California (ABC daily report)" ] }, "default": [ "TX", "CA" ] }, "leadTypes": { "title": "Lead types", "uniqueItems": true, "type": "array", "description": "pending_application = license applied for, business opening soon (earliest signal). newly_issued = license granted, opening imminent/open (confirmed signal). CA source provides pending applications only.", "items": { "type": "string", "enum": [ "pending_application", "newly_issued" ], "enumTitles": [ "Pending applications (earliest signal)", "Newly issued licenses (confirmed)" ] }, "default": [ "pending_application", "newly_issued" ] }, "sinceDays": { "title": "Lookback window (days)", "minimum": 1, "maximum": 90, "type": "integer", "description": "How many days back to search (by application/issue date). For CA this is capped at 14 report days per run to stay polite to the state site.", "default": 14 }, "counties": { "title": "Counties filter", "type": "array", "description": "Optional. Only return leads in these counties (case-insensitive, e.g. \"Harris\", \"Los Angeles\").", "items": { "type": "string" } }, "licenseTypes": { "title": "License type codes filter", "type": "array", "description": "Optional. Only return these raw license-type codes (e.g. TX: MB, BG, P β€” CA: 41, 47, 48). Leave empty for all.", "items": { "type": "string" } }, "onlyNewSinceLastRun": { "title": "Only new since last run (delta mode)", "type": "boolean", "description": "When on, leads already returned by previous runs of this actor (per license/application number) are skipped β€” ideal for scheduled runs feeding a CRM. The first run returns everything in the window.", "default": true }, "maxResults": { "title": "Max results", "minimum": 1, "maximum": 50000, "type": "integer", "description": "Stop after this many leads (across all states).", "default": 1000 }, "socrataAppToken": { "title": "Socrata app token (optional)", "type": "string", "description": "Optional data.texas.gov app token for higher rate limits. Works fine without one at normal volumes." } } }, "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 } } } } } } } } } } ```