# Active Liquor Licensees — California, New York, Texas and Florida licences location dataset All 285,451 locations in California, New York, Texas and Florida licences, as one CSV: 59 fields per record, 52 states, file built October 28, 2026. $199 one-time, with up to 10 real rows free before you buy. Canonical URL: https://locationlists.com/data/liquor-license-list 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. 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. ## The figures - Records: 285,451 locations (285,338 US) - States: 52 - Coverage: California, New York, Texas and Florida licences - Fields: 59 - Price: $199 one-time, CSV download, commercial license (https://locationlists.com/license) - Snapshot built on October 28, 2026. Not rebuilt on a schedule. - File last modified: 2026-10-28 The file has all 285,451 locations across 52 states in one download. Building the same list by searching one area at a time tends to miss places, and a missed place looks like a gap in coverage that is not really there. ## Fields - `licence_record_id`: Our id for the row: state, licence number and type - `state`: State of the premises - `licensing_state`: State that issued the licence (CA, NY, TX or FL) - `licensing_agency`: Agency that issued the licence - `licence_number`: Licence number - `licence_type`: Licence type in the agency's words (e.g. On-Sale General - Eating Place) - `licence_type_code`: The agency's licence type code - `licence_class`: Licence class, where the state has one - `licence_category`: Our category for the licence (e.g. Restaurant / on-premise, Retail off-premise, Bar, Manufacturer, Wholesaler, Direct shipper) - `name`: Business name: the trade name where published, else the licensee - `dba_name`: Trade name (doing business as) - `licensee`: Licensee: the person or company that holds the licence - `address`: Premises street address - `address2`: Second premises address line - `city`: Premises city - `zip`: Premises ZIP code - `zip4`: ZIP+4 extension - `county`: Premises county - `country`: US - `latitude`: Latitude of the premises - `longitude`: Longitude of the premises - `original_issue_date`: Date the licence was first issued - `last_issue_date`: Date the licence was last issued or renewed - `effective_date`: Effective date of the current licence term - `expiration_date`: Date the licence expires - `status`: Active - `status_detail`: Status in the agency's words - `premises_key`: Same street, suite and ZIP: rows sharing it are one premises - `licences_at_premises`: Number of licences at the premises - `premises_in_licensing_state`: N when the premises is outside the licensing state (direct shippers, out-of-state suppliers) - `mail_address`: Mailing address - `mail_address2`: Second mailing address line - `mail_city`: Mailing city - `mail_state`: Mailing state - `mail_zip`: Mailing ZIP code - `ca_fee_codes`: California only: ABC fee codes - `ca_master_licence`: California only: Y for the master licence of a group - `ca_term_months`: California only: licence term in months - `ca_geo_code`: California only: ABC geographic code - `ca_district`: California only: ABC district office - `ca_census_tract`: California only: census tract - `ca_duplicate_licence_count`: California only: number of duplicate licences - `ny_parent_licence_id`: New York only: parent licence id - `ny_legacy_serial_number`: New York only: SLA legacy serial number - `tx_master_file_id`: Texas only: TABC master file id - `tx_legacy_licence_number`: Texas only: legacy licence number - `tx_wine_percent`: Texas only: wine percentage permit class - `tx_gun_sign`: Texas only: the gun sign the premises must post (51% or Blue) - `tx_subordinate_codes`: Texas only: subordinate permit codes - `tx_subordinate_permits`: Texas only: subordinate permits - `fl_licence_group`: Florida only: DBPR licence group - `fl_county_code`: Florida only: DBPR county code - `fl_dual`: Florida only: dual licence flag - `source_url`: The state agency's file or page - `source_date`: Date the state file was read - `geo_precision`: How the map point was found: the SLA's own point (New York), an address match, or a ZIP or city centre - `county_fips`: Five-digit county FIPS code - `county_note`: Set when the ZIP code spans more than one county - `address_quality`: complete, no_house_number, po_box, missing_city_or_zip or missing In the header but under 1% filled, so not in this release: ny_aka_address, fl_flag_2. ## Ask this list a question with a link No connector and no account; each link answers with the matching count, 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) ## The same dataset, for machines - Record as JSON: https://locationlists.com/data/liquor-license-list/dataset.json - Free sample, up to 10 real rows: https://locationlists.com/data/liquor-license-list/sample.csv or https://locationlists.com/data/liquor-license-list/sample.json - Buy link (opens Stripe Checkout): https://locationlists.com/data/liquor-license-list/buy ## Questions ### 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.