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, 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

{
  "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.