United States

US liquor licenses (New York, Texas, Missouri, Colorado)

Liquor license records for New York, Texas, Missouri and Colorado. Compare coverage and date fields, preview a filtered CSV free, or query the API. 159,053 rows. Licence: Public records, state open-data terms. Example: Texas liquor licenses issued since 1 July 2026, as CSV: https://datascoop.io/v1/datasets/us-liquor-licenses/query?source=Texas&issuedSince=2026-07-01

get/v1/datasets/us-liquor-licenses/query

Request

  • Base URL: https://datascoop.io
  • URL: https://datascoop.io/v1/datasets/us-liquor-licenses/query
  • Auth: one of:
    • none
    • HTTP bearer
    • API key in query parameter api_key

Query parameters

source'New York' | 'Texas' | 'Missouri' | 'Colorado'

Source state: exact match, case-insensitive.

areastring

County, State: exact match, case-insensitive. Exact county and state as shown on the list pages

countystring

County contains: substring match, case-insensitive.

citystring

City: exact match, case-insensitive. Exact, case-insensitive

zipPrefixstring

ZIP starts with: prefix match, case-insensitive.

licenseTypestring

License type contains: substring match, case-insensitive.

issuedSincestring

Issued since (YYYY-MM-DD): minimum (inclusive). Inclusive source issue date; NY/TX can use effective/current dates. Unavailable for Colorado. Not an opening date.

expiresBeforestring

Expires before (YYYY-MM-DD): maximum (inclusive).

statusstring

Status: exact match, case-insensitive.

nameContainsstring

Licensee or trade name contains: substring match, case-insensitive.

limitinteger

Rows to return. Free plans are capped at 25; Pro up to 10,000 per JSON page.

offsetinteger

Rows to skip (paging).

format'json' | 'csv'

json (default) or csv. CSV opens in Excel and is never paged.

Response

Matching rows

datasetstring required
plan'free' | 'pro'
totalinteger required

Rows matching the filters

returnedinteger required
offsetinteger
truncatedboolean required

true when fewer rows than total were returned

ignoredstring[]

Filter keys the dataset does not know

rowsobject[] required
attributionstring required

Keep this with the data

licencestring

Changes

No recorded changes to this operation across all 1 revision of this API.