FULL-YEAR DISPENSING ANALYSIS AND EXPLORATORY PROTOTYPE Prepared: 4 November 2026 Coverage: 24 monthly dispenser files, 35,534,316 rows; January 2024 to December 2025. Reconciliation: 621,942 pharmacy/month/chapter combinations; 0 item mismatches; 0 cost differences above 2p. All detailed files were compared with the two supplied competition extracts. Counts use dispensing-location coverage throughout. National totals include all source areas; regional plots use the 14 territorial NHS boards. RESULTS 2024: 8,463,746 antidepressant items; 4,187,571 SSRI items; 21,405,358 supplied BNF chapter 04 items. 2025: 8,585,514 antidepressant items; 4,219,042 SSRI items; 21,658,856 supplied BNF chapter 04 items. Antidepressant item change: +1.439%. Year 2024 2025 change pct Medicine Agomelatine 1923 1831 -92 -4.784191 Amitriptyline 1542409 1547826 5417 0.351204 Citalopram 976819 939305 -37514 -3.840425 Clomipramine 27879 27298 -581 -2.084006 Dosulepin 26616 24528 -2088 -7.844905 Doxepin 2660 2397 -263 -9.887218 Duloxetine 393528 434660 41132 10.452115 Escitalopram 98798 103686 4888 4.947469 Fluoxetine 935160 932719 -2441 -0.261025 Flupentixol 4834 4781 -53 -1.096400 Fluvoxamine 1774 1902 128 7.215333 Imipramine 20391 19609 -782 -3.835025 Isocarboxazid 140 121 -19 -13.571429 Lofepramine 19013 17772 -1241 -6.527113 Mianserin 186 197 11 5.913978 Mirtazapine 1121718 1132070 10352 0.922870 Moclobemide 1940 1897 -43 -2.216495 Nortriptyline 154075 168240 14165 9.193575 Paroxetine 108584 105456 -3128 -2.880719 Phenelzine 1137 1088 -49 -4.309587 Reboxetine 3223 2961 -262 -8.129072 Sertraline 2066436 2135974 69538 3.365118 Tranylcypromine 346 330 -16 -4.624277 Trazodone 301656 305443 3787 1.255404 Trimipramine 1102 1013 -89 -8.076225 Tryptophan 327 323 -4 -1.223242 Venlafaxine 638496 657736 19240 3.013331 Vortioxetine 12576 14351 1775 14.114186 METHOD Antidepressants: BNF prefix 0403. SSRIs: 040303. Items summed across all original product/presentation codes, brands, strengths and formulations. Citalopram codes 0403030D0 and 0403030Z0 combined. No automatic source-row deduplication. Unknown BNF codes retained outside classified totals. Full source copies retained locally, compressed losslessly where newly downloaded. The full-year check replaces the two-month sampling limitation of the earlier feasibility report. It does not change the distinction between dispensing and prescribing geography. Earlier board-prescribing counts and regional shares should not be substituted for these dispensing-based figures. Costs used solely for reconciliation; charts use item counts. Payment-system and cost caveats are documented on the PHS dataset page. There are no claims about price changes, treatment effectiveness, patient switching, depression prevalence, unmet need, individual risk or causal effects. 2024 had 366 days; 2025 had 365. Monthly counts have not been adjusted for working days, holidays or payment timing. Antidepressants may be used for mental-health and other conditions. Clinical indication, age, sex, patient count and duration are unavailable. Differences in regional medicine mix do not establish unwarranted variation. The conflicting year labels in the supplied reference workbook remain unresolved. Its numbers were not used in this analysis. VALIDATION { "months": 24, "records": 35534316, "comparison_combinations": 621942, "merge_counts": { "both": 621942, "left_only": 0, "right_only": 0 }, "item_mismatches": 0, "cost_mismatches_above_2p": 0, "maximum_cost_difference": 2.9103830456733704e-11, "exact_duplicate_rows": 0, "antidepressant_duplicate_keys": 0, "negative_item_rows": 0 } REGIONAL SERTRALINE SHARE OF SSRI ITEMS (%) Year 2024 2025 HBT NHS Western Isles 39.688332 41.095559 NHS Lothian 42.179881 45.327790 NHS Borders 46.487200 48.453954 NHS Fife 48.453058 49.276321 NHS Tayside 48.432139 49.523797 NHS Forth Valley 48.966937 49.723117 NHS Lanarkshire 48.642620 49.911539 NHS Shetland 48.595548 50.079459 NHS Ayrshire and Arran 50.135723 51.068063 NHS Grampian 50.977509 51.548593 NHS Orkney 50.930264 51.614385 NHS Greater Glasgow and Clyde 52.058301 53.124698 NHS Dumfries and Galloway 53.161757 54.075867 NHS Highland 55.443549 56.447710 SOURCES https://thedatalab.com/data-visualisation-competition/ https://www.opendata.nhs.scot/dataset/prescriptions-in-the-community https://www.nhs.uk/medicines/antidepressants/ https://datasync.ed.ac.uk/index.php/s/UN71nmYg1O5BVSi DETAILED DOWNLOAD REGISTER Data by Dispenser Location - January 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/985bd23a-022a-411e-969b-bf6d5f26c296/download/disp_pitc202401.csv SHA-256 9b1bc6a17aec8be7bb055ea9ea1760b360e4e0aa58a4ca2aadaa1409ae5d8230 Data by Dispenser Location - February 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/f422ba81-7aee-4c75-bd4a-c54e0955255f/download/disp_pitc202402.csv SHA-256 b87b9e3bc32c10cb52c574b800c1554a02e7fc317a63bf11616b081573fc44f9 Data by Dispenser Location - March 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/8cbab729-a865-4b16-9f7b-d33f1eea1894/download/disp_pitc202403.csv SHA-256 afd195fd44796bab80ad5b7ac1310d447be1bb3a2024beaac0362477074ffc57 Data by Dispenser Location - April 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/49d2ecff-dae8-4c4e-a25d-c758a77f7f26/download/disp_pitc202404.csv SHA-256 002c9d6d59542880e5a9730035ffd26c525be4643b8806a78f345fb118f29288 Data by Dispenser Location - May 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/e3fac249-4e5f-4f21-9e8b-43f554f635e3/download/disp_pitc202405.csv SHA-256 75a50745306b9c74e20052608e594fedbf1b8df1b533b9ce6c96d4d9d96bef7c Data by Dispenser Location - June 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/93cd6483-d482-4b97-8e8b-47b4c4a0acbf/download/disp_pitc202406.csv SHA-256 4bd32022147ccc133008815f26052f6532d3d2fd42a4649326614ea9a5da347b Data by Dispenser Location - July 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/739a359f-545c-4642-90d0-0f90289b8a2a/download/disp_pitc202407.csv SHA-256 b41004f66f52578a56ac796973cacc89380ba642cc471ee95cb9fd09170e55e5 Data by Dispenser Location - August 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/a1675b63-bc91-45eb-8974-97274e6020b6/download/disp_pitc202408.csv SHA-256 64fbfb43213fd7f6744dc2a5622601e4c966d213fbe4703418179e340d393957 Data by Dispenser Location - September 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/40e36f3e-2d54-4645-aa51-ecee3dd27b2c/download/disp_pitc202409.csv SHA-256 3ec97cffa90a6c7318729c6b9a1d0457272791426bb2b79a6c86e78639b960c9 Data by Dispenser Location - October 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/a9110478-0e23-4982-b78b-e371f491e004/download/disp_pitc202410.csv SHA-256 dbe5052e6e3f83287b39d230d2b86121983e11320b5da7e248f73a4fc7c6b1ce Data by Dispenser Location - November 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/a817d8ec-0caa-4d89-ace7-9d71867822c3/download/disp_pitc202411.csv SHA-256 e6b0cc37afaf1ce502e8d9e623e71cb8928e8cb2e94351eb6df102be2256d6ef Data by Dispenser Location - December 2024 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/a150b663-5197-4384-a6ab-86bac827d040/download/disp_pitc202412.csv SHA-256 94506abbd2d7fa59ac440cef1686052156edaa5dde56c14815e2f4656af05aff Data by Dispenser Location - January 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/9fc9059f-8060-4f2b-aac8-0aa7d3bc6f25/download/disp_pitc202501.csv SHA-256 c230a5d75ee11daf9fb37f84db699cca889e5cdc6ec84733ac0410fae868caa0 Data by Dispenser Location - February 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/090cd45c-910a-4c21-ace0-cf823de41291/download/disp_pitc202502.csv SHA-256 fbfe857f3a13318728bd7c5769ade4ed7f32f92282e43b110b96b0f8a67c7862 Data by Dispenser Location - March 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/50f65219-8bc7-48ea-a5ca-cf13fe0ff7fa/download/disp_pitc202503.csv SHA-256 52a6032251806e40118bab37caa1625f46d5da5bd220d829fc4b853b01e4da5b Data by Dispenser Location - April 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/2f965699-3671-48cf-95ca-c6d427b5dc8d/download/disp_pitc202504.csv SHA-256 92c106d4a54ee0629eee51d0948bbfa04a2dca23010e7861d391fc5f83166856 Data by Dispenser Location - May 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/458db513-1549-42e5-a9ea-5cbd7a3f050d/download/disp_pitc202505.csv SHA-256 b4a54250f680e62e4f991a6484ae1358f7d9e6e0601c22b90ac99ad8fcb6e30f Data by Dispenser Location - June 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/98c5565b-98f2-4de9-a8e1-1cb4e85b9bc3/download/disp_pitc202506.csv SHA-256 514f1bf3b3bebdb95cc84066386cf6a42abf1b0b20f4ddb4b9d81269b24004f5 Data by Dispenser Location - July 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/b59823b3-bcc8-453e-b4bb-979c557da929/download/disp_pitc202507.csv SHA-256 232f47c900ea7d55d58d6995a4514a4f94b1b93b630044cd066616cc2d253ff4 Data by Dispenser Location - August 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/999f93b2-9740-421e-b391-12e9f395b252/download/disp_pitc202508.csv SHA-256 dc7e88bcdcdf0df93ac60726959025f711561cc8ffed00ec9b6fe7ffdb9d1c4c Data by Dispenser Location – September 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/8078b938-4196-4c90-a433-f0460f277a9c/download/disp_pitc202509.csv SHA-256 4e8ed64f1b2568979d98d67f951a721fe5f95c600133906073249bcf96c2f205 Data by Dispenser Location – October 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/a3cc8023-c1d1-41f5-a03c-3c789d39d843/download/disp_pitc202510.csv SHA-256 c5e58ac7b2e2b99affe1a2990472b5d701840cd7c19d05e8a61daa2dbe65df39 Data by Dispenser Location – November 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/458dcba3-e8e2-4698-bdf5-a5a26a79860b/download/disp_pitc202511.csv SHA-256 b74e9bd6d0350cfb7f0a56d689626a79ef211f904c8823cda404c385d0e5a174 Data by Dispenser Location – December 2025 https://www.opendata.nhs.scot/dataset/84393984-14e9-4b0d-a797-b288db64d088/resource/3630d659-1fff-4261-b4d1-004d51999851/download/disp_pitc202512.csv SHA-256 a3dfafc8174e099caf8bfa3d300fb2e1c240eb06c0d835de20fa1f3de8aca269 BROWSER VERIFICATION { "checked_on": "2026-11-04", "browser": "Codex in-app browser via localhost preview", "passed": [ "All four view tabs render", "SSRI and all-antidepressant group filters update charts and exact-value tables", "Monthly medicine and dispensing-area filters update the displayed totals", "Zero-baseline example: reboxetine in Western Isles displays no items in either year", "Alternative regional medicine selection updates the chart", "Regional share table matches the computed dispensing analysis", "Reconciliation table displays 24 months, 35534316 records, 621942 matched combinations and zero differences", "Arrow-key tab navigation works", "Responsive layout checked at 320, 390 and 1280 CSS pixels", "No document-level horizontal overflow in checked phone layouts", "No browser errors or warnings observed" ], "fixes": [ "Stack paired charts below 900 pixels", "Show meaningful wording for zero-baseline percentage changes", "Shorten the clipped context-chart axis title", "Wrap the context legend outside the chart", "Use fewer monthly ticks on phone layouts", "Remove the default chart toolbar", "Add explicit associations between labels and selectors" ], "evidence": "prototype_browser_preview.png", "monthly_chart_correction": { "issue": "Numeric monthly counts inherited a categorical axis through shared mutable Plotly layout objects. Earlier visual QA did not detect this.", "fixes": [ "Clone each plot layout before passing it to Plotly", "Explicit numeric y-axis and ordered categorical month x-axis", "Add monthly year-on-year percentage bars with a zero reference", "Add Scotland comparison markers when a local area is selected", "Show selected medicine, area, totals and changes explicitly" ], "verified": [ "Citalopram and sertraline produce different monthly paths and percentage bars", "Monthly count ticks form a regular numeric scale", "Numeric scale survives switching to a categorical chart and back", "Reboxetine in Western Isles handles a zero baseline without NaN or infinite percentages", "No console errors or warnings observed" ] }, "fixed_percentage_scale": { "default_range": [ -30, 30 ], "behaviour": "Range and ticks remain identical across medicine and area changes; wider manual ranges persist until changed. Out-of-range bars are capped with boundary triangles, exact-value hover and explicit warning.", "verified": [ "Tayside and Western Isles sertraline: identical ticks at -30 to +30 in steps of 10", "Western Isles June +20.4% renders taller than Tayside December +10.7%", "Tranylcypromine Greater Glasgow and Clyde: March +700% explicitly flagged at 30% range; warning clears and full value fits at 1000% range", "No browser warnings or errors" ], "evidence": [ "monthly_tayside_fixed_scale.png", "monthly_western_isles_fixed_scale.png" ] } }