Liquor License Feed

CSV and API

Four ways to move filings into your tools, and if none fits yours, we'll make one that does. One key per subscription, in your welcome email.

Sign in and this page fills in your key, with a copy button on each snippet.

Authentication

Send the key as the X-Api-Key header. State and Region keys pull their own states. National keys pull every covered state.

CSV

GET /export/csv?state=TX
ParameterWhat it does
state=TX,OKOne state, or a comma list on a Region key. National keys may leave it off.
county=Harris,DallasOnly those counties.
since=2026-09-15Only filings first seen on or after that date. For a CRM sync.
kind=onon bars, restaurants, clubs, hotels, venues. maker breweries, wineries, distilleries. off stores. other the rest. Comma-separate several.
chains=0Leave out chains.
brands=0Leave out rows whose name matches a known restaurant, bar or hotel brand (the brand column).
all=1Every license we hold for the state, not only new filings.

Rows are filings: new and pending applications and newly issued licenses. Counties picked at Your feed shape the email only; the export takes its own parameters.

Columns 
business, dba, street, city, state, zip, county, license_type, license_type_label, status, filed, record_url, contact, phone, change, previously_here, operator_other_locations, website, pos, situation, kind, chain, id, email, enforcement, enforcement_detail, enforcement_url, same_operator_count, same_operator_places, brand, sales_band, receipts_stopped, receipts_end_date
  • filed: the state's application date, or the date first seen.
  • record_url: the public record.
  • contact, phone: as printed on the filing where the state prints them; otherwise the owner a public page names and a phone from a public record (New York City's health inspections) or the business's own site.
  • email: the business's own address, from its public place listing. Blank when the listing has none.
  • website, pos: found online for bars, restaurants, makers and independent stores (never chains). A phone found online fills phone where the state printed none. Blank when nothing was found; never guessed.
  • change: new owner or moving, where the record shows it.
  • previously_here, operator_other_locations: the last business at the address and the owner's other licenses under the same legal name in the state, where we hold license history.
  • same_operator_count, same_operator_places: how many other locations this operator holds and where, across states, linked on the legal entity, officers, phone, mailing address and website.
  • brand: the restaurant, bar, hotel or venue brand the business name or DBA matches, such as Chili's or Hampton Inn. It is a name match: it does not say whether the location is franchised, licensed or corporate-owned. Blank when the name matches none of the brands we list.
  • sales_band, receipts_stopped, receipts_end_date: Texas only. Where the Comptroller's monthly mixed-beverage receipts cover the location: Smaller, Mid-size, Larger or Largest against other Texas locations that report, whether the location has stopped reporting (Ended <date> where the state shows an end date, No report since <month> otherwise), and the state's end date. No dollar figures. Blank where the receipts file has no match.
  • enforcement, enforcement_detail, enforcement_url: a suspension or other enforcement action in the last 12 months on this license or at this address, with its date and the state's record. Connecticut, Texas and Washington so far. Blank means no record found in our sources, not that none exists.
  • situation: what kind of opening it is. new owner or moving where the record shows it; added license, existing place when the same business already holds a license at the address (California); new operator when a different licensee files at an address one other licensee held and gave up or is giving up; previously licensed address when a closed bar, restaurant or store held a license there; first license at address when the state's license history we hold has none there before. Blank when neither tells.

Straight into your CRM

Add format= to the CSV link and the file comes out in that tool's own import columns, so the import screen maps itself. The license type, status, filing date, situation and record link ride along in the description or note.

ToolLinkWhere to import it
HubSpot/export/csv?state=TX&format=hubspotImport › Start an import › File from computer › One object › Companies.
Salesforce/export/csv?state=TX&format=salesforceSetup › Data Import Wizard › Leads. Last Name is the contact the state printed, or Owner.
Pipedrive/export/csv?state=TX&format=pipedriveLeads Inbox › Import data. Each filing arrives as a lead with its organization.
AgencyZoom/export/csv?state=TX&format=agencyzoomLead Manager › Import (Admin or Manager). Pick the pipeline and stage on the way in.
Repsly/export/csv?state=TX&format=repslyPlaces › Import. Each ID stays the same on every pull, so a re-import updates a place instead of copying it.

Your tool isn't here, or it wants other columns? Tell us and we'll build it.

Try the import before you pay: every state's free sample takes the same format=, for example /samples/tx.csv?format=hubspot.

Every morning, without a download

Google Sheets

Sheets can't send a header, so this route takes the key in the URL. Paste into a cell; it refreshes about hourly.

=IMPORTDATA("https://liquorlicensefeed.com/sheets/tx.csv?key=YOUR_KEY")

Swap tx for any state on your plan. Treat the link like a password.

JSON

GET /export/json?state=TX returns one object per filing, newest first, each with a stable id (state and record), so a Zapier or Make poll can skip what it has seen. Same key rules and parameters as CSV.

curl -H "X-Api-Key: YOUR_KEY" "https://liquorlicensefeed.com/export/json?state=TX"

Renewals and closures

RouteReturns
/export/renewals.csv?state=KY&days=60Licenses expiring in the next 60 days (up to 365), soonest first, with expires_on. States with expirations: Arizona, California, Colorado, Connecticut, District of Columbia, Florida, Idaho, Illinois, Kentucky, Maine, New Mexico, New York, Ohio, Oklahoma, Oregon, Pennsylvania, South Carolina, Tennessee, Texas, Vermont, Virginia and Wisconsin.
/export/closed.csv?state=MI&since=2026-10-01Licenses that left the state's list since that date (30 days by default), with closed_on.

Both have a .json twin and the same key rules.

New restaurants from health and tax records

GET /export/food_permits.csv?state=NY returns restaurants first inspected, permitted or registered in the last 30 days (or since=). Coffee shops, fast casual and bakeries appear here, not in liquor records. Webhooks send them as "event": "food_permit".

Wherestatesignal and inspected_on
New York CityNYHealth inspection before the permit; the inspection date.
ChicagoILHealth inspection before the city license; the inspection date.
San Diego CountyCACounty food permit opened; the date the permit record opened. result says when it was issued.
Wake County (Raleigh, Cary and the rest)NCCounty food permit date.
Texas, every cityTXState sales tax permit for a restaurant, coffee shop or bar; the permit date. result gives the first sales date the owner reported, which can be weeks ahead.
Florida, every countyFLState food license after plan review; the approval date (about when it opens). Food trucks and carts are left out.
City of Los AngelesCACity business tax registration; the start date the business gave, which can be ahead. The city updates this list monthly.

A county can issue a new permit when a place changes owners, so a Wake County row can be a takeover. San Diego rows leave out a permit for a business that already held the address. Wake County data is from Wake County GIS under CC BY 4.0. phone is filled where the source prints one (New York City, San Diego, Wake, Florida).

Webhooks

Paste a webhook address on Your feed. Each new filing in your states and counties posts to it after the morning run, one JSON request per filing. Zapier, Make, n8n and Clay catch hooks all work.

Example payload 
{
  "id": "TX:661734.0", "event": "filed",
  "business": "Lola's CC LLC", "dba": "It's Italian Cucina",
  "street": "1500 S Lamar Blvd", "city": "Austin", "state": "TX", "zip": "78704", "county": "Travis",
  "license_type": "MB", "license_type_label": "Mixed Beverage Permit (MB)", "status": "Pending",
  "filed": "2026-10-07", "record_url": "https://apps.tabc.texas.gov/publicinquiry/TrackLicense.aspx",
  "contact": "", "phone": "",
  "kind": "on", "chain": false, "change": null,
  "previously_here": null, "operator_other_locations": 0, "website": null, "pos": null,
  "situation": "first license at address",
  "enforcement": "", "enforcement_detail": "", "enforcement_url": "",
  "first_seen": "2026-10-07T12:51:53+00:00"
}

Free sample

Every state page links a free sample with the same header (/states/tx/sample.csv): every filing from one recent full week, names and streets included, and phones where we found them. Map your import on it before you pay.

The same week as JSON needs no key: /states/tx/sample.json, up to 25 filings without phones or owners, 120 requests an hour.

AI assistants

Add this address as a custom connector (Model Context Protocol) in any assistant that supports remote MCP servers. No key or account:

https://liquorlicensefeed.com/mcp

It covers which states we read, one business at a time by name, a county's last 30 days, how long a license takes, a sample of filings, and plans. It's read-only. The current daily feed stays on the paid plans.

Need it another way?

If your CRM, mapping tool or spreadsheet wants different columns, a field we don't send, a filter, a schedule or a tool we haven't listed, tell us what it is. Layout requests are free on every plan and on the trial, and most are live within a few days.

Plans · Coverage · About the data