[ { "phenotype_id": "PH3664", "phenotype_version_id": 8771, "name": "Pharmacy First - Urinary Tract Infection treatment full dmd codelist", "definition": "This codelist was taken from [OpenCodelists](https://www.opencodelists.org/), created by [OpenSAFELY](https://www.opensafely.org/). We recommend viewing this Phenotype on the OpenCodelist website to view the most recent version.\n\n\nThis codelist is used to identify supply of any medication included in the Pharmacy First Patient Group Directions for treatment of urinary tract infection.\n\n\nIt is specific to only the strength/formulations included in the PGDs for urinary tract infection (including both brands and generics).\n\n\n© University of Oxford for the Bennett Institute for Applied Data Science 2025\\. This work may be copied freely for non\\-commercial research and study.\n\n", "implementation": null, "publications": null, "validation": null, "citation_requirements": null, "created": "2026-01-26T23:28:48.370926Z", "author": "OpenSAFELY", "collections": [ { "name": "OpenCodelist", "value": 31 }, { "name": "Phenotype Library", "value": 18 } ], "tags": null, "organisation": { "id": 1, "slug": "opensafely", "name": "OpenSAFELY" }, "world_access": 1, "updated": "2026-01-26T23:28:49.809470Z", "references": [ { "url": "https://github.com/opensafely/codelist-development/issues/298", "title": "GitHub issue" } ], "signed_off": [], "methodology": "PGDs:\n\n\nhttps://www.england.nhs.uk/wp\\-content/uploads/2023/11/PRN01010\\-1a.\\-Urinary\\-tract\\-infection\\-nitrofurantoin\\-patient\\-group\\-direction\\-Pharmacy\\-First.pdf\n\n\nUpdated PGD September 2025:\n\n\nhttps://www.england.nhs.uk/wp\\-content/uploads/2023/11/PRN01010\\-1a.\\-urinary\\-tract\\-infection\\-nitrofurantoin\\-patient\\-group\\-direction\\-pharmacy\\-first.pdf\n\n\nThe following SQL code was used to build the codelist natively in dmd to ensure products without a corresponding BNF code were also included.\n\n\n\n```\nSELECT DISTINCT\ndmd_type, dmd_id, dmd_name, bnf_code\nFROM\n`chris.union_amp_vmp`\nWHERE\n(vtm = 'Nitrofurantoin' AND \n (\n (formroute IN ('capsule.oral', 'tablet.oral') AND strength_num=50) \n OR (formroute IN ('capsulemodified-release.oral') AND strength_num=100)\n )\n)\n\n```\n\nUpdated 20/10/25 following same methodology\n\n", "coding_system": [ { "name": "dm+d codes", "value": 23 } ], "open_codelist_id": "opensafely/pharmacy-first-urinary-tract-infection-treatment-full-dmd-codelist", "source_reference": "https://www.opencodelists.org/codelist/opensafely/pharmacy-first-urinary-tract-infection-treatment-full-dmd-codelist/22b7d338", "concept_information": [ { "concept_id": 8948, "concept_version_id": 16433, "concept_name": "opensafely/pharmacy-first-urinary-tract-infection-treatment-full-dmd-codelist/22b7d338", "coding_system": { "id": 23, "name": "dm+d codes", "description": "dm+d codes" }, "phenotype_id": "PH3664", "phenotype_version_id": 8771, "phenotype_name": "Pharmacy First - Urinary Tract Infection treatment full dmd codelist", "code_attribute_header": [ "dmd_id", "dmd_type", "bnf_code" ], "codes": [ { "code": "11016111000001104", "description": "Nitrofurantoin 50mg tablets (Dr Reddy's Laboratories (UK) Ltd)", "attributes": { "dmd_id": "11016111000001104", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "17946711000001100", "description": "Nitrofurantoin 50mg tablets (Phoenix Healthcare Distribution Ltd)", "attributes": { "dmd_id": "17946711000001100", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "180911000001108", "description": "Nitrofurantoin 50mg tablets (A A H Pharmaceuticals Ltd)", "attributes": { "dmd_id": "180911000001108", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "20327411000001106", "description": "Nitrofurantoin 50mg tablets (Genesis Pharmaceuticals Ltd)", "attributes": { "dmd_id": "20327411000001106", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "21820711000001109", "description": "Nitrofurantoin 50mg tablets (Waymade Healthcare Plc)", "attributes": { "dmd_id": "21820711000001109", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "24209111000001106", "description": "Nitrofurantoin 50mg capsules (Advanz Pharma)", "attributes": { "dmd_id": "24209111000001106", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "24421611000001107", "description": "Nitrofurantoin 50mg capsules (Alliance Healthcare (Distribution) Ltd)", "attributes": { "dmd_id": "24421611000001107", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "24549911000001107", "description": "Nitrofurantoin 50mg capsules (A A H Pharmaceuticals Ltd)", "attributes": { "dmd_id": "24549911000001107", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "29929911000001104", "description": "Nitrofurantoin 50mg tablets (Sigma Pharmaceuticals Plc)", "attributes": { "dmd_id": "29929911000001104", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "30210411000001105", "description": "Macrodantin 50mg capsules (Waymade Healthcare Plc)", "attributes": { "dmd_id": "30210411000001105", "dmd_type": "AMP", "bnf_code": "None" } }, { "code": "30272211000001100", "description": "Macrobid 100mg modified-release capsules (Waymade Healthcare Plc)", "attributes": { "dmd_id": "30272211000001100", "dmd_type": "AMP", "bnf_code": "None" } }, { "code": "30763811000001109", "description": "Nitrofurantoin 50mg tablets (Almus Pharmaceuticals Ltd)", "attributes": { "dmd_id": "30763811000001109", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "30851211000001100", "description": "Nitrofurantoin 50mg tablets (Mawdsley-Brooks & Company Ltd)", "attributes": { "dmd_id": "30851211000001100", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "324558006", "description": "VMP previous to 41953211000001102", "attributes": { "dmd_id": "324558006", "dmd_type": "VMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "324568001", "description": "VMP previous to 39108511000001108", "attributes": { "dmd_id": "324568001", "dmd_type": "VMP", "bnf_code": "0501130R0AAAGAG" } }, { "code": "324570005", "description": "VMP previous to 41953111000001108", "attributes": { "dmd_id": "324570005", "dmd_type": "VMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "32746911000001108", "description": "Genfura 50mg tablets (Genesis Pharmaceuticals Ltd)", "attributes": { "dmd_id": "32746911000001108", "dmd_type": "AMP", "bnf_code": "0501130R0BHABAD" } }, { "code": "35952811000001109", "description": "Nitrofurantoin 50mg capsules (Morningside Healthcare Ltd)", "attributes": { "dmd_id": "35952811000001109", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "36774211000001109", "description": "Nitrofurantoin 50mg capsules (Tillomed Laboratories Ltd)", "attributes": { "dmd_id": "36774211000001109", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "37388111000001102", "description": "Macrobid 100mg modified-release capsules (CST Pharma Ltd)", "attributes": { "dmd_id": "37388111000001102", "dmd_type": "AMP", "bnf_code": "None" } }, { "code": "37460411000001104", "description": "Nitrofurantoin 50mg capsules (DE Pharmaceuticals)", "attributes": { "dmd_id": "37460411000001104", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "37460811000001102", "description": "Nitrofurantoin 50mg tablets (DE Pharmaceuticals)", "attributes": { "dmd_id": "37460811000001102", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "37541311000001100", "description": "Macrobid 100mg modified-release capsules (Mawdsley-Brooks & Company Ltd)", "attributes": { "dmd_id": "37541311000001100", "dmd_type": "AMP", "bnf_code": "None" } }, { "code": "37556911000001106", "description": "Nitrofurantoin 50mg capsules (Accord-UK Ltd)", "attributes": { "dmd_id": "37556911000001106", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "39058411000001105", "description": "Nitrofurantoin 50mg tablets (Medihealth (Northern) Ltd)", "attributes": { "dmd_id": "39058411000001105", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "39108511000001108", "description": "Nitrofurantoin 100mg modified-release capsules", "attributes": { "dmd_id": "39108511000001108", "dmd_type": "VMP", "bnf_code": "0501130R0AAAGAG" } }, { "code": "39237911000001109", "description": "Nitrofurantoin 50mg capsules (Medihealth (Northern) Ltd)", "attributes": { "dmd_id": "39237911000001109", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "39498111000001101", "description": "Nitrofurantoin 50mg capsules (Zentiva Pharma UK Ltd)", "attributes": { "dmd_id": "39498111000001101", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "40291611000001103", "description": "Nitrofurantoin 50mg capsules (Viatris UK Healthcare Ltd)", "attributes": { "dmd_id": "40291611000001103", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "40466111000001101", "description": "Nitrofurantoin 50mg tablets (NorthStar Healthcare Unlimited Company)", "attributes": { "dmd_id": "40466111000001101", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "40622211000001101", "description": "Nitrofurantoin 50mg capsules (Bristol Laboratories Ltd)", "attributes": { "dmd_id": "40622211000001101", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "40633711000001103", "description": "Nitrofurantoin 50mg capsules (Genesis Pharmaceuticals Ltd)", "attributes": { "dmd_id": "40633711000001103", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "41334211000001109", "description": "Nitrofurantoin 100mg modified-release capsules (Advanz Pharma)", "attributes": { "dmd_id": "41334211000001109", "dmd_type": "AMP", "bnf_code": "0501130R0AAAGAG" } }, { "code": "41479711000001108", "description": "Nitrofurantoin 50mg capsules (Medreich Plc)", "attributes": { "dmd_id": "41479711000001108", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "41507511000001107", "description": "Nitrofurantoin 50mg capsules (Glenmark Pharmaceuticals Europe Ltd)", "attributes": { "dmd_id": "41507511000001107", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "41511011000001106", "description": "Nitrofurantoin 50mg tablets (Glenmark Pharmaceuticals Europe Ltd)", "attributes": { "dmd_id": "41511011000001106", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "41953111000001108", "description": "Nitrofurantoin 50mg capsules", "attributes": { "dmd_id": "41953111000001108", "dmd_type": "VMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "41953211000001102", "description": "Nitrofurantoin 50mg tablets", "attributes": { "dmd_id": "41953211000001102", "dmd_type": "VMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "41961011000001102", "description": "Nitrofurantoin 50mg capsules (Milpharm Ltd)", "attributes": { "dmd_id": "41961011000001102", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "4209111000001108", "description": "Nitrofurantoin 50mg tablets (Teva UK Ltd)", "attributes": { "dmd_id": "4209111000001108", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "42326211000001102", "description": "Nitrofurantoin 50mg capsules (Key Pharmaceuticals Ltd)", "attributes": { "dmd_id": "42326211000001102", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "42566811000001105", "description": "Nitrofurantoin 50mg tablets (AAH Hillcross)", "attributes": { "dmd_id": "42566811000001105", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "42856711000001105", "description": "Macrobid 100mg modified-release capsules (Necessity Supplies Ltd)", "attributes": { "dmd_id": "42856711000001105", "dmd_type": "AMP", "bnf_code": "None" } }, { "code": "42864611000001101", "description": "Nitrofurantoin 50mg capsules (Necessity Supplies Ltd)", "attributes": { "dmd_id": "42864611000001101", "dmd_type": "AMP", "bnf_code": "None" } }, { "code": "42959011000001106", "description": "Nitrofurantoin 50mg capsules (Manx Healthcare Ltd)", "attributes": { "dmd_id": "42959011000001106", "dmd_type": "AMP", "bnf_code": "0501130R0AAAAAA" } }, { "code": "44125511000001105", "description": "Nitrofurantoin 100mg modified-release capsules (CNX Therapeutics Ltd)", "attributes": { "dmd_id": "44125511000001105", "dmd_type": "AMP", "bnf_code": "0501130R0AAAGAG" } }, { "code": "44225811000001106", "description": "Nitrofurantoin 100mg modified-release capsules (A A H Pharmaceuticals Ltd)", "attributes": { "dmd_id": "44225811000001106", "dmd_type": "AMP", "bnf_code": "0501130R0AAAGAG" } }, { "code": "44889611000001107", "description": "Nitrofurantoin 100mg modified-release capsules (Alliance Healthcare (Distribution) Ltd)", "attributes": { "dmd_id": "44889611000001107", "dmd_type": "AMP", "bnf_code": "0501130R0AAAGAG" } }, { "code": "44961111000001105", "description": "Nitrofurantoin 100mg modified-release capsules (RPH Pharmaceuticals AB)", "attributes": { "dmd_id": "44961111000001105", "dmd_type": "AMP", "bnf_code": "0501130R0AAAGAG" } }, { "code": "461311000001101", "description": "Urantoin 50mg tablets (Dr Reddy's Laboratories (UK) Ltd)", "attributes": { "dmd_id": "461311000001101", "dmd_type": "AMP", "bnf_code": "0501130R0BDAAAD" } }, { "code": "497811000001101", "description": "Nitrofurantoin 50mg tablets (Alliance Healthcare (Distribution) Ltd)", "attributes": { "dmd_id": "497811000001101", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "517311000001102", "description": "Macrobid 100mg modified-release capsules (Advanz Pharma)", "attributes": { "dmd_id": "517311000001102", "dmd_type": "AMP", "bnf_code": "0501130R0BGAAAG" } }, { "code": "537011000001109", "description": "Nitrofurantoin 50mg tablets (Kent Pharma (UK) Ltd)", "attributes": { "dmd_id": "537011000001109", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "58211000001101", "description": "Furadantin 50mg tablets (Advanz Pharma)", "attributes": { "dmd_id": "58211000001101", "dmd_type": "AMP", "bnf_code": "0501130R0BBAAAD" } }, { "code": "623211000001101", "description": "Macrodantin 50mg capsules (Advanz Pharma)", "attributes": { "dmd_id": "623211000001101", "dmd_type": "AMP", "bnf_code": "0501130R0BCAAAA" } }, { "code": "884111000001105", "description": "Nitrofurantoin 50mg tablets (Actavis UK Ltd)", "attributes": { "dmd_id": "884111000001105", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } }, { "code": "9555111000001106", "description": "Nitrofurantoin 50mg tablets (Viatris UK Healthcare Ltd)", "attributes": { "dmd_id": "9555111000001106", "dmd_type": "AMP", "bnf_code": "0501130R0AAADAD" } } ] } ], "coding_system_release": "", "open_codelist_version_id": "22b7d338", "open_codelist_version_tag": "", "status": 1, "doi": "https://doi.org/10.48533/1m5s-5h89", "is_deleted": false, "publish_status": 2, "owner": "ieuan.scanlon", "template": { "id": 3, "name": "OpenCodelists Phenotype", "description": "OpenSafely's OpenCodelist Phenotype, visit https://www.opencodelists.org/ to learn more", "version_id": 1 }, "versions": [ { "version_id": 8771, "version_name": "Pharmacy First - Urinary Tract Infection treatment full dmd codelist", "version_date": "2026-01-26T23:28:49.821431Z", "is_published": true, "is_latest": true }, { "version_id": 8770, "version_name": "Pharmacy First - Urinary Tract Infection treatment full dmd codelist", "version_date": "2026-01-26T23:28:48.377241Z", "is_published": true, "is_latest": false } ] } ]