Clinical Data Guide

The purpose of the Know Your Tumor Molecular Data Guide is to provide SPARK end-users with information and guidance regarding molecular and genomic data tables and their descriptions. All of the files below are available in .csv file format.

📘

Note:

This data guide assumes a baseline level knowledge of pancreatic cancer, genomic and clinical data and does not cover basic descriptions and explanations.

Data Table Name	Description
onco_care_plan	The onco_care_plan table rolls up treatments into care plans. A care plan represents a distinct treatment plan made up of one or more therapies, essentially a regimen, where a regimen can consist of medications and/or radiotherapy. Surgeries are not included in care plans
onco_colorectal_cancer	Diagnosis and other clinical features relevant to colorectal cancer records
onco_diagnosis	The onco_diagnosis table contains the primary diagnosis for each patient
onco_lab_test	The onco_lab_test table includes both curated and native lab results
onco_line_of_therapy	The onco_line_of_therapy table transforms therapy-level information (i.e., individual rows for medications, radiotherapy, and cell therapy) into an aggregated representation of all treatments for a distinct line of therapy in the advanced setting
onco_medication	The onco_medication table contains all curated antineoplastic medications for the patient’s primary cancer
onco_metastasis	Dates and sites of distant metastasis
onco_nsclc	Diagnosis data for patients with a primary NSCLC diagnosis.
onco_pancreatic_cancer	Diagnosis data for patients with primary pancreatic cancer
onco_patient	The onco_patient table presents demographic details of patients and their vital status, including death information and the last known date
onco_performance_status	The onco_performance_status table includes all available performance statuses at any time point. Performance statuses are represented as ECOG scores; all Karnofsky scores are converted to ECOG
onco_problem_list	The onco_problem_list table includes all known co-occurring or previous problems with which the patient was diagnosed
onco_progression_event	The onco_progression_event table includes progression related data with curated dates of progression in addition to recurrence, death, metastases, CRPC, and BCR
onco_radiotherapy	The onco_radiotherapy table contains all curated radiotherapy. This is radiotherapy used to treat the patient’s primary cancer. Each row captures an individual course of radiotherapy
onco_regimen	The onco_regimen table provides a consolidated and comprehensive view of patient treatment regimens. It includes information from both pre-metastatic and advanced/metastatic settings, offering a complete picture of the patient's treatment journey.
onco_response_assessment	The onco_response_assessment table includes all values and all instances of curated response assessments (including partial responses, complete responses, etc.) for the patient’s primary diagnosis
onco_smoking_status	The onco_smoking_status table offers categorical smoking status data for patients of all cancer types and at all timepoints of collection
onco_surgery	The onco_surgery table contains information about surgical procedures conducted for each patient
onco_tumor_characterization	The onco_tumor_characterization will contain all tumor characterization data associated with the primary diagnosis condition_id