This repository contains code and example data for exploring the NHS England (NHSE) monthly Referral to Treatment (RTT) data. The RTT data provides insights into the performance of healthcare services in England, specifically focusing on the time patients wait for treatment after being referred by a healthcare professional. The live marimo dashboard is hosted on Molab
The RTT data is sourced from the NHS England statistics website, which publishes monthly reports and datasets. See NHSE RTT Data. The data in the data/ directory is a sample of the data downloaded from the NHSE website and the cleaned data that is loaded into the Databricks workspace.
The ETL pipeline script that scrape the NHSE RTT pages, download the data, process it, and load it into a Databricks workspace live in scripts/. The script run on GitHub Actions on a schedule every month. The the static dashboard/notebook (as preview) is in dashboard.html.
I will be adding more charts and other analyses over time, stay tuned! Marimo is awesome!