Automated import pipeline
Laravel 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,292 | 06 Nov 2025 14:43 | — | — |
| Data Imports | 372 | 06 Nov 2025 14:47 | — | — |
| Dispensing Data | 50,612,436 | 04 Nov 2025 14:10 | Nov 2020 | Mar 2025 |
| Hospital Prescriptions | 6,227,434 | 04 Aug 2025 22:48 | Jan 2017 | Apr 2025 |
| Pharmacies | 967 | 06 Nov 2025 14:30 | — | — |
| Prescribers | 12,175 | 06 Nov 2025 14:52 | — | Jun 2025 |
| Prescription Cost Analyses | 957,424 | 29 Jul 2025 13:11 | Jan 2021 | Apr 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.