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_icb_raw

nhs_raw · context NHS England

42rows

1.9KBsize

6columns

2026-08-18updated

OGL 3.0licence

Query this dataset

SELECT * FROM nhs_raw.dim_icb_raw LIMIT 100

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

Schema

Column	Type
icb_code	Nullable(String)
icb_name	Nullable(String)
region	Nullable(String)
status	Nullable(String)
n_trusts	Nullable(Int64)
n_orgs	Nullable(Int64)

Sample rows

QE1	NHS Lancashire And	North West Commiss	active	6	6
QE1	NHS Lancashire And South Cumbria Int	North West Commissioning Region	active	6	6
QF7	NHS South Yorkshire Integrated Care	North East and Yorkshire Commissioni	active	5	5
QGH	NHS Herefordshire And Worcestershire	Midlands Commissioning Region	active	2	2

Cited by papers

none yet