Datasets 16 tables · 25.7m rows
demand
7.2mfct_demand_rtt7.2mfct_rtt2.6mfct_demand_cancer2.6mfct_cancer1.2mfct_demand_gp_appointments1.2mfct_gp_appointments926kfct_demand_diagnostics926kfct_diagnostics478kfct_demand_ae478kfct_ae438kfct_demand_ambulance438kfct_ambulance78kfct_demand_wlms6kfct_demand_cancelled_ops6kfct_demand_vaccination892fct_demand_fft
fct_cancer
nhs_marts · demand NHS England
2.6mrows
93.1MBsize
18columns
2026-09-16updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_marts.fct_cancer LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| month_date | Nullable(Date) |
| date | Nullable(String) |
| measure | Nullable(String) |
| standard | Nullable(String) |
| route | Nullable(String) |
| modality | Nullable(String) |
| cancer_type | Nullable(String) |
| geography_level | Nullable(String) |
| geography_code | Nullable(String) |
| geography_name | Nullable(String) |
| canonical_ods_code | Nullable(String) |
| trust_name | Nullable(String) |
| t.trust_type | Nullable(String) |
| region | Nullable(String) |
| icb_code | Nullable(String) |
| icb_name | Nullable(String) |
| value | Nullable(Float64) |
| unit | Nullable(String) |
Sample rows
| 2024-11-01 | 2024-11 | 62day_total | 62D | Consultant Upgrade | ALL MODALITIES | Haematological - L | trust | RTR | SOUTH TEES HOSPITA | RTR | SOUTH TEES HOSPITA | acute | North East and Yor | QHM | NHS North East And | 2 | patients |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2024-11-01 | 2024-11 | 62day_total | 62D | Consultant Upgrade | ALL MODALITIES | Haematological - Lymphoma | trust | RTR | SOUTH TEES HOSPITALS NHS FOUNDATION | RTR | SOUTH TEES HOSPITALS NHS FOUNDATION | acute | North East and Yorkshire Commissioni | QHM | NHS North East And North Cumbria Int | 2 | patients |
| 2024-07-01 | 2024-07 | 62day_total | 62D | Consultant Upgrade | ALL MODALITIES | Haematological - Other (a) | trust | RVW | NORTH TEES AND HARTLEPOOL NHS FOUNDA | RVW | NORTH TEES AND HARTLEPOOL NHS FOUNDA | acute | North East and Yorkshire Commissioni | QHM | NHS North East And North Cumbria Int | 4.5 | patients |
| 2025-02-01 | 2025-02 | 62day_total | 62D | Consultant Upgrade | ALL MODALITIES | Haematological - Other (a) | trust | RCB | YORK AND SCARBOROUGH TEACHING HOSPIT | RCB | YORK AND SCARBOROUGH TEACHING HOSPIT | acute | North East and Yorkshire Commissioni | QOQ | NHS Humber And North Yorkshire Integ | 6 | patients |