Cited Data

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

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 wordsColumns
Which licenselicense_id (state code and license number, the row key), state, license_number
What kindlicense_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)
Whobusiness_name (trade name), licensee_name (only when it is an organization)
Wherepremises_location, city, county, zip5
Status and datesstatus (active or pending), issue_date, effective_date, expiry_date
Sourcesource_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

OptionPriceWhat you get
Three-state file, one-time$59The full file for the current state files, with the state summary
Annual plan$149 a yearThe 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.

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_class is our mapping, made by hand for every type. The state's own type is always kept in state_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.