SQL Console
Run DuckDB SQL against both Simulacrum versions. Tables are prefixed v1_ or v2_ (e.g. v1_av_patient, v2_sact_regimen).
Available Tables
v1_av_patient
PATIENTID
SEX
LINKNUMBER
ETHNICITY
DEATHCAUSECODE_1A
DEATHCAUSECODE_1B
DEATHCAUSECODE_1C
DEATHCAUSECODE_2
DEATHCAUSECODE_UNDERLYING
DEATHLOCATIONCODE
NEWVITALSTATUS
VITALSTATUSDATE
v1_av_tumour
TUMOURID
PATIENTID
DIAGNOSISDATEBEST
SITE_ICD10_O2
SITE_ICD10_O2_3CHAR
MORPH_ICD10_O2
BEHAVIOUR_ICD10_O2
T_BEST
N_BEST
M_BEST
STAGE_BEST
STAGE_BEST_SYSTEM
GRADE
AGE
SEX
CREG_CODE
LINKNUMBER
SCREENINGSTATUSFULL_CODE
ER_STATUS
ER_SCORE
PR_STATUS
PR_SCORE
HER2_STATUS
CANCERCAREPLANINTENT
PERFORMANCESTATUS
CNS
ACE27
GLEASON_PRIMARY
GLEASON_SECONDARY
GLEASON_TERTIARY
GLEASON_COMBINED
DATE_FIRST_SURGERY
LATERALITY
QUINTILE_2015
v1_sact_cycle
MERGED_CYCLE_ID
MERGED_REGIMEN_ID
CYCLE_NUMBER
START_DATE_OF_CYCLE
OPCS_PROCUREMENT_CODE
PERF_STATUS_START_OF_CYCLE
MERGED_PATIENT_ID
MERGED_TUMOUR_ID
v1_sact_drug_detail
MERGED_DRUG_DETAIL_ID
MERGED_CYCLE_ID
ORG_CODE_OF_DRUG_PROVIDER
ACTUAL_DOSE_PER_ADMINISTRATION
OPCS_DELIVERY_CODE
ADMINISTRATION_ROUTE
ADMINISTRATION_DATE
DRUG_GROUP
MERGED_PATIENT_ID
MERGED_TUMOUR_ID
MERGED_REGIMEN_ID
v1_sact_outcome
MERGED_OUTCOME_ID
MERGED_REGIMEN_ID
DATE_OF_FINAL_TREATMENT
REGIMEN_MOD_DOSE_REDUCTION
REGIMEN_MOD_TIME_DELAY
REGIMEN_MOD_STOPPED_EARLY
REGIMEN_OUTCOME_SUMMARY
MERGED_PATIENT_ID
MERGED_TUMOUR_ID
v1_sact_patient
MERGED_PATIENT_ID
LINK_NUMBER
v1_sact_regimen
MERGED_REGIMEN_ID
MERGED_TUMOUR_ID
HEIGHT_AT_START_OF_REGIMEN
WEIGHT_AT_START_OF_REGIMEN
INTENT_OF_TREATMENT
DATE_DECISION_TO_TREAT
START_DATE_OF_REGIMEN
MAPPED_REGIMEN
CLINICAL_TRIAL
CHEMO_RADIATION
MERGED_PATIENT_ID
BENCHMARK_GROUP
v1_sact_tumour
MERGED_TUMOUR_ID
MERGED_PATIENT_ID
CONSULTANT_SPECIALITY_CODE
PRIMARY_DIAGNOSIS
MORPHOLOGY_CLEAN
v2_av_gene
GENEID
TUMOURID
PATIENTID
GENE_DESC
GENE
COUNT_TESTS
COUNT_RESULTS
COUNT_DATE
ALL_TESTSTATUSES
OVERALL_TS
NO_OF_AB_GATS
DNASEQ_GAT
METHYL_GAT
EXP_GAT
COPYNO_GAT
FUS_TRANS_GAT
ABNORMAL_GAT
NO_OF_SEQ_VARS
ALL_SEQ_VARS
SEQ_VAR
DATE_OVERALL_TS
BEST_DATE_SOURCE_OVERALL_TS
MIN_DATE
MAX_DATE
ALL_PRO_IMPS
NO_OF_PRO_IMPS
PRO_IMP
METHODS
LAB_NAME
v2_av_patient
PATIENTID
GENDER
ETHNICITY
DEATHCAUSECODE_1A
DEATHCAUSECODE_1B
DEATHCAUSECODE_1C
DEATHCAUSECODE_2
DEATHCAUSECODE_UNDERLYING
DEATHLOCATIONCODE
VITALSTATUS
VITALSTATUSDATE
LINKNUMBER
v2_av_tumour
TUMOURID
GENDER
PATIENTID
DIAGNOSISDATEBEST
SITE_ICD10_O2_3CHAR
SITE_ICD10_O2
SITE_ICD10R4_O2_3CHAR_FROM2013
SITE_ICD10R4_O2_FROM2013
SITE_ICDO3REV2011
SITE_ICDO3REV2011_3CHAR
MORPH_ICD10_O2
MORPH_ICDO3REV2011
BEHAVIOUR_ICD10_O2
BEHAVIOUR_ICDO3REV2011
T_BEST
N_BEST
M_BEST
STAGE_BEST
GRADE
AGE
CREG_CODE
STAGE_BEST_SYSTEM
LATERALITY
SCREENINGSTATUSFULL_CODE
ER_STATUS
PR_STATUS
HER2_STATUS
QUINTILE_2019
DATE_FIRST_SURGERY
CANCERCAREPLANINTENT
PERFORMANCESTATUS
CHRL_TOT_27_03
COMORBIDITIES_27_03
GLEASON_PRIMARY
GLEASON_SECONDARY
GLEASON_TERTIARY
GLEASON_COMBINED
v2_rtds_combined
PATIENTID
PRESCRIPTIONID
RTTREATMENTMODALITY
RADIOTHERAPYPRIORITY
RADIOTHERAPYINTENT
RTPRESCRIBEDDOSE
RTPRESCRIBEDFRACTIONS
RTACTUALDOSE
RTACTUALFRACTIONS
RTTREATMENTREGION
RTTREATMENTANATOMICALSITE
DECISIONTOTREATDATE
EARLIESTCLINAPPROPDATE
RADIOTHERAPYEPISODEID
LINKCODE
RADIOISOTOPE
RADIOTHERAPYBEAMTYPE
RADIOTHERAPYBEAMENERGY
TIMEOFEXPOSURE
APPTDATE
ATTENDID
v2_rtds_episode
PATIENTID
RADIOTHERAPYEPISODEID
ATTENDID
APPTDATE
LINKCODE
DECISIONTOTREATDATE
EARLIESTCLINAPPROPDATE
RADIOTHERAPYPRIORITY
RADIOTHERAPYINTENT
v2_rtds_exposure
PRESCRIPTIONID
RADIOISOTOPE
RADIOTHERAPYBEAMTYPE
RADIOTHERAPYBEAMENERGY
TIMEOFEXPOSURE
APPTDATE
ATTENDID
PATIENTID
RADIOTHERAPYEPISODEID
LINKCODE
v2_rtds_prescription
PATIENTID
PRESCRIPTIONID
RTTREATMENTMODALITY
RTPRESCRIBEDDOSE
RTPRESCRIBEDFRACTIONS
RTACTUALDOSE
RTACTUALFRACTIONS
RTTREATMENTREGION
RTTREATMENTANATOMICALSITE
RADIOTHERAPYEPISODEID
LINKCODE
ATTENDID
APPTDATE
v2_sact_cycle
MERGED_REGIMEN_ID
MERGED_CYCLE_ID
CYCLE_NUMBER
START_DATE_OF_CYCLE
OPCS_PROCUREMENT_CODE
PERF_STATUS_START_OF_CYCLE
v2_sact_drug_detail
MERGED_DRUG_DETAIL_ID
MERGED_CYCLE_ID
ACTUAL_DOSE_PER_ADMINISTRATION
OPCS_DELIVERY_CODE
ADMINISTRATION_ROUTE
ADMINISTRATION_DATE
DRUG_GROUP
v2_sact_outcome
MERGED_REGIMEN_ID
DATE_OF_FINAL_TREATMENT
REGIMEN_MOD_DOSE_REDUCTION
REGIMEN_MOD_TIME_DELAY
REGIMEN_MOD_STOPPED_EARLY
REGIMEN_OUTCOME_SUMMARY
v2_sact_regimen
ENCORE_PATIENT_ID
MERGED_REGIMEN_ID
HEIGHT_AT_START_OF_REGIMEN
WEIGHT_AT_START_OF_REGIMEN
INTENT_OF_TREATMENT
DATE_DECISION_TO_TREAT
START_DATE_OF_REGIMEN
MAPPED_REGIMEN
CLINICAL_TRIAL
CHEMO_RADIATION
BENCHMARK_GROUP
LINK_NUMBER