The US Department of Alcohol and Tobacco Tax and Trade Bureau (TTB) issues permits to entities in the United States alcohol industry. Permits for distilleries, importers, and wholesalers are available across several bulk exports on the TTB's website.

Permits for breweries and wineries, are not available for bulk export but can be found in the TTB's Public COLA Registry of product label approvals.

This dataset combines permits from the bulk exports and the COLA registry to produce a comprehensive set of permit-holding companies in the United States alcohol industry.

colas (via permit_number)

Each COLA belongs to a permit_number.

‍is_active - indicates whether the permit_number is either currently listed in the TTB's bulk exports, or has applied for a COLA within the last 365 days. Because breweries and winery permits are not listed in bulk, the definition of is_active spans these two cases.

COLA Involvement

Not all permit holders deal with COLA applications. Usually producers and importers are the companies that apply for COLAs with the TTB when they are needed.

permittees_permit_number (TEXT)
The unique identifier of a TTB permit. It contains 3-4 sections separated by hyphens. The code also includes the type of permit.

is_active (BOOLEAN)
Indicates whether the permit is currently in the TTB's export records, or has been associated with a COLA in the last 365 days.

active_reason (TEXT)
Details the is_active indicator. (TEXT)

company_name (TEXT)
The name of the permit-holding entity associated with the active permit, or the last COLA.

company_zip_code (TEXT)
The 5-digit US ZIP code of the permit-holding entity from the active permit, or the last COLA.

company_state (TEXT)
The US state (in lowercase) of the permit-holding entity from the active permit, or the last COLA.

colas (NUMBER)
The all-time number of COLA applications associated with the permit.

colas_approved (NUMBER)
The all-time number of COLA applications that have been approved for the permit.

last_cola_application_date (DATE)
The date of the most recent COLA application associated with the permit.