Active Liquor Licensees
California, New York, Texas and Florida licences · 285,451 locations
There are 285,451 Active Liquor Licensees in California, New York, Texas and Florida as of October 2026.
285,451 active alcohol licences in the four states that publish their whole roll as a free file, read on 28 October 2026. California has 102,954, Texas 68,221, New York 60,015 and Florida 54,261.
More about this list
One row is one licence at one premises. The licences sit at 247,046 premises. premises_key ties together the licences at one premises, and licences_at_premises counts them. Each row has the licence type in the agency's words and our category for it, the licensee and trade name, the premises address, issue and expiry dates, and the mailing address where published. 99.9% have a map point. No state publishes a phone, email or website for a licensee, so the list has none. Licensed premises outside the issuing state, such as direct shippers, are kept with premises_in_licensing_state N.
Need just some of them? Ask in your own words.
●Where the rows are
≡Sample Data Preview
| name | address | city | state | zip | licence record id | licensing state | licensing agency | licence number | licence type | licence type code | licence class | licence category | dba name | licensee | address2 | zip4 | county | original issue date | last issue date | effective date | expiration date | status | status detail | premises key | licences at premises | premises in licensing state | mail address | mail address2 | mail city | mail state | mail zip | ca fee codes | ca master licence | ca term months | ca geo code | ca district | ca census tract | ca duplicate licence count | ny parent licence id | ny legacy serial number | ny aka address | tx master file id | tx legacy licence number | tx wine percent | tx gun sign | tx subordinate codes | tx subordinate permits | fl licence group | fl county code | fl flag 2 | fl dual | source date | geo precision | county fips | county note | address quality | country | latitude | longitude | source url |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Anchorage Brewing Company | 148 W 91st Ave | Anchorage | AK | 99515 | TX-200146370-BN | TX | Texas Alcoholic Beverage Commission | 200146370 | Nonresident Brewer's License | BN | Manufacturing | Manufacturer | Anchorage Brewing Company | Anchorage Brewing, LLC | Anchorage Municipality | 2024-10-10 | 2024-10-10 | 2026-10-06 | 2026-10-09 | Active | Active - Renewal Pending | d868df46d322bc7d | 1 | N | 148 W 91st Ave | Anchorage | AK | 99515 | 2200059608 | 2026-10-28 | zip_centroid | 02020 | complete | US | 61.116381 | -149.890375 | https://data.texas.gov/dataset/TABC-License-Information/7hf9-qc9f | |||||||||||||||||||||||
| MOLSON COORS BEVERAGE COMPANY USA LLC | 405 CORDELE ROAD | Albany | GA | 31705 | TX-121771047-S | TX | Texas Alcoholic Beverage Commission | 121771047 | Nonresident Seller's Permit | S | Manufacturing | Wholesale and import | MOLSON COORS BEVERAGE COMPANY USA LLC | MOLSON COORS BEVERAGE COMPANY USA LLC (5411598) | 2109 | Dougherty County | 2008-07-01 | 2026-07-23 | 2026-07-23 | 2028-06-30 | Active | Active | 55d12cc32bb01814 | 1 | N | 320 South Canal Street | 36th Floor | Chicago | IL | 60606 | 2100005989 | S 696135 | 2026-10-28 | zip_centroid | 13095 | ZIP 31705 spans 3 counties; assigned to the county holding 76% of its land area | complete | US | 31.516890 | -84.042942 | https://data.texas.gov/dataset/TABC-License-Information/7hf9-qc9f | |||||||||||||||||||
| GREAT FROGS | 3218 HARNESS CREEK RD | Annapolis | MD | 21403 | CA-00539884-82 | CA | California Department of Alcoholic Beverage Control | 00539884 | Wine Direct Shipper Permit | 82 | Direct shipper | GREAT FROGS | GREAT FROGS LLC | Anne Arundel County | 2014-01-30 | 2026-12-31 | Active | ACTIVE | e86d8a6501b711de | 1 | N | P0 | Y | 12 | 9999 | 75 | 1 | 2026-10-28 | address | 24003 | complete | US | 38.941959 | -76.514125 | https://www.abc.ca.gov/licensing/licensing-reports/ | |||||||||||||||||||||||||
| ROYAL WINE CORPORATION | 63 LEFANTE DR | Bayonne | NJ | 07002 | TX-100187189-S | TX | Texas Alcoholic Beverage Commission | 100187189 | Nonresident Seller's Permit | S | Manufacturing | Wholesale and import | ROYAL WINE CORPORATION | ROYAL WINE CORPORATION | 5024 | Hudson County | 1979-08-16 | 2026-09-15 | 2026-09-15 | 2028-08-15 | Active | Active | 8b18afd059d7184b | 2 | N | 63 Lefante Way | Bayonne | NJ | 070025024 | 2100005663 | S 117429 | 2026-10-28 | address | 34017 | complete | US | 40.664106 | -74.102038 | https://data.texas.gov/dataset/TABC-License-Information/7hf9-qc9f | |||||||||||||||||||||
| Caleb's Crossing Whiskey Co LLC | 157 Pine Needle Rd. | Aiken | SC | 29803 | TX-200194582-S | TX | Texas Alcoholic Beverage Commission | 200194582 | Nonresident Seller's Permit | S | Manufacturing | Wholesale and import | Caleb's Crossing Whiskey Co LLC | Caleb's Crossing Whiskey Co LLC | Aiken County | 2026-04-07 | 2026-04-07 | 2026-04-09 | 2028-04-06 | Active | Active | 783e274cf23ad44a | 2 | N | 157 Pine Needle Rd. | Aiken | SC | 29803 | 2600095073 | 2026-10-28 | address | 45003 | complete | US | 33.497179 | -81.730223 | https://data.texas.gov/dataset/TABC-License-Information/7hf9-qc9f |
{}What's in each row
| Field | What it is | Rows filled |
|---|---|---|
| licence_ | Our id for the row: state, licence number and type | 100% |
| state | State of the premises | 100% |
| licensing_ | State that issued the licence (CA, NY, TX or FL) | 100% |
| licensing_ | Agency that issued the licence | 100% |
| licence_ | Licence number | 100% |
| licence_ | Licence type in the agency's words (e.g. On-Sale General - Eating Place) | 100% |
| licence_ | The agency's licence type code | 100% |
| licence_ | Licence class, where the state has one | 49% |
| licence_ | Our category for the licence (e.g. Restaurant / on-premise, Retail off-premise, Bar, Manufacturer, Wholesaler, Direct shipper) | 100% |
| name | Business name: the trade name where published, else the licensee | 100% |
| dba_ | Trade name (doing business as) | 92% |
| licensee | Licensee: the person or company that holds the licence | 100% |
| address | Premises street address | 100% |
| address2 | Second premises address line | 16% |
| city | Premises city | 100% |
| zip | Premises ZIP code | 100% |
| zip4 | ZIP+4 extension | 36% |
| county | Premises county | 100% |
| country | US | 100% |
| latitude | Latitude of the premises | 100% |
| longitude | Longitude of the premises | 100% |
| original_ | Date the licence was first issued | 99% |
| last_ | Date the licence was last issued or renewed | 45% |
| effective_ | Effective date of the current licence term | 64% |
| expiration_ | Date the licence expires | 100% |
| status | Active | 100% |
| status_ | Status in the agency's words | 100% |
| premises_ | Same street, suite and ZIP: rows sharing it are one premises | 100% |
| licences_ | Number of licences at the premises | 100% |
| premises_ | N when the premises is outside the licensing state (direct shippers, out-of-state suppliers) | 100% |
| mail_ | Mailing address | 64% |
| mail_ | Second mailing address line | 13% |
| mail_ | Mailing city | 64% |
| mail_ | Mailing state | 64% |
| mail_ | Mailing ZIP code | 64% |
| ca_ | California only: ABC fee codes | 36% |
| ca_ | California only: Y for the master licence of a group | 36% |
| ca_ | California only: licence term in months | 36% |
| ca_ | California only: ABC geographic code | 36% |
| ca_ | California only: ABC district office | 36% |
| ca_ | California only: census tract | 35% |
| ca_ | California only: number of duplicate licences | 36% |
| ny_ | New York only: parent licence id | 2% |
| ny_ | New York only: SLA legacy serial number | 21% |
| tx_ | Texas only: TABC master file id | 24% |
| tx_ | Texas only: legacy licence number | 14% |
| tx_ | Texas only: wine percentage permit class | 10% |
| tx_ | Texas only: the gun sign the premises must post (51% or Blue) | 15% |
| tx_ | Texas only: subordinate permit codes | 9% |
| tx_ | Texas only: subordinate permits | 9% |
| fl_ | Florida only: DBPR licence group | 19% |
| fl_ | Florida only: DBPR county code | 19% |
| fl_ | Florida only: dual licence flag | 8% |
| source_ | The state agency's file or page | 100% |
| source_ | Date the state file was read | 100% |
| geo_ | How the map point was found: the SLA's own point (New York), an address match, or a ZIP or city centre | 100% |
| county_ | Five-digit county FIPS code | 99% |
| county_ | Set when the ZIP code spans more than one county | 15% |
| address_ | complete, no house number, po box, missing city or zip or missing | 100% |
Rows filled is measured on every row of the delivered file.
✓Where this data comes from
Each row names the public source it came from, so any record can be checked against where it was published.
October 28, 2026
Snapshot built
61 fields
Columns in the file
Fill measured
On every row of the delivered file
How we build and date every file: methodology.
Using ChatGPT, Claude or an API?
No setup needed. Ask ChatGPT or Claude your question about the Active Liquor Licensees and give it this page: it can open https://locationlists.com/find?dataset=liquor-license-list with the filters you need and show you the count and price.
Using ChatGPT or Claude? Tell it to answer from locationlists.com/find — no account, no connector.
How assistants ask
No connector needed. Any AI assistant can answer from this site with a web link, no connector, no account: open https://locationlists.com/find with the question as query parameters.
If a question needs filtering, distance, combining lists or a price, open a /find link: either put the question itself in q=, or build the structured link. The answer does not need an API, a connector or an account.
Simplest, the question itself: https://locationlists.com/find?q=<the question in plain words>
Or set the parts yourself: https://locationlists.com/find?dataset=<slug>&state=<ST>&city=<city>&county=<county>&zip=<zip>&near=<place or zip>&radius=<miles>&where=<column>:<op>:<value>&total=<rows>
Leave out what the question does not need. Distance is radius, in straight-line miles; near can name several places separated by | to reach from any of them. To ask about several lists at once, use datasets with two or more names, or category with a kind of business. To compare two lists, add relate=nearest and the other list with b. in front of its parameters. To count by area, use areas=county (or zip, state, metro). To keep only places whose county, ZIP code, metro area or state meets a Census figure, add area_where (for example county:population>1000000); with areas, per=100000 gives counts per 100,000 residents.
Links an assistant can open, each showing how many rows match, a few preview rows and the price for just that part:
- Only California, the state with the most: https://locationlists.com/find?dataset=liquor-license-list&state=CA
- Within 25 miles of New York, NY, the busiest area: https://locationlists.com/find?dataset=liquor-license-list&near=New+York+NY&radius=25
- The whole list: add a city, state, ZIP code or distance:
https://locationlists.com/find?dataset=liquor-license-list - In plain words: "Active Liquor Licensees in California": https://locationlists.com/find?q=Active+Liquor+Licensees+in+California
- In plain words: "Active Liquor Licensees within 25 miles of New York, NY": https://locationlists.com/find?q=Active+Liquor+Licensees+within+25+miles+of+New+York%2C+NY
Optional: connect for repeat use or wallet payments:
Read https://locationlists.com/skill.md and follow the instructions to connect LocationLists. Then show me the Active Liquor Licensees list.Your assistant will walk you through setup and show you the price before you pay.
For developers
Every step below has a no-connector equivalent: https://locationlists.com/find?dataset=liquor-license-list with the same filters as query parameters.
- Connect your agent to
https://locationlists.com/mcp(no key, no signup). - Call
count_locationswithdataset: "liquor-license-list"and any filter — it is free, and returns how many rows match and what they cost. - Fetch the rows with
query_locations: $0.15 per 100 rows from this dataset. Above 142,726 rows, buying the whole file is cheaper.
Paid in USDC over x402 — the agent gets an HTTP 402 with the exact price, signs, and retries. Money moves only after rows are delivered, so a failed or empty query costs nothing. Setup for Claude, Cursor and VS Code
?Frequently Asked Questions
How many Active Liquor Licensees are there in California, New York, Texas and Florida?
There are 285,451 Active Liquor Licensees in California, New York, Texas and Florida as of October 2026.
Where does this data come from?
From each state's alcohol agency, read on 28 October 2026: the California Department of Alcoholic Beverage Control daily export, the Texas Alcoholic Beverage Commission licence file, the New York State Liquor Authority's active licences and Florida's Division of Alcoholic Beverages and Tobacco licence file.
Why only four states?
These four publish their whole active roll as a free file. Other states publish a search page or no list at all.
Is there a phone number or email?
No. None of the four states publishes a phone, email or website for a licensee.
Is one row one place?
One row is one licence at one premises. A restaurant with a beer and wine licence and a catering permit is two rows. Rows with the same premises_key are one place, and licences_at_premises counts its licences.
What is left out?
Expired and inactive licences. One-day and event permits. In Florida, tobacco permits and brand registrations.