# ChEMBL Clinical-Stage Indication Screen (`nexgenwatch/chembl-clinical-stage-indication-screen`) Actor 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. - **URL**: https://apify.com/nexgenwatch/chembl-clinical-stage-indication-screen.md - **Developed by:** [NexGen Watch](https://apify.com/nexgenwatch) (community) - **Categories:** Automation, Lead generation, Developer tools - **Stats:** 2 total users, 1 monthly users, 80.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing from $13.40 / 1,000 clinical compound records This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have. Learn more: https://docs.apify.com/actors/running/actors-in-store.md#pay-per-event ## What's an Apify Actor? An Actor is a serverless cloud program that runs on the Apify platform. It has two run modes. 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. Apify vocabulary and the platform model are defined once, in the agent quickstart at https://apify.com/agents.md. ## 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. Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run. For examples already wired to this Actor's own input schema, see the [API](#api) section below. Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`). # README ## πŸ”” 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 [![ChEMBL Clinical-Stage Indication Screen sample output β€” a table of real clinical compound record rows (pref_name, molecule_type, chembl_release, release_date) from run dOgfQ2N39Fmk6pTuH on build 0.1.5](https://api.apify.com/v2/key-value-stores/80Y7h3rmVN5CWK7Mw/records/chembl-clinical-stage-indication-screen-sample)](https://apify.com/nexgenwatch/chembl-clinical-stage-indication-screen?fpr=2ayu9b) 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)** ```json { "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** ```json { "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** ```json { "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): ```json { "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)](https://apify.com/nexgenwatch/bulk-email-list-verifier?fpr=2ayu9b) β€” 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](https://apify.com/nexgenwatch/census-address-geography-check?fpr=2ayu9b) β€” A definitive check: does this business/property address resolve to an official U.S. Census geography, and which one? - [ChEMBL Biotherapeutic Sequence Master](https://apify.com/nexgenwatch/chembl-biotherapeutic-sequence-master?fpr=2ayu9b) β€” 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](https://apify.com/nexgenwatch/chembl-source-document-index?fpr=2ayu9b) β€” 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](https://apify.com/nexgenwatch/chembl-target-assay-definition-screener?fpr=2ayu9b) β€” 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](https://apify.com/nexgenwatch/chembl-target-bioactivity-screener?fpr=2ayu9b) β€” 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](https://apify.com/nexgenwatch?fpr=2ayu9b). ### ⭐ Found this useful? If this actor saved you a manual check, a quick **[review on the Apify Store](https://apify.com/nexgenwatch/chembl-clinical-stage-indication-screen?fpr=2ayu9b)** helps other teams find it. Feature request or a source that changed? Open it from the **Issues** tab β€” every one is read. # Actor input Schema ## `maxPhaseMin` (type: `integer`): REQUIRED clinical-stage filter on ChEMBL max_phase (0–4; 4 == approved on ChEMBL's own scale). Screens compounds at or above this phase. A filter is mandatory β€” no unbounded pulls. ## `maxRecords` (type: `integer`): Max clinical compound records delivered (buyer bound; one charge per delivered compound). Hard-capped at 2500. ## `userAgent` (type: `string`): Override the transparent crawler UA. ## Actor input object example ```json { "maxPhaseMin": 4, "maxRecords": 50 } ``` # 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 = { "maxPhaseMin": 4, "maxRecords": 50 }; // Run the Actor and wait for it to finish const run = await client.actor("nexgenwatch/chembl-clinical-stage-indication-screen").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 = { "maxPhaseMin": 4, "maxRecords": 50, } # Run the Actor and wait for it to finish run = client.actor("nexgenwatch/chembl-clinical-stage-indication-screen").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print(f"πŸ’Ύ Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}") for item in client.dataset(run.default_dataset_id).iterate_items(): print(item) # πŸ“š Want to learn more πŸ“–? Go to β†’ https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "maxPhaseMin": 4, "maxRecords": 50 }' | apify call nexgenwatch/chembl-clinical-stage-indication-screen --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "type": "http", "url": "https://mcp.apify.com/?tools=fetch-actor-details,nexgenwatch/chembl-clinical-stage-indication-screen" } } } ``` The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer ` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations). ## OpenAPI specification Download the OpenAPI definition: https://api.apify.com/v2/actors/hXbZsCdK8MnoRicHA/builds/wzgnsCDslzpt9fIpn/openapi.json