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.
Sample rows
preview · 8 of 200 rows · all 31 columns| order_idstring | storage_conditionstring | quantity_orderedinteger | stockout_flagboolean | carrier_namestring | order_datedatetime | supplier_idstring | supplier_namestring | product_idstring | product_namestring | batch_numberstring | expiration_datedate | unit_of_measurestring | order_statusstring | shipment_idstring | shipment_datedatetime | tracking_numberstring | expected_delivery_datedate | actual_delivery_datedate | destination_facility_idstring | destination_facility_namestring | destination_street_addressstring | destination_citystring | destination_statestring | destination_postal_codestring | destination_countrystring | storage_location_idstring | storage_entry_datedatetime | storage_exit_datedatetime | current_inventory_levelinteger | last_updateddatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ORD00001 | room temperature | 5000 | false | DHL Express | 2023-02-14T09:32:00Z | SUP001 | Global Pharma Inc. | PRD1001 | Atorvastatin Calcium Tablets | ATC202302A | 2025-03-31 | tablets | delivered | SHIP1001A | 2023-02-15T14:12:00Z | DHL998774 | 2023-02-18 | 2023-02-18 | FAC001 | Midtown General Hospital | 123 Elm Street | Chicago | IL | 60611 | USA | STOR01 | 2023-02-18T16:20:00Z | blank | 5400 | 2023-02-18T18:05:00Z |
| ORD00002 | refrigerated | 100 | false | UPS Healthcare | 2023-02-15T11:27:00Z | SUP002 | Northway Biologics Ltd. | PRD1002 | Influenza Vaccine Quadrivalent | INFQV2023B | 2024-12-15 | vials | shipped | SHIP1002B | 2023-02-16T10:10:00Z | UPSFLU1234 | 2023-02-19 | blank | FAC002 | Maple Pharmacy | 77 Maple Avenue | Minneapolis | MN | 55401 | USA | COOL01 | blank | blank | 100 | 2023-02-16T10:11:00Z |
| ORD00003 | room temperature | 8000 | false | FedEx Supply Chain | 2023-02-19T13:51:00Z | SUP003 | Cardio Health Solutions | PRD1003 | Metoprolol Tartrate Tablets | MET20230215 | 2026-02-15 | tablets | delivered | SHIP1003C | 2023-02-20T08:00:00Z | FDXMTPL234 | 2023-02-22 | 2023-02-22 | FAC003 | Green Valley Clinic | 201 Oak Lane | Dallas | TX | 75201 | USA | STOR02 | 2023-02-22T12:16:00Z | blank | 8320 | 2023-02-22T14:35:00Z |
| ORD00004 | controlled substance | 20 | false | blank | 2023-02-23T17:42:00Z | SUP004 | EuroPharm Distribution | PRD1004 | Oxycodone Hydrochloride Capsules | OXY2023C02 | 2025-02-28 | capsules | pending | blank | blank | blank | blank | blank | FAC004 | Emerald Rehabilitation Center | 45 Cedar Boulevard | New York | NY | 10016 | USA | blank | blank | blank | 0 | 2023-02-23T17:43:00Z |
| ORD00005 | blank | 200 | true | blank | 2023-03-01T10:00:00Z | SUP005 | AmeriMeds Wholesale | PRD1005 | Amoxicillin Oral Suspension | AMX20230301 | 2025-09-30 | bottles | cancelled | blank | blank | blank | blank | blank | FAC005 | Downtown Family Pharmacy | 49 Main Street | Denver | CO | 80202 | USA | blank | blank | blank | 0 | 2023-03-01T10:02:00Z |
| ORD00006 | refrigerated | 80 | false | Cardinal Health | 2023-03-02T15:20:00Z | SUP002 | Northway Biologics Ltd. | PRD1006 | Human Insulin Injection Vial | INS20230302A | 2025-03-28 | vials | shipped | SHIP1006A | 2023-03-03T17:00:00Z | CRDINS980 | 2023-03-06 | blank | FAC006 | St. George's Hospital | 2201 Pine Street | Philadelphia | PA | 19103 | USA | COOL02 | blank | blank | 80 | 2023-03-03T17:01:00Z |
| ORD00007 | frozen | 3000 | false | UPS Healthcare | 2023-03-05T08:12:00Z | SUP006 | VaccineWorks Europe | PRD1007 | COVID-19 mRNA Vaccine | COV19MRNA2023A | 2024-09-04 | doses | delivered | SHIP1007A | 2023-03-06T11:15:00Z | UPSCOVID7A | 2023-03-08 | 2023-03-08 | FAC007 | Harmony Medical Center | 5 Willow Road | Houston | TX | 77002 | USA | FZR01 | 2023-03-08T13:30:00Z | blank | 2950 | 2023-03-08T14:08:00Z |
| ORD00008 | room temperature | 36 | false | FedEx Supply Chain | 2023-03-07T13:44:00Z | SUP003 | Cardio Health Solutions | PRD1008 | Epinephrine Auto-Injector | EPI20230307 | 2025-08-31 | pens | delivered | SHIP1008A | 2023-03-08T08:55:00Z | FDXEPI888 | 2023-03-09 | 2023-03-09 | FAC008 | Sunrise Outpatient Clinic | 238 Lakeview Drive | Seattle | WA | 98101 | USA | STOR03 | 2023-03-09T10:20:00Z | blank | 36 | 2023-03-09T13:00:00Z |
| ORD00009 | hazardous | 16 | true | AmerisourceBergen | 2023-03-10T15:21:00Z | SUP007 | Nova Chem Corporation | PRD1009 | Methotrexate Injection | MTX20230310 | 2024-07-31 | ampules | delivered | SHIP1009A | 2023-03-11T11:32:00Z | AMSBMTX16 | 2023-03-13 | 2023-03-13 | FAC009 | Redwood Cancer Institute | 98 Redwood Road | San Francisco | CA | 94117 | USA | HAZ01 | 2023-03-13T12:00:00Z | blank | 0 | 2023-03-13T12:09:00Z |
| ORD00010 | controlled substance | 24 | false | blank | 2023-03-12T09:50:00Z | SUP008 | Nordic Pharma AS | PRD1010 | Diazepam Rectal Gel | DZP20230312A | 2026-03-31 | tubes | pending | blank | blank | blank | blank | blank | FAC010 | Bayshore Children’s Hospital | 11 Harbor View | Miami | FL | 33136 | USA | blank | blank | blank | 0 | 2023-03-12T09:51:00Z |
| ORD00011 | room temperature | 10000 | false | FedEx Supply Chain | 2023-04-01T08:15:00Z | SUP009 | Bayer Healthcare | PRD1011 | Levothyroxine Sodium Tablets | LEV20230401 | 2026-04-30 | tablets | delivered | SHIP1011A | 2023-04-02T16:00:00Z | FDXLEV0110 | 2023-04-05 | 2023-04-05 | FAC011 | Saint Michael Hospital | 355 Lake Street | Buffalo | NY | 14202 | USA | STOR04 | 2023-04-05T19:20:00Z | blank | 10250 | 2023-04-05T20:00:00Z |
| ORD00012 | blank | 250 | true | blank | 2023-04-02T10:12:00Z | SUP010 | Medline Canada | PRD1012 | Clopidogrel Bisulfate Tablets | CLOP20230402 | 2025-05-30 | boxes | cancelled | blank | blank | blank | blank | blank | FAC012 | Queen Victoria Medical Center | 17 Queen Street | Toronto | ON | M5G2C2 | Canada | blank | blank | blank | 0 | 2023-04-02T10:13:00Z |
| ORD00013 | controlled substance | 12 | true | McKesson Medical | 2023-04-07T12:04:00Z | SUP011 | Sandoz Pharmaceuticals | PRD1013 | Fentanyl Transdermal System | FEN20230407 | 2026-06-30 | patches | delivered | SHIP1013A | 2023-04-08T09:15:00Z | MCKFEN123 | 2023-04-10 | 2023-04-10 | FAC013 | Mercy Pain Management | 700 South St. | Edmonton | AB | T5J4B7 | Canada | CTRL01 | 2023-04-10T13:22:00Z | blank | 0 | 2023-04-10T14:00:00Z |
| ORD00014 | room temperature | 6000 | false | DHL Express | 2023-04-11T15:33:00Z | SUP012 | Berlin Arzneimittel | PRD1014 | Ibuprofen 400mg Tablets | IBU20230411 | 2026-05-31 | tablets | delivered | SHIP1014A | 2023-04-12T11:00:00Z | DHLIBU6000 | 2023-04-14 | 2023-04-14 | FAC014 | Universitätsklinikum Berlin | Charitéplatz 1 | Berlin | BE | 10117 | Germany | STOR05 | 2023-04-14T14:00:00Z | blank | 6100 | 2023-04-14T15:00:00Z |
| ORD00015 | refrigerated | 50 | true | blank | 2023-04-14T13:00:00Z | SUP002 | Northway Biologics Ltd. | PRD1002 | Influenza Vaccine Quadrivalent | INFQV2023C | 2024-12-15 | vials | backordered | blank | blank | blank | blank | blank | FAC015 | Norwegian Health Clinic | Storgata 50 | Oslo | OS | 0179 | Norway | blank | blank | blank | 0 | 2023-04-14T13:01:00Z |
| ORD00016 | room temperature | 247 | false | Bring Logistics | 2023-04-17T09:05:00Z | SUP013 | Norway Health Supply | PRD1015 | Paracetamol Oral Suspension | PARA20230417 | 2025-09-30 | bottles | delivered | SHIP1015A | 2023-04-18T08:45:00Z | BRGPARA247 | 2023-04-20 | 2023-04-20 | FAC016 | Oslo Pediatric Center | Dronning Eufemias gate 20 | Oslo | OS | 0191 | Norway | STOR06 | 2023-04-20T11:30:00Z | blank | 250 | 2023-04-20T12:00:00Z |
| ORD00017 | hazardous | 10 | true | AmerisourceBergen | 2023-04-18T16:10:00Z | SUP014 | Cytomed Pharmaceuticals | PRD1016 | Docetaxel Injection | DOC20230418B | 2025-11-30 | vials | delivered | SHIP1016A | 2023-04-19T10:10:00Z | AMSDOC010 | 2023-04-21 | 2023-04-21 | FAC017 | Walnut Oncology Center | 900 Walnut Ave | Columbus | OH | 43215 | USA | HAZ02 | 2023-04-21T13:00:00Z | blank | 0 | 2023-04-21T13:10:00Z |
| ORD00018 | room temperature | 600 | false | FedEx Supply Chain | 2023-04-20T12:55:00Z | SUP015 | Pfizer Inc. | PRD1017 | Amlodipine Besylate Tablets | AML20230420A | 2025-12-31 | tablets | delivered | SHIP1017A | 2023-04-21T09:22:00Z | FDXAML0600 | 2023-04-23 | 2023-04-23 | FAC018 | St. Lawrence Hospital | 44 University Ave | Kingston | ON | K7L3N6 | Canada | STOR07 | 2023-04-23T14:00:00Z | blank | 650 | 2023-04-23T16:10:00Z |
| ORD00019 | room temperature | 9999 | false | DHL Express | 2023-04-25T10:25:00Z | SUP001 | Global Pharma Inc. | PRD1001 | Atorvastatin Calcium Tablets | ATC20230425 | 2026-06-30 | tablets | delivered | SHIP1001B | 2023-04-26T15:00:00Z | DHL998799 | 2023-04-29 | 2023-04-29 | FAC019 | Westside Medical Center | 88 Westside Blvd | Los Angeles | CA | 90017 | USA | STOR08 | 2023-04-29T17:30:00Z | blank | 10000 | 2023-04-29T17:40:00Z |
| ORD00020 | refrigerated | 80 | false | UPS Healthcare | 2023-04-28T16:10:00Z | SUP002 | Northway Biologics Ltd. | PRD1002 | Influenza Vaccine Quadrivalent | INFQV2023D | 2024-12-15 | vials | shipped | SHIP1002C | 2023-04-29T09:00:00Z | UPSFLU2102 | 2023-05-01 | blank | FAC020 | Evergreen Pediatrics | 1200 Spruce Drive | Portland | OR | 97209 | USA | COOL03 | blank | blank | 80 | 2023-04-29T09:01:00Z |
What the 200 rows show
from the 200-row sampleRoom temperature (storage condition) stands out: mean quantity_
- 13%stockout_
flag = true - 80median quantity_
ordered - 4destination countries
- 5order statuses
- 13unit of measures
- 44destination states
Median 80, from 0 to 10,000.
- string 20
- integer 2
- date 3
- datetime 5
- boolean 1
Columns
31 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
order_id | string | Unique identifier for each pharmaceutical orderunique | ORD00001 |
supplier_id | string | Unique identifier for the supplier providing the pharmaceuticals | SUP001 |
supplier_name | string | Name of the supplier | Global Pharma Inc. |
product_id | string | Unique identifier for the pharmaceutical product | PRD1001 |
product_name | string | Name of the pharmaceutical product | COVID-19 mRNA Vaccine |
batch_number | string | Batch or lot number of the pharmaceutical product | ATC202302A |
unit_of_measure | string | Unit of measure for the product (e.g., tablets, vials, boxes) | tablets |
order_status | string | Current status of the order (e.g., pending, shipped, delivered, cancelled)pending · shipped · delivered · cancelled · backordered | delivered |
shipment_id | string | Unique identifier for the shipment associated with the orderoptional | SHIP1001A |
carrier_name | string | Name of the shipping carrier or logistics provideroptional | DHL Express |
tracking_number | string | Shipment tracking number provided by the carrieroptional | DHL998774 |
destination_facility_id | string | Unique identifier for the destination facility (e.g., hospital, pharmacy, warehouse) | FAC001 |
destination_facility_name | string | Name of the destination facility | Midtown General Hospital |
destination_street_address | string | Street address of the destination facility | 123 Elm Street |
destination_city | string | City of the destination facility | Chicago |
destination_state | string | State or province of the destination facility | IL |
destination_postal_code | string | Postal or ZIP code of the destination facility | 60611 |
destination_country | string | Country of the destination facility4 countries | USA |
storage_location_id | string | Unique identifier for the storage location within the facility (e.g., warehouse section, cold room)optional | STOR01 |
storage_condition | string | Storage condition required for the pharmaceutical (e.g., refrigerated, room temperature, frozen)5 values · optional | room temperature |
| Numbers 2 columns | |||
quantity_ordered | integer | Total quantity of product ordered1 or more | 5000 |
current_inventory_level | integer | Current inventory level of the product at the destination facility after this transaction0 or more · optional | 5400 |
| Dates and times 8 columns | |||
order_date | datetime | Date and time when the order was placed | 2023-02-14T09:32:00Z |
expiration_date | date | Expiration date of the pharmaceutical batch | 2025-03-31 |
shipment_date | datetime | Date and time when the shipment was dispatchedoptional | 2023-02-15T14:12:00Z |
expected_delivery_date | date | Expected delivery date for the shipmentoptional | 2023-02-18 |
actual_delivery_date | date | Actual date when the shipment was deliveredoptional | 2023-02-18 |
storage_entry_date | datetime | Date and time when the shipment was entered into storageoptional | 2023-02-18T16:20:00Z |
storage_exit_date | datetime | Date and time when the shipment left storage (e.g., for distribution or use)optional | |
last_updated | datetime | Timestamp of the last update to this record | 2023-02-18T18:05:00Z |
| True or false 1 column | |||
stockout_flag | boolean | Indicates whether a stockout occurred as a result of this transactionoptional | false |
15 SQL practice questions for the Pharmaceutical Inventory Supply Chains
Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.
Large delivered orders
Return order_id, product_name and quantity_ordered for every order whose order_status is 'delivered' and whose quantity_ordered is at least 5000. Sort by quantity_ordered from highest to lowest, then by order_id in ascending order.
Tables: pharmaceutical_inventory_supply_chains · your result: 3 columns, 33 rowsDistinct carriers
Return the distinct carrier_name values that are not null, sorted alphabetically. Return a single column named carrier_name.
Tables: pharmaceutical_inventory_supply_chains · your result: 1 columns, 16 rowsOrders per status
Count the orders for each order_status. Return order_status and order_count, sorted by order_count from highest to lowest, then by order_status in ascending order.
Tables: pharmaceutical_inventory_supply_chains · your result: 2 columns, 5 rows
- 04Quantity by countryBeginner
- 05Stockout orders by storage conditionPower BI
- 06Suppliers with many ordersIntermediate
- 07Order size bucketsIntermediate
- 08Orders per monthIntermediate
- 09Countries above average quantityIntermediate
- 10Late delivery rate by carrierPower BI
- 11Top two orders per country by quantityAdvanced
- 12Days since previous order per supplierAdvanced
- 13Running total of quantity by monthAdvanced
- 14Share of quantity by storage conditionAdvanced
- 15Inventory anomalies versus product averagePower BI
Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.
Get the practice kit · $3.99Use it for
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.
- Orders200ORD000015000room tem…ORD00005200—ORD0000916hazardous
A software demo
Believable orders with order_
date, supplier_ id and supplier_ name to fill a screen in front of a buyer.
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.
- Inventory tracked by SKU and batch number
- Temperature-sensitive items logged
- Stockouts and overages recorded
- Suppliers and distributors anonymized
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-inventory-supply-chains