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
dim_prescriber
nhs_raw · prescribing NHSBSA
6.9mrows
448.1MBsize
16columns
2026-09-24updated
varieslicence — see publisher
Query this dataset
SELECT * FROM nhs_raw.dim_prescriber LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| year_month | UInt32 |
| provider_sicbl_code | String |
| provider_sicbl_name | String |
| practice_code | String |
| practice_name | String |
| prescriber_code | String |
| prescriber_title | String |
| prescriber_name | String |
| prescriber_type | String |
| date_joined | String |
| address_field1 | String |
| address_field2 | String |
| address_field3 | String |
| address_field4 | String |
| postcode | String |
| practice_type | String |
Sample rows
| 202207 | RW400 | MERSEY CARE NHS FO | Y05494 | St Helens 0-19 Chi | 00A0059E | MS | Mehlo Kn | NPF Nurse | 19/11/2018 | Hollins Park Hospi | Hollins Lane | Warrington | WA2 8WA | OTHER | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 202207 | RW400 | MERSEY CARE NHS FOUNDATION TRUST | Y05494 | St Helens 0-19 Childrens Service | 00A0059E | MS | Mehlo Kn | NPF Nurse | 19/11/2018 | Hollins Park Hospital | Hollins Lane | Warrington | WA2 8WA | OTHER | |
| 202207 | 02T00 | 02T - WEST YORKSHIRE ICB | Y03418 | Calderdale Community Services | 00A0066E | MRS | Robinson K | NPF Nurse | 20/10/2020 | Calderdale Royal Hospital | Salterhebble | Halifax | West Yorkshire | HX3 0PW | OTHER |
| 202207 | 15F00 | 15F - WEST YORKSHIRE ICB | Y03889 | Lch Neighbourhood Teams | 00A0073E | MRS | Gash M | NIP | 01/04/2020 | Stockdale House | Victoria Road | Leeds | West Yorkshire | LS6 1PF | OTHER |
Cited by papers
- none yet