Pharmacy First - Urinary Tract Infection treatment full dmd codelist

PH3664 / 8770

OpenSAFELY

Jan 26, 2026

REGISTERING DOI...

OpenCodelists Phenotype

  1. Overview

    Codelist ID
    opensafely/pharmacy-first-urinary-tract-infection-treatment-full-dmd-codelist
    Version ID
    6892f37e
    Coding System
    dm+d codes
    Collections
    OpenCodelistPhenotype Library
    Tags
    No data

  2. Definition

    This codelist was taken from OpenCodelists, created by OpenSAFELY. We recommend viewing this Phenotype on the OpenCodelist website to view the most recent version.

    This codelist is used to identify supply of any medication included in the Pharmacy First Patient Group Directions for treatment of urinary tract infection.

    It is specific to only the strength/formulations included in the PGDs for urinary tract infection (including both brands and generics).

    © University of Oxford for the Bennett Institute for Applied Data Science 2025. This work may be copied freely for non-commercial research and study.

  3. Methodology

    PGDs:

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-1a.-Urinary-tract-infection-nitrofurantoin-patient-group-direction-Pharmacy-First.pdf

    Updated PGD September 2025:

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-1a.-urinary-tract-infection-nitrofurantoin-patient-group-direction-pharmacy-first.pdf

    The following SQL code was used to build the codelist natively in dmd to ensure products without a corresponding BNF code were also included.

    SELECT DISTINCT
dmd_type, dmd_id, dmd_name, bnf_code
FROM
`chris.union_amp_vmp`
WHERE
(vtm = 'Nitrofurantoin' AND 
  (
    (formroute IN ('capsule.oral', 'tablet.oral') AND strength_num=50) 
    OR (formroute IN ('capsulemodified-release.oral') AND strength_num=100)
  )
)

    Updated 20/10/25 following same methodology

  4. References

    Source Reference

    https://www.opencodelists.org/codelist/opensafely/pharmacy-first-urinary-tract-infection-treatment-full-dmd-codelist/6892f37e

    References

  5. Clinical Codelist

  6. API

    To Export Phenotype Details:

    FormatAPI
    JSON site_root/api/v1/phenotypes/PH3664/version/8770/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(
     'PH3664',
     version_id=8770
    )

    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(
     'PH3664',
     version_id=8770
    )

    To Export Phenotype Code List:

    FormatAPI
    JSON site_root/api/v1/phenotypes/PH3664/version/8770/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(
     'PH3664',
     version_id=8770
    )

    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(
     'PH3664',
     version_id=8770
    )

  7. Version History

    Version IDNameOwnerPublish date
    8771 Pharmacy First - Urinary Tract Infection treatment full dmd codelist ieuan.scanlon2026-01-26 23:28
    Pharmacy First - Urinary Tract Infection treatment full dmd codelist ieuan.scanlon2026-01-26 23:28