US Tech Automations

Other dated records TTB appear / disappear list 155,608 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-08-25

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. Often it does not: across the dated copies we hold today, about half the appear and disappear rows carry no business name. 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-08-25. We read this source about every 7 days. We hold 4 sealed runs going back to 2026-08-08.

What this page is155,608 rows held · newest sealed read 2026-08-25

  • Between 19 Aug 2026 and 25 Aug 2026 we detected 82 changes in this list: 36 permits appeared for the first time, 3 permits were on the 19 Aug 2026 copy and gone from the 25 Aug 2026 one, and 41 permits sat on both copies with 43 fields that moved between them. 2 of those permits had more than one field move at once, which is why the 43 is the bigger number.
  • We hold 155,608 dated permit rows for this slice, across 4 sealed copies of the government's list dated 8 Aug 2026, 11 Aug 2026, 19 Aug 2026 and 25 Aug 2026. 38,957 permits sit on the newest one.
  • The collector's log holds 12 run records. 4 of those runs downloaded the file and sealed a copy. The rest either found nothing new or came back with nothing at all.
  • 38,957 permits of the 84,273 on the whole 25 Aug 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 82 changes 19 Aug 2026 → 25 Aug 2026
PermitBusinessWhereWhat changed
AK-P-21042Columbia DistributingFairbanks, AKFirst listed 25 Aug 2026
AK-P-21043Columbia DistributingJuneau, AKFirst listed 25 Aug 2026
AL-P-21102name not in our copyHuntsville, ALFirst listed 25 Aug 2026
AZ-P-21326name not in our copyScottsdale, AZFirst listed 25 Aug 2026
CA-P-27537Inner CellarsNapa, CAFirst listed 25 Aug 2026
CA-P-27538name not in our copyDana Point, CAFirst listed 25 Aug 2026
CA-P-27539name not in our copyDenair, CAFirst listed 25 Aug 2026
CA-P-27540Vineyard Squadron WinesLong Beach, CAFirst listed 25 Aug 2026
FL-P-23300michel rivera enterprises incHudson, FLFirst listed 25 Aug 2026
FL-P-23301Revanche Cognac IncMiami Beach, FLFirst listed 25 Aug 2026
FL-P-23302CASKS & BOTTLESTampa, FLFirst listed 25 Aug 2026
FL-P-23303SOUTHERN GLAZER'S OF IACedar Rapids, FLFirst listed 25 Aug 2026
Where the 38,957 wholesaler permits sit — 12 of 52 states and territories 25 Aug 2026
State or territoryPermitsBiggest town there
California9,346Napa
New York2,724New York
Florida2,704Miami
Texas2,143Houston
Washington1,909Seattle
Oregon1,461Portland
Illinois1,154Chicago
Pennsylvania1,005Philadelphia
North Carolina988Raleigh
Iowa929Des Moines
South Carolina920Charleston
Kansas902Wichita

What this page cannot tell you

  • 20,122 of the 38,957 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 4 times: 8 Aug 2026, 11 Aug 2026, 19 Aug 2026 and 25 Aug 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: a person emails you the whole file as a CSV — the same plain spreadsheet as the sample file above, not a login and not a web page — within one working day of your payment.

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. Often it does not: across the dated copies we hold today, about half the appear and disappear rows carry no business name. 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. After you pay, a person emails you the whole appear / disappear file as a CSV within one working day, and a new one every week for as long as the subscription runs. That weekly email is what we undertake to send you. The TTB says on its own page that it posts updates weekly. We have read the source 4 times — 8, 11, 19 and 25 August 2026 — and the gaps were 3, 8 and 6 days, not one of them 7. What we have measured ourselves does not match that weekly rhythm, so the weekly email is what we undertake to send you, not a rhythm we claim to have seen. Where a week brings no new copy of the source, or we could not collect it, that week's file says so rather than repeating itself, and if we stop being able to read the source at all the file says that too. The TTB publishes the permit list as it stands today and overwrites the last one. It publishes the new permits free each week in its own short file, so most of the appearances in your file can also be had free from the TTB: in the most recent week we sealed, 96 of the 105 appearances were in that free file. What is published nowhere free is the permits that stopped being listed and the quiet changes to permits already on the list, and that is what you are paying us to keep. We tell you exactly which dated copies we hold for your state or territory before you pay anything.

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 · 4 reads so far, 3, 8 and 6 days apart

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. Often it does not: across the dated copies we hold today, about half the appear and disappear rows carry no business name. 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. After you pay, a person emails you the whole appear / disappear file as a CSV within one working day, and a new one every week for as long as the subscription runs. That weekly email is what we undertake to send you. The TTB says on its own page that it posts updates weekly. We have read the source 4 times — 8, 11, 19 and 25 August 2026 — and the gaps were 3, 8 and 6 days, not one of them 7. What we have measured ourselves does not match that weekly rhythm, so the weekly email is what we undertake to send you, not a rhythm we claim to have seen. Where a week brings no new copy of the source, or we could not collect it, that week's file says so rather than repeating itself, and if we stop being able to read the source at all the file says that too. The TTB publishes the permit list as it stands today and overwrites the last one. It publishes the new permits free each week in its own short file, so most of the appearances in your file can also be had free from the TTB: in the most recent week we sealed, 96 of the 105 appearances were in that free file. What is published nowhere free is the permits that stopped being listed and the quiet changes to permits already on the list, and that is what you are paying us to keep. We tell you exactly which dated copies we hold for your state or territory before you pay anything.

Rather ask first? Email operations@ustechautomations.com. Say that you want Alcohol wholesalers and we will tell you which weeks we hold for it before you pay.

More from this feed