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
mart_prescribing_per_capita
nhs_marts · prescribing NHSBSA
448rows
14.0KBsize
10columns
2026-08-17updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_marts.mart_prescribing_per_capita LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| region_id | UInt32 |
| region_name | String |
| month_date | Date |
| items | UInt64 |
| quantity | Float64 |
| nic | Float64 |
| actual_cost | Float64 |
| region_population | UInt64 |
| items_per_1k_pop | Nullable(Float64) |
| cost_per_head | Nullable(Float64) |
Sample rows
| 1 | North East and Yor | 1970-01-01 | 58334612 | 1568353618.2000003 | 468903590.7100115 | 441012820.8025272 | 8433640 | 6916.9 | 52.29 |
|---|---|---|---|---|---|---|---|---|---|
| 1 | North East and Yorkshire | 1970-01-01 | 58334612 | 1568353618.2000003 | 468903590.7100115 | 441012820.8025272 | 8433640 | 6916.9 | 52.29 |
| 1 | North East and Yorkshire | 1970-01-01 | 58334612 | 1568353618.2000003 | 468903590.7100115 | 441012820.8025272 | 8433640 | 6916.9 | 52.29 |
| 1 | North East and Yorkshire | 2022-01-01 | 18404910 | 515564130.1 | 148112766.22000444 | 139202526.59115005 | 8433640 | 2182.32 | 16.51 |
Cited by papers
- none yet