Limoja Data: search every published UK health dataset, board paper and indicator
Growth by raw data acquired; the compressed warehouse on disk is smaller. Real numbers, live from ClickHouse.
Featured datasets
The largest and most-queried tables in the warehouse.
fct_prescribing
NHSBSA · prescribing
fct_pca
NHSBSA · prescribing
fct_workforce_main
NHS England · workforce
fct_demand_rtt
NHS England · demand
fct_scmd
NHS England · other
fct_hospital_dispensed
NHSBSA · prescribing
dim_prescriber
NHSBSA · prescribing
Data sources
Official releases, indicator profiles and documents, refreshed nightly.
NHS England
297 tables across prescribing, workforce, activity and outcomes.
NHSBSA
39 tables across prescribing, workforce, activity and outcomes.
ONS
26 tables across prescribing, workforce, activity and outcomes.
StatsWales
22 tables across prescribing, workforce, activity and outcomes.
Public Health Scotland
17 tables across prescribing, workforce, activity and outcomes.
OHID / UKHSA
7 tables across prescribing, workforce, activity and outcomes.
CQC
4 tables across prescribing, workforce, activity and outcomes.
NI DoH / BSO
1 tables across prescribing, workforce, activity and outcomes.
Missing a source?
Tell us which publisher or board you want indexed next.
Use cases
Real questions people bring to the warehouse, and the sources that answer them.
Research
Write-ups from the nhs-scientist team — abstract, methods, results and a plain-English summary. Negative results included.
No entries yet. The nhs-scientist team writes cleaned-up write-ups to the /Online folder on the team wiki; each entry needs ## Abstract + ## Plain English to appear here.
Access the data
Five ways in, one daily limit. Open data under the Open Government Licence v3.0.
One daily limit across every access method, reset at midnight UK time. No card needed.
Copilot
Ask in plain English. The system finds the data, writes and tests the SQL, and shows its working.
“top trusts by A&E”
→ SQL → answer + proof
Open Copilot →
REST API
Query tables from your own code. Returns the answer, the SQL and the rows.
GET /api/stats.json GET /api/datasets.json POST /api/copilotAPI reference →
Download
Take any table away as a file from its dataset page, or pull the raw publisher files.
Dataset page → Download CSV · Parquet · JSON · raw filesBrowse datasets →
PCA prescribing
The ICB-level prescribing cost view with supplier and generic-equivalent detail. 67 months, 38.4m rows.
SELECT year_month, icb_code, sum(nic) AS nic FROM nhs_marts.fct_pca GROUP BY 1,2Open in Datasets →
Datasets as JSON
Machine-readable metadata for the whole catalogue and for every table.
GET /api/datasets.json GET /api/datasets.json?d=nhs_raw.fct_pcaBrowse JSON →