Substance Misuse - Offending

PH1907 / 4434

Hywel T Evans, Gareth Davies, Ian W Farr, Grace Bailey, Josh Dixon, Sam Fallick, Delyth James, Ryan Phillips, Matthew Skermer, Columbus Ohaeri, Joanne Maimaris, Josie Smith

Jul 15, 2025

Clinical-Coded Phenotype

  1. Overview

    Phenotype Type
    Other
    Sex
    Both
    Valid Event Date Range
    No data
    Coding System
    Non-standard codes
    Data Sources
    No data
    Collections
    Phenotype Library
    Tags
    No data
    Ontology
    No data

  2. Definition

    Home Office Offence Codes that were used to identify any drug and alcohol related offences in Data First Ministry of Justice data, as part of the Better Outcomes Through Linked Data (BOLD) project. BOLD is a government data-linking programme which aims to improve the connectedness of government data in England and Wales. In BOLD Wales, SAIL Databank collaborated with Public Health Wales and the Welsh Government to investigate Substance Misuse. Note: this phenotype contains drug or alcohol related offence codes which are not limited to only codes indicating personal substance use. Drug adulteration has been excluded, as the corresponding codes were not specific to only drugs: '101 Adulteration of Food Drug etc.'

  3. Implementation

    Implementation

    OFFENCE_HO_CODE_DESC codes appear in the Data First Magistrates' Court defendant case level dataset (MACO) as values for variables: CJS_OFFENCE_CODE_DESC (Criminal Justice System Offence Code Description), CJS_OFFENCE_CODE_DESC_MSO(Most Serious Offence), OFFENCE_HO_CODE_DESC(Home Office Offence Code Description), OFFENCE_HO_CODE_DESC_MSO. And in the Data First Crown Court defendant case level dataset (CRCO) as values for variables: OFFENCE_HO_CODE_DESC_MSO, OFFENCE_HO_CODE_DESC_MSD. These variables correspond to the 'Description' on the Phenotype Library. The 'Code' field in the list relates to the FINAL_OFFENCE_HO_CODE variable in the datasets, which is instead coded using integers.

  4. Clinical Codelist

  5. Publication

    Related publications

    No known publications

    Citation Example

    Hywel T Evans, Gareth Davies, Ian W Farr, Grace Bailey, Josh Dixon, Sam Fallick, Delyth James, Ryan Phillips, Matthew Skermer, Columbus Ohaeri, Joanne Maimaris, Josie Smith. PH1907 / 4434 - Substance Misuse - Offending. Phenotype Library [Online]. 15 July 2025. Available from: http://phenotypes.healthdatagateway.org/phenotypes/PH1907/version/4434/detail/. [Accessed 21 February 2026]

  6. API

    To Export Phenotype Details:

    FormatAPI
    JSON site_root/api/v1/phenotypes/PH1907/version/4434/detail/?format=json
    R Package

    # Download here

    library(ConceptLibraryClient)


    # Connect to API

    client = ConceptLibraryClient::Connection$new(public=TRUE)


    # Get details of Phenotype

    phenotype_details = client$phenotypes$get_detail(
     'PH1907',
     version_id=4434
    )

    Py Package

    # Download here

    from pyconceptlibraryclient import Client


    # Connect to API

    client = Client(public=True)


    # Get details of Phenotype

    phenotype_detail = client.phenotypes.get_detail(
     'PH1907',
     version_id=4434
    )

    To Export Phenotype Code List:

    FormatAPI
    JSON site_root/api/v1/phenotypes/PH1907/version/4434/export/codes/?format=json
    R Package

    # Download here

    library(ConceptLibraryClient)


    # Connect to API

    client = ConceptLibraryClient::Connection$new(public=TRUE)


    # Get codelist of Phenotype

    phenotype_codelist = client$phenotypes$get_codelist(
     'PH1907',
     version_id=4434
    )

    Py Package

    # Download here

    from pyconceptlibraryclient import Client


    # Connect to API

    client = Client(public=True)


    # Get codelist of Phenotype

    phenotype_codelist = client.phenotypes.get_codelist(
     'PH1907',
     version_id=4434
    )

  7. Version History

    Version IDNameOwnerPublish date
    Substance Misuse - Offending evanhy2025-07-15 16:16
    4432 Substance Misuse - Offending evanhy2025-07-15 16:12
    3994 Substance Misuse - Offending evanhy2025-06-25 18:37