US Tech Automations

Other dated records TTB appear / disappear list 389,752 rows held

Alcohol wholesalers: who appeared and who dropped off the list

The TTB publishes its permit list as it stands today and overwrites the last one. We keep both copies, so you get the wholesaler permits that appeared and the ones that dropped off, with the permit number and the town on every row. Dropping off means a permit was on one copy and not on the next. It is not proof that the business closed.

Price
$99/mo
Built for
Beverage compliance and wholesaler ops
Read
About every week
Newest sealed read
2026-09-30

Subscribe — $99 a month$99 a month, billed monthly, for one state or territory you name — not the national file. You get every permit that appeared and every permit that stopped being listed between the copies we hold, with the permit number, the city, the state, the industry, and the business name where our copy holds one. Some rows have no business name in our copy. We print the gap rather than filling it in, because a permit number you can look up is worth more than a name we guessed. Cancel any month by email, with no account to close and no notice period.

Newest sealed read: 2026-09-30. We read this source about every 7 days. We hold 10 sealed runs going back to 2026-08-08. Collection has paused. We last read this source 15 days ago, and we read it about every 7 days, so no number on this page moves until collection starts again.

What this page is389,752 rows held · newest sealed read 2026-09-30

  • Between 23 Sep 2026 and 30 Sep 2026 we detected 98 changes in this list: 47 permits appeared for the first time, 9 permits were on the 23 Sep 2026 copy and gone from the 30 Sep 2026 one, and 41 permits sat on both copies with 42 fields that moved between them. 1 of those permits had more than one field move at once, which is why the 42 is the bigger number.
  • We hold 389,752 dated permit rows for this slice, across 10 sealed copies of the government's list dated 8 Aug 2026, 11 Aug 2026, 19 Aug 2026, 25 Aug 2026, 1 Sep 2026, 8 Sep 2026, 9 Sep 2026, 16 Sep 2026, 23 Sep 2026 and 30 Sep 2026. 39,092 permits sit on the newest one.
  • The collector's log holds 20 run records. 10 of those runs downloaded the file and sealed a copy. The rest either found nothing new or came back with nothing at all.
  • 39,092 permits of the 84,518 on the whole 30 Sep 2026 copy are wholesaler permits.

Real rows out of our sealed copies

These are rows we read out of dated copies we keep ourselves. The live source shows today only, so once a row moves, what it said before is gone from the place you would go to look.

Every change between two sealed copies of the wholesaler list — 12 of 98 changes 23 Sep 2026 → 30 Sep 2026
PermitBusinessWhereWhat changed
AR-P-21142Whistle Stop CellarsPea Ridge, ARFirst listed 30 Sep 2026
CA-P-27557AbloomCalistoga, CAFirst listed 30 Sep 2026
CA-P-27558name not in our copySalinas, CAFirst listed 30 Sep 2026
CA-P-27559name not in our copyCompton, CAFirst listed 30 Sep 2026
CA-P-27560La Infiel ImportsLong Beach, CAFirst listed 30 Sep 2026
CA-P-27561HAMMER VODKANewport Beach, CAFirst listed 30 Sep 2026
CA-P-27562name not in our copyNipomo, CAFirst listed 30 Sep 2026
CA-P-27563Harbor DistributingHuntington Beach, CAFirst listed 30 Sep 2026
CA-P-27564name not in our copyCarlsbad, CAFirst listed 30 Sep 2026
CA-P-27565name not in our copySacramento, CAFirst listed 30 Sep 2026
CA-P-27566Willow Lake PegasusLathrop, CAFirst listed 30 Sep 2026
CA-P-27567Self ImportsSan Jose, CAFirst listed 30 Sep 2026
Where the 39,092 wholesaler permits sit — 12 of 52 states and territories 30 Sep 2026
State or territoryPermitsBiggest town there
California9,365Napa
New York2,729New York
Florida2,720Miami
Texas2,170Houston
Washington1,913Seattle
Oregon1,465Portland
Illinois1,158Chicago
Pennsylvania1,005Philadelphia
North Carolina991Raleigh
Iowa930Des Moines
South Carolina927Charleston
Kansas907Wichita

