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_trust_raw
nhs_raw · context NHS England
1krows
51.6KBsize
11columns
2026-08-18updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_raw.dim_trust_raw LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| ods_code | Nullable(String) |
| canonical_ods_code | Nullable(String) |
| name | Nullable(String) |
| trust_type | Nullable(String) |
| region | Nullable(String) |
| icb_code | Nullable(String) |
| icb_name | Nullable(String) |
| status | Nullable(String) |
| legal_end | Nullable(String) |
| primary_role_id | Nullable(String) |
| source | Nullable(String) |
Sample rows
| 15F | 15F | NHS WEST YORKSHIRE | unknown | active | RO98 | fact_table | ||||
|---|---|---|---|---|---|---|---|---|---|---|
| 15F | 15F | NHS WEST YORKSHIRE ICB - 15F | unknown | active | RO98 | fact_table | ||||
| 03G | 15F | NHS LEEDS SOUTH AND EAST CCG | unknown | closed | 2018-03-31 | RO98 | fact_table | |||
| RD1 | RD1 | ROYAL UNITED HOSPITALS BATH NHS FOUN | acute | South West Commissioning Region | QOX | NHS Bath And North East Somerset, Sw | active | RO197 | system_mapping |
Cited by papers
- none yet