Datasets 39 datasets

all prescribing activity demand workforce outcome context other

prescribing

1.08bnfct_prescribing 847.5mepd_prescribing 38.4mfct_pca 12.0mfct_hospital_dispensed 6.9mdim_prescriber 6.6mdim_prescriber_raw 3.8mfct_activity_prescribing_secondary 1.7mfct_activity_prescribing_paper 1.7mfct_activity_dispensing_doctor_padm 823kfct_activity_prescribed_dispensed_scot 702kstg_item_prescribing_dispensers 428kfct_context_prescribing_glp1_foi 211kfct_context_scottish_dispensed 197kfct_context_glp1_first_dispensing_foi 187kdim_gp_prescriber_settings_raw 119kfct_activity_dispensing 117kfct_activity_prescribing_bnf_chapter_demog_foi 116kfct_prescribing_foi_antidepressants 83kepd_roll_month_chem 52kfct_dispensing_pharmacy_mis 46kfct_context_nhsbsa_prescription_dispensing 36kfct_prescribing_hrt_nhsbsa 21kdim_chemical_bnf 16kfct_activity_scottish_dispensing 13kfct_context_prescribing_diabetes_pfd 10kfct_activity_prescribing_dispenser_linkage_foi 10kfct_context_ed_prescribing 6kfct_activity_prescribing_nondispensed 5kfct_prescribing_trust 2kepd_roll_month_icb 2krq02b_epd 2kfct_rq02b_epd 971dim_dispensing_practice_raw 465fct_prescribing_strength_pair 465fct_context_prescribing_strength_pair_foi 365fct_context_cannabis_prescribing_foi 357mart_prescribing_per_capita 139fct_prescribing_trust_weights 48epd_roll_month

fct_pca

nhs_raw · prescribing NHSBSA

38.4mrows

1.7GBsize

27columns

2026-09-24updated

varieslicence — see publisher

Query this dataset

SELECT * FROM nhs_raw.fct_pca LIMIT 100

In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot

Schema

Column	Type
year_month	UInt32
region_name	String
region_code	String
icb_name	String
icb_code	String
dispenser_account_type	String
bnf_presentation_code	String
bnf_presentation_name	String
snomed_code	UInt64
supplier_name	String
unit_of_measure	String
generic_bnf_equivalent_code	String
generic_bnf_equivalent_name	String
bnf_chemical_substance_code	String
bnf_chemical_substance	String
bnf_paragraph_code	String
bnf_paragraph	String
bnf_section_code	String
bnf_section	String
bnf_chapter_code	String
bnf_chapter	String
prep_class	String
prescribed_prep_class	String
items	UInt32
total_quantity	Float64
nic	Float64
pharmacy_advanced_service	String

Sample rows

202101	LONDON	Y56			English Pharmacy	0101010C0BBAAAA	Alu-Cap 475mg caps	429311000001109	Meda Pharmaceutica	capsule	0101010C0AAAAAA	Aluminium hydroxid	0101010C0	Aluminium hydroxid	010101	Antacids and simet	0101	Dyspepsia and gast	01	Gastro-Intestinal	03	02	3	84	9.6
202101	LONDON	Y56			English Pharmacy	0101010C0BBAAAA	Alu-Cap 475mg capsules	429311000001109	Meda Pharmaceuticals Ltd	capsule	0101010C0AAAAAA	Aluminium hydroxide 475mg capsules	0101010C0	Aluminium hydroxide	010101	Antacids and simeticone	0101	Dyspepsia and gastro-oesophageal ref	01	Gastro-Intestinal System	03	02	3	84	9.6
202101	LONDON	Y56			English Pharmacy	0101010F0AAAUAU	Magnesium carbonate heavy 500mg caps	8752711000001104	Special Order	capsule	0101010F0AAAUAU	Magnesium carbonate heavy 500mg caps	0101010F0	Magnesium carbonate	010101	Antacids and simeticone	0101	Dyspepsia and gastro-oesophageal ref	01	Gastro-Intestinal System	05	05	2	120	218.6
202101	SOUTH EAST	Y59			English Pharmacy	0101010F0AAAUAU	Magnesium carbonate heavy 500mg caps	8752711000001104	Special Order	capsule	0101010F0AAAUAU	Magnesium carbonate heavy 500mg caps	0101010F0	Magnesium carbonate	010101	Antacids and simeticone	0101	Dyspepsia and gastro-oesophageal ref	01	Gastro-Intestinal System	05	05	1	200	1700

Cited by papers

none yet

Copilotdeep · LLM + SQL