Datasets 112 datasets

all prescribingactivitydemandworkforceoutcomecontextother
context
22.5mfct_context_fingertips_all2.7mdim_postcode_geo1.4mdim_gp_practice_populations_scot_long_raw1.1mfct_context_fingertips_profiles761kfct_context_phof744kfct_context_social_services_wales659kfct_context_pharmacy_quality581kfct_context_population_projections_scot542kfct_context_childhood_vaccination536kdim_activity_diagnostic_imaging457kfct_context_cqc_directory365kdim_outcome_births_hospitals_scot314kdim_cqc_long_raw311kdim_gp_wales297kfct_context_alcohol253kfct_context_la_health_profile233kfct_context_health_protection233kfct_context_flu_covid_surveillance227kfct_context_cancer_prevalence222kdim_population_long_raw194kfct_context_respiratory191kdim_geography174kfct_experience_cqc_survey174kdim_experience_cqc_survey163kfct_context_help_health_costs144kfct_context_public_health134kfct_context_census_migration_birthplace117kfct_context_census_rm_general_health117kdim_context_census_rm_general_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_raw50kfct_context_uk_labour_market48kfct_context_gp_profile46kfct_context_census_rm_economic_activity46kdim_context_census_rm_economic_activity43kdim_national_life_tables_long_raw40kfct_context_census_caring_identity39kfct_context_sti_surveillance37kfct_context_litigation37kdim_population_estimates34kdim_provider_org_register_raw26kfct_context_children_looked_after_wales_stock_flow25kfct_context_contraception_patients_foi21kfct_context_older_people_sex_ratio21kfct_context_dementia_profile16kfct_context_cancer_services16kfct_context_ageing_population_estimates14kfct_context_pcn_debt_recovery14kfct_context_wimd_wales12kfct_context_better_care_fund12kfct_context_census_caring_identity_rm19111kfct_context_census_dwelling_stock10kdim_national_cost_collection_long_raw10kfct_context_adult_obesity10kfct_context_births9kfct_context_population_fingertips9kdim_practice9kfct_context_ncsp_chlamydia_trends8kfct_context_amr_local_indicators7kfct_context_qof_disease_registers_wales7kdim_nhsbsa_contract_long_raw6kdim_gp_practice_map6kdim_pcn6kfct_context_census_veterans_households4kfct_context_opioid_hypnotic_gender_monthly4kdim_pharmacy_fp57_refunds_long_raw3kfct_context_hepatitis_b_surveillance3kfct_context_children_looked_after_wales_ext2kfct_context_census_general_health2kfct_context_ecds_investigations2kfct_context_antidepressant_sicbl_age_foi1kdim_trust_raw1kdim_pcn_raw1kfct_context_pharmacy_openings_closures1kdim_fingertips_indicators1kdim_trust1kdim_trust_sites823dim_outcome_mpox_vaccination779fct_context_hypnotics_sicbl_foi692dim_asc_social_care673fct_context_hypnotics_age_cuts_2023655fct_context_legionellosis_surveillance567fct_context_hypnotics_age_cuts_2023_foi372fct_context_notifiable_diseases299fct_context_vdps298fct_context_ssbbv_sentinel_blood_borne_virus252dim_date162dim_specialty_codes_scot_long_raw140fct_context_pension_payment_delays125fct_context_charge_compliance115fct_context_baby_loss_certificate94fct_context_gp_pension_employment_foi93dim_legacy_org_mapping90fct_context_liothyronine85fct_context_metformin_foi85dim_context_metformin_foi62dim_region_alias44dim_fingertips_area_types42dim_icb_raw38dim_fingertips_profiles20fct_context_pension_transfers_out_foi18dim_region7dim_population_by_region6dim_org_alias4fct_context_nhs_pension_payment_bands_foi

dim_icb_raw

nhs_raw · context NHS England

42rows
1.9KBsize
6columns
2026-09-29updated
varieslicence — see publisher
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

ColumnType
icb_codeNullable(String)
icb_nameNullable(String)
regionNullable(String)
statusNullable(String)
n_trustsNullable(Int64)
n_orgsNullable(Int64)

Sample rows

QE1NHS Lancashire AndNorth West Commissactive66
QE1NHS Lancashire And South Cumbria IntNorth West Commissioning Regionactive66
QF7NHS South Yorkshire Integrated Care North East and Yorkshire Commissioniactive55
QGHNHS Herefordshire And WorcestershireMidlands Commissioning Regionactive22

Cited by papers

  • none yet
Copilotdeep · LLM + SQL