Clinical Trials & Drug Data Aggregator

Collect normalized, non-personal clinical trial and drug/regulatory records from official US government APIs into one Apify dataset. The Actor combines ClinicalTrials.gov trial identity, design, sponsor, eligibility, recruitment-location, outcome, posted-result, and PubMed-reference data with openFDA drug label, NDC, recall, and aggregate adverse-event metrics.

This Actor is for public research, regulatory monitoring, and market intelligence. It is not medical advice.

What It Extracts

• ClinicalTrials.gov study facts: NCT ID, title/acronym, current and last-known status, phase, study design, conditions, enriched interventions, sponsor/collaborator organizations and classes, enrollment count/type, and actual/estimated date metadata.
• Trial eligibility: criteria, sex, age limits, standard age groups, healthy-volunteer flag, study population, and sampling method where supplied.
• Trial locations and outcomes: facility recruitment status, city/state/postal code/country, coordinates, location counts, recruiting-location count, primary outcomes, and secondary outcomes.
• Results and literature: whether registry results are posted, first results-posted date, the official results tab, and up to 25 official PubMed links without copying publication author names into the dataset.
• openFDA drug records: brand name, generic name, manufacturer or labeler organization, product type, route, dosage form, NDC identifiers, and aggregate adverse-event count metrics.
• openFDA recall records: recall number, product description, recall status, classification, recalling organization, recall date, recall reason, product identifiers, and source URL.

The Actor intentionally excludes individual investigators, responsible-person names, trial contacts, emails, phone numbers, patient-level adverse-event reports, and patient demographics. Individual-class sponsors are represented only by their source classification; their names are suppressed.

Supported Sources

Source	Input value	API key	Best for
ClinicalTrials.gov API v2	clinical_trials	No	Studies by condition, drug, sponsor-related keyword, phase, and status
openFDA drug label / NDC / adverse-event aggregates	openfda_drugs	Optional	Drug identity, manufacturer, route, dosage form, NDC, and aggregate event counts
openFDA drug enforcement recalls	openfda_recalls	Optional	Drug recalls, classifications, recall dates, firms, and reasons

openFDA works without an API key for light usage. Add openFdaApiKey or the OPENFDA_API_KEY environment variable if you need higher openFDA rate limits.

Use Cases

• Pharma and biotech pipeline research
• Trial landscape monitoring by condition, drug, phase, or sponsor keyword
• Competitive intelligence across studies, products, manufacturers, and recalls
• Regulatory monitoring for drug recalls and enforcement actions
• Investor and market intelligence for public drug-development signals
• Research data enrichment for dashboards, CRMs, and internal analytics

Quick Start

Search trials and openFDA data for one drug

{
  "sources": ["clinical_trials", "openfda_drugs", "openfda_recalls"],
  "query": "aspirin",
  "drugNames": ["aspirin"],
  "status": "all",
  "phase": "all",
  "maxResults": 10
}

Search recruiting Phase 3 oncology trials

{
  "sources": ["clinical_trials"],
  "query": "oncology",
  "conditions": ["melanoma"],
  "status": "RECRUITING",
  "phase": "PHASE3",
  "maxResults": 10,
  "maxLocationsPerTrial": 50
}

Search openFDA recalls only

{
  "sources": ["openfda_recalls"],
  "query": "metformin",
  "drugNames": ["metformin"],
  "maxResults": 10
}

Input Fields

