Pharmaceutical Supply Chain and Drug Shortages

This dataset provides a detailed view of pharmaceutical supply chain operations, including drug inventory levels, wholesaler transactions, shortage events, backorders, alternative therapy recommendations, and FDA shortage notifications. It enables robust analysis of supply chain resilience, regulatory compliance, and clinical impact, supporting decision-making for healthcare providers, manufacturers, and policymakers.

  • opened 6 times
  • last updated 2 Nov 2025
  • by GoMask
The brief that made it

Monitoring and forecasting drug shortages across supply chains

Sample rows

preview · 8 of 100 rows · all 22 columns
drug_idstringshortage_statusstringbackorder_quantityintegerfda_shortage_reasonstringdrug_namestringndc_codestringmanufacturer_namestringwholesaler_idstringwholesaler_namestringtransaction_idstringtransaction_datedatetimequantity_orderedintegerquantity_suppliedintegerinventory_levelintegerinventory_last_updateddatetimeshortage_start_datedateshortage_end_datedatealternative_therapystringfda_shortage_notification_idstringfda_shortage_notification_datedatedrug_formstringdrug_strengthstring
DRG0001normal0blankAmoxicillin12345-6789-00PharmaGenWH001MedSupply Inc.TXN100012023-09-14T09:12:0050050012002023-09-14T09:15:00blankblankblankblankblankcapsule500mg
DRG0002normal0blankMetformin23456-1234-01HealthWorksWH002PharmaDirectTXN100022023-10-01T13:30:001000100025002023-10-01T13:33:00blankblankblankblankblanktablet850mg
DRG0003normal0blankIbuprofen34567-2345-02WellPharmWH001MedSupply Inc.TXN100032023-08-22T10:45:0080080016002023-08-22T10:48:00blankblankblankblankblanktablet200mg
DRG0004backorder20Manufacturing delayCeftriaxone45678-3456-03BioTherapeuticsWH003RxGlobalTXN100042023-08-05T15:20:002001806002023-08-05T15:23:002023-08-01blankCefotaximeFDA-SHORT-00012023-08-02injection1g/vial
DRG0005normal0blankLosartan56789-4567-04CardioCareWH002PharmaDirectTXN100052023-07-11T11:05:0060060014002023-07-11T11:08:00blankblankblankblankblanktablet50mg
DRG0006normal0blankAtorvastatin67890-5678-05LipidLabsWH004HealthProTXN100062023-09-09T14:17:0070070015002023-09-09T14:20:00blankblankblankblankblanktablet40mg
DRG0007shortage30Increased demandLevofloxacin78901-6789-06AntibiotixWH003RxGlobalTXN100072023-06-28T09:50:003002704002023-06-28T09:53:002023-06-25blankMoxifloxacinFDA-SHORT-00022023-06-26tablet500mg
DRG0008normal0blankHydrochlorothiazide89012-7890-07DiureticaWH001MedSupply Inc.TXN100082023-09-23T12:40:0090090023002023-09-23T12:43:00blankblankblankblankblanktablet25mg

What the 100 rows show

from the 100-row sample

Backorder (shortage status) stands out: mean backorder_quantity is 36.9, against 6.5 for the rest.

  • 0median backorder_quantity
  • 3drug forms
  • 23wholesalers
  • 23wholesaler names
  • 325median quantity_ordered
  • 325median quantity_supplied
Mean backorder_quantity by shortage_status70 rows
020400.0normal39 rows23.3shortage15 rows36.9backorder16 rows
backorder_quantity70 rows, in bands of 5
0204039040100701902550backorder_quantity →

Median 0, from 0 to 50.

fda_shortage_reason31 rows with a value · 69 left blank
  1. Manufacturing delay5
  2. Raw material shortage5
  3. Production issue4
  4. manufacturing delay4
  5. Increased demand3
  6. increased demand3
  7. Distribution problem2
  8. raw material shortage2
  9. Unexpected recall1
  10. distribution delay1
22 columns by typefrom the column list below
  • string 13
  • integer 4
  • date 3
  • datetime 2

Columns

22 columns in three groups
blueprint · 22 columns
columntypedescriptionexample
Text 13 columns
drug_idstringUnique identifier for each drug productuniqueDRG0001
drug_namestringCommercial or generic name of the drugAmoxicillin
ndc_codestringNational Drug Code for the drugunique12345-6789-00
manufacturer_namestringName of the drug manufacturerPharmaGen
wholesaler_idstringUnique identifier for the wholesalerWH001
wholesaler_namestringName of the wholesalerMedSupply Inc.
transaction_idstringUnique identifier for each wholesaler transactionuniqueTXN10001
shortage_statusstringCurrent shortage status of the drug (e.g., normal, shortage, backorder)normal · shortage · backordernormal
alternative_therapystringRecommended alternative therapy or substitute drugoptionalCefotaxime
fda_shortage_notification_idstringUnique identifier for FDA shortage notificationunique · optionalFDA-SHORT-0001
fda_shortage_reasonstringReason for the FDA shortage notification (e.g., manufacturing delay, increased demand)11 reasons · optionalManufacturing delay
drug_formstringForm of the drug (e.g., tablet, injection, capsule)3 formscapsule
drug_strengthstringStrength or concentration of the drug (e.g., 500mg, 10mg/ml)500mg
Numbers 4 columns
quantity_orderedintegerNumber of drug units ordered in the transaction1 or more500
quantity_suppliedintegerNumber of drug units supplied in the transaction0 or more500
inventory_levelintegerCurrent inventory level of the drug at the wholesaler0 or more1200
backorder_quantityintegerNumber of units currently on backorder for the drug0 or more · optional0
Dates and times 5 columns
transaction_datedatetimeDate and time of the wholesaler transaction2023-09-14T09:12:00
inventory_last_updateddatetimeTimestamp of the last inventory update for the drug2023-09-14T09:15:00
shortage_start_datedateDate when the shortage for the drug beganoptional2023-08-01
shortage_end_datedateDate when the shortage for the drug ended (if applicable)optional
fda_shortage_notification_datedateDate of FDA shortage notification for the drugoptional2023-08-02

Use it for

  • median backord…070 rowsmean backorder quanti…0.0normal23.3shorta…36.9backor…

    A logistics dashboard

    Backorder_quantity by shortage_status and a breakdown of fda_shortage_reason. Excel, Power BI or Tableau.

  • Why do the 16 backorder rows have a mean backorder_quantity of 36.9?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable drugs with drug_name, ndc_code and manufacturer_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 22 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset100 rows22 columns
Yours1,000 rows22 columns

blueprint · pharmaceutical-supply-chain-and-drug-shortages

Behind this dataset

Same schema. As many rows as you need.

These 100 rows came out of a blueprint — 22 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • NDC for drug product
  • Wholesaler: McKesson, Cardinal, AmerisourceBergen
  • Inventory levels: on-hand, reorder point, max level
  • Drug shortage status from FDA shortage list
  • Shortage reason: manufacturing, quality, discontinuation, demand surge
  • Backorder status and expected availability
  • Therapeutic alternatives identified
  • Conservation strategies: dose optimization, restricted use
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
pharmaceutical-supply-chain-and-drug-shortages

More in Logistics

Browse all
Also in LogisticsTelecom Infrastructure Supply Chain TrackerCold Chain Logistics Temperature DataDelivery Route Optimization DatasetAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.