Pharmaceutical Sample Data: Prescriptions, Drug Inventory and Clinical Trial Subjects
Pharmacy systems, supply chain reports and clinical trial dashboards all need drug-shaped data. Generate prescriptions, drug inventory and trial subjects in your browser, free, without using any real patient or product data.
Three pharma datasets
Prescriptions has a prescription id, patient id, generic drug name, drug class, strength, dosage form, dose frequency, days supply, prescriber NPI, pharmacy, status and date. Drug inventory has an NDC-style code, drug, strength, form, manufacturer, batch number, quantity on hand, unit cost, manufacturing date and expiry date. Clinical trial subjects has a subject id, trial id, phase, therapeutic area, site, arm (Placebo, Low dose, High dose or Active comparator), age, gender, enrolment date, adverse event, severity and causality.
Drug details that stay together
The drug name, class, strength and form come from one entry, so Metformin is always a Biguanide at 500 mg as a tablet, and Insulin glargine is always an injection pen. The list uses about 30 common generic drugs. The strengths are typical ones, not dosing advice.
Statuses and adverse events use weights rather than equal chances. Most prescriptions are Filled, most adverse events are Mild, and about 45 percent of trial subjects have no adverse event recorded, which keeps the empty cells you would see in real trial data.
Queries worth building
For inventory, find stock that expires soon: SELECT drug_name, batch_number, expires_on, quantity_on_hand FROM drug_inventory WHERE expires_on < DATE '2026-06-30' ORDER BY expires_on; Run it in SQL on Your Files. For trials, count adverse events by arm to build a safety table, and compare the Placebo arm with the dose arms.
What to use it for
Use it to test pharmacy or ERP software, prototype an expiry-date alert, build a Power BI report for a supply chain team, teach SQL group by and date filters, or demo a clinical data tool without real subjects. Download Parquet for a data lake test or CSV for Excel.
What it is not
Everything is random and fictional. The NDC-style codes follow the 5-4-2 layout but are not real product codes, trial ids follow the NCT pattern but are not real registered trials, and manufacturers and pharmacies are invented names. The NPI numbers pass the check-digit test but are random, so one could match a real provider by chance. Do not use the data for safety conclusions, regulatory work or real prescribing. For the related healthcare datasets, see fake patient data.
Related tool pages
- Fake Data Generator: Generate realistic fake data online: names, emails, addresses, dates and more, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- Test Data Generator: Generate test data for databases and apps: names, emails, addresses, dates and numbers, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- Student Data Generator: Fake Student Records: Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
- Student Marks Dataset Generator: Create a student marks dataset by student, subject and exam for SQL, Excel pivot tables and charts. Free, in your browser.
- Sample Data for SQL Practice: Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
- Dummy Data for Excel Practice: Generate dummy sales, student or employee data and download Excel to practise filters, pivot tables and VLOOKUP. Free.
Also try
How to use the Data Generator: step by step
- Open the Data Generator and pick Prescriptions, Drug inventory or Clinical trial subjects.
- Choose the number of rows.
- Pick CSV, Excel, JSON or Parquet.
- Download the file and load it where you need it.
When to use the Data Generator
- Test pharmacy or ERP software
- Build an expiry-date alert report
- Practise SQL on adverse events by trial arm
- Demo a clinical data tool without real subjects
Example
Input: Dataset: Customers, 3 rows
Output: id,name,email 1,Maya Patel,maya.patel@example.com 2,Leo Fischer,leo.fischer@example.com
Frequently asked questions
Are the drug names and strengths real?
The drug names are real generic names and the strengths are common ones, so the data looks right. The rows are random and are not prescribing information.
Are the NDC codes and trial ids real?
No. They follow the usual layouts (5-4-2 for NDC, NCT plus eight digits for trials) but are random, so they do not point to real products or registered trials.
Why are some adverse event cells empty?
About 45 percent of trial subjects have no adverse event, as in real studies. You can change that share by editing the column's empty percentage in the generator.
Tip: Remove the columns you do not need before downloading. A smaller file loads faster in Excel and is easier to review.