CDCDB description

Readme CDCDB is made of the following tables; the tables are visualized in the file CDCDB_schema.png: • aact_combs - drug combinations found in AACT, these drug combinations appeared in clinical trials: clinicalTrials.gov • aact_combs_with_identifiers - similar to aact_combs, but contains the identifiers of the drug in identifiers_entity column. In identifiers_entity, -1 indicates null, the first value is the drugbank_ID, and the second value is the PubChemID of the intervention. • all_combs_unormalized - Contains all of the drug combinations found in CDCDB from any of the sources. The table is an unnormalized version, which means that the combinations are represented in parenthesis. Multiple names which appear in the inner parenthesis of the 'drugs' column are different names used for the same intervention in the original data. The table also contains the identifiers of the interventions and their origin. • conditions - conditions associated with the clinical trials, the trials list can be found in the tables 'trials' • design_group - the design groups (arms ) of the clinical trials, the trials list can be found in the tables 'trials' • mesh_terms - mesh terms associated with the clinical trial, the trials list can be found in the tables 'trials'. This data is collected directly from AACT and not processed by CDCDB. • orangebook_combs - drug combinations curated from the FDA's orange book. The table also contains drug identifiers. • patents_ipc - list of patents and their International Patent Category (IPC) consisting CDCDB. • patents_metadata - metadata describing the patents. • References - references for the clinical trials used in CDCDB. This data is curated from AACT. • transformed_patents_drug - list of drug combinations that appeared in patents, including the drug identifiers. • trials - the list of clinical trails and metadata about them. It was collected from AACT. • web_preview - a simplified representation of CDCDB is provided in the table. Also available using non-programmatic access through our website. The table contains all of the combinations of drugs that appeared in any of the sources used to create CDCDB. The drugs are described using their name, DrugBank ID, and PubChem ID.