Pharmaceutical Inventory Supply Chains

This dataset provides comprehensive, transaction-level records of pharmaceutical inventory supply chains, including order placement, shipment tracking, and storage history at destination facilities. It enables detailed analysis of logistics performance, inventory management, and stockout events, supporting optimization and risk mitigation in pharmaceutical distribution networks.

  • opened 43 times
  • last updated 29 Jul 2025
  • by GoMask
The brief that made it

Optimizing pharmaceutical logistics and delivery routes

Sample rows

preview · 8 of 200 rows · all 31 columns
order_idstringstorage_conditionstringquantity_orderedintegerstockout_flagbooleancarrier_namestringorder_datedatetimesupplier_idstringsupplier_namestringproduct_idstringproduct_namestringbatch_numberstringexpiration_datedateunit_of_measurestringorder_statusstringshipment_idstringshipment_datedatetimetracking_numberstringexpected_delivery_datedateactual_delivery_datedatedestination_facility_idstringdestination_facility_namestringdestination_street_addressstringdestination_citystringdestination_statestringdestination_postal_codestringdestination_countrystringstorage_location_idstringstorage_entry_datedatetimestorage_exit_datedatetimecurrent_inventory_levelintegerlast_updateddatetime
ORD00001room temperature5000falseDHL Express2023-02-14T09:32:00ZSUP001Global Pharma Inc.PRD1001Atorvastatin Calcium TabletsATC202302A2025-03-31tabletsdeliveredSHIP1001A2023-02-15T14:12:00ZDHL9987742023-02-182023-02-18FAC001Midtown General Hospital123 Elm StreetChicagoIL60611USASTOR012023-02-18T16:20:00Zblank54002023-02-18T18:05:00Z
ORD00002refrigerated100falseUPS Healthcare2023-02-15T11:27:00ZSUP002Northway Biologics Ltd.PRD1002Influenza Vaccine QuadrivalentINFQV2023B2024-12-15vialsshippedSHIP1002B2023-02-16T10:10:00ZUPSFLU12342023-02-19blankFAC002Maple Pharmacy77 Maple AvenueMinneapolisMN55401USACOOL01blankblank1002023-02-16T10:11:00Z
ORD00003room temperature8000falseFedEx Supply Chain2023-02-19T13:51:00ZSUP003Cardio Health SolutionsPRD1003Metoprolol Tartrate TabletsMET202302152026-02-15tabletsdeliveredSHIP1003C2023-02-20T08:00:00ZFDXMTPL2342023-02-222023-02-22FAC003Green Valley Clinic201 Oak LaneDallasTX75201USASTOR022023-02-22T12:16:00Zblank83202023-02-22T14:35:00Z
ORD00004controlled substance20falseblank2023-02-23T17:42:00ZSUP004EuroPharm DistributionPRD1004Oxycodone Hydrochloride CapsulesOXY2023C022025-02-28capsulespendingblankblankblankblankblankFAC004Emerald Rehabilitation Center45 Cedar BoulevardNew YorkNY10016USAblankblankblank02023-02-23T17:43:00Z
ORD00005blank200trueblank2023-03-01T10:00:00ZSUP005AmeriMeds WholesalePRD1005Amoxicillin Oral SuspensionAMX202303012025-09-30bottlescancelledblankblankblankblankblankFAC005Downtown Family Pharmacy49 Main StreetDenverCO80202USAblankblankblank02023-03-01T10:02:00Z
ORD00006refrigerated80falseCardinal Health2023-03-02T15:20:00ZSUP002Northway Biologics Ltd.PRD1006Human Insulin Injection VialINS20230302A2025-03-28vialsshippedSHIP1006A2023-03-03T17:00:00ZCRDINS9802023-03-06blankFAC006St. George's Hospital2201 Pine StreetPhiladelphiaPA19103USACOOL02blankblank802023-03-03T17:01:00Z
ORD00007frozen3000falseUPS Healthcare2023-03-05T08:12:00ZSUP006VaccineWorks EuropePRD1007COVID-19 mRNA VaccineCOV19MRNA2023A2024-09-04dosesdeliveredSHIP1007A2023-03-06T11:15:00ZUPSCOVID7A2023-03-082023-03-08FAC007Harmony Medical Center5 Willow RoadHoustonTX77002USAFZR012023-03-08T13:30:00Zblank29502023-03-08T14:08:00Z
ORD00008room temperature36falseFedEx Supply Chain2023-03-07T13:44:00ZSUP003Cardio Health SolutionsPRD1008Epinephrine Auto-InjectorEPI202303072025-08-31pensdeliveredSHIP1008A2023-03-08T08:55:00ZFDXEPI8882023-03-092023-03-09FAC008Sunrise Outpatient Clinic238 Lakeview DriveSeattleWA98101USASTOR032023-03-09T10:20:00Zblank362023-03-09T13:00:00Z

What the 200 rows show

from the 200-row sample