Field	Type	Default	Description
sources	array	All three sources	Select clinical_trials, openfda_drugs, and/or openfda_recalls.
query	string	aspirin	General keyword used by the selected sources. Examples: aspirin, diabetes, oncology, melanoma.
conditions	array	Empty	Optional clinical trial condition terms such as diabetes or breast cancer. Used for trial searches.
drugNames	array	Empty	Optional drug names used for openFDA searches and trial searches.
status	string	all	Optional ClinicalTrials.gov status filter, such as RECRUITING, ENROLLING_BY_INVITATION, COMPLETED, or TERMINATED.
phase	string	all	Optional ClinicalTrials.gov phase filter, such as PHASE2, PHASE3, or PHASE4.
maxResults	integer	10	Maximum clean records to save across selected sources, capped at 1000.
maxLocationsPerTrial	integer	50	Maximum public facility-location summaries per trial, from 1 to 200; contact and investigator fields are never requested.
openFdaApiKey	string	Empty	Optional secret openFDA API key for higher openFDA rate limits.
userAgent	string	ClinicalTrialsDrugDataAggregator/1.0 public-data-research	Descriptive User-Agent sent to official APIs.
proxyConfiguration	object	No proxy	Not required for these official JSON APIs; included for Apify compatibility.

If no search term is provided, the Actor uses aspirin as a safe default.

Output Overview

Each dataset item is a normalized public research record. Depending on the source, fields include:

Field group	Example fields
Source and identity	source, query, recordType, recordId, sourceUrl, attribution, scrapedAt
Trial identity and design	title, name, acronym, status, lastKnownStatus, whyStopped, phase, studyType, studyDesign, conditions, interventions
Sponsors and eligibility	sponsorOrManufacturer, leadSponsor, collaborators, collaboratorOrganizations, eligibility
Trial dates and scale	enrollmentCount, enrollmentType, startDate, primaryCompletionDate, completionDate, their actual/estimated types, studyFirstPostDate, lastUpdateDate, lastUpdatePostDate
Locations and outcomes	locationCount, recruitingLocationCount, countries, locationsSummary, primaryOutcomes, secondaryOutcomes
Results and publications	hasResults, resultsFirstPostDate, resultsUrl, publicationReferences, publicationCount
Drug/product details	genericName, brandName, productType, route, dosageForm, ndc, adverseEventCount
Recall details	recallDate, classification, recallReason, status, sponsorOrManufacturer

Verified Sample Output

This shortened trial record comes from a direct live ClinicalTrials.gov API proof on August 24, 2026. Contact, responsible-person, and investigator-name fields were not requested.

{
  "source": "clinical_trials",
  "query": "NCT02798211",
  "recordType": "trial",
  "recordId": "NCT02798211",
  "name": "Study to Evaluate the Safety and Efficacy of Secukinumab 300 mg and 150 mg in Adult Patients With Active Psoriatic Arthritis (PsA) After 16 Weeks of Treatment Compared to Placebo",
  "status": "COMPLETED",
  "phase": "PHASE4",
  "studyType": "INTERVENTIONAL",
  "studyDesign": {
    "allocation": "RANDOMIZED",
    "interventionModel": "PARALLEL",
    "primaryPurpose": "TREATMENT",
    "masking": "DOUBLE",
    "maskingRoles": ["PARTICIPANT", "INVESTIGATOR"]
  },
  "conditions": ["Psoriatic Arthritis"],
  "interventions": [
    {
      "name": "Secukinumab 300 mg",
      "type": "DRUG",
      "description": "150 mg x 2 s.c. injection",
      "otherNames": ["AIN457"]
    }
  ],
  "leadSponsor": {
    "name": "Novartis Pharmaceuticals",
    "agencyClass": "INDUSTRY"
  },
  "enrollmentCount": 258,
  "enrollmentType": "ACTUAL",
  "startDate": "2016-06-27",
  "startDateType": "ACTUAL",
  "primaryCompletionDate": "2018-12-05",
  "primaryCompletionDateType": "ACTUAL",
  "completionDate": "2018-12-05",
  "completionDateType": "ACTUAL",
  "eligibility": {
    "sex": "ALL",
    "minimumAge": "18 Years",
    "maximumAge": null,
    "standardAges": ["ADULT", "OLDER_ADULT"],
    "healthyVolunteers": false
  },
  "hasResults": true,
  "resultsFirstPostDate": "2021-01-28",
  "resultsUrl": "https://clinicaltrials.gov/study/NCT02798211?tab=results",
  "publicationReferences": [
    {
      "pmid": "35428722",
      "referenceType": "DERIVED",
      "pubmedUrl": "https://pubmed.ncbi.nlm.nih.gov/35428722/"
    }
  ],
  "locationCount": 58,
  "recruitingLocationCount": 0,
  "countries": ["United States", "Puerto Rico"],
  "locationsSummary": [
    {
      "facility": null,
      "status": null,
      "city": "Birmingham",
      "state": "Alabama",
      "postalCode": "35205",
      "country": "United States",
      "latitude": 33.52066,
      "longitude": -86.80249
    }
  ],
  "sourceUrl": "https://clinicaltrials.gov/study/NCT02798211"
}

