Datasets 69 tables · 8.7m rows

all prescribing activity demand workforce outcome context other

context

1.4mdim_gp_practice_populations_scot_long_raw 1.1mfct_context_fingertips_profiles 761kfct_context_phof 659kfct_context_pharmacy_quality 581kfct_context_population_projections_scot 542kfct_context_childhood_vaccination 443kfct_context_cqc_directory 314kdim_cqc_long_raw 297kfct_context_alcohol 253kfct_context_la_health_profile 233kfct_context_health_protection 233kfct_context_flu_covid_surveillance 222kdim_population_long_raw 194kfct_context_respiratory 163kfct_context_help_health_costs 144kfct_context_public_health 116kfct_context_smoking 93kfct_context_personal_wellbeing_ons_api 91kfct_context_adhd_stimulant 83kfct_context_liver_disease 80kfct_context_palliative_care 79kfct_context_census_rm_multivariate 74kfct_context_private_adhd_cns_foi 71kfct_context_nimdm17_ni 58kdim_bnf_raw 48kfct_context_gp_profile 43kdim_national_life_tables_long_raw 39kfct_context_sti_surveillance 37kfct_context_litigation 37kdim_population_estimates 25kfct_context_contraception_patients_foi 21kfct_context_dementia_profile 16kfct_context_cancer_services 14kfct_context_pcn_debt_recovery 12kfct_context_better_care_fund 12kfct_context_census_caring_identity_rm191 11kfct_context_census_dwelling_stock 10kdim_national_cost_collection_long_raw 10kfct_context_adult_obesity 9kfct_context_population_fingertips 9kdim_practice 8kfct_context_amr_local_indicators 7kfct_context_qof_disease_registers_wales 4kdim_pharmacy_fp57_refunds_long_raw 3kfct_context_hepatitis_b_surveillance 2kfct_context_census_general_health 2kfct_context_antidepressant_sicbl_age_foi 1kdim_trust_raw 1kdim_pcn_raw 1kfct_context_pharmacy_openings_closures 1kdim_trust 779fct_context_hypnotics_sicbl_foi 673fct_context_hypnotics_age_cuts_2023 655fct_context_legionellosis_surveillance 567fct_context_hypnotics_age_cuts_2023_foi 299fct_context_vdps 298fct_context_ssbbv_sentinel_blood_borne_virus 252dim_date 125fct_context_charge_compliance 115fct_context_baby_loss_certificate 94fct_context_gp_pension_employment_foi 93dim_legacy_org_mapping 90fct_context_liothyronine 62dim_region_alias 42dim_icb_raw 42dim_icb 18dim_region 7dim_population_by_region 4fct_context_nhs_pension_payment_bands_foi

dim_bnf_raw

nhs_raw · context NHS England

58krows

1.8MBsize

19columns

2026-08-18updated

OGL 3.0licence

Query this dataset

SELECT * FROM nhs_raw.dim_bnf_raw LIMIT 100

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

Schema

Column	Type
month	Nullable(String)
BNF_CHAPTER	Nullable(String)
BNF_CHAPTER_CODE	Nullable(String)
BNF_SECTION	Nullable(String)
BNF_SECTION_CODE	Nullable(String)
BNF_PARAGRAPH	Nullable(String)
BNF_PARAGRAPH_CODE	Nullable(String)
BNF_SUBPARAGRAPH	Nullable(String)
BNF_SUBPARAGRAPH_CODE	Nullable(String)
BNF_CHEMICAL_SUBSTANCE	Nullable(String)
BNF_CHEMICAL_SUBSTANCE_CODE	Nullable(String)
BNF_PRODUCT	Nullable(String)
BNF_PRODUCT_CODE	Nullable(String)
BNF_PRESENTATION	Nullable(String)
BNF_PRESENTATION_CODE	Nullable(String)
pillar	Nullable(String)
series	Nullable(String)
source_pub	Nullable(String)
source_url	Nullable(String)

Sample rows

2026-07	Gastro-Intestinal	01	Dyspepsia and gast	0101	Antacids and simet	010101	Antacids and simet	0101010	Other antacid and	010101000	Proprietary compou	010101000BB	Indigestion mixtur	010101000BBAJA0	reference	bnf	NHSBSA BNF Code In	https://opendata.n
2026-07	Gastro-Intestinal System	01	Dyspepsia and gastro-oesophageal ref	0101	Antacids and simeticone	010101	Antacids and simeticone	0101010	Other antacid and simeticone prepara	010101000	Proprietary compound preparation BNF	010101000BB	Indigestion mixture	010101000BBAJA0	reference	bnf	NHSBSA BNF Code Information (current	https://opendata.nhsbsa.net/dataset/
2026-07	Gastro-Intestinal System	01	Dyspepsia and gastro-oesophageal ref	0101	Antacids and simeticone	010101	Antacids and simeticone	0101010	Alexitol sodium	0101010A0	Alexitol sodium	0101010A0AA	Alexitol sodium 360mg tablets	0101010A0AAAAAA	reference	bnf	NHSBSA BNF Code Information (current	https://opendata.nhsbsa.net/dataset/
2026-07	Gastro-Intestinal System	01	Dyspepsia and gastro-oesophageal ref	0101	Antacids and simeticone	010101	Antacids and simeticone	0101010	Alexitol sodium	0101010A0	Actal	0101010A0BB	Actal 360mg tablets	0101010A0BBAAAA	reference	bnf	NHSBSA BNF Code Information (current	https://opendata.nhsbsa.net/dataset/

Cited by papers

none yet