Room temperature (storage condition) stands out: mean quantity_ordered is 3,658, against 100.0 for the rest.

  • 13%stockout_flag = true
  • 80median quantity_ordered
  • 4destination countries
  • 5order statuses
  • 13unit of measures
  • 44destination states
Mean quantity_ordered by storage_condition190 rows
02,0004,00058.9refrig…48 rows3,658room t…103 rows1,505frozen2 rows61.2contro…23 rows103.9hazard…14 rows
quantity_ordered200 rows, in bands of 1,000
070140133103123106051805,00010kquantity_ordered →

Median 80, from 0 to 10,000.

carrier_name154 rows with a value · 46 left blank
  1. UPS Healthcare26
  2. FedEx Health25
  3. DHL Medical16
  4. FedEx Health Logistics15
  5. Cardinal Courier11
  6. FedEx Supply Chain10
  7. Amerisource Bergen9
  8. DHL Express8
  9. Cardinal Health8
  10. UPS Health8
31 columns by typefrom the column list below
  • string 20
  • integer 2
  • date 3
  • datetime 5
  • boolean 1

Columns

31 columns in four groups
blueprint · 31 columns
columntypedescriptionexample
Text 20 columns
order_idstringUnique identifier for each pharmaceutical orderuniqueORD00001
supplier_idstringUnique identifier for the supplier providing the pharmaceuticalsSUP001
supplier_namestringName of the supplierGlobal Pharma Inc.
product_idstringUnique identifier for the pharmaceutical productPRD1001
product_namestringName of the pharmaceutical productCOVID-19 mRNA Vaccine
batch_numberstringBatch or lot number of the pharmaceutical productATC202302A
unit_of_measurestringUnit of measure for the product (e.g., tablets, vials, boxes)tablets
order_statusstringCurrent status of the order (e.g., pending, shipped, delivered, cancelled)pending · shipped · delivered · cancelled · backordereddelivered
shipment_idstringUnique identifier for the shipment associated with the orderoptionalSHIP1001A
carrier_namestringName of the shipping carrier or logistics provideroptionalDHL Express
tracking_numberstringShipment tracking number provided by the carrieroptionalDHL998774
destination_facility_idstringUnique identifier for the destination facility (e.g., hospital, pharmacy, warehouse)FAC001
destination_facility_namestringName of the destination facilityMidtown General Hospital
destination_street_addressstringStreet address of the destination facility123 Elm Street
destination_citystringCity of the destination facilityChicago
destination_statestringState or province of the destination facilityIL
destination_postal_codestringPostal or ZIP code of the destination facility60611
destination_countrystringCountry of the destination facility4 countriesUSA
storage_location_idstringUnique identifier for the storage location within the facility (e.g., warehouse section, cold room)optionalSTOR01
storage_conditionstringStorage condition required for the pharmaceutical (e.g., refrigerated, room temperature, frozen)5 values · optionalroom temperature
Numbers 2 columns
quantity_orderedintegerTotal quantity of product ordered1 or more5000
current_inventory_levelintegerCurrent inventory level of the product at the destination facility after this transaction0 or more · optional5400
Dates and times 8 columns
order_datedatetimeDate and time when the order was placed2023-02-14T09:32:00Z
expiration_datedateExpiration date of the pharmaceutical batch2025-03-31
shipment_datedatetimeDate and time when the shipment was dispatchedoptional2023-02-15T14:12:00Z
expected_delivery_datedateExpected delivery date for the shipmentoptional2023-02-18
actual_delivery_datedateActual date when the shipment was deliveredoptional2023-02-18
storage_entry_datedatetimeDate and time when the shipment was entered into storageoptional2023-02-18T16:20:00Z
storage_exit_datedatetimeDate and time when the shipment left storage (e.g., for distribution or use)optional
last_updateddatetimeTimestamp of the last update to this record2023-02-18T18:05:00Z
True or false 1 column
stockout_flagbooleanIndicates whether a stockout occurred as a result of this transactionoptionalfalse

Use it for

  • stockout flag13%26 of 200 rowsmean quantity ordered…58.9refr…3.7kroom…1.5kfroz…61.2cont…

    A logistics dashboard

    The stockout_flag rate, quantity_ordered by storage_condition and a breakdown of carrier_name. Excel, Power BI or Tableau.

  • Why do the 103 room temperature rows have a mean quantity_ordered of 3,658?

    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 orders with order_date, supplier_id and supplier_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset200 rows31 columns
Yours10,000 rows31 columnsdestination_street_address: UK only

blueprint · pharmaceutical-inventory-supply-chains

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 31 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
  • Inventory tracked by SKU and batch number
  • Temperature-sensitive items logged
  • Stockouts and overages recorded
  • Suppliers and distributors anonymized
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
pharmaceutical-inventory-supply-chains

More in Logistics

Browse all
Also in LogisticsDisaster Relief Supply Chain TrackerLogistics Shipment Delay PredictionCold Chain Pharmaceutical Temp LogsAll 1,947 datasets
In collectionsPharmacy and Prescription Datasets

What should your data show?

Preview 20 rows free
No signup. No card.