What this page cannot tell you

  • 20,190 of the 39,092 permits on the newest copy have no trading name. The government's own file leaves that box empty, so we cannot fill it. Those rows carry the permit number and the town and say the name is missing, rather than showing an empty cell as though it were a name.
  • A permit dropping off means it was on one dated copy and not on the next one. That is all it means. It is not proof that TTB revoked the permit, and it is not proof that the business closed: the government's file carries no issue date, no expiry date and no status, so nobody reading it can tell you why a row left, and we will not guess. We sealed our first copy on 8 Aug 2026, so anything that moved before that date is not in what we hold.
  • This page is one trade out of the 4 trades the government's file carries. A permit sits in exactly one of them, so nothing here is counted twice.
  • Town and county names arrive from the government in capital letters. We print them in ordinary mixed case. Nothing else about a row is changed.
  • We have read this file 10 times: 8 Aug 2026, 11 Aug 2026, 19 Aug 2026, 25 Aug 2026, 1 Sep 2026, 8 Sep 2026, 9 Sep 2026, 16 Sep 2026, 23 Sep 2026 and 30 Sep 2026. That is not enough to know how often it changes, so the 7-day figure on this page is what we promise to send you, not a rhythm we measured. Everything above is one of those copies compared with another.

See the file before you pay

You do not have to take our word for what is in the file. Here are 25 rows of the real thing, carrying all 8 of its columns, cut out of the dated copies we sealed ourselves. Nothing in it is made up and nothing in it is tidied up.

  • Open the 25 rows as a CSVA plain spreadsheet file. It saves to your machine rather than painting itself into a browser tab, and it opens in Excel, Numbers or Google Sheets.
  • The same 25 rows as JSONThe same rows again, laid out for reading with code.

What arrives after you pay: Stripe sends you to the receipt page. After payment confirmation, your dated CSV for the state or territory selected at checkout appears there. Keep the receipt link for subsequent files. Nobody emails you. The subscriber CSV uses machine-readable column names and includes appeared, changed and gone rows, plus a coverage row naming the two source dates. The public preview uses shorter labels.

What you would be paying for: $99 a month, billed monthly, for one state or territory you name — not the national file. You get every permit that appeared and every permit that stopped being listed between the copies we hold, with the permit number, the city, the state, the industry, and the business name where our copy holds one. Some rows have no business name in our copy. We print the gap rather than filling it in, because a permit number you can look up is worth more than a name we guessed. Cancel any month by email, with no account to close and no notice period. At checkout, choose one state or territory in the required Which state field. After your active payment is confirmed, the receipt page shows a dated CSV for that state. New source comparisons add dated files when available. Missing or invalid state input remains unassigned; email operations@ustechautomations.com to correct it.

These 25 rows are a slice of the file, not the whole of it. What we cannot show you here is how far back it goes: that is the part you are paying for.

Subscribe to this feed

$99/mo · Dated source pairs

Subscribe — $99 a month

$99 a month, billed monthly, for one state or territory you name — not the national file. You get every permit that appeared and every permit that stopped being listed between the copies we hold, with the permit number, the city, the state, the industry, and the business name where our copy holds one. Some rows have no business name in our copy. We print the gap rather than filling it in, because a permit number you can look up is worth more than a name we guessed. Cancel any month by email, with no account to close and no notice period. At checkout, choose one state or territory in the required Which state field. After your active payment is confirmed, the receipt page shows a dated CSV for that state. New source comparisons add dated files when available. Missing or invalid state input remains unassigned; email operations@ustechautomations.com to correct it.

Rather ask first? Email operations@ustechautomations.com. Select the state or territory at checkout; the receipt page carries that selection and the dated state CSV. Email operations@ustechautomations.com to correct missing or invalid input.

More from this feed