Automated import pipeline
Queues orchestrate ingestion from NHS BSA CKAN releases. Each dataset run is versioned, validated, and rolled back automatically if anomalies appear.
Pharmadata dataset coverage
We continually import and normalise NHS Business Services Authority datasets. Use this dashboard to understand the breadth and freshness of our data.
Dataset summary
Counts and refresh dates for each table in the warehouse.
| Dataset | Records | Latest update | Earliest date | Latest date |
|---|---|---|---|---|
| Bnf Codes | 54,666 | 10 May 2026 13:03 | — | — |
| Data Imports | 377 | 07 Nov 2025 15:54 | — | — |
| Dispensing Data | 50,612,436 | 05 Dec 2025 16:45 | Nov 2020 | Mar 2025 |
| Hospital Prescriptions | 6,300,414 | 05 Dec 2025 14:58 | Jan 2017 | Aug 2025 |
| Pharmacies | 970 | 10 May 2026 10:37 | — | — |
| Prescribers | 12,307 | 10 May 2026 12:52 | — | Dec 2025 |
| Prescription Cost Analyses | 974,906 | 07 Nov 2025 15:54 | Jan 2021 | Aug 2025 |
| Scmd Entries | 817,375 | 28 Jul 2025 16:04 | Apr 2020 | Mar 2025 |
How we keep data fresh
Reliability and transparency underpin the platform.
Cache-first delivery
All heavy queries are cached with automatic invalidation when new imports land. That keeps pages fast and API responses consistent.