Datasets 69 tables · 8.7m rows
context
1.4mdim_gp_practice_populations_scot_long_raw1.1mfct_context_fingertips_profiles761kfct_context_phof659kfct_context_pharmacy_quality581kfct_context_population_projections_scot542kfct_context_childhood_vaccination443kfct_context_cqc_directory314kdim_cqc_long_raw297kfct_context_alcohol253kfct_context_la_health_profile233kfct_context_health_protection233kfct_context_flu_covid_surveillance222kdim_population_long_raw194kfct_context_respiratory163kfct_context_help_health_costs144kfct_context_public_health116kfct_context_smoking93kfct_context_personal_wellbeing_ons_api91kfct_context_adhd_stimulant83kfct_context_liver_disease80kfct_context_palliative_care79kfct_context_census_rm_multivariate74kfct_context_private_adhd_cns_foi71kfct_context_nimdm17_ni58kdim_bnf_raw48kfct_context_gp_profile43kdim_national_life_tables_long_raw39kfct_context_sti_surveillance37kfct_context_litigation37kdim_population_estimates25kfct_context_contraception_patients_foi21kfct_context_dementia_profile16kfct_context_cancer_services14kfct_context_pcn_debt_recovery12kfct_context_better_care_fund12kfct_context_census_caring_identity_rm19111kfct_context_census_dwelling_stock10kdim_national_cost_collection_long_raw10kfct_context_adult_obesity9kfct_context_population_fingertips9kdim_practice8kfct_context_amr_local_indicators7kfct_context_qof_disease_registers_wales4kdim_pharmacy_fp57_refunds_long_raw3kfct_context_hepatitis_b_surveillance2kfct_context_census_general_health2kfct_context_antidepressant_sicbl_age_foi1kdim_trust_raw1kdim_pcn_raw1kfct_context_pharmacy_openings_closures1kdim_trust779fct_context_hypnotics_sicbl_foi673fct_context_hypnotics_age_cuts_2023655fct_context_legionellosis_surveillance567fct_context_hypnotics_age_cuts_2023_foi299fct_context_vdps298fct_context_ssbbv_sentinel_blood_borne_virus252dim_date125fct_context_charge_compliance115fct_context_baby_loss_certificate94fct_context_gp_pension_employment_foi93dim_legacy_org_mapping90fct_context_liothyronine62dim_region_alias42dim_icb_raw42dim_icb18dim_region7dim_population_by_region4fct_context_nhs_pension_payment_bands_foi
dim_icb
nhs_marts · context NHS England
42rows
1.7KBsize
4columns
2026-09-16updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_marts.dim_icb 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) |
| n_trusts | Nullable(Int64) |
Sample rows
| QWE | NHS South West Lon | London Commissioni | 4 |
|---|---|---|---|
| QWE | NHS South West London Integrated Car | London Commissioning Region | 4 |
| QK1 | NHS Leicester, Leicestershire And Ru | Midlands Commissioning Region | 11 |
| QRL | NHS Hampshire And Isle Of Wight Inte | South East Commissioning Region | 8 |