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_legacy_org_mapping

nhs_marts · context NHS England

93rows

5.1KBsize

5columns

2026-08-17updated

OGL 3.0licence

Query this dataset

SELECT * FROM nhs_marts.dim_legacy_org_mapping LIMIT 100

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

Schema

Column	Type
canonical_ods_code	String
canonical_trust_name	String
legacy_ods_code	String
legacy_trust_name	String
rows_seen	UInt64

Sample rows

0DA	NHS YORKSHIRE AND	0AV	NHS North Yorkshir	1538
0DA	NHS YORKSHIRE AND HUMBER COMMISSIONI	0AV	NHS North Yorkshire and Humber Commi	1538
0DA	NHS YORKSHIRE AND HUMBER COMMISSIONI	0CF	NHS West and South Yorkshire and Bas	1189
0DE	NHS ARDEN AND GREATER EAST MIDLANDS	0AA	NHS Arden Commissioning Support Unit	1489

Cited by papers

Bidirectional Association Between NHS Trust Staff Sickness Absence and A&E 4-Hou