---
title: "US liquor licenses (New York, Texas, Missouri, Colorado)"
method: GET
path: "/v1/datasets/us-liquor-licenses/query"
tags: ["United States"]
---

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

`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`

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

## Query parameters

- `source` 'New York' | 'Texas' | 'Missouri' | 'Colorado'
- `area` string
- `county` string
- `city` string
- `zipPrefix` string
- `licenseType` string
- `issuedSince` string
- `expiresBefore` string
- `status` string
- `nameContains` string
- `limit` integer
- `offset` integer
- `format` 'json' | 'csv'

## Response `200`

Matching rows

- QueryResult
  - `dataset` string, required
  - `plan` 'free' | 'pro'
  - `total` integer, required: Rows matching the filters
  - `returned` integer, required
  - `offset` integer
  - `truncated` boolean, required: true when fewer rows than total were returned
  - `ignored` string[]: Filter keys the dataset does not know
  - `columns` object[]
    - `key` string
    - `label` string
  - `rows` object[], required
  - `attribution` string, required: Keep this with the data
  - `licence` string
  - `next_step` object: Present when the plan capped the result: links and wording for getting every row
    - `message` string
    - `buy_export_url` string, uri
    - `signup_url` string, uri
    - `pricing_url` string, uri

---

[API](https://skmtc.dev/datascoop/apis/datascoop-api.md) · [All operations](https://skmtc.dev/datascoop/apis/datascoop-api/llms.txt) · [OpenAPI document](https://skmtc.dev/datascoop/apis/datascoop-api/revisions/102c5cf316da?raw)