Datasets 29 tables · 1.70bn rows
prescribing
1.70bnepd_prescribing3.8mfct_activity_prescribing_secondary1.7mfct_activity_prescribing_paper1.7mfct_activity_dispensing_doctor_padm823kfct_activity_prescribed_dispensed_scot428kfct_context_prescribing_glp1_foi197kfct_context_glp1_first_dispensing_foi131kfct_activity_dispensing117kfct_activity_prescribing_bnf_chapter_demog_foi83kepd_roll_month_chem83kfct_prescribing_roll_month_chem50kfct_activity_scottish_dispensing46kfct_context_nhsbsa_prescription_dispensing21kdim_chemical_bnf13kfct_context_prescribing_diabetes_pfd10kfct_activity_prescribing_dispenser_linkage_foi10kfct_context_ed_prescribing6kfct_activity_prescribing_nondispensed5kfct_prescribing_trust2kepd_roll_month_icb2kfct_prescribing_roll_month_icb971dim_dispensing_practice_raw465fct_prescribing_strength_pair465fct_context_prescribing_strength_pair_foi463fct_context_cannabis_prescribing_foi448mart_prescribing_per_capita139fct_prescribing_trust_weights48epd_roll_month48fct_prescribing_roll_month
fct_prescribing_trust
nhs_marts · prescribing NHSBSA
5krows
117.5KBsize
14columns
2026-09-16updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_marts.fct_prescribing_trust LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| month_date | Date |
| month | String |
| canonical_ods_code | Nullable(String) |
| trust_name | Nullable(String) |
| trust_type | Nullable(String) |
| w.region | Nullable(String) |
| icb_code | String |
| w.icb_name | Nullable(String) |
| allocated_items | Float64 |
| allocated_nic | Float64 |
| allocated_cost | Float64 |
| allocation_weight | Float64 |
| trusts_in_icb | UInt64 |
| attribution_method | String |
Sample rows
| 2022-05-01 | 202205 | RXN | LANCASHIRE TEACHIN | acute | North West Commiss | QE1 | NHS Lancashire And | 1814410.3 | 14349529.57 | 13480872.67 | 0.268869 | 4 | activity_weighted_ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022-05-01 | 202205 | RXN | LANCASHIRE TEACHING HOSPITALS NHS FO | acute | North West Commissioning Region | QE1 | NHS Lancashire And South Cumbria Int | 1814410.3 | 14349529.57 | 13480872.67 | 0.268869 | 4 | activity_weighted_icb_allocation |
| 2022-05-01 | 202205 | RXL | BLACKPOOL TEACHING HOSPITALS NHS FOU | acute | North West Commissioning Region | QE1 | NHS Lancashire And South Cumbria Int | 1706403.6 | 13495343.25 | 12678395 | 0.252864 | 4 | activity_weighted_icb_allocation |
| 2022-05-01 | 202205 | RTX | UNIVERSITY HOSPITALS OF MORECAMBE BA | acute | North West Commissioning Region | QE1 | NHS Lancashire And South Cumbria Int | 1619080.6 | 12804735.88 | 12029593.94 | 0.239924 | 4 | activity_weighted_icb_allocation |