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