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_gp_prescriber_settings_raw
nhs_raw · prescribing NHSBSA
187krows
9.1MBsize
20columns
2026-09-29updated
varieslicence — see publisher
Query this dataset
SELECT * FROM nhs_raw.dim_gp_prescriber_settings_raw LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| pillar | Nullable(String) |
| series | Nullable(String) |
| practitioner_code | Nullable(String) |
| training_number | Nullable(String) |
| rel_type | Nullable(String) |
| setting | Nullable(String) |
| linked_org_code | Nullable(String) |
| canonical_ods_code | Nullable(String) |
| building | Nullable(String) |
| address_line_1 | Nullable(String) |
| address_town | Nullable(String) |
| address_county | Nullable(String) |
| postcode | Nullable(String) |
| status | Nullable(String) |
| window_start | Nullable(String) |
| window_end | Nullable(String) |
| window_end_current | Nullable(String) |
| source | Nullable(String) |
| source_pub | Nullable(String) |
| source_url | Nullable(String) |
Sample rows
| reference | reference_gp_presc | G0102926 | Y61 | O | QUE | D81001 | D81001 | LENSFIELD MEDICAL | 48 LENSFIELD ROAD | CAMBRIDGE | CAMBRIDGESHIRE | CB2 1EH | A | 19740401 | 19911231 | historical | egpcur | NHS ODS GP Prescri | https://web.archiv |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| reference | reference_gp_prescriber_settings | G0102926 | Y61 | O | QUE | D81001 | D81001 | LENSFIELD MEDICAL PRAC. | 48 LENSFIELD ROAD | CAMBRIDGE | CAMBRIDGESHIRE | CB2 1EH | A | 19740401 | 19911231 | historical | egpcur | NHS ODS GP Prescribing-Setting Regis | https://web.archive.org/web/20241227 |
| reference | reference_gp_prescriber_settings | G0105912 | Y56 | O | QMJ | E83600 | E83600 | 682 FINCHLEY ROAD | GOLDERS GREEN | LONDON | NW11 7NP | A | 19740401 | 19920731 | historical | egpcur | NHS ODS GP Prescribing-Setting Regis | https://web.archive.org/web/20241227 | |
| reference | reference_gp_prescriber_settings | G0107031 | Y62 | O | QOP | P82013 | P82013 | GREAT LEVER HEALTH CENTRE | RUPERT STREET,GREAT LEVER | BOLTON | LANCASHIRE | BL3 6RN | A | 19740401 | 19910525 | historical | egpcur | NHS ODS GP Prescribing-Setting Regis | https://web.archive.org/web/20241227 |
Cited by papers
- none yet