Using Oxford-RCGP RSC for observational studies

Using Oxford-RCGP RSC for observational studies

The Oxford-RCGP RSC has a current membership of over 1800 general practices in England covering approximately 8 million patients who are broadly representative of the English general population. The emergent COVID-19 pandemic has seen a rapid increase in the number of new practices joining the network to support the national surveillance program. The Oxford-RCGP RSC team transforms routine clinical data from individual patient records at practice level into an accessible repository of data for health research. Data is transformed to series of themed datasets readily available research. These datasets include standard RSC population configuration (based on age band, ethnicity, index of multiple deprivation, and rurality), clinical case definitions (generally ontological), covariates, and outcomes. These are benchmarked to ONS standard populations to enable rapid comparisons between the study and national populations.

How to access RCGP RSC data

RCGP RSC data is available for researchers interested in conducting primary care/ linked data studies. To work with us, please download and complete the data request form (below) and email  to practiceenquiries@phc.ox.ac.uk.

We would also need :

  • a protocol, clearly defining the purpose of the request and use of data
  • a list of variables (no abbreviations for the medical terms)
  • ethics approval (evidence if such is not needed – for what evidence you can present, please refer to the guidance notes on the form).

Once processed the request is assigned a reference number and added to the log. It is then scheduled for consideration at the weekly technical meeting and monthly RSC Operational meeting. The official approval happens at the fourth Wednesday of each month when the RCGP RSC operational meeting is held.

    Data request form

    Oxford-RCGP RSC Theme datasets

    The Oxford-RCGP RSC team is developing a series of themed datasets that will allow researchers rapid access to theme specific datasets that can be used for research studies. We offer standard protocols that can be modified to cater to the needs of specific research studies. These datasets can be linked to other data sources and prepared according a data structure that fits the analytical requirements of  the proposed study.

    Our currently planned themes (at different stages of development) are given below. Explore our theme datasets which are ready for research studies by clicking on the buttons on the right.

    Image

    How we develop phenotypes and ontologies to support theme datasets
    We start theme development by forming a group of theme experts led by a theme lead. The theme lead will design the theme dataset based on the common requirements for the research theme. The theme lead populates a theme template based on expert knowledge (or study requirement, if the theme is initially focused on producing a dataset for a study). The theme lead then works with a team of code curators to convert the data requirements of a in to a clinical code specification. This is carried out as a two stage approach (click on the links on the right to learn more). The outputs of the code curation process are stored in a code repository in the secure environment. The codes committed to the code repository are immediately available to be used for data extraction. The code repository is capable of updating automatically to reflect to most code changes in future SNOMED CT releases.
    Image

    Systems involved in the theme development process
    Image

    SNOMED CT Code Tool

    Theme leads and clinicians (with expertise in the theme)  use the SNOMED CT code tool developed by the Oxford-RCGP RSC team to curate variables/codes within each theme.

    Image

    Cardiovascular & diabetes theme

    General inclusions/exclusions and population covariates:

    • People will be included in cohorts who have a least one year’s historic data in their records.
    • Age will be represented as year or birth
    • Ethnicity will be listed in five categories (we can conduct multiple imputation for missing data)
    • IMD provided at LSOA level to individual records, derived from postcode. Where missing we substitute the practice cohort. Plus provided in quintiles (quintile 1 most deprived)
    • Household size (N.B. Relies on identical address & registered with same practice)
    • Urban, town and city, conurbation (ONS population density)
    • NHS Region – North, Midlands and East, South and London.
    • Registration will be full registration and not include temporary residents
    • We will include a practice indicator
    • We will exclude records where: no valid age or gender, no agreement to share data (approx. 0.2%)
    CVD Theme Template(Nexus 365 access required)
    RAGConditionIDCategoryConditionNameVariableTypeOutputTypeCommentAvailable
    95PHENOTYPEChronic Kidney Disease
    100EXPOSUREBody Mass Index
    105EXPOSUREHeight
    110EXPOSUREWeight
    1500INVESTGATIONeGFR
    1501INVESTGATIONPlateletCount
    1502INVESTGATIONBMICat_normal
    1503INVESTGATIONBMICat_obese
    1504INVESTGATIONBMICat_Overwt
    1505INVESTGATIONBMICat_Severeobesity
    1506OUTCOMECOVID19HospDisch
    1507OUTCOMECOVID-19HospAttempt
    1508OUTCOMECOVID-19MechVent
    1509OUTCOMECOVID-19OxygenRxAttempt
    1510OUTCOMECOVID-19TimeICU
    1511INVESTGATIONCRP_elevated
    1512INVESTGATIONCRP_normal
    1513INVESTGATIONCRP_numeric
    1514INVESTGATIONLFT_ALT
    1515INVESTGATIONLFT_AST
    1516INVESTGATIONDMARD
    1517INVESTGATIONAntiCoagMonitor
    1518INVESTGATIONINRMonitor_num
    1519OUTCOMECOVID-19ShieldedIndicative of being in high risk category for developing serious COVID-19 complication
    1520EXPOSURETemperature
    1521EXPOSUREFever
    1522INVESTGATIONHbA1c_IFCC
    1523INVESTGATIONHbA1c_DCCT
    1524INVESTGATIONHbA1c_Unspecified
    1525PHENOTYPEPeriphVascDiseaseLeg
    1526PHENOTYPEChronicLungDisease
    2008PHENOTYPEHaemorrhagicStrokeCase findingDichotomousExcludes intracranial haemorrhage explicitly trauma related
    2010PHENOTYPEHypertension
    2011PHENOTYPEIschaemicStroke
    2018PHENOTYPEMyocardialInfarctionCase findingDichotomousStrong evidence of myocardial infarct ever - not just acute
    2021PHENOTYPEAngina
    2025PHENOTYPEAtrialFibrillation
    2031PHENOTYPECongestiveCardiacFailure
    2041PHENOTYPERheumatoidArthritis
    2044PHENOTYPETIA
    2045PHENOTYPEUnstableAngina
    2046INVESTGATIONRandom Blood Glucose
    2047PHENOTYPEDiabetes T1
    2048PHENOTYPEDiabetes T2
    2049INVESTGATIONFasting Blood Glucose
    2050INVESTGATIONHbA1c
    2051EXPOSUREBlood Pressure - Both
    2052EXPOSUREBlood Pressure - Diastolic
    2053EXPOSUREBlood Pressure - Systolic
    2054INVESTGATIONHDL cholesterol
    2055INVESTGATIONLDL cholesterol
    2056INVESTGATIONTotal cholesterol
    2064PHENOTYPEAsthmaDiagnosis
    2065EXPOSUREActiveSmoker
    2066EXPOSUREEx-smoker
    2067EXPOSURENon-Smoker
    2126COPDProcessOfCare
    2133PHENOTYPECOPD
    2144INVESTGATIONACR
    2147PHENOTYPEChronic Kidney Disease - Stages 3 to 5
    2148INVESTGATIONCreatinine
    2149INVESTGATIONPCR
    3160PHENOTYPEIschemicHeartDiseaseJS
    "4204OUTCOMEAsthmaExacerbationCase findingDichotomous
    "4205EXPOSUREAsthmaPrescribedInhaledCorticosteriods
    "4206EXPOSUREAsthmaPrescribedOralCorticosteriods
    "4207OUTCOMEAccidentAndEmergencyDepartmentAttended
    "4208EXPOSUREAsthmaReviewCase findingDichotomous
    "4209EXPOSUREAsthmaManagementPlanCase findingDichotomous
    "4210EXPOSUREAsthmaManagementNoPlanCase findingDichotomous
    "4580OUTCOMEFindingOfDecreaseInAppetiteCase findingDichotomousCurated for use as Adverse Event Indicator
    "4581OUTCOMEFindingOfDiarrhoeaCase findingDichotomousCurated for use as Adverse Event Indicator
    "4582OUTCOMEFindingOfNauseaCase findingDichotomousCurated for use as Adverse Event Indicator
    "4583OUTCOMEFindingOfVomitingCase findingDichotomousCurated for use as Adverse Event Indicator
    "4588OUTCOMEFindingOfHeadacheCase findingDichotomousCurated for use as Adverse Event Indicator
    "4608OUTCOMEAnaphylaxisCase findingDichotomousCurated for use as Adverse Event Indicator
    "4660OUTCOMEFindingOfHaemolysisCase findingDichotomousCurated for use as Adverse Event Indicator
    "4661OUTCOMEHaemolyticAnaemiaCase findingDichotomousCurated for use as Adverse Event Indicator
    "4662OUTCOMEAgranulocytosisCase findingDichotomousCurated for use as Adverse Event Indicator
    "4663OUTCOMEAplasticAnaemiaCase findingDichotomousCurated for use as Adverse Event Indicator
    "4664OUTCOMEBoneMarrowDepressionCase findingDichotomousCurated for use as Adverse Event Indicator
    "4665OUTCOMEFindingOfLeucopeniaCase findingDichotomousCurated for use as Adverse Event Indicator
    "4666OUTCOMEFindingOfNeutropeniaCase findingDichotomousCurated for use as Adverse Event Indicator
    "4667OUTCOMEThrombocytopenicDisorderCase findingDichotomousCurated for use as Adverse Event Indicator
    "4668OUTCOMEStevens-JohnsonSyndromeCase findingDichotomousCurated for use as Adverse Event Indicator
    "4669OUTCOMELyellSyndromeCase findingDichotomousCurated for use as Adverse Event Indicator
    "4670OUTCOMEDrugReactionWithEosinophiliaAndSystemicSymptomsCase findingDichotomousCurated for use as Adverse Event Indicator
    "4671OUTCOMEErythemaMultiformeCase findingDichotomousCurated for use as Adverse Event Indicator
    "4672OUTCOMEItchingOfSkinCase findingDichotomousCurated for use as Adverse Event Indicator
    "4673OUTCOMEHenoch-SchonleinPurpuraCase findingDichotomousCurated for use as Adverse Event Indicator
    "4674OUTCOMEToxicLiverDiseaseCase findingDichotomousCurated for use as Adverse Event Indicator
    "4675OUTCOMEChoestaticJaundiceSyndromeCase findingDichotomousCurated for use as Adverse Event Indicator
    "4676OUTCOMEHepaticFailureCase findingDichotomousCurated for use as Adverse Event Indicator
    "4677OUTCOMEFindingOfAbdominalPainCase findingDichotomousCurated for use as Adverse Event Indicator
    "4678OUTCOMEClostridiumDifficileDiarrhoeaCase findingDichotomousCurated for use as Adverse Event Indicator
    "4679OUTCOMEPancreatitisCase findingDichotomousCurated for use as Adverse Event Indicator
    "4680OUTCOMEOesophagitisCase findingDichotomousCurated for use as Adverse Event Indicator
    "4681OUTCOMEUlcerOfOesphagusCase findingDichotomousCurated for use as Adverse Event Indicator
    "4682OUTCOMEAngioedemaCase findingDichotomousCurated for use as Adverse Event Indicator
    "4683OUTCOMEFindingOfCloudedConsciousnessCase findingDichotomousCurated for use as Adverse Event Indicator
    "4684OUTCOMEDeliriumCase findingDichotomousCurated for use as Adverse Event Indicator
    "4685OUTCOMEFindingOfExtraPyramidalMovementsCase findingDichotomousCurated for use as Adverse Event Indicator
    "4686OUTCOMEFindingOfHallucinationsCase findingDichotomousCurated for use as Adverse Event Indicator
    "4687OUTCOMEFindingOfPsychomotorAgitationCase findingDichotomousCurated for use as Adverse Event Indicator
    "4688OUTCOMEBenignIntracranialHypertensionCase findingDichotomousCurated for use as Adverse Event Indicator
    "4689OUTCOMEFindingOfTinnitusCase findingDichotomousCurated for use as Adverse Event Indicator
    "4690OUTCOMEBacterialVaginosisCase findingDichotomousCurated for use as Adverse Event Indicator
    "4691OUTCOMEPericarditisCase findingDichotomousCurated for use as Adverse Event Indicator
    "4710OUTCOMEDiabeticFootUlcerCase findingDichotomous
    "4711OUTCOMELowerExtremityAmputationMinorCase findingDichotomous
    "4712OUTCOMELowerExtremityAmputationMajorCase findingDichotomous
    "4713OUTCOMEDiabeticNeuropathyCase findingDichotomous
    "4714OUTCOMEDiabeticRetinopathyCase findingDichotomous

    Cancer theme

    General inclusions/exclusions and population covariates:

    • People will be included in cohorts who have a least one year’s historic data in their records.
    • Age will be represented as year or birth
    • Ethnicity will be listed in five categories (we can conduct multiple imputation for missing data)
    • IMD provided at LSOA level to individual records, derived from postcode. Where missing we substitute the practice cohort. Plus provided in quintiles (quintile 1 most deprived)
    • Household size (N.B. Relies on identical address & registered with same practice)
    • Urban, town and city, conurbation (ONS population density)
    • NHS Region – North, Midlands and East, South and London.
    • Registration will be full registration and not include temporary residents
    • We will include a practice indicator
    • We will exclude records where: no valid age or gender, no agreement to share data (approx. 0.2%)
    Cancer Theme Template(Nexus 365 access required)
    RAGConditionIDCategoryConditionNameVariableTypeOutputTypeCommentAvailable
    100Body Mass Index
    105Height
    110Weight
    1501PlateletCount
    1502BMICat_normal
    1503BMICat_obese
    1504BMICat_Overwt
    1505BMICat_Severeobesity
    1506COVID19HospDisch
    1507COVID-19HospAttempt
    1508COVID-19MechVent
    1509COVID-19OxygenRxAttempt
    1510COVID-19TimeICU
    1511CRP_elevated
    1512CRP_normal
    1513CRP_numeric
    1514LFT_ALT
    1515LFT_AST
    1519COVID-19ShieldedIndicative of being in high risk category for developing serious COVID-19 complication
    1520Temperature
    1521Fever
    1527PHENOTYPEcancer_groups_cervical_InSitu_CIN3
    1528PHENOTYPEcancer_groups_cervical_total
    1529PHENOTYPEcancer_groups_colon_InSitu
    1530PHENOTYPEcancer_groups_colon_total
    1531PHENOTYPEcancer_groups_melanoma_InSitu
    1532PHENOTYPEcancer_groups_myeloma_MGUS
    1533PHENOTYPEcancer_groups_oesophagus_Barretts_InSitu
    1534PHENOTYPEcancer_groups_oesophagus_total
    1535PHENOTYPEcancer_groups_pancreas_InSitu
    1536PHENOTYPEcancer_groups_pancreas_total
    1537PHENOTYPEcancer_groups_stomach_InSitu
    1538PHENOTYPEcancer_groups_stomach_total
    1539cancer_symptoms_postmenopausal_bleeding
    1540cancer_symptoms_vaginaldischarge
    1541cancer_2ww_referrals_urol
    1542cancer_2ww_referrals_UpperGI
    1543cancer_2ww_referrals_Skin
    1544cancer_2ww_referrals_Sarcoma
    1545cancer_2ww_referrals_Lung
    1546cancer_2ww_referrals_HeadNeck
    1547cancer_2ww_referrals_HaemMalig
    1548cancer_2ww_referrals_Gynae
    1549cancer_2ww_referrals_Colorectal
    1550cancer_2ww_referrals_Breast
    1551cancer_2ww_referrals_LowerGI
    1552cancer_2ww_referrals_Braincancer
    1553PHENOTYPEcancer_groups_bladder_InSitu
    1554PHENOTYPEcancer_groups_bladder_Total
    1555PHENOTYPEcancer_groups_prostateCa_InSitu
    1556PHENOTYPEcancer_groups_prostateCa_Total
    1557PHENOTYPEcancer_groups_prostateCa_Primary
    1558PHENOTYPEcancer_groups_ovarian_total
    1559PHENOTYPEcancer_groups_endometrial_InSitu
    1560PHENOTYPEcancer_groups_endometrial_total
    1561PHENOTYPEcancer_groups_renal_InSitu
    1562cancer_symptoms_Test_Scrotum_Pain
    1563PHENOTYPEcancer_groups_renal_Total
    1564cancer_symptoms_Test_Scrotum_Mass
    1565cancer_symptoms_NonCardiac_Chest_Pain
    1566cancer_symptoms_UrinaryUrgency
    1567cancer_symptoms_UrinaryFrequency
    1568cancer_symptoms_Nocturia
    1569cancer_symptoms_Retention
    1570PHENOTYPEcancer_groups_T0_pTis_InSitu
    1571cancer_symptoms_ChangeBowelHabit
    1572PHENOTYPEcancer_groups_FIGO_Stage4
    1573PHENOTYPEcancer_groups_FIGO_Stage3
    1574PHENOTYPEcancer_groups_FIGO_Stage2
    1575PHENOTYPEcancer_groups_FIGO_Stage1
    1576PHENOTYPEcancer_groups__Stage_M1
    1577PHENOTYPEcancer_groups__Stage_M0
    1578PHENOTYPEcancer_groups__Stage_T4
    1579PHENOTYPEcancer_groups__Stage_T3
    1580PHENOTYPEcancer_groups__Stage_T2
    1581PHENOTYPEcancer_groups__Stage_T1
    1582PHENOTYPEcancer_groups__Stage_N4
    1583PHENOTYPEcancer_groups__Stage_N3
    1584PHENOTYPEcancer_groups__Stage_N2
    1585PHENOTYPEcancer_groups__Stage_N1
    1586PHENOTYPEcancer_groups__Stage_N0
    1587PHENOTYPEcancer_groups__Dukes_A
    1588PHENOTYPEcancer_groups__Dukes_B
    1589PHENOTYPEcancer_groups__Dukes_C
    1590PHENOTYPEcancer_groups__Dukes_D
    1591PHENOTYPEcancer_groups_breast_InSitu
    1592PHENOTYPEcancer_groups_breast_Total
    1593PHENOTYPEcancer_groups_lung_InSitu
    1594PHENOTYPEcancer_groups_lung_Total
    1595PHENOTYPEcancer_symptoms_breast_SkinNippleChanges
    1596cancer_symptoms_breast_Pain
    1597PHENOTYPEcancer_symptoms_UrinaryTractInfection
    1598PHENOTYPEcancer_groups_anal_Total
    1599PHENOTYPEcancer_groups_Bone_Total
    1600PHENOTYPEcancer_groups_penis_total
    1601PHENOTYPEcancer_groups_hepato_InSitu
    1602PHENOTYPEcancer_groups_hepato_Total
    1603PHENOTYPEcancer_groups__Leukaemia_Other
    1604PHENOTYPEcancer_groups__Leukaemia_Total_Overarching
    1605PHENOTYPEcancer_groups__Leukaemia_CLL
    1606PHENOTYPEcancer_groups__Leukaemia_CML
    1607PHENOTYPEcancer_groups__Leukaemia_ALL
    1608PHENOTYPEcancer_groups__Leukaemia_AML
    1609PHENOTYPEcancer_groups_NonHodgkinsLymphoma
    1610PHENOTYPEcancer_groups_HodgkinsLymphoma
    1611PHENOTYPEcancer_groups_SpermaticCord_Total
    1612PHENOTYPEcancer_groups_testicular_InSitu
    1613PHENOTYPEcancer_groups_testicular_Total
    1614diagnosis_basedonDeathCert_Autopsy
    1614diagnosis_basedonDeathCert_Autopsy
    1615referrals_2ww_AllCancers_seen
    1616referrals_2ww_Urological_seen
    1617referrals_2ww_UpperGI_seen
    1618referrals_2ww_Skin_seen
    1619referrals_2ww_Sarcoma_seen
    1620referrals_2ww_Lung_seen
    1621referrals_2ww_HaemMalig_seen
    1622referrals_2ww_Gynae_seen
    1623referrals_2ww_ColoRectal_seen
    1624referrals_2ww_Breast_seen
    1625referrals_2ww_BrainCancer_seen
    1626referrals_2ww_HeadNeck_seen
    1627PHENOTYPEcancer_groups_gallbladder_InSitu
    1628PHENOTYPEcancer_groups_gallbladder_Total
    1629PHENOTYPEcancer_groups_peritoneum_Total
    2001PHENOTYPECysticFibrosisCase findingDichotomous
    2008HaemorrhagicStrokeCase findingDichotomousExcludes intracranial haemorrhage explicitly trauma related
    2011IschaemicStroke
    2018MyocardialInfarctionCase findingDichotomousStrong evidence of myocardial infarct ever - not just acute
    3000cancer_2ww_referrals_
    3001cancer_symptoms_apetite_loss
    3008cancer_symptoms_clubbing
    3009cancer_symptoms_constipation
    3010cancer_symptoms_cough
    3011PHENOTYPEcancer_symptoms_diarrhea
    3012cancer_symptoms_distension
    3015cancer_symptoms_dysphagia
    3016cancer_symptoms_dysuria
    3017cancer_symptoms_fatigue
    3019cancer_symptoms_haematuria
    3020cancer_symptoms_hoarse
    3021cancer_symptoms_ida
    3022cancer_symptoms_infectrecur
    3023cancer_symptoms_jaundice
    3024cancer_symptoms_lumpbreast
    3026cancer_symptoms_lymphaden
    3027cancer_symptoms_lymphaneck
    3028cancer_symptoms_massabdo
    3032cancer_symptoms_nausea
    3034cancer_symptoms_painabdom
    3035cancer_symptoms_painback
    3036cancer_symptoms_painbone
    3038cancer_symptoms_painupabdo
    3040cancer_symptoms_reflux
    3041cancer_symptoms_sob
    3042cancer_symptoms_splenomegaly
    3045cancer_symptoms_weight_loss
    3046cancer_tests_brain_MRI
    3047cancer_tests_ca125
    3048cancer_tests_chest_xray
    3049cancer_tests_colonoscopy
    3051cancer_tests_CTPelvis
    3057cancer_tests_PSA
    3058PHENOTYPEcancer_tests_serumprotein_electro
    3059cancer_tests_USSabdo
    3061PHENOTYPEcancer_groups_oesophagus
    3062PHENOTYPEcancer_groups_stomach
    3064PHENOTYPEcancer_groups_colon
    3065cancer_groups_rectum
    3066PHENOTYPEcancer_groups_anal
    3067PHENOTYPEcancer_groups_hepato
    3068PHENOTYPEcancer_groups_gallbladder
    3070PHENOTYPEcancer_groups_pancreas
    3071PHENOTYPEcancer_groups_peritoneum
    3072PHENOTYPEcancer_groups_lung
    3075PHENOTYPEcancer_groups_osteo
    3076PHENOTYPEcancer_groups_melanoma
    3078PHENOTYPEcancer_groups_breast
    3079PHENOTYPEcancer_groups_vulval
    3080cancer_groups_cervical
    3081PHENOTYPEcancer_groups_endometrial
    3082PHENOTYPEcancer_groups_ovarian
    3083PHENOTYPEcancer_groups_choriocarcinoma
    3084PHENOTYPEcancer_groups_penis
    3086PHENOTYPEcancer_groups_testicular
    3087PHENOTYPEcancer_groups_spermatic cord
    3088PHENOTYPEcancer_groups_renal
    3089PHENOTYPEcancer_groups_bladder
    3090PHENOTYPEcancer_groups_eye
    3095PHENOTYPEcancer_groups_secondary_malignancy
    3098PHENOTYPEcancer_groups_myeloma
    4002cancer_tests_CTHead
    4004cancer_tests_CT_abdo
    4005cancer_tests_CTscan_AllSites
    4006cancer_tests_CT_chest
    4007PHENOTYPEcancer_groups_CNSwho_meningioma_all
    4008PHENOTYPEcancer_groups_CNSwho_meningioma_I
    4009PHENOTYPEcancer_groups_CNSwho_meningioma_II
    4010PHENOTYPEcancer_groups_CNSwho_meningioma_III
    4011PHENOTYPEcancer_groups_CNSwho_AstrocyticOligodendroglial
    4012PHENOTYPEcancer_groups_CNSwho_Embryonal
    4013PHENOTYPEcancer_groups_CNSwho_TumoursSpinalParaspinalNerves
    4014PHENOTYPEcancer_groups_CNSwho_Pineal
    4015PHENOTYPEcancer_groups_CNSwho_Ependymoma
    4016PHENOTYPEcancer_groups_CNSwho_ChoroidPlexus
    4017PHENOTYPEcancer_groups_CNSwho_mesenchymalCase findingDichotomous
    4018PHENOTYPEcancer_groups_CNSwho_SellarRegion
    4019PHENOTYPEcancer_groups_CNSwho_Neuronal_MixedNeuronalGlial
    4020PHENOTYPEcancer_groups_EyeAndOrbit_total
    4022cancer_tests_SerumLDH
    4023cancer_tests_brain_MRIJS_normal
    4024cancer_tests_brain_MRIJS_abnormal
    4025cancer_tests_CT_resultAbnormal
    4026cancer_tests_CT_resultNormal
    4027cancer_tests_chest_xrayJS_normal
    4028cancer_tests_chest_xrayJS_abnormal
    4029cancer_tests_PSAJS_result_Abormal
    4030cancer_tests_PSAJS_result_Normal
    4031cancer_tests_PSAJS_result_ObEntity
    4032cancer_tests_ca125JS_procedure
    4033cancer_tests_serumprotein_electroJS_procedure
    4034cancer_tests_USSabdoJS_Abnormal
    4035cancer_tests_USSabdoJS_Normal
    4036cancer_tests_USSpelvis
    4037cancer_tests_mammogram
    4038cancer_tests_mammogram_result_Normal
    4039cancer_tests_mammogram_result_Abnormal
    4040cancer_groups_stage_WHOcns_I
    4041cancer_groups_stage_WHOcns_II
    4042cancer_groups_stage_WHOcns_III
    4043cancer_groups_stage_WHOcns_IV
    4044cancer_groups_stage_TNM_ObEntity
    4045cancer_groups_Small_Intestine_primary
    4046cancer_groups_Small_Intestine_total
    4047cancer_groups_rectumJS_total
    4048cancer_groups_rectum_InSitu
    4049cancer_tests_WhiteCellCount_procedure
    4050cancer_tests_WhiteCellCount_ObEntity
    4051cancer_tests_LymphocyteCount_procedure
    4052cancer_tests_lymphocyteCount_ObEntity
    4053cancer_tests_platelets_procedure
    4054cancer_tests_platelets_ObEntity
    4055cancer_tests_CRP_procedure
    4056cancer_tests_CRP_ObEntity
    4057cancer_tests_ESR_procedure
    4058cancer_tests_ESR_ObEntity
    4059DiagnosisDeath_QualValue
    4060cancer_tests_colonoscopy_result_abnormal
    4061cancer_tests_colonoscopy_result_normal
    4062cancer_tests_sigmoidoscopy
    4063cancer_tests_sigmoidoscopy_result_abnormal
    4064cancer_tests_sigmoidoscopy_result_normal
    4123cancer_symptoms_MicroscopicHaematuria
    4124cancer_tests_haemoglobin_procedure
    4125cancer_tests_haemoglobin_ObEntity
    4126cancer_tests_MCV_procedure
    4127cancer_tests_MCV_ObEntity
    4128cancer_tests_MCH_procedure
    4129cancer_tests_MCH_ObEntity
    4130cancer_tests_VitD3_procedure
    4131cancer_tests_VitD3_ObEntity
    4132cancer_tests_oesophagogastroduodenoscopyOGD
    4133cancer_tests_OGD_result_normal
    4134cancer_tests_OGD_result_abnormal
    4135cancer_tests_cystoscopy_procedure
    4136cancer_tests_cystoscopy_result_normal
    4137cancer_tests_cystoscopy_result_abnormal
    4138cancer_screen_bowel_FOB_procedure
    4139cancer_screen_bowel_FOB_normal
    4140cancer_screen_bowel_FOB_abnormal
    4141cancer_screen_bowel_FOB_result_ObEntity
    4142cancer_tests_FOB_NonScreening_result_abnormal
    4143cancer_tests_FOB_NonScreening_result_normal
    4144cancer_tests_FOB_NonScreening_result_ObEntity
    4145cancer_tests_FOB_procedure_NonScreening
    4146cancer_screen_bowel_FIT_result_ObEntity
    4152cancer_screen_bowel_FIT_normal
    4153cancer_screen_bowel_FIT_Abnormal
    4154cancer_screen_bowel_sigmoidoscopy_procedure
    4155cancer_screen_bowel_DNA_DidNotRespond
    4158cancer_screen_bowel_sigmoidoscopy_FurtherInvest
    4159cancer_screen_bowel_sigmoidoscopy_cancer_detected
    4160cancer_screen_bowel_sigmoidoscopy_normal
    4161cancer_diagnosis_BowelCancer_screening
    4162cancer_diagnosis_BreastCancer_screening
    4163cancer_screen_breast_MRI_procedure
    4164cancer_screen_breast_mammogram_procedure
    4165cancer_screen_breast_result_abnormal
    4166cancer_screen_breast_result_normal
    4167cancer_screen_breast_DNA_DidNotRespond
    4168cancer_tests_HPVTest_procedure
    4169cancer_tests_HPVTest_result_ObEntity
    4170cancer_tests_HPVTest_result_positive
    4171cancer_tests_HPVTest_result_negative
    4172cancer_tests_PapSmear_procedure
    4173cancer_tests_PapSmear_result_ObEntity
    4174cancer_tests_PapSmear_result_normal
    4175cancer_tests_PapSmear_result_abnormal
    4176cancer_tests_colposcopy_procedure
    4177cancer_tests_colposcopy_abnormal
    4178cancer_tests_colposcopy_normal
    4204PHENOTYPEAsthmaExacerbationCase findingDichotomous
    4208PHENOTYPEAsthmaReviewCase findingDichotomous
    4209PHENOTYPEAsthmaManagementPlanCase findingDichotomous
    4210PHENOTYPEAsthmaManagementNoPlanCase findingDichotomous
    4737PHENOTYPEHereditaryHaemochromatosisCase findingDichotomous
    4738PHENOTYPEOperationOnPancreasCase findingDichotomous
    4739PHENOTYPEMalignantTumourOfExocrinePancreasCase findingDichotomousIncludes some secondary cancers
    4740PHENOTYPEPrimaryAdenocarcinomaOfPancreasCase findingDichotomous
    4741PHENOTYPEAcinarCellCarcinomaOfPancreasCase findingDichotomous
    4742PHENOTYPEPrimaryMalignantNeuroendocrineNeoplasmOfPancreasCase findingDichotomous
    4743PHENOTYPECarcinoembryonicAntigenLevelInvestigationNumeric
    4744PHENOTYPEHighCarcinoembryonicAntigenLevelInvestigationDichotomous
    4745PHENOTYPEPancreaticoduodenectomyCase findingDichotomous
    4746PHENOTYPEPancreatectomyCase findingDichotomousNB this includes all pancreaticoduodenectomies
    4747PHENOTYPERadiationOncologyAndOrRadiotherapyCase findingDichotomous
    4748PHENOTYPEChemotherapyCase findingDichotomous
    4749PHENOTYPESuspectedPancreaticCancerCase findingDichotomous
    4868PHENOTYPERectalHaemorrhageCase findingDichotomous
    4869PHENOTYPERectalExaminationNADCase findingDichotomous
    4870PHENOTYPERectalExaminationOfProstateAbnormalityDetectedCase findingDichotomous
    4871PHENOTYPERectalExaminationRectalMassCase findingDichotomous
    4872PHENOTYPEFindingOfIndigestionCase findingDichotomous
    4873PHENOTYPEFindingOfPelvicMassCase findingDichotomous
    4874PHENOTYPEMicroscopicHaematuriaCase findingDichotomous
    4875PHENOTYPEBCSP-FaecalImmunochemicalTestNormalCase findingDichotomous
    4876PHENOTYPEBCSP-FaecalImmunochemicalTestAbnormalCase findingDichotomous
    4877PHENOTYPEMalignantTumourOfHead&NeckCase findingDichotomousBased on ICD C76.x,C00-C14,C30-C32. Does not include tracheal neoplasms
    4878PHENOTYPEMalignantTumourOfExtrahepaticBileDuctCase findingDichotomousBased on ICD C24.x
    4879PHENOTYPEMalignantTumourOfMeningesCase findingDichotomousBased on ICD C70.x
    4880PHENOTYPEFindingOfHaemoptysisCase findingDichotomous
    4881PHENOTYPEQuantitativeFaecalImmunochemicalTestCase findingNumeric
    4882PHENOTYPEMalignantTumourOfTracheaCase findingDichotomousBased on ICD C33

    Surveillance & acute pathways of care theme

    General inclusions/exclusions and population covariates:

    • People will be included in cohorts who have a least one year’s historic data in their records.
    • Age will be represented as year or birth
    • Ethnicity will be listed in five categories (we can conduct multiple imputation for missing data)
    • IMD provided at LSOA level to individual records, derived from postcode. Where missing we substitute the practice cohort. Plus provided in quintiles (quintile 1 most deprived)
    • Household size (N.B. Relies on identical address & registered with same practice)
    • Urban, town and city, conurbation (ONS population density)
    • NHS Region – North, Midlands and East, South and London.
    • Registration will be full registration and not include temporary residents
    • We will include a practice indicator
    • We will exclude records where: no valid age or gender, no agreement to share data (approx. 0.2%)
    RAGConditionIDCategoryConditionNameVariableTypeOutputTypeCommentAvailable
    RAGConditionIDCategoryConditionNameVariableTypeOutputTypeCommentAvailable
    1001PHENOTYPEMusculoskeletalSymptoms-WRptCase findingDichotomousFor weekly reports. Based specifically on ICD R25-R29
    1003PHENOTYPELaryngitisOrTracheitis-WrptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1005PHENOTYPEStrepThroatOrPeritonsillarAbscess-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1006PHENOTYPEIntestinalInfectiousDisease-WRptCase findingDichotomousFor weekly reports. Guided by ICD10: A00-A09
    1007PHENOTYPEUpperRespiratoryInfection-WRptCase findingDichotomousFor weekly reports
    1008PHENOTYPEAsthma-WRptCase findingDichotomousFor weekly reports. Includes semantic tags disorders, findings, situations, events etc. - anything signifying diagnois of astham highly likely
    1011PHENOTYPEVaricella-WRptCase findingDichotomous
    1018PHENOTYPEAcuteOtitisMedia-WRptCase findingDichotomousFor weekly reports
    1020PHENOTYPEInfluenza-likeIllness-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1021PHENOTYPERubella-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1022PHENOTYPEDisorderOfRespiratorySystem-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1028PHENOTYPERespiratoryAndChestSymptoms-WRptSymptomDichotomousFor weekly reports. Based specifically on ICD R05-R07, R09
    1030PHENOTYPEMumps-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1031PHENOTYPEImpetigo-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1035PHENOTYPEConjunctivalDisorder-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1036PHENOTYPEPleurisy-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1037PHENOTYPEHerpesSimplex-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1038PHENOTYPESkinAndIntegumentSymptoms-WRptCase findingDichotomousFor weekly reports. Based specifically on ICD R20 - R23
    1042PHENOTYPEInfestationCausedBySarcoptes-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1044PHENOTYPEPertussis-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1045PHENOTYPEMeningitisOrEncephalitis-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1046PHENOTYPEUrinaryTractInfectiousDisease-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1048PHENOTYPENoninfectiousEnteritisOrColitis-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1052PHENOTYPEPneumoniaOrPneumonitis-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1054PHENOTYPESinusitis-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1055PHENOTYPELowerRespiratoryTractInfection-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1056PHENOTYPEViralHepatitis-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1057PHENOTYPEAllergicRhinitis-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1058PHENOTYPEBronchitis-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag. Excludes bronchiolitis
    1060PHENOTYPEHerpesZoster-WRptCase findingDichotomous
    1061PHENOTYPEInfectiousMononucleosis-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1062PHENOTYPEInfectionOfSkinOrsubcutaneousTissues-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1063PHENOTYPETonsillitisOrPharyngitis-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1066PHENOTYPEPeripheralNerveDisease-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    1067PHENOTYPEBullousDermatoses-WRptCase findingDichotomousFor weekly reports. Excludes simple blisters traumatic and otherwise. Limited to concepts with disorder semantic tag
    1068PHENOTYPEMeasles-WRptCase findingDichotomousFor weekly reports. Limited to concepts with disorder semantic tag
    2001PHENOTYPECysticFibrosisCase findingDichotomous
    2002PHENOTYPEDementiaCase findingDichotomous
    2008PHENOTYPEHaemorrhagicStrokeCase findingDichotomousExcludes intracranial haemorrhage explicitly trauma related
    2011PHENOTYPEIschaemicStroke
    2018PHENOTYPEMyocardialInfarctionCase findingDichotomousStrong evidence of myocardial infarct ever - not just acute
    2019PHENOTYPEAcutePancreatitisCase findingDichotomous
    2029PHENOTYPEChronicPancreatitisCase findingDichotomous
    2044PHENOTYPETIA
    2133PHENOTYPECOPD
    2140PHENOTYPEPregOntPregnant
    2143PHENOTYPEPregOntTimedCase findingDichotomousCurated specifically for pregnancy ontology
    3109PHENOTYPEBronchiolitisCase findingDichotomous
    3111PHENOTYPEScarletFeverCase findingDichotomous
    4180EXPOSUREInfluenzaVaccinesPrescribableWithinGPQOFDrug VaccinationDichotomousdm+d codes. Taken from QOF RefsetID 12465201000001105
    4182EXPOSUREInfluenzaVaccinationAdministeredByThirdPartyVaccinationDichotomousAdministration codes
    4183EXPOSUREInfluenzaVaccinationAdministeredVaccinationDichotomousAdministration codes
    4186EXPOSUREFluVac20QIVeSanofiPasteurDrug VaccinationDichotomousdm+d codes
    4187EXPOSUREFluVac20LAIVAstraZeneca-FluenzTetraDrug VaccinationDichotomousdm+d codes
    4188EXPOSUREFluVac20QIVeGSK-FluarixTetraDrug VaccinationDichotomousdm+d codes
    4189EXPOSUREFluVac20QIVeMylan-InfluenzaVaccTetraMYLDrug VaccinationDichotomousdm+d codes
    4190EXPOSUREFluVac20QIVeMylan-InfluvacSub-unitDrug VaccinationDichotomousdm+d codes
    4191EXPOSUREFluVac20QIVcSeqirus-FlucelvaxTetraDrug VaccinationDichotomousdm+d codes
    4192EXPOSUREFluVac20ATIVSeqirus-FluadDrug VaccinationDichotomousdm+d codes
    4193EXPOSUREFluVac20TIV-HDSanofiPasteurDrug VaccinationDichotomousdm+d codes
    4194EXPOSUREFluVac20QIVeMASTADrug VaccinationDichotomousdm+d codes
    4198EXPOSUREFluVac20-aTIVGenericDrug VaccinationDichotomousdm+d codes
    4202OUTCOMEInfluenzaVaccinationDeclinedVaccinationDichotomousAdmin codes
    4203OUTCOMEInfluenzaVaccinationDNAVaccinationDichotomousAdmin codes
    4516ETHNICITYEthnicityWhiteEnglishWelshScottishNIrishBritishCase findingDichotomous
    4518ETHNICITYEthnicityWhiteIrishCase findingDichotomous
    4520ETHNICITYEthnicityWhiteOtherCase findingDichotomous
    4522ETHNICITYEthnicityBlackAfricanCase findingDichotomous
    4525ETHNICITYEthnicityBlackCaribbeanCase findingDichotomous
    4527ETHNICITYEthnicityBlackOtherCase findingDichotomous
    4531PHENOTYPEFindingOfHomelessnessCase findingDichotomous
    4580OUTCOMEFindingOfDecreaseInAppetiteCase findingDichotomousCurated for use as Adverse Event Indicator
    4581OUTCOMEFindingOfDiarrhoeaCase findingDichotomousCurated for use as Adverse Event Indicator
    4582OUTCOMEFindingOfNauseaCase findingDichotomousCurated for use as Adverse Event Indicator
    4583OUTCOMEFindingOfVomitingCase findingDichotomousCurated for use as Adverse Event Indicator
    4584OUTCOMEFindingOfDrowsinessCase findingDichotomousCurated for use as Adverse Event Indicator
    4585OUTCOMEFindingOfFatigueCase findingDichotomousCurated for use as Adverse Event Indicator
    4586OUTCOMEFindingOfIrritabilityCase findingDichotomousCurated for use as Adverse Event Indicator
    4587OUTCOMEFindingOfMalaiseCase findingDichotomousCurated for use as Adverse Event Indicator
    4588OUTCOMEFindingOfHeadacheCase findingDichotomousCurated for use as Adverse Event Indicator
    4589OUTCOMEFindingOfLocalisedErythemaCase findingDichotomousCurated for use as Adverse Event Indicator
    4590OUTCOMEArthropathyCase findingDichotomousCurated for use as Adverse Event Indicator
    4591OUTCOMEFindingOfMyalgiaCase findingDichotomousCurated for use as Adverse Event Indicator
    4592OUTCOMEGuillainBarrieSyndromeCase findingDichotomousCurated for use as Adverse Event Indicator
    4593OUTCOMEFindingOfPeripheralTremorCase findingDichotomousCurated for use as Adverse Event Indicator
    4594OUTCOMESeizureCase findingDichotomousCurated for use as Adverse Event Indicator
    4595OUTCOMEFebrileConvulsionCase findingDichotomousCurated for use as Adverse Event Indicator
    4596OUTCOMEBellsPalsyCase findingDichotomousCurated for use as Adverse Event Indicator
    4597OUTCOMEEruptionOfSkinCase findingDichotomousCurated for use as Adverse Event Indicator. Note "EruptioOfSkin" stands for "skin rash"
    4598OUTCOMEConjunctivitisCase findingDichotomousCurated for use as Adverse Event Indicator
    4599OUTCOMECommonColdCase findingDichotomousCurated for use as Adverse Event Indicator
    4600OUTCOMEFindingOfCoughCase findingDichotomousCurated for use as Adverse Event Indicator
    4601OUTCOMEBleedingFromNoseCase findingDichotomousCurated for use as Adverse Event Indicator
    4602OUTCOMEFindingOfHoarsenessCase findingDichotomousCurated for use as Adverse Event Indicator
    4603OUTCOMEFindingOfNasalCongestionCase findingDichotomousCurated for use as Adverse Event Indicator
    4604OUTCOMEFindingOfPainfulMouthCase findingDichotomousCurated for use as Adverse Event Indicator
    4605OUTCOMEFindingOfSoreThroatCase findingDichotomousCurated for use as Adverse Event Indicator
    4606OUTCOMEFindingOfNasalDischargeCase findingDichotomousCurated for use as Adverse Event Indicator
    4607OUTCOMEFindingOfWheezingCase findingDichotomousCurated for use as Adverse Event Indicator
    4608OUTCOMEAnaphylaxisCase findingDichotomousCurated for use as Adverse Event Indicator
    4609OUTCOMEFindingOfOedemaOfFaceCase findingDichotomousCurated for use as Adverse Event Indicator
    4610OUTCOMEHypersensitivityReactionCase findingDichotomousCurated for use as Adverse Event Indicator
    4632ETHNICITYEthnicityAsianIndianCase findingDichotomous
    4660OUTCOMEFindingOfHaemolysisCase findingDichotomousCurated for use as Adverse Event Indicator
    4661OUTCOMEHaemolyticAnaemiaCase findingDichotomousCurated for use as Adverse Event Indicator
    4662OUTCOMEAgranulocytosisCase findingDichotomousCurated for use as Adverse Event Indicator
    4663OUTCOMEAplasticAnaemiaCase findingDichotomousCurated for use as Adverse Event Indicator
    4664OUTCOMEBoneMarrowDepressionCase findingDichotomousCurated for use as Adverse Event Indicator
    4665OUTCOMEFindingOfLeucopeniaCase findingDichotomousCurated for use as Adverse Event Indicator
    4666OUTCOMEFindingOfNeutropeniaCase findingDichotomousCurated for use as Adverse Event Indicator
    4667OUTCOMEThrombocytopenicDisorderCase findingDichotomousCurated for use as Adverse Event Indicator
    4668OUTCOMEStevens-JohnsonSyndromeCase findingDichotomousCurated for use as Adverse Event Indicator
    4669OUTCOMELyellSyndromeCase findingDichotomousCurated for use as Adverse Event Indicator
    4670OUTCOMEDrugReactionWithEosinophiliaAndSystemicSymptomsCase findingDichotomousCurated for use as Adverse Event Indicator
    4671OUTCOMEErythemaMultiformeCase findingDichotomousCurated for use as Adverse Event Indicator
    4672OUTCOMEItchingOfSkinCase findingDichotomousCurated for use as Adverse Event Indicator
    4673OUTCOMEHenoch-SchonleinPurpuraCase findingDichotomousCurated for use as Adverse Event Indicator
    4674OUTCOMEToxicLiverDiseaseCase findingDichotomousCurated for use as Adverse Event Indicator
    4675OUTCOMEChoestaticJaundiceSyndromeCase findingDichotomousCurated for use as Adverse Event Indicator
    4676OUTCOMEHepaticFailureCase findingDichotomousCurated for use as Adverse Event Indicator
    4677OUTCOMEFindingOfAbdominalPainCase findingDichotomousCurated for use as Adverse Event Indicator
    4678OUTCOMEClostridiumDifficileDiarrhoeaCase findingDichotomousCurated for use as Adverse Event Indicator
    4679OUTCOMEPancreatitisCase findingDichotomousCurated for use as Adverse Event Indicator
    4680OUTCOMEOesophagitisCase findingDichotomousCurated for use as Adverse Event Indicator
    4681OUTCOMEUlcerOfOesphagusCase findingDichotomousCurated for use as Adverse Event Indicator
    4682OUTCOMEAngioedemaCase findingDichotomousCurated for use as Adverse Event Indicator
    4683OUTCOMEFindingOfCloudedConsciousnessCase findingDichotomousCurated for use as Adverse Event Indicator
    4684OUTCOMEDeliriumCase findingDichotomousCurated for use as Adverse Event Indicator
    4685OUTCOMEFindingOfExtraPyramidalMovementsCase findingDichotomousCurated for use as Adverse Event Indicator
    4686OUTCOMEFindingOfHallucinationsCase findingDichotomousCurated for use as Adverse Event Indicator
    4687OUTCOMEFindingOfPsychomotorAgitationCase findingDichotomousCurated for use as Adverse Event Indicator
    4688OUTCOMEBenignIntracranialHypertensionCase findingDichotomousCurated for use as Adverse Event Indicator
    4689OUTCOMEFindingOfTinnitusCase findingDichotomousCurated for use as Adverse Event Indicator
    4690OUTCOMEBacterialVaginosisCase findingDichotomousCurated for use as Adverse Event Indicator
    4691OUTCOMEPericarditisCase findingDichotomousCurated for use as Adverse Event Indicator
    4709PHENOTYPEFindingOfLossOfSenseOfSmellCase findingDichotomousCovers all concepts relating to anosmia so use with time filter for acute anosmia
    4715PHENOTYPEFindingOfSedentaryLifestyleCase findingDichotomous
    4716PHENOTYPEFindingOfParentingProblemsCase findingDichotomous
    4717PHENOTYPEFindingOfPoorDietCase findingDichotomous
    4718PHENOTYPEFindingOfUnemploymentCase findingDichotomous
    4719PHENOTYPEFindingOfUnsatisfactoryLivingConditionsCase findingDichotomous
    4720PHENOTYPEFindingOfSchoolNonAttendanceCase findingDichotomous
    4721PHENOTYPEFindingOfLiteracyProblemsCase findingDichotomous
    4722PHENOTYPEFindingOfBereavementCase findingDichotomous
    4723PHENOTYPEFindingOfFinancialProblemCase findingDichotomous
    4724PHENOTYPEFindingOfLowerClassEconomicStatusCase findingDichotomous
    4725ETHNICITYEthnicityAsianPakistaniCase findingDichotomous
    4726ETHNICITYEthnicityAsianBangladeshiCase findingDichotomous
    4727ETHNICITYEthnicityAsianChineseCase findingDichotomous
    4728ETHNICITYEthnicityAsianOtherCase findingDichotomous
    4729ETHNICITYEthnicityArabCase findingDichotomous
    4730ETHNICITYEthnicityMixedMultipleEthnicGroupsCase findingDichotomous
    4731ETHNICITYEthnicityOtherCase findingDichotomous
    4732PHENOTYPERespiratorySystemDiseasesCase findingDichotomousFor weekly reports. Based on ICD J00 - J99. Replacement for 1022
    4733PHENOTYPEDiphtheriaCase findingDichotomous
    4734PHENOTYPEInfectionCausedByHumanPoliovirusCase findingDichotomous
    4735PHENOTYPETetanusCase findingDichotomous
    4737PHENOTYPEHereditaryHaemochromatosisCase findingDichotomous
    4773PHENOTYPERheumaticDiseaseCharlsonCase findingDichotomousCharlson index variable based on ICD M0.5x, M06x,M31.5,M32x-M34x,M35.1,M35.3,M36.0
    4774PHENOTYPEPepticUlcerCase findingDichotomous
    4775PHENOTYPEDiabetesWithComplicationCharlsonCase findingDichotomousCharlson index variable based on ICD E10.2-E10.5,E10.7,E11.2-E11.5,E11.7,E12.2-E12.5,E12.7,E13.2-E13.5,E13.7,E14.2-E14.5,E14.7
    4776PHENOTYPEHemiplegiaCase findingDichotomous
    4777PHENOTYPEParaplegiaCase findingDichotomous
    4778PHENOTYPEMalignantNeoplasticDiseaseExceptSkinCase findingDichotomous
    4779PHENOTYPEMildLiverDiseaseCharlsonCase findingDichotomousCharlson index variable based on ICD B18x,K70.0-K70.3,K70.9,K71.3-K71.5,K71.7,K73.x,K74.x,K76.0,K76.2-K76.4,K76.8,K76.9,Z94.4
    4780PHENOTYPEModerateSevereLiverDiseaseCharlsonCase findingDichotomousCharlson index variable based on ICD I85.0,I85.9,I86.4,I98.2,K70.4,K71.1,K72.1,K72.9,K76.5,K76.6,K76.7
    4781PHENOTYPESecondaryMalignantNeoplasticDiseaseCase findingDichotomous
    4782PHENOTYPEHumanImmunodeficiencyVirusInfectionCase findingDichotomous
    4783PHENOTYPECOVID-19ConfirmedV4Case findingDichotomousCOVID-19 Case finding V4 - ask data team for details of version sequence 1-4
    4784PHENOTYPECOVID-19ExposureV4Case findingDichotomousCOVID-19 Case finding V4 - ask data team for details of version sequence 1-4
    4785PHENOTYPECOVID-19InvestigationV4Case findingDichotomousCOVID-19 Case finding V4 - ask data team for details of version sequence 1-4
    4786PHENOTYPECOVID-19NotDetectedV4Case findingDichotomousCOVID-19 Case finding V4 - ask data team for details of version sequence 1-4
    4787PHENOTYPECOVID-19ProbableV4Case findingDichotomousCOVID-19 Case finding V4 - ask data team for details of version sequence 1-4
    4788PHENOTYPECOVID-19SuspectedV4Case findingDichotomousCOVID-19 Case finding V4 - ask data team for details of version sequence 1-4
    4793PHENOTYPEMeaslesMumpsAndRubellaVaccinationVaccination eventDichotomous
    4794PHENOTYPEMeaslesVaccinationVaccination eventDichotomous
    4795PHENOTYPEMumpsVaccinationVaccination eventDichotomous
    4796PHENOTYPERubellaVaccinationVaccination eventDichotomous
    4797PHENOTYPEMeaslesMumpsRubellaVaricellaVaccinationVaccination eventDichotomous
    4798PHENOTYPEDiphtheriaPertussisAndTetanusVaccinationVaccination eventDichotomous
    4816PHENOTYPEDiphtheriaPertussisTetanusAndPolioVaccinationVaccination eventDichotomous
    4818PHENOTYPEDiphtheriaPertussisTetanusPolioHIB-VaccinationVaccination eventDichotomous
    4819PHENOTYPEDiphtheriaPertussisTetanusPolioHIBHepB-VaccinationVaccination eventDichotomous
    4820PHENOTYPEDiphtheriaVaccinationVaccination eventDichotomous
    4821PHENOTYPEPertussisVaccinationVaccination eventDichotomous
    4822PHENOTYPETetanusVaccinationVaccination eventDichotomous
    4823PHENOTYPEPolioVaccinationVaccination eventDichotomous
    4824PHENOTYPEHaemophilusInfluenzaeTypeB-VaccinationVaccination eventDichotomous
    4825PHENOTYPEHepatitisB-VaccinationVaccination eventDichotomous
    4826PHENOTYPEHepatitisA-VaccinationVaccination eventDichotomous
    4827PHENOTYPEHepatitisA&B-VaccinationVaccination eventDichotomous
    4828PHENOTYPEHepatitisA&TyphoidVaccinationVaccination eventDichotomous
    4829PHENOTYPEHerpes ZosterVaccinationVaccination eventDichotomous
    4830PHENOTYPEMeningitisC&HIB-VaccinationVaccination eventDichotomous
    4831PHENOTYPEHumanPapillomavirusVaccinationVaccination eventDichotomous
    4832PHENOTYPEMeaslesAndRubellaVaccinationVaccination eventDichotomous
    4833PHENOTYPEMeningococcusVaccinationVaccination eventDichotomous
    4834PHENOTYPEMeningitisA&C-VaccinationVaccination eventDichotomous
    4835PHENOTYPEMeningitisACWY-VaccinationVaccination eventDichotomous
    4836PHENOTYPEMeningitisB-VaccinationVaccination eventDichotomous
    4837PHENOTYPEPneumococcalVaccinationVaccination eventDichotomous
    4838PHENOTYPERotavirusVaccinationVaccination eventDichotomous
    4839PHENOTYPEVaricellaVaccinationVaccination eventDichotomous
    4840PHENOTYPEDiphtheriaTetanusPolioVaccinationVaccination eventDichotomous
    4841PHENOTYPEMeningitisC-VaccinationVaccination eventDichotomous
    4842PHENOTYPETetanusAndPolioVaccinationVaccination eventDichotomous
    4846FindingOfDyspnoeaCase FindingDichotomous
    4847FindingOfLossOfTasteCase FindingDichotomous
    4848BloodOxygenSaturationInvestigationNumericTest result - observable entities for various types of oxygen saturation
    4849PHENOTYPEDeepVenousThrombosisCase findingDichotomousIncludes all deep venous thrombosis - i.e. all regions of body & limbs
    4850PHENOTYPEPulmonaryEmbolismCase findingDichotomousPulmonary embolism by blood clot - excludes other forms of embolism
    4851PHENOTYPESARS-CoV-2RNADetectionResultPositiveCase findingDichotomousAny concept indicating positive test result for SARS-CoV-2 - rna
    4852PHENOTYPESARS-CoV-2AntigenDetectionResultPositiveCase findingDichotomousAny concept indicating positive test result for SARS-CoV-2 - antigen
    4853PHENOTYPECOVID-19Case findingDichotomousAny concept indicating clinical diagnosis of COVID-19
    4854PHENOTYPEExposureToSARS-CoV-2InfectionCase findingDichotomousAny concept indicating exposure to SARS-CoV-2
    4855PHENOTYPESuspectedCOVID-19Case findingDichotomousAny concept indicating suspected SARS-CoV-2
    4856PHENOTYPECOVID-19ConfirmedByLaboratoryTestCase findingDichotomousAny concept indicating positive test result for SARS-CoV-2 - rna or antigen
    4857PHENOTYPECOVID-19ConfirmedClinicallyCase findingDichotomousAny concept indicating explicit clinical confirmation of diagnosis of COVID-19
    4858PHENOTYPEGastroenteritisCase FindingDichotomousFor syndromic surveillance
    4859PHENOTYPEDiarrhoeaOfPresumedInfectiousOriginCase FindingDichotomousFor syndromic surveillance
    4860PHENOTYPEHeatStrokeCase FindingDichotomousFor syndromic surveillance
    4861PHENOTYPECellulitisCase FindingDichotomousFor syndromic surveillance
    4862PHENOTYPEBiteOfArthropodCase FindingDichotomousFor syndromic surveillance
    4883PHENOTYPECOVID-19ExcludedByLaboratoryTestCase findingDichotomousExplicit statement that COVID-19 excluded by lab test but not emcompassing lab test results
    4884PHENOTYPECOVID-19ExcludedUsingClinicalDiagnosticCriteriaCase findingDichotomousExplicit statement that COVID-19 excluded using clinical diagnostic criteria
    4885PHENOTYPESARS-CoV-2DetectionResultNegativeCase findingDichotomousAny concept indicating negative test result for SARS-CoV-2 - rna or antigen
    4886PHENOTYPESARS-CoV-2RNADetectionResultNegativeCase findingDichotomousAny concept indicating negative test result for SARS-CoV-2 - rna
    4887PHENOTYPESARS-CoV-2AntigenDetectionResultNegativeCase findingDichotomousAny concept indicating negative test result for SARS-CoV-2 - antigen
    4888PHENOTYPESARS-CoV-2AntibodyDetectionResultNegativeCase findingDichotomousAny concept indicating negative test result for SARS-CoV-2 antibody, nonspecific or IGa,IgG, IgM
    4889PHENOTYPESARS-CoV-2AntibodyDetectionResultPositiveCase findingDichotomousAny concept indicating positive test result for SARS-CoV-2 antibody, nonspecific or IGa,IgG, IgM
    4890PHENOTYPESARS-CoV-2InvestigationDoneCase findingDichotomousAny procedural concept indicating test for SARS-CoV-2 excluding antibody tests & excluding results of tests
    4891PHENOTYPESARS-CoV-2VaccinationCase findingDichotomousAny concept indicating administration of SARS-CoV-2 vaccination whether first or any subsequent dose
    4892PHENOTYPEAdministrationOfFirstDoseOfSARS-CoV-2VaccineCase findingDichotomousAdministration of SARS-CoV-2 vaccination first dose
    4893PHENOTYPEAdministrationOfSecondDoseOfSARS-CoV-2VaccineCase findingDichotomousAdministration of SARS-CoV-2 vaccination second dose
    4894PHENOTYPEMeasurementOfSARS-CoV-2AntibodyCase findingDichotomousAny concept indicating test procedure for SARS-CoV-2 antibody. Note this does NOT imply any result to test
    4895PHENOTYPESARS-CoV-2DetectionResultPositiveCase findingDichotomousPositive test result for SARS-CoV-2 - rna or antigen
    4896PHENOTYPECOVID-19ExcludedCase findingDichotomousExplicit statement that COVID-19 is excluded (overarches 4883 and 4884)
    4897PHENOTYPECoronavirusInfectionCase findingDichotomousSole concept for non specific Coronavirus infection
    4898PHENOTYPESuspectedCoronavirusInfectionCase findingDichotomousSole concept for suspected non specific Coronavirus infection
    4899PHENOTYPEExposureToCoronavirusInfectionCase findingDichotomousSole concept for exposure to non specific Coronavirus infection
    4900PHENOTYPESocialPrescribingOfferedCase findingDichotomous
    4901PHENOTYPESocialPrescribingForMentalHealthTherapyCase findingDichotomousReceiving mental health therapy resulting from social prescribing
    4902PHENOTYPESocialPrescribingDeclinedCase findingDichotomous
    4903PHENOTYPEAcuteCOVID-19InfectionCase findingDichotomous
    4904PHENOTYPEOngoingSymptomaticCOVID-19InfectionCase findingDichotomous
    4905PHENOTYPEPostCOVID-19SyndromeCase findingDichotomous
    4906PHENOTYPEEntericCampylobacteriosisCase findingDichotomousAny entry strongly implying Campylobacter intestinal infection
    4907PHENOTYPESalmonellaGastroenteritisCase findingDichotomousAny entry strongly implying Salmonella intestinal infection
    4908PHENOTYPEClostridialEntericDiseaseCase findingDichotomousAny entry strongly implying Clostridium perfringens intestinal infection
    4909PHENOTYPEFindingOfTightChestCase findingDichotomousAny symptom indicating tight chest
    4910PHENOTYPEFindingOfChestPainCase findingDichotomousAny symptom indicating chest pain regardless of cause - cardiac, non cardiac etc
    4911PHENOTYPEFindingOfPalpitationsCase findingDichotomous
    4912PHENOTYPEFindingOfAmnesiaCase findingDichotomousany finding of memory loss or impairment
    4913PHENOTYPEFindingOfForgetfulnessCase findingDichotomous
    4914PHENOTYPEFindingOfInabilityToConcentrateCase findingDichotomous
    4915PHENOTYPEFindingOfParaesthesiaCase findingDichotomousParaesthesia but excluding numbness on its own
    4916PHENOTYPEFindingOfNumbnessCase findingDichotomous
    4917PHENOTYPEFindingOfDizzinessCase findingDichotomousDizziness but excluding vertigo
    4918PHENOTYPEFindingOfJointPainCase findingDichotomousAny finding of joint pain
    4919PHENOTYPEFindingOfDepressedMoodCase findingDichotomousFindings indicating depressed mood but excluding depression disorders
    4920PHENOTYPEFindingOfAnxietyCase findingDichotomousFindings indicating anxious or worried but excluding anxiety disorder
    4921PHENOTYPEFindingOfOtalgiaCase findingDichotomousFindings indicating earache but excluding any disorder such as otitis media
    4922PHENOTYPEFindingOfParosmiaCase findingDichotomousDisturbed sensation of smell distinct from absent sense of smell
    4923EXPOSURECOVID-19mRNAVaccineBNT162b2PfizerBioNTechDrug vaccinationDichotomousPfizer BioNTech vaccine administered

    Mental health theme

    General inclusions/exclusions and population covariates:

    • People will be included in cohorts who have a least one year’s historic data in their records.
    • Age will be represented as year or birth
    • Ethnicity will be listed in five categories (we can conduct multiple imputation for missing data)
    • IMD provided at LSOA level to individual records, derived from postcode. Where missing we substitute the practice cohort. Plus provided in quintiles (quintile 1 most deprived)
    • Household size (N.B. Relies on identical address & registered with same practice)
    • Urban, town and city, conurbation (ONS population density)
    • NHS Region – North, Midlands and East, South and London.
    • Registration will be full registration and not include temporary residents
    • We will include a practice indicator
    • We will exclude records where: no valid age or gender, no agreement to share data (approx. 0.2%)
    Mental Health Theme Template(Nexus 365 access required)
    RAGConditionIDCategoryConditionNameVariableTypeOutputTypeCommentAvailable
    2070PHENOTYPEDomesticViolenceCase findingDichotomous
    4179PHENOTYPEAcutePolymorphicPsychoticDisWoSympOfSchizophreniaCase findingDichotomous
    4369PHENOTYPEVascularDementiaCase findingDichotomousIncludes vascular dementia with behavioural disturbance. Includes vascular dementia without behavioural disturbance 
    4370PHENOTYPEDementiaDueToPicksDiseaseCase findingDichotomous
    4371PHENOTYPEDementiaDueToCreutzfeldtJakobDiseaseCase findingDichotomousInclude cerebral degeneration due to CJD (disorder) 
    4372PHENOTYPEDementiaDueToHuntingtonChoreaCase findingDichotomous
    4373PHENOTYPEDementiaDueToParkinsonsDiseaseCase findingDichotomousInclude cerebral degeneration due to Parkinson’s Disease (disorder) 
    4374PHENOTYPEDementiaAssociatedWithAIDSCase findingDichotomous
    4375PHENOTYPEOrganicHallucinosisCase findingDichotomousExclude alcohol hallucinosis (disorder) ; Exclude psychoactive substance-induced organic hallucinosis ; Exclude hallucinogen hallucinosis ; Exclude sedative, hypnotic and/or anxiolytic-induced psychotic disorder with hallucinations 
    4376PHENOTYPEOrganicCatatonicDisorderCase findingDichotomous
    4377PHENOTYPEOrganicDelusionalDisorderCase findingDichotomousExclude sedative, hypnotic and/or anxiolytic-induced psychotic disorder with delusions ; Exclude psychoactive substance-induced organic delusional disorder ;  Exclude other alcohol and drug induced psychotic disorder 
    4378PHENOTYPEOrganicMoodDisorderCase findingDichotomousExclude mood disorders due to alcohol and other psychoactive substances 
    4379PHENOTYPEOrganicAnxietyDisorderCase findingDichotomousExcluse anxiety disorders due to alcohol and other psychoactive substances 
    4380PHENOTYPEOrganicDissociativeDisorderCase findingDichotomous
    4381PHENOTYPEOrganicEmotionallyLabileDisorderCase findingDichotomousIncludes Obsessive-compulsive and related disorder due to a known physiological condition ;  Includes Epileptic psychosis NOS
    4382PHENOTYPEOrganicPersonalityDisorderCase findingDichotomousExclude psychoactive substance-induced organic personality disorder 
    4383PHENOTYPEPostencephaliticMyoclonusCase findingDichotomous
    4384PHENOTYPEPostconcussionSyndromeCase findingDichotomousInclude post-traumatic dementia ;  Include punch drunk syndrome ; Exclude postconcussion state (finding). Include Organic psychosyndrome
    4385PHENOTYPEAlcoholIntoxicationCase findingDichotomousInclude ketoacidosis due to acute alcohol intoxication (disorder) ; Include pathological alcohol intoxication (disorder) ; Include chronic pancreatitis due to acute alcohol intoxication (disorder) 
    4386PHENOTYPEOpioidIntoxicationCase findingDichotomous
    4387PHENOTYPECannabisIntoxicationCase findingDichotomousExclude intentional cannabis poisoning (disorder) 
    4388PHENOTYPEHypnoticIntoxicationCase findingDichotomous
    4389PHENOTYPECocaineIntoxicationCase findingDichotomousInclude cocaine delirium (disorder) 
    4390PHENOTYPEStimulantIntoxicationCase findingDichotomousInclude acute stimulant intoxication (disorder) 
    4391PHENOTYPEHallucinogenIntoxicationCase findingDichotomousInclude hallucinogen intoxication delirium (disorder) 
    4392PHENOTYPEHarmfulUseOfAlcoholCase findingDichotomous
    4393PHENOTYPEHarmfulUseOfOpioidCase findingDichotomous
    4394PHENOTYPEHarmfulUseOfCannabisCase findingDichotomous
    4395PHENOTYPEHarmfulUseOfSyntheticCannabinoidCase findingDichotomous
    4396PHENOTYPEHarmfulUseOfHypnoticCase findingDichotomousAdded concepts for sedatives and anxiolytics– all grouped in SNOMED CT  
    4397PHENOTYPEHarmfulUseOfCocaineCase findingDichotomous
    4398PHENOTYPEHarmfulUseOfHallucinogenCase findingDichotomous
    4399PHENOTYPEParanoidSchizophreniaCase findingDichotomousIncludes Paraphrenic schizophrenia 
    4400PHENOTYPEDisorganisedSchizophreniaCase findingDichotomous
    4401PHENOTYPECatatonicSchizophreniaCase findingDichotomous
    4402PHENOTYPEUndifferentiatedSchizophreniaCase findingDichotomousIncludes Atypical schizophrenia 
    4403PHENOTYPEPost-schizophrenicDepressionCase findingDichotomous
    4404PHENOTYPEResidualSchizophreniaCase findingDichotomousIncludes Restzustand 
    4405PHENOTYPESimpleSchizophreniaCase findingDichotomous
    4406PHENOTYPECoenesthopathicSchizophreniaCase findingDichotomous
    4407PHENOTYPESchizotypalPersonalityDisorderCase findingDichotomousInclude organic Pseudopsychopathic personality ; include schizophrenic prodrome 
    4408PHENOTYPEDelusionalDisorderCase findingDichotomous
    4409PHENOTYPEDelusionalDysmorphophobiaCase findingDichotomous
    4410PHENOTYPEInvolutionalParanoidStateCase findingDichotomous
    4411PHENOTYPEParanoiaQuerulansCase findingDichotomous
    4412PHENOTYPEAcuteSchizophrenia-likePsychoticDisorderCase findingDichotomousExclude psychotic disorder with schizophreniform symptoms caused by synthetic cathinone (disorder) 
    4413PHENOTYPESharedParanoidDisorderCase findingDichotomous
    4414PHENOTYPEInducedPsychoticDisorderCase findingDichotomous
    4415PHENOTYPESchizoaffectiveDisorderManicTypeCase findingDichotomousInclude schizoaffective schizophrenia ; Include cyclic schizophrenia 
    4416PHENOTYPESchizoaffectiveDisorderDepressiveTypeCase findingDichotomous
    4417PHENOTYPESchizoaffectiveDisorderMixedTypeCase findingDichotomous
    4418PHENOTYPEHypomaniaCase findingDichotomous
    4419PHENOTYPEManicDisorderSingleEpisodeCase findingDichotomousExcluding Single manic episode, severe, with psychosis and  Recurrent manic episodes, severe, with psychosis 
    4420PHENOTYPERecurrentManicEpisodesCase findingDichotomous
    4421PHENOTYPEManiaWithPsychoticFeaturesCase findingDichotomousInclude Single manic episode, severe, with psychosis 
    4422PHENOTYPEManiaWithMood-congruentPsychoticFeaturesCase findingDichotomous
    4423PHENOTYPEManiaWithMood-incongruentPsychoticFeaturesCase findingDichotomous
    4424PHENOTYPEBipolarIDisorderMostRecentEpisodeHypomanicCase findingDichotomous
    4425PHENOTYPEBipolarAffectiveDisorderCurrentEpisodeManicCase findingDichotomousExcluding Bipolar affective disorder, currently manic, severe, with psychosis 
    4426PHENOTYPEBipolarAffectiveDisorderCurrentEpisodeDepressionCase findingDichotomousExcluding Psychosis and severe depression co-occurrent and due to bipolar affective disorder 
    4427PHENOTYPEBipolarAffectiveDisorderCurrentEpisodeMixedCase findingDichotomous
    4428PHENOTYPEBipolarIIDisorderCase findingDichotomous
    4429PHENOTYPEMildMajorDepressionSingleEpisodeCase findingDichotomous
    4430PHENOTYPEModerateMajorDepressionSingleEpisodeCase findingDichotomous
    4431PHENOTYPEModeratelySevereMajorDepressionSingleEpisodeCase findingDichotomous
    4432PHENOTYPESingleMajorDepressiveEpisodeSevereWithPsychosisCase findingDichotomous
    4433PHENOTYPEMildRecurrentMajorDepressionCase findingDichotomous
    4434PHENOTYPEModerateRecurrentMajorDepressionCase findingDichotomous
    4435PHENOTYPECyclothymiaCase findingDichotomous
    4436PHENOTYPEDysthymiaCase findingDichotomous
    4437PHENOTYPEAgoraphobiaCase findingDichotomousInclude Panic disorder with agoraphobia 
    4438PHENOTYPESocialPhobiaCase findingDichotomous
    4439PHENOTYPEAcrophobiaCase findingDichotomous
    4440PHENOTYPEZoophobiaCase findingDichotomous
    4441PHENOTYPEClaustrophobiaCase findingDichotomous
    4442PHENOTYPESimplePhobiaCase findingDichotomous
    4443PHENOTYPEPanicDisorderCase findingDichotomousExcept Panic disorder with agoraphobia. Acute panic state due to acute stress reaction  
    4444PHENOTYPEGeneralisedAnxietyDisorderCase findingDichotomous
    4445PHENOTYPEObsessive-compulsiveDisorderCase findingDichotomousExclude OCD caused by drugs 
    4446PHENOTYPEAcuteStressDisorderCase findingDichotomousInclude psychogenic fugue co-occurrent and due to stress reaction (disorder),  Include stress reaction with psychomotor agitation (disorder)
    4447PHENOTYPEPosttraumaticStressDisorderCase findingDichotomous
    4448PHENOTYPEPsychogenicAmnesiaCase findingDichotomous
    4449PHENOTYPEPsychogenicFugueCase findingDichotomousExclude psychogenic fugue co-occurrent and due to stress reaction (disorder) 
    4450PHENOTYPEDissociativeStuporCase findingDichotomous
    4451PHENOTYPEDissociativeTranceCase findingDichotomous
    4452PHENOTYPEDissociativeMotorDisorderCase findingDichotomous
    4453PHENOTYPEDissociativeConvulsionsCase findingDichotomous
    4454PHENOTYPEDissociativeAnaesthesiaCase findingDichotomousInclude dissociative anaesthesia (finding). Exclude dissociative anaesthesia (procedure) 
    4455PHENOTYPEPsychologicConversionDisorderCase findingDichotomous
    4456PHENOTYPEGanserSyndromeCase findingDichotomous
    4457PHENOTYPEMultiplePersonalityDisorderCase findingDichotomous
    4458PHENOTYPEBriquetsSyndromeCase findingDichotomous
    4459PHENOTYPEUndifferentiatedSomatoformDisorderCase findingDichotomous
    4460PHENOTYPEBodyDysmorphicDisorderCase findingDichotomous
    4461PHENOTYPEIllnessAnxietyDisorderCase findingDichotomous
    4462PHENOTYPECutaneousHypochondriasisCase findingDichotomous
    4463PHENOTYPEPsychogenicDyspepsiaCase findingDichotomous
    4464PHENOTYPENeurocirculatoryAstheniaCase findingDichotomous
    4465PHENOTYPEPsychalgiaCase findingDichotomous
    4466PHENOTYPEDepersonalisation-derealisationSyndromeCase findingDichotomous
    4467PHENOTYPEDhatCase findingDichotomous
    4468PHENOTYPEPsychasthenicNeurosisCase findingDichotomous
    4469PHENOTYPEPsychogenicSyncopeCase findingDichotomous
    4470PHENOTYPEOccupationalNeurosisCase findingDichotomous
    4471PHENOTYPEAnorexiaNervosaCase findingDichotomous
    4472PHENOTYPEAtypicalAnorexiaNervosaCase findingDichotomous
    4473PHENOTYPEBulimiaNervosaCase findingDichotomousExcluding Atypical bulimia nervosa 
    4474PHENOTYPEAtypicalBulimiaNervosaCase findingDichotomous
    4475PHENOTYPEPicaCase findingDichotomousExcluding Pica of infancy and childhood 
    4476PHENOTYPENonorganicInsomniaCase findingDichotomous
    4477PHENOTYPEPrimaryHypersomniaCase findingDichotomousExclude autosomal dominant cerebellar ataxia, deafness and narcolepsy syndrome (disorder) 
    4478PHENOTYPENon-organicDisorderOfTheSleep-wakeScheduleCase findingDichotomous
    4479PHENOTYPESleepWalkingDisorderCase findingDichotomousIncluding finding related to sleep walking (finding) 
    4480PHENOTYPESleepTerrorDisorderCase findingDichotomousExclude somnambulism co-occurrent with sleep terror disorder 
    4481PHENOTYPELackOrLossOfSexualDesireCase findingDichotomous
    4482PHENOTYPEAnhedoniaCase findingDichotomous
    4483PHENOTYPEFemaleSexualArousalDisorderCase findingDichotomous
    4484PHENOTYPEPrimaryErectileDysfunctionCase findingDichotomous
    4485PHENOTYPEPsychogenicImpotenceCase findingDichotomous
    4486PHENOTYPEInhibitedFemaleOrgasmCase findingDichotomous
    4487PHENOTYPEInhibitedMaleOrgasmCase findingDichotomous
    4488PHENOTYPELifelongGeneralisedAnorgasmiaCase findingDichotomous
    4489PHENOTYPELifelongSituationalAnorgasmiaCase findingDichotomous
    4490PHENOTYPELifelongGeneralisedEarlyEjaculationCase findingDichotomous
    4491PHENOTYPELifelongSituationalEarlyEjaculationCase findingDichotomous
    4492PHENOTYPEPsychologicVaginismusCase findingDichotomous
    4493PHENOTYPEPsychologicDyspareuniaCase findingDichotomous
    4494PHENOTYPEExcessiveSexualDriveCase findingDichotomous
    4495PHENOTYPEPostpartumDepressionCase findingDichotomousExcluding Major depressive disorder, single episode with postpartum onset 
    4496PHENOTYPEPostpartumPsychosisCase findingDichotomousExclude H/O postpartum psychosis (situation) 
    4497PHENOTYPEParanoidPersonalityDisorderCase findingDichotomous
    4498PHENOTYPESchizoidPersonalityDisorderCase findingDichotomous
    4499PHENOTYPEAntisocialPersonalityDisorderCase findingDichotomous
    4500PHENOTYPEEmotionallyUnstablePersonalityDisorderCase findingDichotomous
    4501PHENOTYPEHistrionicPersonalityDisorderCase findingDichotomous
    4502PHENOTYPEObsessiveCompulsivePersonalityDisorderCase findingDichotomous
    4503PHENOTYPEAvoidantPersonalityDisorderCase findingDichotomous
    4504PHENOTYPEDependentPersonalityDisorderCase findingDichotomous
    4505PHENOTYPEEccentricPersonalityDisorderCase findingDichotomous
    4506PHENOTYPEImmaturePersonalityDisorderCase findingDichotomousExcluding immature personality (finding) 
    4507PHENOTYPENarcissisticPersonalityDisorderCase findingDichotomous
    4508PHENOTYPEPassiveAggressivePersonalityDisorderCase findingDichotomous
    4509PHENOTYPEPsychoneuroticPersonalityDisorderCase findingDichotomous
    4510PHENOTYPECompulsiveGamblingCase findingDichotomous
    4511PHENOTYPEPyromaniaCase findingDichotomous
    4512PHENOTYPEKleptomaniaCase findingDichotomous
    4513PHENOTYPETrichotillomaniaCase findingDichotomous
    4514PHENOTYPEMunchausensSyndromeCase findingDichotomous
    4515PHENOTYPEMildLearningDisabilityCase findingDichotomousIncludes mild intellectual disability 
    4517PHENOTYPEModerateLearningDisabilityCase findingDichotomousIncludes moderate intellectual disability 
    4519PHENOTYPESevereLearningDisabilityCase findingDichotomousIncludes severe intellectual disability 
    4521PHENOTYPEProfoundLearningDisabilityCase findingDichotomousIncludes profound intellectual disability 
    4523PHENOTYPEDevelopmentalArticulationDisorderCase findingDichotomous
    4524PHENOTYPEExpressiveLanguageDisorderCase findingDichotomous
    4526PHENOTYPEReceptiveLanguageDisorderCase findingDichotomous
    4528PHENOTYPEAcquiredEpilepticAphasiaCase findingDichotomous
    4529PHENOTYPELispingCase findingDichotomous
    4530PHENOTYPESpecificReadingDisorderCase findingDichotomous
    4532PHENOTYPESpecificSpellingDisorderCase findingDichotomous
    4533PHENOTYPEDyscalculiaCase findingDichotomous
    4534PHENOTYPEAphasia-angularGyrusSyndromeCase findingDichotomous
    4535PHENOTYPEMixedDisorderOfScholasticSkillsCase findingDichotomous
    4536PHENOTYPEDCD-DevelopmentalCoordinationDisorderCase findingDichotomous
    4537PHENOTYPEAutisticDisorderOfChildhoodOnsetCase findingDichotomous
    4538PHENOTYPEAtypicalAutismCase findingDichotomous
    4539PHENOTYPERettsDisorderCase findingDichotomousExcluding Dementia due to Retts syndrome
    4540PHENOTYPEAspergersDisorderCase findingDichotomous
    4541PHENOTYPEAttentionDeficitHyperactivityDisorderCase findingDichotomousExcluding Hyperkinesis with developmental delay. Exclude Hyperkinetic conduct disorder. Exclude Adult Attention Deficit Disorder
    4542PHENOTYPEHyperkineticConductDisorderCase findingDichotomous
    4543PHENOTYPESocialisedBehaviourDisorderCase findingDichotomous
    4544PHENOTYPEConductDisorder-UnsocialisedCase findingDichotomous
    4545PHENOTYPEOppositionalDefiantDisorderCase findingDichotomous
    4546PHENOTYPEDepressiveConductDisorderCase findingDichotomous
    4547PHENOTYPESeparationAnxietyDisorderOfChildhoodCase findingDichotomous
    4548PHENOTYPEChildhoodPhobicAnxietyDisorderCase findingDichotomous
    4549PHENOTYPESiblingJealousyCase findingDichotomous
    4550PHENOTYPEElectiveMutismCase findingDichotomous
    4551PHENOTYPEReactiveAttachmentDisorderCase findingDichotomous
    4552PHENOTYPEChildhoodDisinhibitedAttachmentDisorderCase findingDichotomous
    4553PHENOTYPETransientTicDisorderCase findingDichotomous
    4554PHENOTYPEChronicMotorTicDisorderCase findingDichotomous
    4555PHENOTYPEVocalTicDisorderCase findingDichotomous
    4556PHENOTYPEGillesDeLaTourettesSyndromeCase findingDichotomous
    4557PHENOTYPEUrinaryIncontinenceOfNon-organicOriginCase findingDichotomous
    4558PHENOTYPENon-organicContinuousEncopresisCase findingDichotomous
    4559PHENOTYPENon-organicDiscontinuousEncopresisCase findingDichotomous
    4560PHENOTYPEDevelopmentalDelayInFeedingCase findingDichotomous
    4561PHENOTYPENon-organicInfantFeedingDisturbanceCase findingDichotomous
    4562PHENOTYPEPicaOfInfancyAndChildhoodCase findingDichotomous
    4563PHENOTYPEStereotypyHabitDisorderCase findingDichotomous
    4564PHENOTYPEStammeringCase findingDichotomous
    4565PHENOTYPEClutteringCase findingDichotomous
    4566PHENOTYPEIntentionalPoisoningByDrugCase findingDichotomous
    4567PHENOTYPEIntentionalPoisoningCase findingDichotomousExcluding Intentional poisoning by drug 
    4568PHENOTYPEIntentionallyHarmingSelfCase findingDichotomous
    4574PHENOTYPEAcutePolymorphicPsychoticDisWiSympOfSchizophreniaCase findingDichotomous
    4575PHENOTYPEBPDMostRecentEpisodeManicSevereWithPsychosisCase findingDichotomous
    4576PHENOTYPEPsychosisAndSevereDepressionWithAndDueToBPDCase findingDichotomous
    4577PHENOTYPESevereMajorDepressiveDisWithAnxietySingleEpisodeCase findingDichotomous
    4578PHENOTYPESevereRecurrentMajorDepressionCase findingDichotomous
    4579PHENOTYPESevereRecurrentMajorDepressionWithPsychoticFeatureCase findingDichotomous
    4611PHENOTYPEDementiaWithLewyBodiesCase findingDichotomous
    4612PHENOTYPEDementiaWithParkinsonismCase findingDichotomous
    4613PHENOTYPEDementiaWithEpilepsyCase findingDichotomous
    4614PHENOTYPEFrontotemporalDementiaCase findingDichotomousExclude Picks Disease. Includes inclusion body myopathy with early-onset Paget Disease and frontotemporal dementia 
    4615PHENOTYPEDementiaWithHepatolenticularDegenerationCase findingDichotomousInclude wilson’s disease 
    4616PHENOTYPEDementiaDueToHypercalcaemiaCase findingDichotomousIncludes dementia due to metabolic abnormality 
    4617PHENOTYPEDementiaDueToHypothyroidism
    4618PHENOTYPEDementiaDueToIntoxicationCase findingDichotomousIncludes dementia assoc with alcoholism. Includes drug-induced dementia 
    4619PHENOTYPEDementiaDueToMultipleSclerosisCase findingDichotomous
    4620PHENOTYPEDementiaDueToNeurosyphilisCase findingDichotomous
    4621PHENOTYPEDementiaDueToNiacinDeficiency
    4622PHENOTYPEDementiaDueToPolyarteritisNodosa
    4623PHENOTYPEDementiaDueToPrionDiseaseCase findingDichotomous
    4624PHENOTYPEDementiaDueToSLE
    4625PHENOTYPEDementiaDueToTraumaticBrainInjuryCase findingDichotomousExclude post-traumatic dementia.  Exclude punch drunk syndrome 
    4626PHENOTYPEDementiaDueToTrypanosomiasis
    4627PHENOTYPEDementiaDueToVitaminBDeficiency
    4628PHENOTYPEAcuteSubacuteBrainSyndromeCase findingDichotomous
    4629PHENOTYPEAcuteSubacuteConfusionalStateCase findingDichotomous
    4630PHENOTYPEAcuteSubacuteInfectivePsychosisCase findingDichotomous
    4631PHENOTYPESchizophreniformDisorder
    4633PHENOTYPEDeliriumOfMixedEtiologyCase findingDichotomous
    4634PHENOTYPEDeliriumSuperimposedOnDementiaCase findingDichotomous
    4635PHENOTYPESundowningCase findingDichotomous
    4636PHENOTYPEVolatileSolventIntoxication
    4637PHENOTYPEHarmfulUseOfVolatileSolvents
    4638PHENOTYPEParanoidDisorderCase findingDichotomousExclude alcoholic paranoia. Include shared paranoid disorder 
    4639PHENOTYPEParaphreniaCase findingDichotomous
    4640PHENOTYPEAcuteParanoidReactionCase findingDichotomous
    4641PHENOTYPEPyschogenicParanoidPsychosis
    4642PHENOTYPEAtypicalDepression
    4643PHENOTYPEPremenstrualDysphoricDisorderCase findingDichotomous
    4644PHENOTYPEDisruptiveMoodDysregulationDisorderCase findingDichotomous
    4645PHENOTYPENaturalEnvironmentTypePhobiaCase findingDichotomous
    4646PHENOTYPEBloodInjuryInjectionTypePhobiaCase findingDichotomous
    4647PHENOTYPEAndrophobiaCase findingDichotomous
    4648PHENOTYPEGynephobiaCase findingDichotomous
    4649PHENOTYPEAdjustmentDisorderCase findingDichotomous
    4650PHENOTYPEPsychogenicDysmenorrheaCase findingDichotomous
    4651PHENOTYPEPsychogenicDysphagiaCase findingDichotomous
    4652PHENOTYPEPsychogenicPruritisCase findingDichotomous
    4653PHENOTYPEPsychogenicTorticollisCase findingDichotomous
    4654PHENOTYPESomatoformAutonomicDysfunctionCase findingDichotomous
    4655PHENOTYPETeethGrindingCase findingDichotomous
    4656PHENOTYPEPseudobulbarAffectCase findingDichotomous
    4657PHENOTYPENightmareDisorderCase findingDichotomousIncludes dream anxiety disorder. Excludes nightmares assoc with chronic PTSD 
    4658PHENOTYPESexualAversionDisorderCase findingDichotomous
    4659PHENOTYPEIntermittentExplosiveDisorderCase findingDichotomousIncluding paraphilias 
    4698PHENOTYPEVictimOfAbuseCase findingDichotomous
    4699PHENOTYPEDomesticAbuseCase findingDichotomous
    4700PHENOTYPEDomesticEmotionalAbuseCase findingDichotomous
    4701PHENOTYPEDomesticSexualAbuseCase findingDichotomous
    4702PHENOTYPEDomesticAbuseOfAdultCase findingDichotomous
    4789PHENOTYPEMentalDisorderCase findingDichotomousStrong evidence of any mental disorder based on disorders and findings and some procedural and situation concepts
    4790PHENOTYPEDepressiveDisorderCase findingDichotomousIncludes depression as disorder, including bipolar depression, and as finding but not depressed mood
    4791PHENOTYPEAnxietyDisorderCase findingDichotomousIncludes Anxiety as disorder and as finding but not anxious or worried
    4863PHENOTYPEReferralToBenefitsAgencyCase findingDichotomous
    4864PHENOTYPEReferralToPhysicalActivityProgrammeCase findingDichotomous
    4865PHENOTYPEReferralToArtsTherapyServicesCase findingDichotomous
    4866PHENOTYPESocialPrescribingForMentalHealthCase findingDichotomous
    4867PHENOTYPEHealthEducationOfferedCase findingDichotomous

    Inflammatory conditions theme

    General inclusions/exclusions and population covariates:

    • People will be included in cohorts who have a least one year’s historic data in their records.
    • Age will be represented as year or birth
    • Ethnicity will be listed in five categories (we can conduct multiple imputation for missing data)
    • IMD provided at LSOA level to individual records, derived from postcode. Where missing we substitute the practice cohort. Plus provided in quintiles (quintile 1 most deprived)
    • Household size (N.B. Relies on identical address & registered with same practice)
    • Urban, town and city, conurbation (ONS population density)
    • NHS Region – North, Midlands and East, South and London.
    • Registration will be full registration and not include temporary residents
    • We will include a practice indicator
    • We will exclude records where: no valid age or gender, no agreement to share data (approx. 0.2%)
    RAGConditionIDCategoryConditionNameVariableTypeOutputTypeCommentAvailable
    2032PHENOTYPEMultipleSclerosisCase findingDichotomous
    4792PHENOTYPEGoutCase findingDichotomousStrong evidence of gout based on disorder, finding and other semantic tags
    4799PHENOTYPEAutoimmuneHypothyroidismCase findingDichotomousHypothyroidism clearly defined as autoimmune in origin
    4800PHENOTYPEHashimotoThyroiditisCase findingDichotomous
    4801PHENOTYPEHypothyroidismCase findingDichotomousHypothyroidism of any cause e.g. autoimmune, post surgery, or unspecified
    4802PHENOTYPEHypothyroidismExcludingAutoimmuneCase findingDichotomous
    4803PHENOTYPEGravesDiseaseCase findingDichotomous
    4804PHENOTYPEAddisonsDiseasesCase findingDichotomous
    4805PHENOTYPESystemicLupusErythematosusCase findingDichotomous
    4806PHENOTYPEPerniciousAnaemiaCase findingDichotomous
    4807PHENOTYPEVitiligoCase findingDichotomous
    4808PHENOTYPESjogrensSyndromeCase findingDichotomous
    4809PHENOTYPEPolymyalgiaRheumaticaCase findingDichotomous
    4810PHENOTYPEDrugOverdoseCase findingDichotomousMedication overdose of any type
    4811PHENOTYPESuicideAttemptByInadequateMeansCase findingDichotomousSuicide attempted by any specified or unspecified means
    4814ImprovingAccessToPsychologicalTherapiesUseInterventionDichotomousUse of NHS Improving Access to Psychological Therapies (IAPT) Service
    4815PsychiatricReviewInterventionDichotomousReview by any psychiatric service