🔔 NYC DCWP Business Licence Registry

One business_licence_record per DCWP licence: licence number, business + DBA name, category, type, status, creation/expiration dates, contact phone, and full address, from the keyless Socrata API.

One structured registry_record per record from the NYC Open Data DCWP licences resource (Socrata w7w3-xahh, ~69,885 rows). Public, logged-out, robots-honoured.

Output is one business_licence_record 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.cityofnewyork.us.

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

Who buys this

Buyers usually search for NYC business license or DCWP license.

• Sales and lead-generation teams building lists from NYC business license.
• KYB, onboarding and compliance teams checking DCWP license.
• Market researchers and data teams that need the official record as rows.

📊 Sample Output

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

license_number	business_name	business_category	license_type	license_creation_date	license_expiration_date
0002902-DCA	GEM FINANCIAL SERVICES, INC.	Pawnbroker	Premises	2007-04-18T00:00:00.000	2027-04-30T00:00:00.000
0010669-DCA	SAYYED, IQBAL	Newsstand	Premises	2002-03-25T00:00:00.000	2028-03-31T00:00:00.000
0010699-DCA	KALOGIANNAKIS, MARINOS	Newsstand	Premises	2002-05-14T00:00:00.000	2028-03-31T00:00:00.000
0010971-DCA	KAUFMAN, MARILYN	Newsstand	Premises	1999-02-12T00:00:00.000	2024-03-31T00:00:00.000
0010985-DCA	TOM, SIK PUI	Newsstand	Premises	1999-02-11T00:00:00.000	2024-03-31T00:00:00.000
0011544-DCA	OLSEN NEWS CORP.	Newsstand	Premises	1999-02-12T00:00:00.000	2026-03-31T00:00:00.000
0011671-DCA	DESAI, INDUBEN K	Newsstand	Premises	1999-02-11T00:00:00.000	2028-03-31T00:00:00.000
0016371-DCA	JAMES ROBINSON, INC.	Secondhand Dealer - General	Premises	2003-10-31T00:00:00.000	2027-07-31T00:00:00.000

The run finished with the status message: CAPPED: delivered 50 of 51 unique rows (maxRecords=50). 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. business_licence_record
• license_number (string/null) — e.g. 0002902-DCA
• business_name (string/null) — e.g. GEM FINANCIAL SERVICES, INC.
• dba_trade_name (string/null) — e.g. GEM PAWNBROKERS
• business_category (string/null) — e.g. Pawnbroker
• license_type (string/null) — e.g. Premises
• license_status (string/null) — e.g. Active
• license_creation_date (string/null) — e.g. 2007-04-18T00:00:00.000
• license_expiration_date (string/null) — e.g. 2027-04-30T00:00:00.000
• contact_phone (string/null) — e.g. 7182371166
• address (string/null) — e.g. 608 8TH AVE
• city (string/null) — e.g. NEW YORK
• state (string/null) — e.g. NY
• zip (string/null) — e.g. 10018
• borough (string/null) — e.g. Manhattan
• source (string/null) — e.g. nyc-dcwp-business-licence-registry
• release_date (string/null) — null in every sample row
• source_url (string/null) — e.g. https://data.cityofnewyork.us/resource/w7w3-xahh.json
• observed_at (string/null) — e.g. 2026-09-23T16:14:30Z
• 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

✅ What you get

• record_type (string) — e.g. business_licence_record
• license_number (string/null) — e.g. 0002902-DCA
• business_name (string/null) — e.g. GEM FINANCIAL SERVICES, INC.
• dba_trade_name (string/null) — e.g. GEM PAWNBROKERS
• business_category (string/null) — e.g. Pawnbroker
• license_type (string/null) — e.g. Premises
• license_status (string/null) — e.g. Active
• license_creation_date (string/null) — e.g. 2007-04-18T00:00:00.000
• license_expiration_date (string/null) — e.g. 2027-04-30T00:00:00.000
• contact_phone (string/null) — e.g. 7182371166
• address (string/null) — e.g. 608 8TH AVE
• city (string/null) — e.g. NEW YORK
• state (string/null) — e.g. NY
• zip (string/null) — e.g. 10018
• borough (string/null) — e.g. Manhattan
• source (string/null) — e.g. nyc-dcwp-business-licence-registry
• release_date (string/null) — null in every sample row
• source_url (string/null) — e.g. https://data.cityofnewyork.us/resource/w7w3-xahh.json
• observed_at (string/null) — e.g. 2026-09-18T05:50:14Z
• 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

