Licensed Hospitality and Retail Businesses Dataset (NY, CO, OR) by Cited Data
72,549 active state license records for licensed hospitality and retail businesses in New York, Colorado and Oregon, in one file with one schema, with each business's premises address, license type and dates.
What we added to the public records
- Merged across states: three state files, each with its own columns and license types, become one file with one schema.
- One class for every license: each state's license types are mapped by hand to one common class and marked on-premise or off-premise, with the state's own type kept beside it.
- Cleaned: names title-cased, street lines standardized to USPS abbreviations, ZIP codes cut to 5 digits.
- Deduplicated: one row per license, the term in force on the state's as-of date.
- Narrowed to the businesses: producers, wholesalers, importers, direct shippers, temporary permits, permits attached to another license, and expired or inactive licenses left out.
- Personal names removed: 2,337 licensee names that looked like a person's are blank.
- Kept current: rebuilt from each state's newest file; the yearly plan sends each update.
- Cited: every source file, its download date and its SHA-256 are listed.
New York, Colorado and Oregon each publish the licenses they issue to restaurants, hotels, clubs, caterers and stores, in their own formats and with their own license types. This dataset reads all three (103,390 state rows) and keeps the 72,549 active and pending licenses held by businesses that serve or sell to the public: 48,125 in New York, 12,399 in Colorado and 12,025 in Oregon.
Each row gives the business name, the licensee when it is an organization, the premises address, city, county and ZIP, the license number, the state's own license type, our common class, whether it is on-premise or off-premise, its status, and its issue, start and expiry dates where the state gives them. Every row carries the state agency it comes from and the date that state's file was last updated.
Of the 72,549, 41,275 are licenses for service on the premises (restaurants, venues and the like), 26,980 for sale to take away (grocery, convenience and specialty stores), and the rest are clubs, hotels, caterers and a few others.
No owner or officer names, phone numbers or emails are in the file; the addresses are of business premises. A free sample and a full table of counts by state and class are available first.
What's in it
19 columns, one row per license
| In plain words | Columns |
|---|---|
| Which license | license_id (state code and license number, the row key), state, license_number |
| What kind | license_class (our common class: on-premise or off-premise, full or limited, club, hotel, caterer or other), sale_type (on-premise, off-premise, or both), state_license_type and state_license_code (the state's own) |
| Who | business_name (trade name), licensee_name (only when it is an organization) |
| Where | premises_location, city, county, zip5 |
| Status and dates | status (active or pending), issue_date, effective_date, expiry_date |
| Source | source_agency, source_date |
Free sample
100 licenses drawn by state with a fixed seed (22 from Colorado, 56 from New York, 22 from Oregon), with the same 19 columns as the full file. With it: every state's license counts by class (24 rows), and the data dictionary.
Price
| Option | Price | What you get |
|---|---|---|
| Three-state file, one-time | $59 | The full file for the current state files, with the state summary |
| Annual plan | $149 a year | The full file now, and a quarterly update for a year |
Checkout opens when the store goes live.
See the refund policy and the terms.
Sources
Built from the active license lists that New York, Colorado and Oregon publish on their open data portals, fetched through each portal's own download links.
- Current Liquor Authority Active Licenses: https://data.ny.gov/d/9s3h-dpkz
- Liquor Licenses in Colorado: https://data.colorado.gov/d/ier5-5ms2
- OLCC Liquor Business Licenses & Endorsements: https://data.oregon.gov/d/srxe-qkm2
Permission: New York's OPEN-NY Terms of Use allow reuse of its data in private-sector projects; Colorado publishes its file as public domain; Oregon law (ORS 276A.356) places no restrictions on the use of the data it publishes.
The data made available here has been modified for use from its original source, which is the State of Colorado.
No warranty: the source data comes from the States of New York, Colorado and Oregon with no warranty of accuracy, completeness or timeliness, and the files are provided as they are.
Cited Data is not affiliated with or endorsed by the States of New York, Colorado and Oregon or any government body.
Questions
- Which businesses are in the file?
- Every business holding an active or pending retail license from the three states: restaurants, venues, hotels, clubs, caterers, and grocery, convenience, drug and specialty stores. Producers, wholesalers, importers and direct shippers are left out.
- How fresh is the data?
- Colorado's file as of 2026-10-20 and New York's and Oregon's as of 2026-10-30. Each row carries
source_date, so you always know which state file it came from. - How often is it updated?
- Quarterly, from each state's newest file. The annual plan includes each update for the year.
- Why do some active licenses show a past expiry date?
- A state can list a license as active while its renewal is processed. The file keeps the state's status and dates as published.
- How do the classes line up across states?
- License types don't match exactly between states, so
license_classis our mapping, made by hand for every type. The state's own type is always kept instate_license_type. - Are personal details included?
- No owner or officer names, phone numbers or emails. A licensee name is kept only when it is an organization (it has a legal form such as Inc or LLC, a word only an organization uses, or a number); otherwise it is blank, and so is a trade name that is that person's own name. The addresses are of business premises.
- What format is it?
- A CSV file with a header row (19 columns), plus the state summary and the data dictionary.