🔔 EPA Pesticide Products (PPIS)

One structured pesticide_product_record per EPA pesticide registration — from the official EPA Pesticide Product Information System bulk files, public-domain and logged-out.

Difference: One joined product record per EPA registration number — product name, status (active/cancelled), signal word, formulation code, restricted-use and conditional-registration flags, approval and cancellation dates — joined to the registrant's organization name and business address. Sourced from EPA's own weekly bulk files, not the interactive search site.

Output is one epa_pesticide_product row per result; billing is pay-per-event, the value event being one pesticide product record (a $0.02 start fee per run, then $0.02 per pesticide product record). Source: www3.epa.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 ZIhMLO1raYqQcIfn7 on build 0.1.5 (2026-09-18), the same input as the Quick start below — every value is as the source published it (emails masked, long text shortened):

reg_number_raw	product_name	product_status	approval_date	registrant_name	registrant_street
00000107173	SOUTHERN'S SOLUBLE OIL	Cancelled/Transferred	19760101	PRATT LABORATORIES	PO BOX 6187
00000107313	SUN'S ROACH & ANT KILLER	Cancelled/Transferred	19760101	PRATT LABORATORIES	PO BOX 6187
00000108512	SQUIRREL TEN-EIGHTY POISON	Cancelled/Transferred	19760101	PRATT LABORATORIES	PO BOX 6187
00000205983	DIPHACINONE JACK RABBIT BAIT	Cancelled/Transferred	19760101	A. FISCHEL, INC
00000300001	HARRIS FAMOUS ROACH TABLETS	Active	19480702	P.F. HARRIS MANUFACTURING COMPANY, LLC	755 TRI-STATE PARKWAY
00000300003	HARRIS FAMOUS ROACH KILLER	Cancelled/Transferred	19850621	P.F. HARRIS MANUFACTURING COMPANY, LLC	755 TRI-STATE PARKWAY
00000300005	FORMULA BF-101 (ROACH AND ANT KILLER)	Cancelled/Transferred	19851011	P.F. HARRIS MANUFACTURING COMPANY, LLC	755 TRI-STATE PARKWAY
00000300006	FORMULA BF-201 (ROACH AND ANT KILLER)	Cancelled/Transferred	19851011	P.F. HARRIS MANUFACTURING COMPANY, LLC	755 TRI-STATE PARKWAY

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. epa_pesticide_product
• reg_number (string/null) — e.g. 1-7173
• reg_number_raw (string/null) — e.g. 00000107173
• product_name (string/null) — e.g. SOUTHERN'S SOLUBLE OIL
• product_status (string/null) — e.g. Cancelled/Transferred
• signal_word (string/null) — e.g. None
• form_code (string/null) — e.g. 90
• restricted_use (string/null) — e.g. false
• conditionally_registered (string/null) — null in every sample row
• approval_date (string/null) — e.g. 19760101
• cancellation_date (string/null) — e.g. 19760622
• change_reason_code (string/null) — e.g. 00
• pm_code (string/null) — e.g. 10
• registrant_company_number (string/null) — e.g. 000001
• registrant_name (string/null) — e.g. PRATT LABORATORIES
• registrant_street (string/null) — e.g. PO BOX 6187
• registrant_city (string/null) — e.g. AUSTIN
• registrant_state (string/null) — e.g. TX
• registrant_zip (string/null) — e.g. 78721
• source (string/null) — e.g. epa-ppis-pesticide-products
• release_date (string/null) — null in every sample row
• source_url (string/null) — e.g. https://www3.epa.gov/pesticides/PPISdata/product.zip
• observed_at (string/null) — e.g. 2026-09-18T21:37:01Z
• license (string/integer/null) — e.g. U.S. EPA public domain data (Pesticide Product Information System).
• attribution (string/integer/null) — e.g. Source: U.S. Environmental Protection Agency — Pesticide Product Information Sys
• 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. epa_pesticide_product
• reg_number (string/null) — e.g. 1-7173
• reg_number_raw (string/null) — e.g. 00000107173
• product_name (string/null) — e.g. SOUTHERN'S SOLUBLE OIL
• product_status (string/null) — e.g. Cancelled/Transferred
• signal_word (string/null) — e.g. None
• form_code (string/null) — e.g. 90
• restricted_use (string/null) — e.g. false
• conditionally_registered (string/null) — null in every sample row
• approval_date (string/null) — e.g. 19760101
• cancellation_date (string/null) — e.g. 19760622
• change_reason_code (string/null) — e.g. 00
• pm_code (string/null) — e.g. 10
• registrant_company_number (string/null) — e.g. 000001
• registrant_name (string/null) — e.g. PRATT LABORATORIES
• registrant_street (string/null) — e.g. PO BOX 6187
• registrant_city (string/null) — e.g. AUSTIN
• registrant_state (string/null) — e.g. TX
• registrant_zip (string/null) — e.g. 78721
• source (string/null) — e.g. epa-ppis-pesticide-products
• release_date (string/null) — null in every sample row
• source_url (string/null) — e.g. https://www3.epa.gov/pesticides/PPISdata/product.zip
• observed_at (string/null) — e.g. 2026-09-18T21:17:25Z
• license (string/integer/null) — e.g. U.S. EPA public domain data (Pesticide Product Information System).
• attribution (string/integer/null) — e.g. Source: U.S. Environmental Protection Agency — Pesticide Product Information Sys
• 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 pesticide_product_record per registration, deduplicated on the registration number, each carrying its registrant organization. A run_receipt row carries scope, license, attribution, and 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 pesticide_product_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": 200000
}

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

