A US liquor license list you can open in Excel
State liquor authorities publish who holds a license, but each state does it on its own system with its own license types and export limits. Turning that into one list of new or active licenses, the classic lead list for distributors and suppliers, means wrestling each state separately.
Preview a filtered liquor-license list See the liquor-license dataset
Worked example: New York liquor licenses
Choose US liquor licenses, set Source: New York, and you have New York State's liquor licensees. Add a county, license type or issue date to narrow it to your list.
| Licensee | License type | License number | Status | Issued on | City |
|---|---|---|---|---|---|
| MAHANT KRUPA 3811 INC | Wholesale Beer (Retail) | 0001-22-100483 | Active | 2025-11-07 | Levittown |
| FLAG BEVERAGE STORE INC | Wholesale Beer (Retail) | 0001-22-100586 | Active | 2025-12-23 | Lindenhurst |
| ESPINOZA BROTHERS BEVERAGE LLC | Wholesale Beer (Retail) | 0001-22-101177 | Active | 2025-12-01 | Mineola |
| SMITH POINT BEER & SMOKE ISLAND INC | Wholesale Beer (Retail) | 0001-22-101205 | Active | 2026-10-28 | Shirley |
| BEER WORLD 13 CORP | Wholesale Beer (Retail) | 0001-22-101373 | Active | 2026-11-03 | Peekskill |
The table shows 6 selected columns. The free CSV includes all 20 public columns for these first 5 rows. Blank source values stay blank in the CSV. Coverage in this example is New York State; DataScoop also carries Texas, Missouri and Colorado.
Source: New York State (open data). DataScoop import: 2026-11-14. Rows can change after a new import.
Download 5 example rows freeBuild this list with your own filters
Liquor license coverage by issuing register
These are license records, not unique premises, businesses or openings. One business can hold multiple licenses. Counts use the DataScoop import dated 2026-11-14. An issuing register can include addresses outside its state.
| Issuing register | License records | With issue date | With county value | With address state | In a US address area | Date and status meaning |
|---|---|---|---|---|---|---|
| New York | 58,684 | 58,684 | 58,560 | 58,606 | 58,606 | Original issue date; effective date used when original is absent. Active-license feed. Official source |
| Texas | 79,316 | 79,308 | 74,116 | 79,111 | 78,793 | Original issue date; current issue date used when original is absent. Active and Active - Renewal Pending records. Official source |
| Missouri | 511 | 511 | 511 | 507 | 507 | Original date from the source. Status is retained as published. Official source |
| Colorado | 19,860 | 0 | 0 | 19,858 | 19,858 | No issue date is mapped. No county field is mapped; use city or ZIP. Active-license feed. Official source |
Review the US liquor license dataset and CSV sample before building your list.
Start with New York or Texas
- New York license list
- Texas license list
- New York: issue date on or after 2026-10-15
- Texas: issue date on or after 2026-10-15
The dated examples start 30 days before the recorded import. Change the cutoff in the explorer. The filter is inclusive and excludes blank issue dates; Colorado therefore cannot produce a dated shortlist. These are licenses present in the current import, not a history of every license issued during that period.
Issuing register or address location
Choose an issuing register to see its license records, or choose a reported address state or area for a location list. Address areas require a known US state and a usable county or city; foreign and incomplete addresses remain in the register's records. Missing country values stay blank. Colorado-issued licenses with Oregon addresses.
Shared fields and their limits
- Source + license number: identify the issuing register and the published license number. A number can repeat within a register and is not a unique business identifier.
- Licensee and trade name: official registration and DBA wording, which may differ from the name on a storefront.
- License type and status: source terminology is preserved, so an exact status or type may not apply in another state.
- Issued date: the source mapping above can include an effective or current issue date. It does not establish an opening date.
- Expiry date: blank where unavailable, including Missouri in the current mapping.
- Reported address: street, city, state or province and country where supplied. Foreign postal codes are kept whole. A published address is not a verified trading location.
- Register grouping: retains the older county/city grouping under the issuing register. Use Address area for reported address geography.
Check the state record before acting on a specific license. The export contains public licensing facts, without phone numbers or personal contact enrichment.
What is happening
US search suggestions ask for liquor license lists, new liquor licenses, liquor license databases, and CSV or Excel downloads by state. These are prospecting and territory lists for distributors, suppliers and service providers.
The state feeds are free and authoritative. The obstacle is that each state models licenses differently, so a single multi-state list is a cleaning and merging job, not a download.
What it disrupts
- A list of new or active licenses by state, county or license type becomes a state-by-state export and merge job.
- License-type vocabularies and status codes differ by state, so the files do not align without cleaning.
- Distributor and supplier teams pay lead brokers for a list the public record already contains.
Why it happens
- Each state alcohol authority runs its own system for regulation, not to provide a national, spreadsheet-ready licensee list.
- License types, privileges and status codes are set by each state and are not standardised.
- The feeds are built for lookups and small exports, not a filtered bulk list across several states.
Checks to make now
- Decide whether you need licenses from a particular issuing register or records with addresses in a particular state. Then choose a date cutoff if needed.
- Write down the license-type, county, city and status filters that define your list before exporting.
- For a decision on a single licensee, confirm the current record with the relevant state authority.
Where DataScoop fits
DataScoop keeps a filtered copy of several states' liquor-license registers under one schema. The current catalog contains 158,371 records and was last imported on 2026-11-14.
Filter by issuing register, reported address state or area, city, postal code, license type, status and issue date. Preview 25 rows free, then the explorer shows the enabled one-off export price for your currency.
Where it fits, and where it does not
Good fit
- Distributor, supplier and service-provider prospecting and territory planning from public licensing facts.
- Developers and agents that need the same multi-state license data through CSV, REST API or MCP.
Not the right fit
- Personal-contact enrichment, phone numbers or the licensee's home address.
- A real-time license-status or compliance decision; confirm with the state authority.
Proof and boundaries
Coverage is the states DataScoop has imported, currently New York, Texas, Missouri and Colorado, not every US state.
License types and status codes are reproduced from each state, so they are not identical across states.
The address is the premises or business address published in the record, not a verified trading address. An issuing register can include out-of-state and foreign addresses; incomplete address states are not inferred from the register.
Some licensee names are sole-trader names; they are reproduced only as the official license registration, and no personal-contact fields are mapped.
There is no customer outcome claim yet. The proof is the official row scale, the visible filter schema, a free preview, a dated import and the source attribution.
Questions people ask
Which states are included?
Currently New York, Texas, Missouri and Colorado, kept under one schema so you can filter them together. More states are added from the public roadmap.
Is this official data?
Yes. Each state's liquor-license register comes from its official open-data feed, and DataScoop keeps the source attribution and import date with the result.
Can I get only newly issued licenses?
Use the issue-date filter for New York, Texas or Missouri. New York and Texas use an effective or current date when the original date is missing. Colorado has no mapped issue date. The result is a shortlist of current source records, not proof of newly opened businesses or a complete issue history.
Does the export include personal contact details?
No. DataScoop carries organisation-level license facts and excludes personal-contact fields.
Is the license status real-time?
No. Status reflects the last import shown on the page. For a live decision, confirm the current record with the state authority.
Build your liquor-license list before you export
Choose an issuing register or an address location, add a license type, and inspect 25 matching records free before downloading the full list.
Preview a filtered liquor-license list