# TTB COLA Scraper — New Alcohol Label Approvals & Alerts (`scrapersdelight/ttb-cola-scraper`) Actor Scrape the U.S. TTB public COLA registry — every approved beer, wine & spirits label with brand, fanciful name, class/type, origin, permit & approval date. Filter by date, class, origin, or brand; monitor NEW approvals on a schedule with Slack/email/webhook alerts. $4 per 1,000 labels. - **URL**: https://apify.com/scrapersdelight/ttb-cola-scraper.md - **Developed by:** [Scrapers Delight](https://apify.com/scrapersdelight) (community) - **Categories:** Lead generation, Automation, Other - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing from $4.00 / 1,000 per record returneds This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## 🍷 TTB COLA — Alcohol Label Approval Scraper & New-Approval Monitor **Scrape the U.S. TTB public COLA registry — the federal record of every approved beer, wine, and spirits label — with brand, fanciful name, class/type, origin, permit, serial, and approval date. Filter by date, class, origin, or brand, and run it on a schedule to monitor NEW label approvals with Slack / email / webhook alerts.** No login, no anti-bot — it's public federal data served as server-rendered HTML. (A paid SaaS, COLA Cloud, sells exactly this "monitor new approvals" capability; this actor gives you the scheduled scraper.) --- ### What does it do? It searches the TTB Public COLA Registry (Certificate/Exemption of Label/Bottle Approval) and returns clean rows you can export to **JSON, CSV, Excel, or push to your app via API** — and, on a schedule, it alerts you to brand-new approvals. - 🍾 **Every approved label** in your date range / filters. - 🏷️ **Brand name, fanciful name, class/type, origin, permit no., serial no., TTB ID.** - 📅 **Approval (completed) date** + a link to the full TTB detail page. - 🔔 **New-approval monitor** — alert when a new label is approved matching your class/origin/brand. --- ### What data does it extract? For every approval: `ttb_id`, `permit_no`, `serial_number`, `completed_date`, `fanciful_name`, `brand_name`, `origin_code`, `origin`, `class_code`, `class_type`, `detail_url`, `is_new` (monitor), `scraped_at`. --- ### Who is it for? - ⚖️ **Beverage-alcohol compliance & legal teams** tracking approvals and competitors. - 🏭 **Brands & importers** monitoring their own and rivals' label activity. - 🎨 **Label-design firms** and 📊 **market-intel** analysts watching new product launches. --- ### How to use it (step by step) 1. Click **Try for free**. 2. Set a **date range** (or just **Lookback days** for a rolling window) and any **class / origin / brand** filters. 3. Click **Start**, then open the **Dataset** tab to view/export. 4. *(Optional)* set **monitorMode** + a **Schedule** + an alert channel to get pinged on new approvals. #### Quick start ```json { "lookbackDays": 7 } ```` #### New-approval monitor example ```json { "lookbackDays": 2, "brandName": "RESERVE", "monitorMode": true, "slackWebhookUrl": "https://hooks.slack.com/services/…" } ``` *** ### Input | Field | What it does | |-------|--------------| | `dateFrom` / `dateTo` / `lookbackDays` | approval completed-date range | | `productSource`, `classType`, `origin`, `brandName`, `fancifulName` | TTB search filters | | `maxRecords` | hard cap per run (0 = all matching, up to TTB's ~1000/search cap) | | `monitorMode`, `alertOnNewApproval` | recurring new-approval watcher + alerts | | `webhookUrl`, `slackWebhookUrl`, `emailRecipients` | alert channels | | `proxyConfiguration` | proxy settings | *** ### Output Each approval is one dataset record (fields above). Export to **JSON, CSV, Excel, HTML, or RSS**, or fetch via the **Apify API**. *** ### How much does it cost? Pay-per-event — you pay for what you pull: | Event | What it covers | Suggested price | |-------|----------------|-----------------| | `lot-scraped` | each approval returned | ~$0.003 / approval | | `monitor-run-completed` | each scheduled watch run | ~$0.05 / run | | `new-lot-detected` | each newly-approved label | ~$0.02 / approval | | `alert-delivered` | each Slack/email/webhook push | ~$0.005 / alert | *(Final per-event prices are set on the actor's pricing page.)* *** ### Notes & limits - TTB caps each search at ~1,000 results — narrow by date range / class / origin to page through everything. - This actor returns the **registry row data** (brand, class, origin, dates, IDs) + a link to the TTB detail page for the full record and label image. *** ### Is it legal to scrape TTB COLA data? Yes — the COLA registry is **public U.S. federal data**, published by the TTB for public search, and contains label/product data (not personal data). You're still responsible for your use: review TTB's site terms and any rules on bulk use. *** ### FAQ **What's a COLA?** A Certificate of Label Approval — TTB's required approval before a beer/wine/spirits label can be sold across state lines. **Can I get only new approvals?** Yes — `monitorMode` outputs/alerts only approvals new since the last run. **Do I get the label image?** The actor returns the registry fields plus a `detail_url` to the TTB page that shows the full record and label image. **How do I export?** JSON, CSV, Excel, HTML, or RSS from the Dataset tab, or via the Apify API. *** ### Feedback Want full detail-page enrichment (alcohol %, net contents, formula) or a bulk historical backfill? Open an issue on the actor. # Actor input Schema ## `dateFrom` (type: `string`): Approval completed-date range start. Leave empty to use today minus 'Lookback days'. ## `dateTo` (type: `string`): Approval completed-date range end. Leave empty for today. ## `lookbackDays` (type: `integer`): When no explicit dateFrom is given, scan approvals from this many days ago up to today (great for a daily monitor). ## `productSource` (type: `string`): TTB 'product or source' filter code (default '2'). Controls which product source the search returns. ## `classType` (type: `string`): Optional TTB class/type code to filter (e.g. wine/spirits class). ## `origin` (type: `string`): Optional TTB origin code to filter (state/country). ## `brandName` (type: `string`): Optional brand-name search. ## `fancifulName` (type: `string`): Optional fanciful-name search. ## `maxRecords` (type: `integer`): Hard cap per run (0 = all matching, up to the site's ~1000 cap per search). Prefilled to 100 for a fast first run. ## `monitorMode` (type: `boolean`): Recurring watcher: diff against the prior run's seen approvals (per filter scope) and output/alert ONLY new approvals. Pair with an Apify Schedule. ## `alertOnNewApproval` (type: `boolean`): In monitor mode, alert for each new label approval. ## `webhookUrl` (type: `string`): POST endpoint for new-approval alerts. ## `slackWebhookUrl` (type: `string`): Slack incoming-webhook URL. ## `emailRecipients` (type: `array`): Emails for the new-approval digest (via apify/send-mail). ## `proxyConfiguration` (type: `object`): Proxy settings. Public federal site; datacenter rotation is plenty. ## `diagnose` (type: `boolean`): Dev only. Logs the total matching count + the first parsed record, then exits. ## Actor input object example ```json { "lookbackDays": 7, "productSource": "2", "maxRecords": 100, "monitorMode": false, "alertOnNewApproval": true, "proxyConfiguration": { "useApifyProxy": true }, "diagnose": false } ``` # Actor output Schema ## `approvals` (type: `string`): The dataset of COLA label approvals (one item per approval). # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "maxRecords": 100 }; // Run the Actor and wait for it to finish const run = await client.actor("scrapersdelight/ttb-cola-scraper").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "maxRecords": 100 } # Run the Actor and wait for it to finish run = client.actor("scrapersdelight/ttb-cola-scraper").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "maxRecords": 100 }' | apify call scrapersdelight/ttb-cola-scraper --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=scrapersdelight/ttb-cola-scraper", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "TTB COLA Scraper — New Alcohol Label Approvals & Alerts", "description": "Scrape the U.S. TTB public COLA registry — every approved beer, wine & spirits label with brand, fanciful name, class/type, origin, permit & approval date. Filter by date, class, origin, or brand; monitor NEW approvals on a schedule with Slack/email/webhook alerts. $4 per 1,000 labels.", "version": "0.1", "x-build-id": "Qj72giiPpeQmSoogP" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/scrapersdelight~ttb-cola-scraper/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-scrapersdelight-ttb-cola-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/scrapersdelight~ttb-cola-scraper/runs": { "post": { "operationId": "runs-sync-scrapersdelight-ttb-cola-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/scrapersdelight~ttb-cola-scraper/run-sync": { "post": { "operationId": "run-sync-scrapersdelight-ttb-cola-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "properties": { "dateFrom": { "title": "Completed date from (MM/DD/YYYY)", "type": "string", "description": "Approval completed-date range start. Leave empty to use today minus 'Lookback days'." }, "dateTo": { "title": "Completed date to (MM/DD/YYYY)", "type": "string", "description": "Approval completed-date range end. Leave empty for today." }, "lookbackDays": { "title": "Lookback days", "minimum": 1, "type": "integer", "description": "When no explicit dateFrom is given, scan approvals from this many days ago up to today (great for a daily monitor).", "default": 7 }, "productSource": { "title": "Product/source filter code", "type": "string", "description": "TTB 'product or source' filter code (default '2'). Controls which product source the search returns.", "default": "2" }, "classType": { "title": "Class/type code", "type": "string", "description": "Optional TTB class/type code to filter (e.g. wine/spirits class)." }, "origin": { "title": "Origin code", "type": "string", "description": "Optional TTB origin code to filter (state/country)." }, "brandName": { "title": "Brand name contains", "type": "string", "description": "Optional brand-name search." }, "fancifulName": { "title": "Fanciful name contains", "type": "string", "description": "Optional fanciful-name search." }, "maxRecords": { "title": "Max records per run", "minimum": 0, "type": "integer", "description": "Hard cap per run (0 = all matching, up to the site's ~1000 cap per search). Prefilled to 100 for a fast first run.", "default": 0 }, "monitorMode": { "title": "Monitor mode (new-approval watcher)", "type": "boolean", "description": "Recurring watcher: diff against the prior run's seen approvals (per filter scope) and output/alert ONLY new approvals. Pair with an Apify Schedule.", "default": false }, "alertOnNewApproval": { "title": "Alert on new approvals", "type": "boolean", "description": "In monitor mode, alert for each new label approval.", "default": true }, "webhookUrl": { "title": "Webhook URL", "type": "string", "description": "POST endpoint for new-approval alerts." }, "slackWebhookUrl": { "title": "Slack webhook URL", "type": "string", "description": "Slack incoming-webhook URL." }, "emailRecipients": { "title": "Email recipients", "type": "array", "description": "Emails for the new-approval digest (via apify/send-mail).", "items": { "type": "string" } }, "proxyConfiguration": { "title": "Proxy", "type": "object", "description": "Proxy settings. Public federal site; datacenter rotation is plenty.", "default": { "useApifyProxy": true } }, "diagnose": { "title": "Diagnostic mode (dev)", "type": "boolean", "description": "Dev only. Logs the total matching count + the first parsed record, then exits.", "default": false } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```