4. A filtered run

{
  "maxRecords": 50,
  "fieldMatch": {
    "product_name": "SOUTHERN'S SOLUBLE OIL"
  }
}

Keeps only rows whose product_name contains SOUTHERN'S SOLUBLE OIL (a value from the sample run above), matched case-insensitively after the source is read and before the maxRecords cap, so the cap counts matches and only delivered matches are billed. searchText does the same across every column. Zero matches end the run as EMPTY_SELECTION with no row charged — if the source has moved on since that sample run, pick a value you see in your own first run. The source is still read in full — this narrows what you receive and pay for, not what the source serves.

🧾 JSON sample record

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

{
  "record_type": "epa_pesticide_product",
  "reg_number": "1-7173",
  "reg_number_raw": "00000107173",
  "product_name": "SOUTHERN'S SOLUBLE OIL",
  "product_status": "Cancelled/Transferred",
  "signal_word": "None",
  "form_code": "90",
  "restricted_use": "false",
  "conditionally_registered": null,
  "approval_date": "19760101",
  "cancellation_date": "19760622",
  "change_reason_code": "00",
  "pm_code": null,
  "registrant_company_number": "000001",
  "registrant_name": "PRATT LABORATORIES",
  "registrant_street": "PO BOX 6187",
  "registrant_city": "AUSTIN",
  "registrant_state": "TX",
  "registrant_zip": "78721",
  "source": "epa-ppis-pesticide-products",
  "release_date": null,
  "source_url": "https://www3.epa.gov/pesticides/PPISdata/product.zip",
  "observed_at": "2026-09-18T21:37:01Z",
  "license": "U.S. EPA public domain data (Pesticide Product Information System).",
  "attribution": "Source: U.S. Environmental Protection Agency — Pesticide Product Information System (PPIS) public files."
}

🔧 How it works

Source. The actor reads www3.epa.gov — endpoints: https://www3.epa.gov/pesticides/PPISdata. 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. Pacing: CRAWL_DELAY=0.0.

Charging. Each pesticide product record is charged at the moment it is pushed (pesticide_product_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

product.zip (Basic Registration Information) and company.zip (Registrant Name and Address) are downloaded and verified behind an integrity gate — each zip's CRC is checked and a size floor + header-position canary run BEFORE any row is parsed. The fixed-width records are sliced deterministically per the official PPIS Data Dictionary layout and joined on the registrant company number. Files refresh every Tuesday.

Privacy: registrant/agent contact names, emails, and phones are suppressed — the CO_CONTACT and CO_PHONE columns are never emitted, and the registrant's-agent file (agent.zip) is never fetched. Output is organization/product-level only. The interactive ordspub.epa.gov service (robots Disallow: /) is never called; the bulk file is the lawful door.

Source

https://www3.epa.gov/pesticides/PPISdata/product.zip + company.zip

Attribution

Source: U.S. Environmental Protection Agency — Pesticide Product Information System (PPIS) public files (public domain).

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
Pesticide product record (pesticide_product_record)	$0.02	$0.018	$0.016	$0.0134

Worked at the live Free-tier price:

• 8 pesticide product records: $0.02 start + 8 × $0.02 = $0.18
• 25 pesticide product records: $0.02 start + 25 × $0.02 = $0.52
• 100 pesticide product records: $0.02 start + 100 × $0.02 = $2.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 www3.epa.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 (www3.epa.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 200000). 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 www3.epa.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

• EPA GHGRP Sector-Gas Emission Ledger — One sector_emission_record per row of EPA GHGRP's PUB_FACTS_SECTOR_GHG_EMISSION table — one facility × reporting sector / subsector × gas × year, wit…
• EPA GHGRP Subpart-Gas Emission Ledger — One subpart_emission_record per row of EPA GHGRP's PUB_FACTS_SUBP_GHG_EMISSION table — one facility × reporting subpart × gas × year, with the self-r…
• EPA Pesticide Registration Check — One pesticide_registration_check verdict per queried registration number / product SKU — resolve against a local index built from the official EPA PP…
• ESMA BMR Benchmarks Register — One structured benchmark_record per benchmark registered under the EU Benchmarks Regulation (BMR) — from the official ESMA registers machine endpoint…
• ESMA EU Fund Register — One fund_record per entry in the official ESMA EU fund register via the ESMA registers machine endpoint — keyless, logged-out
• ESMA Investment Firm Permissions Register — One structured permission_record per authorised investment firm in ESMA's Union authorisation/passporting register — from the official ESMA registers…
• 🏢 About NexGenData — NexGen Watch is NexGenData's fleet 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.