# New York Liquor License Search — Official State SLA Open Data (`keeganlabs/ny-liquor-licenses`) Actor Every active New York State Liquor Authority (SLA) license and temporary permit from the state's official open-data feed (~60k records), refreshed daily. Legal & trade name, license class, issue/expiration dates, premises address, county, geocoordinates. Filter by county, city, ZIP, class, or name. - **URL**: https://apify.com/keeganlabs/ny-liquor-licenses.md - **Developed by:** [Keegan Labs](https://apify.com/keeganlabs) (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 usage This Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage, which gets cheaper the higher subscription plan you have. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-usage ## What's an Apify Actor? Actors are web data automations that power AI and operations. They run on the Apify platform to scrape websites, process data, connect APIs, and automate workflows. 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 York Liquor License Search — Official State SLA Open Data **Every active New York liquor license, refreshed daily.** This actor pulls the full registry of active licenses and temporary permits published by the **New York State Liquor Authority (SLA)** — roughly **60,000 records** covering every restaurant, bar, grocery, liquor store, club, hotel, winery, brewery, wholesaler, and distributor licensed to sell or manufacture alcohol in New York State — and hands them back as clean, structured JSON you can filter, dedupe, and load straight into a CRM or database. Data comes directly from New York's official open-data portal ([data.ny.gov](https://data.ny.gov/Economic-Development/Current-Liquor-Authority-Active-Licenses/9s3h-dpkz), dataset `9s3h-dpkz`, "Current Liquor Authority Active Licenses"). It is affirmatively public government open data, refreshed **daily** by the state. No scraping of login-walled or private pages — this is a polite client for the state's documented Socrata API. ### Who buys this - **Alcohol distributors & beverage wholesalers** — a live, statewide prospect list of every on- and off-premise account, filtered by county, city, or license class. - **POS, payments & fintech vendors** — target newly licensed restaurants and bars the week they come online (filter by original issue date). - **Restaurant, bar & hospitality suppliers** — food service, glassware, kegs, tap systems: every new establishment, with premises address and geocoordinates. - **Commercial real estate & brokers** — track licensed premises by ZIP and county; spot expirations for tenant turnover signals. - **Compliance, AML/KYC & risk teams** — verify a counterparty's active NY alcohol license by legal name, DBA, license permit ID, or serial number. - **Market researchers & data teams** — a normalized, geocoded census of NY's licensed alcohol economy. ### What you get One normalized record per active license/permit: | Field | Description | | --- | --- | | `licensePermitId` | Full SLA License Permit ID (e.g. `0001-22-100483`) | | `serialNumber` | Legacy serial number | | `parentLicenseId` | Parent license ID (for additional-bar / linked permits) | | `type` / `typeLabel` | Record type: `1` = License, `2` = Temporary Permit | | `licenseClass` | SLA class code (e.g. `0340`, `0100`) | | `licenseClassDescription` | Human-readable class (Restaurant, Liquor Store, Club…) | | `status` | Always `Active` — this dataset is the active-license registry | | `legalName` | Licensee legal (business) name | | `dba` | Trade / doing-business-as name | | `address` | Structured premises address: `street`, `additionalInfo`, `akaAddress`, `city`, `state`, `zip`, `county`, `country` | | `location` | `latitude` / `longitude` of the premises | | `originalIssueDate` | First issue date (ISO `YYYY-MM-DD`) | | `lastIssueDate` | Most recent issue date | | `effectiveDate` | Effective date | | `expirationDate` | Expiration date — target upcoming renewals | | `sourceDataset` / `sourceUrl` | Provenance back to the official state feed | #### Example output record ```json { "licensePermitId": "0001-22-100483", "serialNumber": "1330642", "parentLicenseId": "", "type": "1", "typeLabel": "License", "licenseClass": "0001", "licenseClassDescription": "Wholesale Beer (Retail)", "status": "Active", "legalName": "MAHANT KRUPA 3811 INC", "dba": "CASE & KEG", "address": { "street": "3811 HEMPSTEAD TPKE", "additionalInfo": "", "akaAddress": "", "city": "LEVITTOWN", "state": "New York", "zip": "11756", "county": "NASSAU", "country": "United States" }, "location": { "latitude": 40.72619, "longitude": -73.49535 }, "originalIssueDate": "2025-11-07", "lastIssueDate": "2025-11-07", "effectiveDate": "2025-12-01", "expirationDate": "2026-11-30", "sourceDataset": "9s3h-dpkz", "sourceUrl": "https://data.ny.gov/resource/9s3h-dpkz.json" } ```` ### Filters (all optional) - **County** — premises county, partial match (`Kings`, `New York`, `Erie`, `Nassau`…). - **City** — partial match (`Brooklyn`, `Buffalo`, `Rochester`…). - **ZIP code** — prefix match (`112` = all Brooklyn 112xx ZIPs; `11222` = exact). - **License class code** — exact SLA class (`0100` Liquor Store, `0340` Restaurant…). - **Class description contains** — free text (`Restaurant`, `Winery`, `Wholesale`…). - **Legal or trade (DBA) name contains** — matches either name. - **License / Permit ID** or **Serial number** — exact single-record lookup. - **Issued on/after & on/before** — original issue date range (find new licensees). - **Expires on/after & on/before** — expiration date range (target renewals). - **Maximum records** — cap the result set (default 5,000). Leave everything blank to pull the entire active registry (~60k records). All filtering is pushed **server-side** to the state's SODA API via a `$where` clause, so you only download the rows you want. ### How it works - Queries the official NY SLA Socrata dataset `9s3h-dpkz` over its documented JSON API. - Pages at 1,000 rows/request, ordered by `licensePermitId`, with polite pacing. - Exponential backoff on rate-limits (HTTP 429) and server errors. - Descriptive `User-Agent`; optional Socrata **app token** to raise throttling limits (not required — the API works without one). - Emits normalized records with `Actor.pushData`; a run summary is stored in the key-value store under `SUMMARY`. ### Pricing (pay-per-event) - **Actor start** — **$0.005** per run. Covers query construction and the paged, backed-off API calls. - **License record** — **$0.003** per normalized record pushed. A full-state pull of ~60k records runs about **$180**; a targeted pull — say every active license in Kings County, or every restaurant licensed in the last 90 days — is typically a few hundred records, i.e. well under a dollar. You pay only for the rows you actually take, because filtering happens server-side. There is no monthly rental. ### Source & licensing New York State Liquor Authority, "Current Liquor Authority Active Licenses," published on the State of New York open-data portal (data.ny.gov) as public open data. This actor accesses only that affirmatively-public government dataset through its official API and re-shapes it; it collects no private or personal data beyond what the state publishes. # Actor input Schema ## `county` (type: `string`): Filter by the premises county (partial match, case-insensitive). Examples: New York (Manhattan), Kings (Brooklyn), Queens, Bronx, Erie, Nassau, Suffolk, Monroe. ## `city` (type: `string`): Filter by city (partial match, case-insensitive). Example: Brooklyn, Buffalo, Rochester. ## `zipcode` (type: `string`): Filter by ZIP code. Matches on prefix, so '112' returns all Brooklyn 112xx ZIPs and '11222' matches that exact ZIP. ## `licenseClass` (type: `string`): SLA license class code (exact match). Common: 0340/0240 (Restaurant), 0100 (Liquor Store), 0081/0071 (Grocery Store), 0370 (Food & Beverage Business), 0423 (Additional Bar), 0349 (Club), 0343 (Hotel), 0032 (Farm Winery), 0014 (Micro-Brewer), 0036 (Direct Shipper Wine). ## `description` (type: `string`): Free-text substring matched against the license class description, case-insensitive. Examples: Restaurant, Liquor Store, Grocery Store, Club, Hotel, Winery, Brewer, Wholesale. ## `nameContains` (type: `string`): Free-text substring matched against both the licensee legal name and the trade (DBA) name, case-insensitive. ## `licensePermitId` (type: `string`): Look up a single license by its full SLA License Permit ID (exact match). Example: 0340-21-119344. ## `serialNumber` (type: `string`): Look up a license by its legacy serial number (exact match). Example: 1272162. ## `issuedFrom` (type: `string`): Only include licenses whose original issue date is on or after this date (ISO YYYY-MM-DD). Useful for finding newly licensed premises. ## `issuedTo` (type: `string`): Only include licenses whose original issue date is on or before this date (ISO YYYY-MM-DD). ## `expiresFrom` (type: `string`): Only include licenses whose expiration date is on or after this date (ISO YYYY-MM-DD). ## `expiresTo` (type: `string`): Only include licenses whose expiration date is on or before this date (ISO YYYY-MM-DD). Useful for targeting upcoming renewals. ## `maxRecords` (type: `integer`): Hard cap on the number of license records to return. The full dataset is ~60k active licenses & temporary permits. ## `socrataAppToken` (type: `string`): Optional data.ny.gov / Socrata application token to raise API throttling limits. Not required — the API works without one. ## Actor input object example ```json { "county": "Kings", "city": "Brooklyn", "zipcode": "112", "licenseClass": "0100", "description": "Liquor Store", "nameContains": "Pizza", "licensePermitId": "0340-21-119344", "serialNumber": "1272162", "issuedFrom": "2025-01-01", "issuedTo": "2025-12-31", "expiresFrom": "2026-01-01", "expiresTo": "2026-12-31", "maxRecords": 5000 } ``` # 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 = {}; // Run the Actor and wait for it to finish const run = await client.actor("keeganlabs/ny-liquor-licenses").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 = {} # Run the Actor and wait for it to finish run = client.actor("keeganlabs/ny-liquor-licenses").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 '{}' | apify call keeganlabs/ny-liquor-licenses --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=keeganlabs/ny-liquor-licenses", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "New York Liquor License Search — Official State SLA Open Data", "description": "Every active New York State Liquor Authority (SLA) license and temporary permit from the state's official open-data feed (~60k records), refreshed daily. Legal & trade name, license class, issue/expiration dates, premises address, county, geocoordinates. Filter by county, city, ZIP, class, or name.", "version": "1.0", "x-build-id": "OUkVlHOcMTOBmHhbu" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/keeganlabs~ny-liquor-licenses/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-keeganlabs-ny-liquor-licenses", "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/keeganlabs~ny-liquor-licenses/runs": { "post": { "operationId": "runs-sync-keeganlabs-ny-liquor-licenses", "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/keeganlabs~ny-liquor-licenses/run-sync": { "post": { "operationId": "run-sync-keeganlabs-ny-liquor-licenses", "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": { "county": { "title": "Premises county", "type": "string", "description": "Filter by the premises county (partial match, case-insensitive). Examples: New York (Manhattan), Kings (Brooklyn), Queens, Bronx, Erie, Nassau, Suffolk, Monroe." }, "city": { "title": "City", "type": "string", "description": "Filter by city (partial match, case-insensitive). Example: Brooklyn, Buffalo, Rochester." }, "zipcode": { "title": "ZIP code prefix", "type": "string", "description": "Filter by ZIP code. Matches on prefix, so '112' returns all Brooklyn 112xx ZIPs and '11222' matches that exact ZIP." }, "licenseClass": { "title": "License class code", "type": "string", "description": "SLA license class code (exact match). Common: 0340/0240 (Restaurant), 0100 (Liquor Store), 0081/0071 (Grocery Store), 0370 (Food & Beverage Business), 0423 (Additional Bar), 0349 (Club), 0343 (Hotel), 0032 (Farm Winery), 0014 (Micro-Brewer), 0036 (Direct Shipper Wine)." }, "description": { "title": "License class description contains", "type": "string", "description": "Free-text substring matched against the license class description, case-insensitive. Examples: Restaurant, Liquor Store, Grocery Store, Club, Hotel, Winery, Brewer, Wholesale." }, "nameContains": { "title": "Legal or trade (DBA) name contains", "type": "string", "description": "Free-text substring matched against both the licensee legal name and the trade (DBA) name, case-insensitive." }, "licensePermitId": { "title": "License / Permit ID", "type": "string", "description": "Look up a single license by its full SLA License Permit ID (exact match). Example: 0340-21-119344." }, "serialNumber": { "title": "Legacy serial number", "type": "string", "description": "Look up a license by its legacy serial number (exact match). Example: 1272162." }, "issuedFrom": { "title": "Originally issued on/after (YYYY-MM-DD)", "type": "string", "description": "Only include licenses whose original issue date is on or after this date (ISO YYYY-MM-DD). Useful for finding newly licensed premises." }, "issuedTo": { "title": "Originally issued on/before (YYYY-MM-DD)", "type": "string", "description": "Only include licenses whose original issue date is on or before this date (ISO YYYY-MM-DD)." }, "expiresFrom": { "title": "Expires on/after (YYYY-MM-DD)", "type": "string", "description": "Only include licenses whose expiration date is on or after this date (ISO YYYY-MM-DD)." }, "expiresTo": { "title": "Expires on/before (YYYY-MM-DD)", "type": "string", "description": "Only include licenses whose expiration date is on or before this date (ISO YYYY-MM-DD). Useful for targeting upcoming renewals." }, "maxRecords": { "title": "Maximum records", "minimum": 1, "maximum": 100000, "type": "integer", "description": "Hard cap on the number of license records to return. The full dataset is ~60k active licenses & temporary permits.", "default": 5000 }, "socrataAppToken": { "title": "Socrata app token (optional)", "type": "string", "description": "Optional data.ny.gov / Socrata application token to raise API throttling limits. Not required — the API works without one." } } }, "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 } } } } } } } } } } ```