Datasets 293 tables · 1.80bn rows

all prescribingactivitydemandworkforceoutcomecontextother
prescribing
1.70bnepd_prescribing
workforce
16.0mfct_workforce_main16.0mfct_workforce_main
demand
7.2mfct_demand_rtt7.2mfct_rtt
outcome
6.9mfct_outcome_gp_survey
prescribing
3.8mfct_activity_prescribing_secondary
demand
2.6mfct_demand_cancer2.6mfct_cancer
activity
1.8mtalking_therapies_raw1.8mfct_activity_talking_therapies1.7mfct_activity_talking_therapies
prescribing
1.7mfct_activity_prescribing_paper1.7mfct_activity_dispensing_doctor_padm
activity
1.4mfct_activity_uec_sitrep
context
1.4mdim_gp_practice_populations_scot_long_raw
demand
1.2mfct_demand_gp_appointments1.2mfct_gp_appointments
context
1.1mfct_context_fingertips_profiles
activity
1.1mfct_activity_winter_sitrep
outcome
1.0mfct_outcome_la_life_expectancy
demand
926kfct_demand_diagnostics926kfct_diagnostics
outcome
859kfct_outcome_ons_la_life_expectancy
prescribing
823kfct_activity_prescribed_dispensed_scot
context
761kfct_context_phof
activity
679kfct_activity_dental_contractor_payments_foi
context
659kfct_context_pharmacy_quality
workforce
609kfct_workforce_sickness_absence609kfct_workforce_sickness_absence
context
581kfct_context_population_projections_scot
outcome
548kfct_outcome_covid_19_wider_impacts_scot
context
542kfct_context_childhood_vaccination
outcome
518kfct_outcome_heart_disease_statistics_scot
activity
507kfct_activity_chc_fnc
demand
478kfct_demand_ae478kfct_ae
activity
450kfct_activity_dental_stats_england
context
443kfct_context_cqc_directory
demand
438kfct_demand_ambulance438kfct_ambulance
prescribing
428kfct_context_prescribing_glp1_foi
activity
418kfct_activity_csds
outcome
396kfct_outcome_proms383kfct_outcome_smoking_quit_success
activity
375kfct_activity_mh_eip
outcome
316kfct_mortality_weekly
context
314kdim_cqc_long_raw297kfct_context_alcohol
activity
286kfct_activity_hes286kfct_activity_hes
context
253kfct_context_la_health_profile233kfct_context_health_protection233kfct_context_flu_covid_surveillance222kdim_population_long_raw
activity
222kfct_activity_breastfeeding203kfct_activity_pc_ooh_scot
prescribing
197kfct_context_glp1_first_dispensing_foi
outcome
197kfct_outcome_ons_weekly_deaths
context
194kfct_context_respiratory
workforce
170kdim_gp_workforce_scot_raw
context
163kfct_context_help_health_costs
outcome
161kfct_outcome_mortality_weekly
other
155kfct_acute_plac
context
144kfct_context_public_health
activity
136kfct_activity_hospital_activity
prescribing
131kfct_activity_dispensing
activity
123kfct_activity_bed_occupancy123kfct_activity_bed_occupancy
outcome
120kfct_outcome_screening
prescribing
117kfct_activity_prescribing_bnf_chapter_demog_foi
context
116kfct_context_smoking
activity
107kfct_activity_iucadc
context
93kfct_context_personal_wellbeing_ons_api
activity
92kfct_activity_outpatient_referrals
context
91kfct_context_adhd_stimulant
activity
89kfct_activity_vte86kfct_activity_outpatient_transformation85kfct_activity_pharmacy_first_payments_foi
prescribing
83kepd_roll_month_chem83kfct_prescribing_roll_month_chem
context
83kfct_context_liver_disease
activity
82kfct_activity_dementia_screening
context
80kfct_context_palliative_care
activity
79kfct_activity_iuc111
context
79kfct_context_census_rm_multivariate
demand
78kfct_demand_wlms
activity
77kfct_activity_mixed_sex77kfct_activity_gp_extended_access_historical
workforce
74kfct_workforce_vacancies74kfct_workforce_vacancies
context
74kfct_context_private_adhd_cns_foi71kfct_context_nimdm17_ni
activity
66kfct_activity_community_discharge64kfct_activity_shmi64kfct_activity_smi_health_checks
other
62kmart_ae_trust_monthly
activity
62kfct_activity_ed_wait_times_wales61kfct_activity_mhsds61kfct_activity_mhsds61kfct_activity_cyped60kfct_activity_pharmacy_first_referrals_foi58kfct_activity_pharmacy_child_flu_pilot
context
58kdim_bnf_raw
outcome
55kfct_outcome_qof54kfct_outcome_mortality54kfct_outcome_ons_monthly_deaths53kfct_outcome_breastfeeding_wales
other
51kmart_rtt_incomplete_trust_monthly
activity
50kfct_activity_cdc
prescribing
50kfct_activity_scottish_dispensing
context
48kfct_context_gp_profile
outcome
47kfct_outcome_mh_measure_wales
prescribing
46kfct_context_nhsbsa_prescription_dispensing
context
43kdim_national_life_tables_long_raw
outcome
42kfct_outcome_nod_audit
context
39kfct_context_sti_surveillance
activity
38kfct_activity_nhs_claims_history
context
37kfct_context_litigation37kdim_population_estimates
activity
32kfct_activity_mh_community_teams31kfct_activity_fft
outcome
31kfct_outcome_lung_cancer_audit25kfct_outcome_death_cause_summary
other
25kmart_cancer_trust_monthly
context
25kfct_context_contraception_patients_foi
activity
25kfct_activity_wheelchair
outcome
24kfct_outcome_hcai_all_cause_fatality
activity
24kfct_activity_nhs_resolution_claims
outcome
23kfct_outcome_cancer_experience
prescribing
21kdim_chemical_bnf
other
21kfct_drug_alcohol_initial_assessments_scot
context
21kfct_context_dementia_profile
outcome
21kfct_outcome_child_flying_start_wales20kfct_outcome_noids_weekly19kfct_outcome_personal_wellbeing
activity
19kfct_activity_gp_extended_access
other
18kfct_older_people_sex_ratio
activity
17kfct_activity_estates_eric
context
16kfct_context_cancer_services
outcome
16kfct_outcome_cancer_experience_trust16kfct_outcome_nela_emergency_laparotomy
activity
15kfct_activity_dental_new_patient_premium
context
14kfct_context_pcn_debt_recovery
activity
14kfct_activity_acute_provider_performance14kfct_activity_acute_provider_performance
outcome
14kfct_outcome_maternity_child_wales
workforce
13kmart_workforce_wte_trust_monthly
other
13kmart_percapita_trust_monthly
prescribing
13kfct_context_prescribing_diabetes_pfd
context
12kfct_context_better_care_fund12kfct_context_census_caring_identity_rm191
outcome
12kfct_outcome_stroke_scot
activity
11kfct_activity_genomic_testing
context
11kfct_context_census_dwelling_stock
outcome
11kfct_outcome_ons_child_mortality
activity
11kfct_activity_virtual_ward
context
10kdim_national_cost_collection_long_raw
outcome
10kfct_outcome_pancreatic_cancer_audit
context
10kfct_context_adult_obesity
prescribing
10kfct_activity_prescribing_dispenser_linkage_foi
outcome
10kfct_outcome_heart_failure_audit
prescribing
10kfct_context_ed_prescribing
activity
9kfct_activity_post_covid
context
9kfct_context_population_fingertips9kdim_practice
activity
9kfct_outcome_gp_survey_dental
outcome
9kfct_outcome_smoking_cessation_quits_wales
context
8kfct_context_amr_local_indicators
outcome
8kfct_outcome_cancer_experience_icb
other
7kvaccination_raw
activity
7kfct_activity_maternity_services_monthly
context
7kfct_context_qof_disease_registers_wales
activity
7kfct_activity_ucr
prescribing
6kfct_activity_prescribing_nondispensed
other
6keric_raw
activity
6kfct_activity_eric
demand
6kfct_demand_cancelled_ops6kfct_demand_vaccination
outcome
5kfct_outcome_kidney_cancer_audit
prescribing
5kfct_prescribing_trust
activity
5kfct_activity_npda_audit5kfct_dental_patients_wales5kfct_activity_dental_patients_wales5kfct_activity_cancelled_elective_ops
outcome
5kfct_outcome_smoking_cessation_scot5kfct_outcome_conceptions4kfct_outcome_patient_safety4kfct_outcome_oesophago_gastric_cancer_audit4kfct_outcome_alcohol_deaths
context
4kdim_pharmacy_fp57_refunds_long_raw
activity
4kfct_activity_corridor_care4kfct_activity_msds4kfct_activity_msds
outcome
4kfct_outcome_deaths_by_cause4kfct_outcome_hpv_vaccine_coverage
other
4kiuk_awards_agg3kfft_raw
activity
3kfct_activity_dental_treatment_detail_wales
context
3kfct_context_hepatitis_b_surveillance
activity
3kfct_activity_dental_wales
outcome
3kfct_outcome_cancer_experience_ca3kfct_outcome_influenza_annual_uk2kfct_outcome_picanet_audit
other
2kgovt_funded_research
activity
2kfct_activity_critical_care2kfct_activity_critical_care
context
2kfct_context_census_general_health
outcome
2kfct_outcome_hiv_action_plan_mef2kfct_outcome_coroners_statistics2kmart_excess_mortality_weekly
other
2kfct_pharmacy_wales
activity
2kfct_activity_pharmacy_wales
outcome
2kfct_outcome_prostate_cancer_audit
context
2kfct_context_antidepressant_sicbl_age_foi
prescribing
2kepd_roll_month_icb2kfct_prescribing_roll_month_icb
context
1kdim_trust_raw1kdim_pcn_raw1kfct_context_pharmacy_openings_closures
activity
1kfct_activity_england_nhse_community_bed_audit
context
1kdim_trust
activity
1kfct_activity_bed_kh031kfct_activity_orthodontic_children_adults_foi
prescribing
971dim_dispensing_practice_raw
demand
892fct_demand_fft
context
779fct_context_hypnotics_sicbl_foi
activity
735fct_activity_wgos_ophthalmics_wales
outcome
714fct_outcome_shmi
activity
710fct_activity_community_bed_audit
context
673fct_context_hypnotics_age_cuts_2023655fct_context_legionellosis_surveillance
activity
624fct_activity_dental_uda_performer
outcome
620mart_mortality_by_imd_monthly
activity
592fct_activity_dtoc592fct_activity_dtoc
context
567fct_context_hypnotics_age_cuts_2023_foi
outcome
513fct_outcome_vaccination_seasonal
activity
494fct_activity_dental_antibiotic
prescribing
465fct_prescribing_strength_pair465fct_context_prescribing_strength_pair_foi463fct_context_cannabis_prescribing_foi448mart_prescribing_per_capita
context
299fct_context_vdps298fct_context_ssbbv_sentinel_blood_borne_virus
activity
294fct_activity_ihs_reimbursement_students279fct_activity_dental_treatment_wales
outcome
278fct_outcome_maternal_mortality_audit_databrief
context
252dim_date
outcome
237fct_outcome_enterococcus_bacteraemia
workforce
231mart_workforce_per_capita_region_monthly
other
213_ingest_manifest
outcome
209fct_outcome_flu_vaccination144fct_outcome_maternal_mortality_audit
prescribing
139fct_prescribing_trust_weights
context
125fct_context_charge_compliance
outcome
122fct_outcome_cancer_experience_national
context
115fct_context_baby_loss_certificate94fct_context_gp_pension_employment_foi93dim_legacy_org_mapping90fct_context_liothyronine
other
87fct_productivity_ons87fct_productivity_ons67mart_critical_care_beds_daily
context
62dim_region_alias
other
53isrctn_commercial_by_dimension
prescribing
48epd_roll_month48fct_prescribing_roll_month
context
42dim_icb_raw42dim_icb
workforce
32mart_workforce_by_staffgroup_monthly
other
29ctgov_uk_industry_by_year26isrctn_commercial_by_year20isrctn_commercial_top_funders
context
18dim_region
other
15ctgov_uk_industry_top_sponsors15ctgov_uk_industry_top_conditions13rq16_ichp12rq16_hin_south_london12ctgov_uk_industry_by_status10rq16_scorecard_add10rq16_mhra_performance
activity
9fct_activity_hrt_ppc
other
8rq16_uclpartners8rq16_scorecard_headline8rq16_oecd_hcqi8ctgov_uk_industry_by_phase
context
7dim_population_by_region
other
6isrctn_commercial_results_reporting
context
4fct_context_nhs_pension_payment_bands_foi
other
4rq16_hin_network4ctgov_uk_industry_results_reporting3_t2

dim_region_alias

nhs_marts · context NHS England

62rows
853Bsize
2columns
2026-08-17updated
OGL 3.0licence
Query this dataset 
SELECT * FROM nhs_marts.dim_region_alias LIMIT 100

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

Schema

ColumnType
alias_lowercaseString
region_idUInt32

Sample rows

east4
east4
east4
east midlands3

Cited by papers

  • none yet
Limoja NHS Data — an autonomous research warehouse of all published UK health data, built by human + AI agent teams. All data open (OGL v3.0 unless noted); cite the original publisher and this portal. Live from the warehouse · v3.