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 |
|---|---|---|---|---|---|
| VISTA BEER & BEVERAGE INC | Wholesale Beer (Retail) | 0001-22-100330 | Active | 2025-10-23 | South Salem |
| 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 | 2025-10-24 | Shirley |
The table shows 6 selected columns. The free CSV includes all 17 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-10-04. Rows can change after a new import.
Download 5 example rows freeBuild this list with your own filters
Liquor license coverage by state
These are license records, not unique premises, businesses or openings. One business can hold multiple licenses. Counts use the DataScoop import dated 2026-10-04. Coverage is limited to these four sources.
| State | License records | With issue date | With county | Date and status meaning |
|---|---|---|---|---|
| New York | 59,808 | 59,808 | 59,684 | Original issue date; effective date used when original is absent. Active-license feed. Official source |
| Texas | 78,823 | 78,815 | 73,628 | Original issue date; current issue date used when original is absent. Active and Active - Renewal Pending records. Official source |
| Missouri | 365 | 365 | 365 | Original date from the source. Status is retained as published. Official source |
| Colorado | 19,608 | 0 | 0 | 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-09-04
- Texas: issue date on or after 2026-09-04
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.
Shared fields and their limits
- Source + license number: use both when comparing records across states. License numbers alone are not a national 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.
- County, city and ZIP: location fields as published. Missing fields stay blank; a license address is not a verified trading location.
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 which states you need, and whether you want all active licenses or only those issued since a date.
- 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,604 records and was last imported on 2026-10-04.
Filter by state, county, city, ZIP, 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 licensed premises or business address as recorded by the state, not a verified trading address.
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 a state and license type and inspect 25 matching licenses free before downloading the full list.
Preview a filtered liquor-license list