Raw health data description (UNDER CONSTRUCTION)
This page describes the raw phenotype files currently available in the TRE, and their location in the TRE file structure. Column headings are replicated directly, brief summaries of file contents and column contents will be updated.
For most users and use cases, this documment should serve as a reference guide only. Members of the GH data team have used the raw files described here to produce curated products, that will in most cases be more useful (and user friendly).
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/AntiMullerianHormone_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/ApolipoproteinA1_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/ApolipoproteinB100_April2021.csv
| PseudoNHSNo | Age at Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Basophil_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/BileAcidSerum_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/CPeptideSerum_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/DHEA_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Eosinophil_April2021.csv
| PeudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Fasting Glucose..csv
| PseudoNHSNo | Age at Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/GAD Antibodies.csv
| PseudoNHSNo | Age at Test | TFCResultDT | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Haematocrit_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Haemoglobin_April2021.csv
| PseudoNHSNo | Age At Test | Result | Units |
|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/HDL_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Insulin Antibodies.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Islet Antibody.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Function Code |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/LDL_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/LH_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/LipoproteinA_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date Of Test | Result |
|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Lymphoctyes_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/MCH_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Result | Unit |
|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/MCHC_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date Of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/MCV_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Monocytes_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Neutrophils_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Oestradiol_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Platelet_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Progesterone_April2021.csv
| PseudoNHSNo | Age at Test | Test Name | Result | Unit |
|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Prolactin_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Random Glucose..csv
| V1 | V2 | V3 | V4 | V5 | V6 | V7 |
|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/RBC_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date Of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/RDW_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Result | Unit |
|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/SHBG_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/Testosterone_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/TotalCholesterol_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/TriglycerideSerum_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date Of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2021_04_PathologyLab/WhiteBloodCellCount_April2021.csv
| PseudoNHSNo | Age At Test | Test Name | Date Of Test | Result | Unit |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2022_03_ResearchDatasetv1.3/2022_05_23__icd10_combined_redacted.txt
| PseudoNHS | ICD10_code | ICD10_name | CodingDate | AgeAtCoding | EncounterType |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2022_03_ResearchDatasetv1.3/2022_05_26__opcs_combined_redacted.txt
| PseudoNHS | OPCS_code | OPCS_name | ActualProcedureDate | CodingDate | AgeAtCoding | EncounterType |
|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2022_03_ResearchDatasetv1.3/GandH_Pathology_202203191143_redacted_noHistopathologyReport.csv
| PseudoNHSnumber | RequestDate | TestCode | TestName | TestDesc | Result_nbr | ResultTxt | ResultUnit | ResUpper | ResLower | Resultfinding | ReportDate | Report | OrderStatus | ResStatus | SnomedCode |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2022_03_ResearchDatasetv1.3/GandH_Patient_Demographics_202203191143_redacted.csv
| PseudoNHSnumber | Date_of_Birth | GENDER_CD | Gender | ETHNIC_CD | Ethnicity | Date_of_Death |
|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2022_03_ResearchDatasetv1.3/GandH_PC_Diagnosis_202203191144_redacted_with_conceptIDs.csv
| PseudoNHSNumber | Confirmation | DiagDt | Classification | ClinService | DiagType | DiagCode | Vocab | Axis | Diagnosis | descriptionID | conceptId | term |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2022_03_ResearchDatasetv1.3/GandH_PC_Problems_202203191144_redacted_with_conceptIDs.csv
| PseudoNHSNumber | Confirmation | Classification | OnsetDate | StatusDate | Stat_LifeCycle | LifeCycleCancReson | Vocab | Axis | ProbCode | Problem | Annot_Disp | SecDesc | descriptionID | conceptId | term |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2022_03_ResearchDatasetv1.3/GandH_PC_Procedures_202203191144_redacted_with_conceptIDs.csv
| PseudoNHSNumber | AdmissionDT | DischargeDT | TreatmentFunc | Specialty | ProcDt | ProcCD | ProcType | EncType | Comment | ProcDetails | descriptionID | conceptId | term |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2022_03_ResearchDatasetv1.3/GandH_PowerForms_202203191143__HeightWeightBMI_subsetv2_redacted.csv
| V1 | V2 | V3 | V4 | V5 | V6 | V7 | V8 |
|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BartsHealth_NHS_Trust/2022_03_ResearchDatasetv1.3/GandH_PowerForms_202203191143_ListOfDatafields_redacted.csv
| NumberOfDataRows Form | Section | Element | Component |
|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BradfordTeachingHospitals_NHSFoundation_Trust/2022_06_BTHNFT/1578_gh_cerner_measurements_2022-06-10_redacted.tsv
| PseudoNHS | age_at_measurement | date_of_measurement | EVENT_CD | EVENT_TITLE | EVENT_ANSWER |
|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BradfordTeachingHospitals_NHSFoundation_Trust/2022_06_BTHNFT/1578_gh_diagnoses_2022-06-10_redacted.tsv
| PseudoNHS | icd10_code | icd10_name | episode_start_date | age_at_episode_start |
|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BradfordTeachingHospitals_NHSFoundation_Trust/2022_06_BTHNFT/1578_gh_procedures_2022-06-10_redacted.tsv
| PseudoNHS | opcs_code | opcs_procedure_description | episode_start_date | age_at_episode_start | actual_procedure_date | age_at_procedure_date |
|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BradfordTeachingHospitals_NHSFoundation_Trust/2022_06_BTHNFT/2022_05_26_nhsnumberuniq_redacted.txt
| PseudoNHSnumber |
|---|
| Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BradfordTeachingHospitals_NHSFoundation_Trust/2022_06_BTHNFT/bradford_cerner_diagnoses_with_conceptIDs_14July2022edits_redacted.tsv
| V1 | V2 | V3 | V4 | V5 | V6 | V7 | V8 | V9 |
|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__BradfordTeachingHospitals_NHSFoundation_Trust/2022_06_BTHNFT/bradford_cerner_problems_with_conceptIDs_14July2022edits_redacted.tsv
| V1 | V2 | V3 | V4 | V5 | V6 | V7 | V8 |
|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_04_Discovery/GNH_bhr-phase2-outfiles_merge/GNH_bhr_medications_ord_output_dataset_20220412.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | dose | quantity_value | quantity_unit | duration_days | medication_statement_id | original_term |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_04_Discovery/GNH_bhr-phase2-outfiles_merge/GNH_bhr_medications_stmt_output_dataset_20220412.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | is_active | cancellation_date | dose | quantity_value | quantity_unit | original_term |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_04_Discovery/GNH_bhr-phase2-outfiles_merge/GNH_bhr_observations_output_dataset_20220412.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | result_value | result_value_units | parent_observation_id | original_term | problem_end_date |
|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_04_Discovery/GNH_bhr-phase2-outfiles_merge/GNH_bhr_procedure_req_output_dataset_20220412.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | original_term |
|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_04_Discovery/GNH_thwfnech-phase2-outfiles_merge/GNH_thwfnech_medications_ord_output_dataset_20220423.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | dose | quantity_value | quantity_unit | duration_days | medication_statement_id | original_term |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_04_Discovery/GNH_thwfnech-phase2-outfiles_merge/GNH_thwfnech_medications_stmt_output_dataset_20220423.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | is_active | cancellation_date | dose | quantity_value | quantity_unit | original_term |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_04_Discovery/GNH_thwfnech-phase2-outfiles_merge/GNH_thwfnech_observations_output_dataset_20220423.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | result_value | result_value_units | parent_observation_id | original_term | problem_end_date |
|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_04_Discovery/GNH_thwfnech-phase2-outfiles_merge/GNH_thwfnech_procedure_req_output_dataset_20220424.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | original_term |
|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_12_Discovery/gh3_demographics_dataset_20221216_forTRE.csv
| ExtractDate | PseudoNHSNumber | Gender | Age | DateOfBirth_mm-yyyy | EthnicityLCode | EthnicityLTerm | BirthCountryLCode | BirthCountryLTerm | RegistrationStart | RegistrationEnd | IMD2010 | IMD2015 | Townsend2011 | LSOA2011 | PracticeODSCode | PracticeODSName | CCGName | DateOfDeath_mm-yyyy | F2fVisits_Total | F2fVisits_1year | F2fVisits_5years |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_12_Discovery/GNH_bhr-phase2-outfiles_merge/gh2_medications_ord_dataset_20221207.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | dose | quantity_value | quantity_unit | duration_days | medication_statement_id | original_term |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_12_Discovery/GNH_bhr-phase2-outfiles_merge/gh2_medications_stmt_dataset_20221207.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | is_active | cancellation_date | dose | quantity_value | quantity_unit | original_term |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_12_Discovery/GNH_bhr-phase2-outfiles_merge/gh2_observations_dataset_20221207.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | result_value | result_value_units | parent_observation_id | original_term | problem_end_date |
|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_12_Discovery/GNH_bhr-phase2-outfiles_merge/gh2_procedure_req_20221207.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | original_term |
|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_12_Discovery/GNH_thwfnech-phase2-outfiles_merge/cohort_gh2_medications_ord_output_dataset_20221207.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | dose | quantity_value | quantity_unit | duration_days | medication_statement_id | original_term |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_12_Discovery/GNH_thwfnech-phase2-outfiles_merge/cohort_gh2_medications_stmt_output_dataset_20221207.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | is_active | cancellation_date | dose | quantity_value | quantity_unit | original_term |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_12_Discovery/GNH_thwfnech-phase2-outfiles_merge/cohort_gh2_observations_output_dataset_20221207.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | result_value | result_value_units | parent_observation_id | original_term | problem_end_date |
|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2022_12_Discovery/GNH_thwfnech-phase2-outfiles_merge/cohort_gh2_procedure_req_output_dataset_20221208.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | original_term |
|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2023_01_Discovery/gh3_medication_ord.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | dose | quantity_value | quantity_unit | duration_days | medication_statement_id | original_term |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2023_01_Discovery/gh3_medication_stmt.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | cancellation_date | dose | quantity_value | quantity_unit | original_term |
|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2023_03_Discovery/gh3_medication_ord.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | dose | quantity_value | quantity_unit | duration_days | medication_statement_id | original_term |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2023_03_Discovery/gh3_medication_stmt.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | cancellation_date | dose | quantity_value | quantity_unit | original_term |
|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2023_03_Discovery/gh3_observations.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | result_value | result_value_units | parent_observation_id | original_term | problem_end_date |
|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/DSA__Discovery_7CCGs/2023_03_Discovery/gh3_procedure_req.csv
| pseudo_nhs_number | id | clinical_effective_date | original_code | original_term |
|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/QMUL__Stage1LabCollector/Stage1LabCollector_2023_01_30_v2.csv
| LABCO_OrageneID | LABCO_YYYY_DateInLab | ABCO_MM-YYYY_DateInLab | LABCO_RecruitmentSite |
|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/QMUL__Stage1Questionnaire/2023_01_24_S1QST_redacted_v2.csv
| S1QST_Oragene_ID | S1QST_MM-YYYY_ofBirth | S1QST_Gender | S1QST_EthnicGroup | S1QST_EthnicGroupOther | S1QST_NHSnumber_comment | S1QST_Diabetes | S1QST_ParentsBloodRelated | S1QST_ParentsBloodRelated2 | S1QST_ParentsBloodRelatedOther | S1QST_HealthWellbeing |
|---|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/QMUL__Stage1Questionnaire/old/2021_07_05_S1QST_deidentified_hasvalidNHSonly.txt
| S1QST_OrageneID | S1QST_YearBirth | S1QST_Gender | S1QST_EthnicGroup | S1QST_EthnicGroupOther | S1QST_Diabetes | S1QST_ParentsBloodRelated | S1QST_ParentsBloodRelated2 | S1QST_ParentsBloodRelatedOther | S1QST_HealthWellbeing |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/QMUL__Stage1Questionnaire/old/2022_05_05_S1QST_redacted.tab
| S1QST_OrageneID | S1QST_MM-YYYY_ofBirth | S1QST_Gender | S1QST_EthnicGroup | S1QST_EthnicGroupOther | S1QST_NHSnumber_comment | S1QST_Diabetes | S1QST_ParentsBloodRelated | S1QST_ParentsBloodRelated2 | S1QST_ParentsBloodRelatedOther | S1QST_HealthWellbeing |
|---|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/QMUL__Stage1Questionnaire/old/2022_07_29_S1QST_redacted.tab
| S1QST_Oragene_ID | S1QST_MM-YYYY_ofBirth | S1QST_Gender | S1QST_EthnicGroup | S1QST_EthnicGroupOther | S1QST_EmailAddress_comment | S1QST_MobilePhoneNumber_comment | S1QST_NHSnumber_comment | S1QST_Diabetes | S1QST_ParentsBloodRelated | S1QST_ParentsBloodRelated2 | S1QST_ParentsBloodRelatedOther | S1QST_HealthWellbeing |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |
/genesandhealth/library-red/genesandhealth/phenotypes_rawdata/QMUL__Stage1Questionnaire/old/2022_11_16_S1QST_redacted.tab
| S1QST_Oragene_ID | S1QST_MM-YYYY_ofBirth | S1QST_EthnicGroup | S1QST_EthnicGroupOther | S1QST_NHSnumber_comment | S1QST_Diabetes | S1QST_ParentsBloodRelated | S1QST_ParentsBloodRelated2 | S1QST_ParentsBloodRelatedOther | S1QST_HealthWellbeing |
|---|---|---|---|---|---|---|---|---|---|
| Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here | Type description here |