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_ae
nhs_marts · demand NHS England
478krows
4.2MBsize
22columns
2026-09-16updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_marts.fct_ae LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| pillar | Nullable(String) |
| series | Nullable(String) |
| measure | Nullable(String) |
| geography_level | Nullable(String) |
| geography_code | Nullable(String) |
| geography_name | Nullable(String) |
| category_code | Nullable(String) |
| category | Nullable(String) |
| date | Nullable(String) |
| period | Nullable(String) |
| value | Nullable(Float64) |
| unit | Nullable(String) |
| source_pub | Nullable(String) |
| source_url | Nullable(String) |
| canonical_ods_code | Nullable(String) |
| trust_type | Nullable(String) |
| month_date | Nullable(Date) |
| trust_name | Nullable(String) |
| trust_region | Nullable(String) |
| trust_icb_code | Nullable(String) |
| trust_icb_name | Nullable(String) |
| quality_flag | Nullable(String) |
Sample rows
| demand | ae | ae_gt4h_type2 | trust | Y03007 | Erdington GP Healt | ALL | ALL ATTENDANCES | 2019-12 | month | 0 | attendances | NHSE A&E Attendanc | https://www.englan | Y03007 | unknown | 2019-12-01 | ERDINGTON GP HEALT | Midlands Commissio | QHL | NHS Birmingham And | S |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| demand | ae | ae_gt4h_type2 | trust | Y03007 | Erdington GP Health & Wellbeing Wic | ALL | ALL ATTENDANCES | 2019-12 | month | 0 | attendances | NHSE A&E Attendances (time series + | https://www.england.nhs.uk/statistic | Y03007 | unknown | 2019-12-01 | ERDINGTON GP HEALTH & WELLBEING WIC | Midlands Commissioning Region | QHL | NHS Birmingham And Solihull Integrat | S |
| demand | ae | ae_gt4h_type3 | trust | Y03007 | Erdington GP Health & Wellbeing Wic | ALL | ALL ATTENDANCES | 2019-12 | month | 0 | attendances | NHSE A&E Attendances (time series + | https://www.england.nhs.uk/statistic | Y03007 | unknown | 2019-12-01 | ERDINGTON GP HEALTH & WELLBEING WIC | Midlands Commissioning Region | QHL | NHS Birmingham And Solihull Integrat | None |
| demand | ae | ae_attend_gt4h | trust | Y03007 | Erdington GP Health & Wellbeing Wic | ALL | ALL ATTENDANCES | 2019-12 | month | 0 | attendances | NHSE A&E Attendances (time series + | https://www.england.nhs.uk/statistic | Y03007 | unknown | 2019-12-01 | ERDINGTON GP HEALTH & WELLBEING WIC | Midlands Commissioning Region | QHL | NHS Birmingham And Solihull Integrat | None |