Datasets 39 datasets
prescribing
1.08bnfct_prescribing847.5mepd_prescribing38.4mfct_pca12.0mfct_hospital_dispensed6.9mdim_prescriber6.6mdim_prescriber_raw3.8mfct_activity_prescribing_secondary1.7mfct_activity_prescribing_paper1.7mfct_activity_dispensing_doctor_padm823kfct_activity_prescribed_dispensed_scot702kstg_item_prescribing_dispensers428kfct_context_prescribing_glp1_foi211kfct_context_scottish_dispensed197kfct_context_glp1_first_dispensing_foi187kdim_gp_prescriber_settings_raw119kfct_activity_dispensing117kfct_activity_prescribing_bnf_chapter_demog_foi116kfct_prescribing_foi_antidepressants83kepd_roll_month_chem52kfct_dispensing_pharmacy_mis46kfct_context_nhsbsa_prescription_dispensing36kfct_prescribing_hrt_nhsbsa21kdim_chemical_bnf16kfct_activity_scottish_dispensing13kfct_context_prescribing_diabetes_pfd10kfct_activity_prescribing_dispenser_linkage_foi10kfct_context_ed_prescribing6kfct_activity_prescribing_nondispensed5kfct_prescribing_trust2kepd_roll_month_icb2krq02b_epd2kfct_rq02b_epd971dim_dispensing_practice_raw465fct_prescribing_strength_pair465fct_context_prescribing_strength_pair_foi365fct_context_cannabis_prescribing_foi357mart_prescribing_per_capita139fct_prescribing_trust_weights48epd_roll_month
mart_prescribing_per_capita
nhs_marts · prescribing NHSBSA
357rows
17.4KBsize
10columns
2026-08-17updated
varieslicence — see publisher
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 | 2022-05-01 | 18190332 | 500743731.8 | 136624963.90000868 | 128539592.98192513 | 8433640 | 2156.877931711574 | 15.241294741289067 |
|---|---|---|---|---|---|---|---|---|---|
| 1 | North East and Yorkshire | 2022-05-01 | 18190332 | 500743731.8 | 136624963.90000868 | 128539592.98192513 | 8433640 | 2156.877931711574 | 15.241294741289067 |
| 1 | North East and Yorkshire | 2022-06-01 | 17681431 | 498290455.4 | 134156152.66000444 | 126204816.29921255 | 8433640 | 2096.536133863907 | 14.964453818186755 |
| 1 | North East and Yorkshire | 2022-07-01 | 17433274 | 500851824.4 | 134839484.16001347 | 126778698.63830379 | 8433640 | 2067.1114726262917 | 15.032500632977431 |
Cited by papers
- none yet