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
fct_acute_plac
nhs_raw · other NHS England
155krows
1.3MBsize
15columns
2026-09-05updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_raw.fct_acute_plac 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) |
| measure_label | Nullable(String) |
| geography_level | Nullable(String) |
| geography_code | Nullable(String) |
| geography_name | Nullable(String) |
| canonical_ods_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) |
Sample rows
| activity | acute_plac | plac_ae_total_acti | Accident and Emerg | national | England | Total Activities | 2018-19-03-31 | 2018-19 | 18431620 | count | NHS Digital — Acut | https://digital.nh | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| activity | acute_plac | plac_ae_total_activities | Accident and Emergency Total Activit | national | England | Total Activities | 2018-19-03-31 | 2018-19 | 18431620 | count | NHS Digital — Acute Patient-Level Ac | https://digital.nhs.uk/data-and-info | ||
| activity | acute_plac | plac_ae_total_cost | Accident and Emergency Total Cost | national | England | Total Cost | 2018-19-03-31 | 2018-19 | 3298448615.2 | gbp | NHS Digital — Acute Patient-Level Ac | https://digital.nhs.uk/data-and-info | ||
| activity | acute_plac | plac_ae_gender_and_age_group | Accident and Emergency Gender and Ag | national | England | gender_and_age|Female|0 years | 2018-19-03-31 | 2018-19 | 217493 | count | NHS Digital — Acute Patient-Level Ac | https://digital.nhs.uk/data-and-info |
Cited by papers
- none yet