🔔 Missouri Active Alcohol Licenses

One record per associated-person row on each active Missouri alcohol licence (licence number + type, licensee, DBA name, premise address, county, and the associated person's role + name) from the keyless Missouri open-data resource (Division of Alcohol & Tobacco Control). Statutory licence + associated-person rows carried VERBATIM as published; nulls preserved.

Public, robots-honoured.

Output is one mo_alcohol_license_association row per result; billing is pay-per-event, the value event being one registry record (a $0.02 start fee per run, then $0.02 per registry record). Source: data.mo.gov.

No login, no API key and no CAPTCHA solving are involved: the source is read logged-out with an identified contact User-Agent.

📊 Sample Output

Real rows from run FYznS1BowPtJfYZOP on build 0.1.4 (2026-09-18), the same input as the Quick start below — every value is as the source published it (emails masked, long text shortened):

licensee	dbaname	street	city	state	phone_number
SCHAFER-REICHART SELECTIONS, INC.	SCHAFER-REICHART SELECTIONS INC.	SALISBURY RD STE 530	JACKSONVILLE	Florida	3474655459
001 VINTNERS, LLC	001 VINTNERS	CARNEROS HWY	NAPA	California	7077777001
1 BROADWAY LLC	RAQQA FOOD MART	S BROADWAY	SAINT LOUIS	Missouri	3148999988
1 PHILLIPS KWIK STOP INC	PHILLIPS 66	50PENNSYLVANIA	PAGEDALE	Missouri	3143395624
10 PIN ALLEY LLC	10 PIN ALLEY	N OSAGE BLVD	NEVADA	Missouri	4174484399
10-55 BAR&QUE LLC	10-42 BAR&QUE	VALLEY ROAD	GRAVOIS MILLS	Missouri	8168383140
1001 WASHINGTON TENANT, LLC	BUDDY'S WINE BAR & BISTRO	WASHINGTON AVE	SAINT LOUIS	Missouri	3147627201
10901 HALLS FERRY OPERATIONS LLC	10901 HALLS FERRY OPERATIONS	HALLS FERRY RD	FERGUSON	Missouri	9015902877

The run finished with the status message: NORMAL: 50 unique rows (0 duplicates collapsed). billable=50

✅ What you get

Each row is flat JSON with these fields (from the dataset schema and the sample run; a field the source does not publish for a given row is null):

• record_type (string) — e.g. mo_alcohol_license_association
• licensee (string/null) — e.g. SCHAFER-REICHART SELECTIONS, INC.
• dbaname (string/null) — e.g. SCHAFER-REICHART SELECTIONS INC.
• street_number (string/null) — e.g. 4500
• street (string/null) — e.g. SALISBURY RD STE 530
• city (string/null) — e.g. JACKSONVILLE
• state (string/null) — e.g. Florida
• zipcode (string/null) — e.g. 32216
• phone_number (string/null) — e.g. 3474655459
• primary_license (string/null) — e.g. 317942
• primary_type (string/null) — e.g. 22% Solicitor - Out-State
• county (string/null) — e.g. 00 - OUT OF STATE
• assoc (string/null) — e.g. MGR
• name (string/null) — e.g. NERMIN KURTESI
• phone (string/null) — e.g. 3474655459
• source (string/null) — e.g. missouri-active-alcohol-licenses
• release_date (string/null) — null in every sample row
• source_url (string/null) — e.g. https://data.mo.gov/resource/yyhn-562y.json
• observed_at (string/null) — e.g. 2026-09-18T19:46:39Z
• terminal (string/integer/null) — null in every sample row
• reported_total (string/integer/null) — null in every sample row
• raw_seen (string/integer/null) — null in every sample row
• duplicates (string/integer/null) — null in every sample row
• unique_found (string/integer/null) — null in every sample row
• delivered (string/integer/null) — null in every sample row
• scope (string/integer/null) — null in every sample row
• note (string/integer/null) — null in every sample row
• license (string/integer/null) — null in every sample row
• attribution (string/integer/null) — null in every sample row

What you get

One registry_record per entity, deduplicated on the source-native id. Fields the source does not publish are honest null. A run_receipt row carries the source URL, scope, reconciliation counts, and delivered/duplicate totals.

⚙️ Sample inputs

1. Quick start — the Store example (this is what the sample above came from)

{
  "maxRecords": 50
}

The sample run charged exactly: 2 × $0.02 apify-actor-start + 50 × $0.02 registry_record = $1.04 on the Free tier — every delivered row was billed.

2. A smaller, narrowed run

{
  "maxRecords": 5
}

Caps the run at 5 rows — about $0.12 on the Free tier ($0.02 start + 5 × $0.02).

3. A full-size run

{
  "maxRecords": 5000
}

Up to 5000 rows (the schema default for maxRecords) — about $100.02 on the Free tier ($0.02 start + 5000 × $0.02) if the source has that many.

🧾 JSON sample record

One real record from run FYznS1BowPtJfYZOP, exactly as it lands in the dataset (emails masked, long text shortened):

{
  "record_type": "mo_alcohol_license_association",
  "licensee": "SCHAFER-REICHART SELECTIONS, INC.",
  "dbaname": "SCHAFER-REICHART SELECTIONS INC.",
  "street_number": "4500",
  "street": "SALISBURY RD STE 530",
  "city": "JACKSONVILLE",
  "state": "Florida",
  "zipcode": "32216",
  "phone_number": "3474655459",
  "primary_license": "317942",
  "primary_type": "22% Solicitor - Out-State",
  "county": "00 - OUT OF STATE",
  "assoc": "MGR",
  "name": "NERMIN KURTESI",
  "phone": "3474655459",
  "source": "missouri-active-alcohol-licenses",
  "release_date": null,
  "source_url": "https://data.mo.gov/resource/yyhn-562y.json",
  "observed_at": "2026-09-18T19:46:39Z"
}

🔧 How it works

Transport. Plain HTTPS from the Apify platform, no proxy. robots.txt is read first and a disallowed path is never fetched. Every request carries an identified contact User-Agent. Pacing: CRAWL_DELAY=0.0.

Charging. Each registry record is charged at the moment it is pushed (registry_record); a row that fails to charge is not delivered, so the dataset count always equals the charged count.

How it behaves

Rows are paged from the MO Socrata resource (:id order, $limit/$offset) and count(*) reconciled. Each licence carries one row per associated person/role (manager, contact, etc.); records are keyed on the licence + role + person composite so distinct associations are kept while exact-duplicate rows collapse. Fields copied verbatim. Streaming, bounded to maxRecords.

Source

https://data.mo.gov/resource/yyhn-562y.json

What is not done. No login, no cookie or CAPTCHA bypass, no private or personal-account data, no browser automation.

💰 Pricing example

Event	Free	Bronze	Silver	Gold
Actor Start (apify-actor-start)	$0.02	$0.02	$0.02	$0.02
Registry Record (registry_record)	$0.02	$0.02	$0.02	$0.01

Worked at the live Free-tier price:

• 8 registry records: $0.02 start + 8 × $0.02 = $0.18
• 25 registry records: $0.02 start + 25 × $0.02 = $0.52
• 5000 registry records: $0.02 start + 5000 × $0.02 = $100.02

A run that delivers zero rows charges the $0.02 start fee only. A BLOCKED run (source refused) fails loud and charges no value event. The start fee is charged once per GB of run memory; the default run memory is 4096 MB.

Yield on the sample run: NORMAL: 50 unique rows (0 duplicates collapsed). billable=50. maxRecords is a hard ceiling on what is delivered and billed, never a target.

⚖️ Legal & ToS

This actor reads public, logged-out pages and feeds published by data.mo.gov. It collects only what the source publishes to any visitor, keeps to the source's robots rules (checked on every run), identifies itself with a contact User-Agent, and does not access accounts, private data or anything behind authentication. Use the output in line with the source's terms and your local law; the intended use is B2B research and monitoring.

❓ FAQ

Q: Do I need an API key or a login?
A: No. The source (data.mo.gov) is read logged-out; the input schema has no key field and the actor carries no secrets.

Q: Why did my run return 0 rows?
A: Read the run's status message. GENUINE_EMPTY means the source was read and had nothing in scope for your input; BLOCKED means the source refused and the run failed without billing a value event — retry later or narrow the input. A zero-row run bills the start fee only.

Q: How many rows can one run return?
A: Up to maxRecords (default 5000). Raise the cap for a bigger run; you pay per delivered row.

Q: How fresh is the data?
A: Every run reads the source live at run time; nothing is cached between runs. Put it on a schedule for a continuous feed.

Q: What formats can I export?
A: The dataset downloads as JSON, CSV, Excel, XML or RSS from the run's Dataset tab or the Apify API, and any run can push to a webhook or integration.

Q: How is this different from the other NexGen Watch actors actors?
A: Same output shape and billing model; this one covers data.mo.gov. The siblings under Related Actors cover the other sources or slices — run several on one schedule for a combined feed.

Q: Are there rate limits?
A: The actor paces itself against the source (CRAWL_DELAY=0.0) and honours its robots rules; there is no per-buyer limit beyond your Apify plan's concurrency.

🆘 Troubleshooting

• Run FAILED with BLOCKED → the source refused the request or changed its page shape → nothing was billed beyond the start fee; retry after a while, and if it persists open an Issue with the run id.
• Status says CAPPED → your cap (maxRecords) was reached → raise it for a bigger run.
• Input validation error on start → a field is outside the schema's allowed values → start from the Quick start block and change one field at a time.
• Run TIMED-OUT → a very wide request on a slow day → raise the run timeout in Run options or narrow the input; what was delivered before the timeout is still in the dataset.

🔗 Related Actors

• Latvia Annual-Report Financial Statements — Latvia Annual-Report Financial Statements
• Lithuania Financial Statement Lines — same family, different source
• Lithuania Legal Entity Roster — same family, different source
• NY OCM Licence Registry — One structured registryrecord per record from the New York Office of Cannabis Management licence dataset (keyless NY Socrata jskf-tt3q, ~2,927 rows).…
• NYC DCWP Business Licence Registry — One structured registryrecord per record from the NYC Open Data DCWP licences resource (Socrata w7w3-xahh, ~69,885 rows). Public, logged-out, robots-…
• Oregon Active Businesses Master — One structured registryrecord per record from the official public source, logged-out. Public, robots-honoured
• 🏢 About NexGenData — NexGen Watch is NexGenData's fleet of 256 public monitoring and lookup actors built on official sources, pay-per-result. Browse the catalog at apify.com/nexgenwatch.

⭐ Found this useful?

If this actor saved you a manual check, a quick review on the Apify Store helps other teams find it. Feature request or a source that changed? Open it from the Issues tab — every one is read.