recall_spend_window

What it answers

1. 1Given an FDA-assigned recall_number, returns recall metadata plus Medicare Part D and Medicaid SDUD federal spend on the recalled drug during the recall window (initiation -> termination), summed SERVER-SIDE with per-year Part D rows and per-NDC Medicaid rows riding the answer.
2. 2The recall source carries NO NDC (openfda_product_ndc_first is NULL on all 17,830 current rows), so the Medicaid leg reaches NDCs through dim_drug on the openFDA product name and says so.
3. 3Each leg reports its own published-year coverage, so 'no spend', 'not published yet' and 'no join key' are three different answers instead of one null.
4. 4Medicaid totals EXCLUDE the SDUD national roll-up, which CMS publishes under state 'XX' beside the 50 state rows and which would otherwise roughly double every Medicaid figure.
5. 5Reference demo: recall_number D-1489-2019 (Fresenius Kabi fluorouracil, Class I, window 2019-2022) exercises both legs and the NDC bridge.
6. 6This description quotes NO dollar figure on purpose: the answer is the only place a number lives, so a change to the computation can never leave a stale figure in the documentation.
7. 7It did once -- the demo totals here were the pre-2026-08-10 national-roll-up double count and stood six weeks after the fix.

Inputs (3)

Call it

# MCP (https://mcp.vladahealth.com/mcp): the tool by name
recall_spend_window(recall_number="D-1489-2019", detail_limit=5)

curl -X POST https://api.vladahealth.com/v1/tools/recall_spend_window \
  -H "Authorization: Bearer $VLADA_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"recall_number":"D-1489-2019","detail_limit":5}'

# the schema, no key
curl https://api.vladahealth.com/v1/tools/recall_spend_window/schema

A real answer