What you get

One registry_record per entity, deduplicated on the source-native id. Fields the source does not publish for a row are honest null. A run_receipt row carries the source URL, any reported total, and the delivered/duplicate counts.

⚙️ Sample inputs

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

{
  "maxRecords": 10
}

The sample run charged exactly: 1 × $0.02 apify-actor-start + 50 × $0.02 registry_record = $1.02 on the Free tier — every delivered row was billed. If you leave maxRecords out, the run delivers at most 5000 rows (the schema default); pass a number up to 1000000 for a bigger export. An explicit value is always honoured up to that maximum.

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 — about $100.02 on the Free tier ($0.02 start + 5000 × $0.02) if the source has that many; maxRecords goes up to 1000000.

4. A filtered run

{
  "maxRecords": 10,
  "fieldMatch": {
    "business_name": "onemain"
  }
}

NYC licences for businesses whose name contains onemain; the source applies this filter before paging and before the maxRecords cap, so a match deep in the dataset is found, the reconciled count is the matched count, and only delivered matches are billed. A confirmed no-match ends EMPTY_SELECTION with nothing charged.

🧾 JSON sample record

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

{
  "record_type": "business_licence_record",
  "license_number": "0002902-DCA",
  "business_name": "GEM FINANCIAL SERVICES, INC.",
  "dba_trade_name": "GEM PAWNBROKERS",
  "business_category": "Pawnbroker",
  "license_type": "Premises",
  "license_status": "Active",
  "license_creation_date": "2007-04-18T00:00:00.000",
  "license_expiration_date": "2027-04-30T00:00:00.000",
  "contact_phone": "7182371166",
  "address": "608 8TH AVE",
  "city": "NEW YORK",
  "state": "NY",
  "zip": "10018",
  "borough": "Manhattan",
  "source": "nyc-dcwp-business-licence-registry",
  "release_date": null,
  "source_url": "https://data.cityofnewyork.us/resource/w7w3-xahh.json",
  "observed_at": "2026-09-23T16:14:30Z"
}

🔧 How it works

Source. The actor reads data.cityofnewyork.us — endpoints: https://data.cityofnewyork.us/resource/w7w3-xahh.json. Public pages and feeds only; nothing behind a login.

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.

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 works

How it behaves

Keyless Socrata $limit/$offset pagination. Bound the run with maxRecords; raise it for the full register. maxRecords caps the count. Duplicates, outages, and schema drift charge nothing.

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.018	$0.016	$0.0134

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: CAPPED: delivered 50 of 51 unique rows (maxRecords=50). 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.cityofnewyork.us. 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.cityofnewyork.us) 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.cityofnewyork.us. 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 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

• NOAA Storm Events Database Scraper — Scrape the NOAA Storm Events Database: event type, location, date, damage and casualties. One record per result. Pay per result
• NOAA Storm Events Locations — Structured storm-event location points from the U.S. NOAA/NCEI Storm Events Database, read directly from the official public bulk directory (http://www.ncei%E2%80%A6
• NY OCM Licence Registry — One ocm_licence_record per licence or application: entity name, DBA, licence type, status (label AND source status code preserved verbatim), see-cate…
• New Zealand Charities Register — One structured charity_record per registered organisation from New Zealand's official Charities Register — keyless, logged-out, CC BY 3.0 NZ
• NZX Market Announcements — One structured registryrecord per record from the official public source, logged-out. Public, robots-honoured
• OpenAlex Funder Master — Structured research funder records from the official OpenAlex data snapshot (funders entity), read directly from the anonymous public S3 snapshot — t…
• 🏢 About NexGen Watch — NexGen Watch is a catalog of more than 300 public data 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.