🔔 ChEMBL Clinical-Stage Indication Screen

One structured clinical compound record per molecule at or above the clinical phase you set — max_phase, first approval year, molecule type, route flags, and the compound's registered indications joined in from ChEMBL's drug_indication and nested underneath the compound (MeSH/EFO terms, per-indication max phase, and the source references). Built for clinical, BD, and competitive- intelligence teams screening the developed/approved compound landscape by stage — keyed and deduplicated on molecule_chembl_id.

Differentiation: generic ChEMBL wrappers return flat endpoint pages; this screen is stage-scoped by contract (a maxPhaseMin filter is mandatory), joins indications by batch (no per-compound fan-out), and nests them under the compound so you are billed per compound, not per indication row. Every max_phase and per-indication qualifier is carried verbatim — the screen never invents an "approved" flag; it reports ChEMBL's own max_phase (4 == approved on ChEMBL's scale) and lets you read it.

Output is one chembl_clinical_compound row per result; billing is pay-per-event, the value event being one clinical compound record (a $0.02 start fee per run, then $0.02 per clinical compound record). Source: www.ebi.ac.uk.

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 dOgfQ2N39Fmk6pTuH 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):

pref_name	molecule_type	chembl_release	release_date	license	attribution
PRAZOSIN	Small molecule	ChEMBL_37	ChEMBL_37	CC BY-SA 3.0	ChEMBL / EMBL-EBI (https://www.ebi.ac.uk/chembl/)
NICOTINE	Small molecule	ChEMBL_37	ChEMBL_37	CC BY-SA 3.0	ChEMBL / EMBL-EBI (https://www.ebi.ac.uk/chembl/)
OFLOXACIN	Small molecule	ChEMBL_37	ChEMBL_37	CC BY-SA 3.0	ChEMBL / EMBL-EBI (https://www.ebi.ac.uk/chembl/)
NALIDIXIC ACID	Small molecule	ChEMBL_37	ChEMBL_37	CC BY-SA 3.0	ChEMBL / EMBL-EBI (https://www.ebi.ac.uk/chembl/)
INDOMETHACIN	Small molecule	ChEMBL_37	ChEMBL_37	CC BY-SA 3.0	ChEMBL / EMBL-EBI (https://www.ebi.ac.uk/chembl/)
SULBACTAM	Small molecule	ChEMBL_37	ChEMBL_37	CC BY-SA 3.0	ChEMBL / EMBL-EBI (https://www.ebi.ac.uk/chembl/)
TAZOBACTAM	Small molecule	ChEMBL_37	ChEMBL_37	CC BY-SA 3.0	ChEMBL / EMBL-EBI (https://www.ebi.ac.uk/chembl/)
CIPROFLOXACIN	Small molecule	ChEMBL_37	ChEMBL_37	CC BY-SA 3.0	ChEMBL / EMBL-EBI (https://www.ebi.ac.uk/chembl/)

The run finished with the status message: NORMAL: 50 unique rows (0 duplicates collapsed) from ChEMBL_37. 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/null) — e.g. chembl_clinical_compound
• molecule_chembl_id (string/null) — e.g. CHEMBL2
• pref_name (string/null) — e.g. PRAZOSIN
• max_phase (string/null) — e.g. 4.0
• first_approval (string/null) — e.g. 1976
• molecule_type (string/null) — e.g. Small molecule
• oral (string/null) — e.g. True
• parenteral (string/null) — e.g. False
• topical (string/null) — e.g. False
• black_box_warning (string/null) — e.g. 0
• withdrawn_flag (string/null) — e.g. False
• full_mwt (string/null) — e.g. 383.41
• indications (string/null) — e.g. [{"mesh_id": "D006973", "mesh_heading": "Hypertension", "efo_id": "EFO:0000537",
• indication_count (string/integer/null) — e.g. 10
• chembl_release (string/null) — e.g. ChEMBL_37
• source (string/null) — e.g. chembl-clinical-stage-indication-screen
• release_date (string/null) — e.g. ChEMBL_37
• source_url (string/null) — e.g. https://www.ebi.ac.uk/chembl/api/data/molecule.json
• observed_at (string/null) — e.g. 2026-09-18T21:35:39Z
• license (string/null) — e.g. CC BY-SA 3.0
• attribution (string/null) — e.g. ChEMBL / EMBL-EBI (https://www.ebi.ac.uk/chembl/)
• terminal (string/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/null) — null in every sample row
• note (string/null) — null in every sample row

✅ What you get

• record_type (string/null) — e.g. chembl_clinical_compound
• molecule_chembl_id (string/null) — e.g. CHEMBL2
• pref_name (string/null) — e.g. PRAZOSIN
• max_phase (string/null) — e.g. 4.0
• first_approval (string/null) — e.g. 1976
• molecule_type (string/null) — e.g. Small molecule
• oral (string/null) — e.g. True
• parenteral (string/null) — e.g. False
• topical (string/null) — e.g. False
• black_box_warning (string/null) — e.g. 0
• withdrawn_flag (string/null) — e.g. False
• full_mwt (string/null) — e.g. 383.41
• indications (string/null) — e.g. [{"mesh_id": "D006973", "mesh_heading": "Hypertension", "efo_id": "EFO:0000537",
• indication_count (string/integer/null) — e.g. 10
• chembl_release (string/null) — e.g. ChEMBL_37
• source (string/null) — e.g. chembl-clinical-stage-indication-screen
• release_date (string/null) — e.g. ChEMBL_37
• source_url (string/null) — e.g. https://www.ebi.ac.uk/chembl/api/data/molecule.json
• observed_at (string/null) — e.g. 2026-09-18T21:25:30Z
• license (string/null) — e.g. CC BY-SA 3.0
• attribution (string/null) — e.g. ChEMBL / EMBL-EBI (https://www.ebi.ac.uk/chembl/)
• terminal (string/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/null) — null in every sample row
• note (string/null) — null in every sample row

What you get

• Doors: ChEMBL molecule.json (filtered by max_phase__gte) joined to drug_indication.json (batched by molecule_chembl_id__in), both public and keyless at EMBL-EBI.
• One clinical_compound_record per molecule, deduped on molecule_chembl_id.
• Fields include max_phase, first_approval, molecule_type, route flags, black_box_warning, withdrawn_flag, and indications (a nested list: mesh_heading, efo_term, max_phase_for_ind, indication_refs) plus indication_count.
• A final run_receipt with the terminal (NORMAL / CAPPED / PARTIAL), counts, and licence.

⚙️ Sample inputs

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

{
  "maxPhaseMin": 4,
  "maxRecords": 50
}

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

2. A smaller, narrowed run

{
  "maxPhaseMin": 4,
  "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

{
  "maxPhaseMin": 4,
  "maxRecords": 2500
}

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

🧾 JSON sample record

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

{
  "record_type": "chembl_clinical_compound",
  "molecule_chembl_id": "CHEMBL2",
  "pref_name": "PRAZOSIN",
  "max_phase": "4.0",
  "first_approval": "1976",
  "molecule_type": "Small molecule",
  "oral": "True",
  "parenteral": "False",
  "topical": "False",
  "black_box_warning": "0",
  "withdrawn_flag": "False",
  "full_mwt": "383.41",
  "indications": "[{\"mesh_id\": \"D006973\", \"mesh_heading\": \"Hypertension\", \"efo_id\": \"EFO:0000537\", \"efo_term\": \"hypertension\", \"max_phase_for_ind\": \"4.0\", \"indication_refs\": [{\"ref_type\": \"ATC\", \"ref_id\": \"C02CA01\", \"ref_url\": \"https://www.whocc.no/atc_ddd_i",
  "indication_count": 10,
  "chembl_release": "ChEMBL_37",
  "source": "chembl-clinical-stage-indication-screen",
  "release_date": "ChEMBL_37",
  "source_url": "https://www.ebi.ac.uk/chembl/api/data/molecule.json",
  "observed_at": "2026-09-18T21:35:39Z",
  "license": "CC BY-SA 3.0",
  "attribution": "ChEMBL / EMBL-EBI (https://www.ebi.ac.uk/chembl/)"
}

🔧 How it works

Source. The actor reads www.ebi.ac.uk — endpoints: https://www.ebi.ac.uk, https://www.ebi.ac.uk/chembl/, https://www.ebi.ac.uk/chembl/api/data/drug_indication.json, https://www.ebi.ac.uk/chembl/api/data/molecule.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. Pacing: CRAWL_DELAY=10.0.

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

🔧 How it works

Fidelity

max_phase and every indication's max_phase_for_ind and reference qualifiers are reproduced exactly as ChEMBL publishes them. No approval status is inferred or added.

Transport & fair use

A single serialized client at a 10-second crawl delay, no parallel fan-out; the indication join is batched to keep the request count bounded. robots.txt on www.ebi.ac.uk is honoured; /chembl is permitted.

Licence & attribution

ChEMBL data is released by EMBL-EBI under Creative Commons Attribution-ShareAlike 3.0 (CC BY-SA 3.0). By using this output you accept CC BY-SA 3.0:

• Attribution: ChEMBL / EMBL-EBI — https://www.ebi.ac.uk/chembl/
• Release: stamped on every record (chembl_release, e.g. ChEMBL_37).
• ShareAlike: redistribution or derivative works must be licensed under the same CC BY-SA 3.0.

Every record carries license = CC BY-SA 3.0 and attribution so the share-alike obligation travels with the data.

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
Clinical compound record (clinical_compound_record)	$0.02	$0.018	$0.016	$0.0134

Worked at the live Free-tier price:

• 8 clinical compound records: $0.02 start + 8 × $0.02 = $0.18
• 25 clinical compound records: $0.02 start + 25 × $0.02 = $0.52
• 2500 clinical compound records: $0.02 start + 2500 × $0.02 = $50.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) from ChEMBL_37. 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 www.ebi.ac.uk. 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 (www.ebi.ac.uk) 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 2500). 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 www.ebi.ac.uk. 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=10.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

• Bulk Email List Hygiene Check (Syntax · MX · Disposable · Role) — Clean an email list before you send — one email_verification_check row per address, answered from syntax and DNS alone: is the address well-formed, d…
• Census Address Geography Check — A definitive check: does this business/property address resolve to an official U.S. Census geography, and which one?
• ChEMBL Biotherapeutic Sequence Master — One structured record per ChEMBL biotherapeutic — the molecule id, the HELM notation, the biocomponent array, and the description. A master index ove…
• ChEMBL Source Document Index — One structured record per ChEMBL source document — the document id, doc type, and the bibliographic identifiers (DOI, PubMed id, patent id, journal,…
• ChEMBL Target Assay Definition Screener — One structured record per assay for the ChEMBL target(s) you name — the assay id, type and description, category, organism/tissue/cell, BAO format/la…
• ChEMBL Target Bioactivity Screener — One structured bioactivity record per measured activity for the ChEMBL target(s) you name — the assay/target/molecule ids, the standard measurement (…
• 🏢 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.