TTB Alcohol Production Reports
Monthly and annual federal alcohol production statistics — beer, wine, and distilled spirits production volumes, denaturing, and withdrawal totals from TTB Statistical Releases.
The TTB publishes monthly statistical releases summarizing US alcohol production: how much beer was bottled, how much wine was bottled and shipped, how much spirits was distilled and withdrawn. The data has been published in PDFs and Excel files since the early 2010s. It's the most reliable federal source for industry-wide production volumes.
This dataset is the consolidated long-format version of those reports — every commodity, every statistical category, every month, in a single tidy table. Redacted cells (where TTB withholds for confidentiality) are preserved with an is_redacted flag rather than dropped.
Use it to build trend charts the way BW166 and analyst shops do, without paying for a subscription that wraps the same source data.
Schema
| Column | Type | Description |
|---|---|---|
commodity |
string | beer, wine, or distilled spirits |
report_type |
string | monthly or annual |
year |
integer | Report year |
month_number |
integer | Report month (1-12), null for annual reports |
report_date |
date | First day of the report period |
statistical_group |
string | Top-level grouping from the TTB release (e.g. 'Operations at Denaturing Facility') |
statistical_category |
string | Sub-grouping under the statistical group |
statistical_detail |
string | Finest-grain row label from the TTB table |
count_ims |
integer | Number of reporting establishments contributing to the cell |
value |
numeric | Reported value (volume, weight, etc.) |
value_unit |
string | Unit of measure (proof gallons, barrels, wine gallons, etc.) |
is_redacted |
boolean | True if TTB withheld the value for confidentiality |
Sample query
select report_date, value
from production_reports
where commodity = 'distilled spirits'
and statistical_category = 'Category Total'
and value_unit = 'proof gallons'
and report_type = 'monthly'
order by report_date;Who uses this
- Replicate the volume-side of a BW166-style market report using the underlying federal source.
- Track domestic vs. imported spirits production over time.
- Build a beer / wine / spirits production index for an investor deck.
- Detect inflection points in category-level volumes (e.g. RTD growth in malt beverages).
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.