{
 "value": {
  "headline": 22744256.999999996,
  "recall_number": "D-1489-2019",
  "status": "ok",
  "classification": "Class I",
  "reason_for_recall": "Presence of Particulate Matter; glass particulates",
  "recalling_firm": "Fresenius Kabi USA, LLC",
  "product_description": "Fluorouracil Injection, USP, 5 g / 100 mL (50 mg / mL), 100 mL fill in a 100 mL vial, Rx Only, Mfd. by:  Fresenius Kabi, Lake Zurich, IL 60047.  63323-117-61 [Fresenius Kabi brand] and NDC 63323-117-69 [NOVAPLUS brand]",
  "recall_initiation_date": "2019-06-28",
  "termination_date": "2022-09-20",
  "recall_still_open": false,
  "openfda_product_ndc": null,
  "openfda_brand_name": "FLUOROURACIL",
  "openfda_generic_name": "FLUOROURACIL",
  "ndcs_bridged": 66,
  "ndcs_bridged_capped": false,
  "part_d_window_years": [
   2019,
   2020,
   2021,
   2022
  ],
  "medicaid_window_years": [
   2019,
   2020,
   2021,
   2022
  ],
  "part_d_published_years": [
   2019,
   2024
  ],
  "medicaid_published_years": [
   1991,
   2026
  ],
  "part_d_leg_status": "ok",
  "medicaid_leg_status": "ok",
  "part_d_spend_during_window_usd": 196753616.45000002,
  "medicaid_spend_during_window_usd": 22744256.999999996,
  "combined_federal_spend_usd": 22744256.999999996,
  "recalled_form_family": "injectable",
  "part_d_in_combined": false,
  "ndcs_excluded_other_form": 33,
  "medicaid_ndcs_with_spend": 32,
  "medicaid_suppressed_rows_excluded": 7112,
  "part_d_year_lines": [
   {
    "data_year": 2019,
    "brand_name": "Fluorouracil*",
    "generic_name": "Fluorouracil",
    "total_spending_usd": 40135037.1
   },
   {
    "data_year": 2019,
    "brand_name": "Carac",
    "generic_name": "Fluorouracil",
    "total_spending_usd": 306684.05
   },
   {
    "data_year": 2019,
    "brand_name": "Efudex",
    "generic_name": "Fluorouracil",
    "total_spending_usd": 40763.03
   },
   {
    "data_year": 2020,
    "brand_name": "Fluorouracil*",
    "generic_name": "Fluorouracil",
    "total_spending_usd": 48774659.52
   },
   {
    "data_year": 2020,
    "brand_name": "Efudex",
    "generic_name": "Fluorouracil",
    "total_spending_usd": 30804.79
   },
   {
    "data_year": 2020,
    "brand_name": "Tolak",
    "generic_name": "Fluorouracil",
    "total_spending_usd": null
   },
   {
    "data_year": 2021,
    "brand_name": "Fluorouracil*",
    "generic_name": "Fluorouracil",
    "total_spending_usd": 52372838.9
   },
   {
    "data_year": 2021,
    "brand_name": "Efudex",
    "generic_name": "Fluorouracil",
    "total_spending_usd": 28797.06
   },
   {
    "data_year": 2022,
    "brand_name": "Fluorouracil*",
    "generic_name": "Fluorouracil",
    "total_spending_usd": 55041063.92
   },
   {
    "data_year": 2022,
    "brand_name": "Efudex",
    "generic_name": "Fluorouracil",
    "total_spending_usd": 22968.08
   }
  ],
  "medicaid_ndc_lines": [
   {
    "ndc11": "63323011710",
    "product_name": "FLUOROURAC",
    "rows": 720,
    "years_covered": 4,
    "medicaid_reimbursed_usd": 5326521.550000002
   },
   {
    "ndc11": "16729027638",
    "product_name": "Fluorourac",
    "rows": 857,
    "years_covered": 4,
    "medicaid_reimbursed_usd": 4744115.33
   },
   {
    "ndc11": "63323011720",
    "product_name": "FLUOROURAC",
    "rows": 738,
    "years_covered": 4,
    "medicaid_reimbursed_usd": 3410847.3899999997
   },
   {
    "ndc11": "63323011761",
    "product_name": "FLUOROURAC",
    "rows": 873,
    "years_covered": 4,
    "medicaid_reimbursed_usd": 2384789.79
   },
   {
    "ndc11": "16729027611",
    "product_name": "Fluorourac",
    "rows": 425,
    "years_covered": 4,
    "medicaid_reimbursed_usd": 1409314.6200000006
   }
  ],
  "detail_rows_returned": 15,
  "detail_rows_total": 32,
  "sql_executed": []
 },
 "unit": "USD",
 "result_status": "answered_with_caveats",
 "methodology_era": {
  "era_name": "openfda_enforcement_post_2009",
  "era_start": "2009-01-01",
  "era_end": "2099-12-31"
 },
 "methodology_blend_factors": null,
 "source": {
  "source_url": "medicare://recall_spend_window"
 },
 "vintage": "as_restated",
 "cms_vintage_sequence": 1,
 "parse_revision": 1,
 "as_of_observed": null,
 "as_of_asserted": null,
 "as_of_effective": null,
 "caveats": [
  {
   "caveat_type": "coverage_gap",
   "severity": "info",
   "message": "Part D spending and Medicaid SDUD are ANNUAL. Spend is aggregated over whole calendar years that intersect the recall window, so a recall opened mid-year carries that whole year's spend, not the part of it inside the window.",
   "structured_fields": {}
  }
 ],
 "confidence": 1.0,
 "confidence_basis": "tool_measured",
 "finality_confidence": null,
 "response_hash": "6e25c8ec11df775c6c7716d51e2905067218b8f2599e01dab72920db0d3fca04",
 "semantic_version": 2,
 "tool_version": "2.0.0",
 "parser_artifact_hash": "0b11193fb97519397f53ffe2917938b1bf95f408fccb5bae6d356b17ef22a148",
 "parser_artifact_hash_basis": "tool_source_sha256",
 "signature": null,
 "tenant_id": "probe-customer-canary",
 "status": "complete",
 "audit_id": "b116a02e-001d-4226-a2d5-66e12d5200f5",
 "timestamp": "2026-11-09T21:38:46.159735Z",
 "request_id": "0fd9feee-d5ff-4bf5-9297-1106983883dd",
 "audience": "customer",
 "answer": {
  "value": 22744256.999999996,
  "value_ref": "value",
  "unit": "USD",
  "scope": {
   "tool": "recall_spend_window",
   "filters": {
    "recall_number": "D-1489-2019",
    "detail_limit": 5
   }
  }
 },
 "method": "Read from the CMS publication. The published values are reported as published, with no adjustment or modelling applied.",
 "evidence": {
  "response_hash": "6e25c8ec11df775c6c7716d51e2905067218b8f2599e01dab72920db0d3fca04",
  "audit_id": "b116a02e-001d-4226-a2d5-66e12d5200f5",
  "request_id": "0fd9feee-d5ff-4bf5-9297-1106983883dd"
 }
}

What comes back

Sources

Known limits (2)

1. 1medicaid_sdud_suppression_used_flag
2. 2part_d_puf_annual_grain_only