# US State Liquor License Aggregator (`jungle_synthesizer/us-state-liquor-license-aggregator-scraper`) Actor Aggregates active ABC/liquor license data from US state portals — California (CSV), Texas and New York (Socrata API). Returns license holder, trade name, license type, status, address, and county. Ideal for distributor prospecting, compliance research, and POS system outreach. - **URL**: https://apify.com/jungle\_synthesizer/us-state-liquor-license-aggregator-scraper.md - **Developed by:** [BowTiedRaccoon](https://apify.com/jungle_synthesizer) (community) - **Categories:** Lead generation, Business - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, NaN bookmarks - **User rating**: No ratings yet ## Pricing Pay per event 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 ## US State Liquor License Aggregator Aggregates active alcoholic beverage control (ABC) / liquor license data from multiple US state open-data portals. Returns standardized records covering license holder, trade name, license type, status, address, and county — across California, Texas, and New York in a single run. ### Data Sources | State | Agency | Source | |-------|--------|--------| | CA | California ABC | Daily CSV bulk export (~129k records) | | TX | Texas TABC | Socrata API — data.texas.gov (~77k active records) | | NY | New York SLA | Socrata API — data.ny.gov (~59k active records) | All sources are publicly available open government data. No authentication or proxy is required. ### Input | Field | Type | Default | Description | |-------|------|---------|-------------| | `states` | array | `["CA","TX","NY"]` | State codes to fetch. Supported: `CA`, `TX`, `NY`. | | `licenseStatus` | string | `"active"` | `"active"` returns only active/current licenses; `"all"` includes expired and inactive. | | `maxItems` | integer | `10` | Maximum total records to return across all selected states. `0` = unlimited. | #### Example Input ```json { "states": ["CA", "TX"], "licenseStatus": "active", "maxItems": 500 } ```` ### Output Each record contains the following fields: | Field | Description | |-------|-------------| | `licenseHolderName` | Legal name of the license holder (individual or entity) | | `tradeName` | Trade name / DBA (Doing Business As) | | `licenseNumber` | State-assigned license or file number | | `licenseType` | License type code (state-specific, e.g. `47` for CA On-Sale General) | | `licenseClass` | License class or category description | | `licenseStatus` | Current status (Active, Expired, Suspended, etc.) | | `issuedDate` | Original issue date (YYYY-MM-DD) | | `expirationDate` | Expiration date (YYYY-MM-DD) | | `address` | Street address of the licensed premises | | `city` | City | | `state` | US state code (CA, TX, NY) | | `zip` | ZIP code | | `county` | County | | `sourceUrl` | URL of the source portal or data file | | `sourceState` | Two-letter US state code of the data source | | `scrapedAt` | ISO 8601 timestamp when the record was scraped | #### Example Output Record ```json { "licenseHolderName": "SMITH ENTERPRISES LLC", "tradeName": "THE DOWNTOWN BAR", "licenseNumber": "612345", "licenseType": "48", "licenseClass": "LIC", "licenseStatus": "ACTIVE", "issuedDate": "2019-03-15", "expirationDate": "2027-03-14", "address": "123 MAIN ST", "city": "LOS ANGELES", "state": "CA", "zip": "90001", "county": "LOS ANGELES", "sourceUrl": "https://www.abc.ca.gov/licensing/licensing-reports/", "sourceState": "CA", "scrapedAt": "2026-05-10T10:36:12.000Z" } ``` ### Use Cases - **Distributor prospecting** — Identify licensed retailers, bars, and restaurants in target markets - **Compliance research** — Verify license status before executing contracts or shipments - **POS / ordering system outreach** — Build contact lists for B2B alcohol tech sales - **Market analysis** — Map the distribution of license types across counties and cities ### Performance & Scale - CA: ~7 MB ZIP download, ~129k total records. The actor applies an active-status filter client-side; the CA CSV includes both issued licenses (LIC) and pending applications (APP). - TX: Server-side `$where=primary_status='Active'` filter reduces the dataset to ~77k active records before transfer. Pagination at 5,000 records per request. - NY: The NY SLA dataset is pre-filtered to current active licenses only (~59k records). No additional filtering required. For large full-state runs (`maxItems: 0`), set the actor timeout to at least 30 minutes and memory to 512 MB. ### Pricing Pay-per-event pricing: $0.10 per run + $0.00125 per record scraped. # Actor input Schema ## `sp_intended_usage` (type: `string`): Please describe how you plan to use the data extracted by this crawler. ## `sp_improvement_suggestions` (type: `string`): Provide any feedback or suggestions for improvements. ## `sp_contact` (type: `string`): Provide your email address so we can get in touch with you. ## `states` (type: `array`): US state codes to include. Supported: CA, TX, NY. Defaults to all three. ## `licenseStatus` (type: `string`): Filter by license status. 'active' returns only active/current licenses. 'all' includes expired and inactive. ## `maxItems` (type: `integer`): Maximum number of license records to return (across all selected states). 0 = unlimited. ## Actor input object example ```json { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "states": [ "CA", "TX", "NY" ], "licenseStatus": "active", "maxItems": 10 } ``` # Actor output Schema ## `results` (type: `string`): No description # 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 = { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "states": [ "CA", "TX", "NY" ], "licenseStatus": "active", "maxItems": 10 }; // Run the Actor and wait for it to finish const run = await client.actor("jungle_synthesizer/us-state-liquor-license-aggregator-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 = { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "states": [ "CA", "TX", "NY", ], "licenseStatus": "active", "maxItems": 10, } # Run the Actor and wait for it to finish run = client.actor("jungle_synthesizer/us-state-liquor-license-aggregator-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 '{ "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "states": [ "CA", "TX", "NY" ], "licenseStatus": "active", "maxItems": 10 }' | apify call jungle_synthesizer/us-state-liquor-license-aggregator-scraper --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=jungle_synthesizer/us-state-liquor-license-aggregator-scraper", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "US State Liquor License Aggregator", "description": "Aggregates active ABC/liquor license data from US state portals — California (CSV), Texas and New York (Socrata API). Returns license holder, trade name, license type, status, address, and county. Ideal for distributor prospecting, compliance research, and POS system outreach.", "version": "0.1", "x-build-id": "D9xtKGtiaGrGkl2Zv" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/jungle_synthesizer~us-state-liquor-license-aggregator-scraper/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-jungle_synthesizer-us-state-liquor-license-aggregator-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/jungle_synthesizer~us-state-liquor-license-aggregator-scraper/runs": { "post": { "operationId": "runs-sync-jungle_synthesizer-us-state-liquor-license-aggregator-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/jungle_synthesizer~us-state-liquor-license-aggregator-scraper/run-sync": { "post": { "operationId": "run-sync-jungle_synthesizer-us-state-liquor-license-aggregator-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", "required": [ "states", "maxItems" ], "properties": { "sp_intended_usage": { "title": "What is the intended usage of this data?", "minLength": 1, "type": "string", "description": "Please describe how you plan to use the data extracted by this crawler." }, "sp_improvement_suggestions": { "title": "How can we improve this crawler for you?", "minLength": 1, "type": "string", "description": "Provide any feedback or suggestions for improvements." }, "sp_contact": { "title": "Contact Email", "minLength": 1, "type": "string", "description": "Provide your email address so we can get in touch with you." }, "states": { "title": "States to Scrape", "type": "array", "description": "US state codes to include. Supported: CA, TX, NY. Defaults to all three." }, "licenseStatus": { "title": "License Status Filter", "enum": [ "active", "all" ], "type": "string", "description": "Filter by license status. 'active' returns only active/current licenses. 'all' includes expired and inactive." }, "maxItems": { "title": "Max Items", "type": "integer", "description": "Maximum number of license records to return (across all selected states). 0 = unlimited.", "default": 10 } } }, "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 } } } } } } } } } } ```