Spiral gives your agent every tool with one account. Browse the tools →

AlexandriaHealthAvailable now

NHSBSA Secondary Care Medicines Data (SCMD) · Search

opendata-nhsbsa-net/hospital-medicines/search

Get health and medical data with NHSBSA Secondary Care Medicines Data (SCMD) · Search from Alexandria through one Spiral API key. Search. It runs in the background and returns structured JSON. Pay as you go, with no subscription.

Pricing

$0.00873 per call.

Limits

Runs
In the background
Returns
json
Longest queue wait
1 hour
Run deadline
5 minutes
Longest run, end to end
225 minutes
Largest inline input
1 MB
Largest input file
2 GB
Largest output
5 GB

Input

FieldKindDefaultDescription
medicine requiredtext—

Part of the dm+d product (VMP) name, matched case-insensitively anywhere in it: pembrolizumab, adalimumab 40mg, insulin aspart. Generic names, not brands (Keytruda is pembrolizumab). Or a VMP SNOMED code of 6 to 20 digits for one exact product: 34378411000001105. Letters, digits, spaces and . , / % + ( ) - only. Pattern: ^[A-Za-z0-9 .,/%+()-]+$.

totext—

Last month, YYYY-MM. At most 24 months per call; months not yet published are listed in months_unavailable, not refused. Pattern: ^[0-9]{4}-(0[1-9]|1[0-2])$.

fromtext—

First month, YYYY-MM. SCMD starts at 2019-04. Without from and to, the latest 12 published months; with one of them, 12 months from or to it. Pattern: ^[0-9]{4}-(0[1-9]|1[0-2])$.

limitnumber
1 to 500
50

Most rows to return; total_count counts all and totals covers all.

trustlist—

Only these trusts, by ODS code: ["RBV", "RGT"]. Omit for every trust in England.

group_byone of
product, trust, month
product

product (default): one row per VMP and unit for the whole window. trust: per trust and VMP, with the trust's name. month: per month and VMP, a time series.

Same request in code

curl https://api.spiral.ai/v1/runs \
  -H "Authorization: Bearer $SPIRAL_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{
    "provider": "alexandria",
    "model": "opendata-nhsbsa-net/hospital-medicines/search",
    "input": {
      "medicine": "<medicine>"
    }
  }'

Frequently asked questions

How much does NHSBSA Secondary Care Medicines Data (SCMD) · Search cost?

$0.00873 per call. You pay as you go from one Spiral balance, with no subscription, and a failed run is not charged.

How do I use NHSBSA Secondary Care Medicines Data (SCMD) · Search through an API?

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "opendata-nhsbsa-net/hospital-medicines/search"` and the input fields on this page, using one Spiral API key. It runs in the background: poll the run, or name a webhook to be told when it finishes.

Do I need an account with Alexandria to use NHSBSA Secondary Care Medicines Data (SCMD) · Search?

No. Spiral runs it on its own Alexandria account and charges your Spiral balance.

Can my AI agent use NHSBSA Secondary Care Medicines Data (SCMD) · Search?

Yes. Agents find and run it through Spiral's MCP server, CLI or agent skill, with the same API key.