Tips For Better Results

• Use specific condition and drug terms. melanoma pembrolizumab or type 2 diabetes metformin is usually better than a very broad keyword.
• For trial-only research, select only clinical_trials and use status / phase filters to reduce noise.
• For regulatory monitoring, select openfda_recalls and search by drug name, ingredient, product family, or recall-reason keyword.
• Keep maxResults small for exploratory runs, then increase it once the query is right.
• Use an openFDA API key for larger openFDA workloads or repeated recall/drug-label checks.
• ClinicalTrials.gov status and phase filters are applied at the source before local validation, so filtered runs do not silently miss matching later pages.
• Raise maxLocationsPerTrial only when you need more site-level rows inside each trial record; summary counts still describe all returned public locations.

Known Limits

• The Actor depends on official public API availability and rate limits.
• openFDA adverse-event values are aggregate report counts, not patient-level reports and not proof that a drug caused an event. The field is null when that optional enrichment request is unavailable.
• recordType distinguishes trial, drug_label, drug_ndc, and drug_recall records.
• Clinical trial location arrays default to 50 public facilities per trial and can be raised to 200. Contact and investigator subobjects are not requested.
• PubMed reference output is limited to 25 unique PMID links per trial. publicationCount reports the number of unique linked references found in the bounded API response.
• Trial status and phase are normalized from the source record and may vary by study.
• studyDesign.maskingRoles can contain non-personal role enums such as INVESTIGATOR; no investigator names or contact details are returned.
• The Actor does not provide medical, regulatory, investment, or legal advice.

Pricing

This Actor uses pay-per-event pricing.

Event	When charged	Price
trial-record-scraped	One clean non-personal clinical trial, drug, or recall record saved	$0.002
Actor start	Platform startup charge based on allocated memory	$0.00005 per GB, minimum one event

Each clean non-personal record is saved and charged atomically. Empty searches, forbidden fields, and failed source requests are not charged, and later source queries stop when the user's spending limit is reached. A legitimate empty result succeeds with zero record charges; a run fails if every attempted source query fails before returning a valid API response.

Data Safety

This Actor is designed for non-personal organizational and public research data only. ClinicalTrials.gov requests use an explicit allowlist that omits contact, investigator, and responsible-person fields. Output keys are scanned recursively, personal-looking organizations are suppressed, email/phone patterns in allowed descriptive text are redacted, and registry/publication URLs must use official ClinicalTrials.gov, FDA, or PubMed hosts. openFDA adverse-event data is represented only as aggregate counts.

Medical Disclaimer

This Actor provides public research data and is not medical advice. Do not use this data to diagnose, treat, prevent, or make medical decisions. Consult qualified medical and regulatory professionals for clinical interpretation.

Responsible Use

This Actor is intended for lawful collection and processing of publicly available information only. Users are responsible for ensuring their use complies with source terms, applicable privacy laws, and all local regulations.

Do not use this Actor to collect, store, sell, or misuse personal data without a lawful basis. The Actor author is not responsible for misuse by end users.

License

Apache-2.0