Datasets 36 tables · 371k rows
other
155kfct_acute_plac62kmart_ae_trust_monthly51kmart_rtt_incomplete_trust_monthly25kmart_cancer_trust_monthly21kfct_drug_alcohol_initial_assessments_scot18kfct_older_people_sex_ratio13kmart_percapita_trust_monthly7kvaccination_raw6keric_raw4kiuk_awards_agg3kfft_raw2kgovt_funded_research2kfct_pharmacy_wales213_ingest_manifest87fct_productivity_ons87fct_productivity_ons67mart_critical_care_beds_daily53isrctn_commercial_by_dimension29ctgov_uk_industry_by_year26isrctn_commercial_by_year20isrctn_commercial_top_funders15ctgov_uk_industry_top_sponsors15ctgov_uk_industry_top_conditions13rq16_ichp12rq16_hin_south_london12ctgov_uk_industry_by_status10rq16_scorecard_add10rq16_mhra_performance8rq16_uclpartners8rq16_scorecard_headline8rq16_oecd_hcqi8ctgov_uk_industry_by_phase6isrctn_commercial_results_reporting4rq16_hin_network4ctgov_uk_industry_results_reporting3_t2
mart_percapita_trust_monthly
nhs_marts · other NHS England
13krows
308.3KBsize
12columns
2026-09-16updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_marts.mart_percapita_trust_monthly LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| f.canonical_ods_code | Nullable(String) |
| trust_name | Nullable(String) |
| tr.region_id | Nullable(UInt32) |
| f.month_date | Nullable(Date) |
| fte | Nullable(Float64) |
| rtt_pathways | Nullable(Float64) |
| ae_attend | Nullable(Float64) |
| region_population | UInt64 |
| allocated_population | Nullable(Float64) |
| fte_per_1k_pop | Nullable(Float64) |
| rtt_pathways_per_1k | Nullable(Float64) |
| ae_attend_per_1k | Nullable(Float64) |
Sample rows
| RVN | AVON AND WILTSHIRE | None | 2025-09-01 | 13883.813460000001 | None | None | 0 | None | None | None | None |
|---|---|---|---|---|---|---|---|---|---|---|---|
| RVN | AVON AND WILTSHIRE MENTAL HEALTH PAR | None | 2025-09-01 | 13883.813460000001 | None | None | 0 | None | None | None | None |
| T1510 | NHS ENGLAND - T1510 | None | 2016-02-01 | 11381.768939999998 | None | None | 0 | None | None | None | None |
| 0DF | NHS SOUTH, CENTRAL AND WEST COMMISSI | None | 2019-10-01 | 6884.998560000002 | None | None | 0 | None | None | None | None |
Cited by papers
- none yet