US Tech Automations

Other dated records TTB appear / disappear list 83,924 rows held

California alcohol permits: 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 California permits that appeared and the ones that dropped off, cut down to California before it reaches you. 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 is83,924 rows held · newest sealed read 2026-08-25

  • Between 19 Aug 2026 and 25 Aug 2026 we detected 43 changes in this list: 22 permits appeared for the first time, 5 permits were on the 19 Aug 2026 copy and gone from the 25 Aug 2026 one, and 16 permits sat on both copies with 16 fields that moved between them.
  • We hold 83,924 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. 21,002 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.
  • The most common trade in California is Wholesaler (Alcohol), on 9,346 of its 21,002 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 California list — 12 of 43 changes 19 Aug 2026 → 25 Aug 2026
PermitBusinessWhereWhat changed
CA-I-24409name not in our copySan Diego, CAFirst listed 25 Aug 2026
CA-I-24410name not in our copyWestminster, CAFirst listed 25 Aug 2026
CA-I-24411Amigos AgaverosRiverside, CAFirst listed 25 Aug 2026
CA-I-24412name not in our copyDenair, CAFirst listed 25 Aug 2026
CA-I-24413Vineyard Squadron WinesLong Beach, CAFirst 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
CA-S-20606SLO Fish CoSan Luis Obispo, CAFirst listed 25 Aug 2026
CA-S-20607name not in our copySan Diego, CAFirst listed 25 Aug 2026
CA-S-20608name not in our copySanta Ynez, CAFirst listed 25 Aug 2026
Where California's 21,002 permits sit — 12 of 901 towns and cities 25 Aug 2026
Town or cityPermitsMost common trade there
Napa1,811Wine Producer
Los Angeles846Wholesaler (Alcohol)
Paso Robles645Wine Producer
Santa Rosa625Wholesaler (Alcohol)
San Francisco578Wholesaler (Alcohol)
Healdsburg540Wine Producer
San Diego501Wholesaler (Alcohol)
Saint Helena493Wholesaler (Alcohol)
Sonoma479Wine Producer
Calistoga330Wine Producer
San Jose238Wholesaler (Alcohol)
Sebastopol213Wine Producer

What this page cannot tell you

  • 8,784 of the 21,002 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.
  • A permit lands on this page when the address on its own row says California. Every permit in this slice has one, so none were placed by the state letters at the front of the permit number. Those letters sometimes disagree with the address: 2 permits with a California address carry another state's letters, and 0 permits numbered as California sit at an address elsewhere. We keep the address and flag the disagreement rather than quietly picking one.
  • 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 California and we will tell you which weeks we hold for it before you pay.

More from this feed