I Built a Tool to Track What Big Pharma Is Testing (Using Free Data)

Last month, a friend working in biotech asked me: "How can I quickly see what trials Pfizer is running right now?" He was spending hours on ClinicalTrials.gov, clicking through pages manually. I said: "Give me 20 minutes." The Problem ClinicalTrials.gov has 500,000+ trials. The website works, but if you want to: Monitor a specific company's pipeline Track a disease area over time Export data for analysis ...you're stuck clicking around. The Solution: 15 Lines of Python import requests def track_company(sponsor, status='RECRUITING'): resp = requests.get('https://clinicaltrials.gov/api/v2/studies', params={ 'query.sponsor': sponsor, 'filter.overallStatus': status, 'pageSize': 20, 'format': 'json' }) trials = resp.json().get('studies', []) print(f"\n{sponsor} — {len(trials)} {status.lower()} trials:\n") for s in trials: p = s['protocolSection'] title = p['identificationModule']['briefTitle'] phase = ', '.join(p.get('designModule', {}).get('phases', ['N/A'])) print(f" [{phase}] {title}") r