TTB Formula Processing Times
Daily snapshots of TTB formula approval queue: median turnaround and queue depth for spirits, wine, malt beverage formulas, and sample analysis.
Some alcohol products need formula approval before they can apply for a COLA — flavored spirits, wine with non-standard ingredients, certain malt beverage classes. Formula review is a separate TTB queue with its own turnaround clock.
This dataset is a daily snapshot of that queue — same shape as our COLA processing times file, but for formulas and sample analysis. Use it to plan launch sequencing when your product needs both a formula and a label approval.
Schema
| Column | Type | Description |
|---|---|---|
commodity |
string | beer (malt beverage), wine, or distilled spirits — or 'all' for sample analysis |
formula_type |
string | Specific TTB formula category (e.g. 'Wine Formulas', 'All Wines That Require Sample Analysis') |
snapshot_date |
date | Date the TTB page was scraped |
turnaround_days_median |
integer | Median calendar days from filing to approval |
queue_frontier_date |
date | Filing date TTB is currently working on |
queue_depth_days |
integer | snapshot_date minus queue_frontier_date, in days |
Sample query
select snapshot_date, formula_type, turnaround_days_median
from formula_processing_times
where snapshot_date > current_date - 30
order by snapshot_date desc, formula_type;Who uses this
- Plan launch sequencing for a product that needs both formula and COLA approval.
- Decide whether to reformulate around an ingredient that triggers formula review.
- Track whether sample analysis turnaround is a real bottleneck for a category.
License & reuse
This dataset is dedicated to the public domain under Creative Commons CC0 1.0 Universal. Use it however you like — commercially, in derivative products, in research — with no attribution required. Attribution to COLA Cloud is appreciated but not required.
The data is sourced from the US Alcohol and Tobacco Tax and Trade Bureau (TTB), a federal agency. Federal government works are not copyrightable; the cleaning and normalization layered on top is dedicated to the public domain.