I am trying to query these databases and identify trials that passed, and those that didn't. I have gone through and parsed all of ClinicalTrials.gov and matched it to records from chEMBL to build a database.
The fields I have available to be for each drug are:
+ is_fda_regulated_drug: which is null in 99% of cases + overall_status: Terminated, Completed, Recruiting, etc. + phase: "Phase 1", "Phase 2", ... + primary_completion_date: Date as a string or null + primary_outcome: Date as a string or null + primary_outcome: mess of text that is too inconsistent to parse + start_date: either date as a string or na + time_frame: mess of text and often not a timeframe at all + CHEMBL_ID: as string + FIRST_APPROVAL: a year, but this is first approval for any application, not the study in question + MAX_PHASE_FOR_IND: 1,2,3,4
So far the only definitive logic I've been able to define is:
if overall_status = terminated and phase != 4 then the trial failed