E-Prescribing and Medication Orders

This dataset provides comprehensive electronic prescription records, including detailed medication information, standardized RxNorm codes, prescriber and pharmacy identifiers, and SCRIPT message tracking for order and dispensing events. It enables robust analysis of prescribing patterns, medication safety, and pharmacy workflow optimization, supporting interoperability across healthcare systems.

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

Medication safety and adherence analysis

Sample rows

preview · 8 of 120 rows · all 24 columns
prescription_idstringscript_message_typestringrefillsintegerpharmacy_statestringpatient_idstringdrug_namestringrxnorm_codestringdose_amountfloatdose_unitstringfrequencystringquantityintegerprescriber_idstringprescriber_namestringprescriber_npistringpharmacy_idstringpharmacy_namestringpharmacy_street_addressstringpharmacy_citystringpharmacy_postal_codestringpharmacy_countrystringscript_message_idstringscript_message_datetimedatetimedispense_datedatenotesstring
RX1001NewRx3MAP00001Simvastatin86635040mgonce daily90DR101Dr. Richard Adams1223344556PHARM01CVS Pharmacy123 Main StBoston02108USASM10012023-01-15T09:45:002023-01-15Take in the evening as prescribed
RX1002NewRx2ILP00002Lisinopril29046220mgonce daily30DR102Dr. Susan Miller1234567890PHARM02Walgreens Pharmacy44 Charles StChicago60602USASM10022023-01-16T14:15:002023-01-16Monitor blood pressure regularly
RX1003NewRx4FLP00003Metformin860975500mgtwice daily60DR103Dr. Alan Choi1357924680PHARM03Walmart Pharmacy202 Oak DrOrlando32801USASM10032023-01-17T10:22:002023-01-17Take with food to reduce stomach upset
RX1004NewRx2MAP00004Levothyroxine19736175mcgonce daily90DR104Dr. Emily Nguyen1122334455PHARM04CVS Pharmacy1050 Beacon StBrookline02446USASM10042023-01-18T08:30:002023-01-18Take on empty stomach
RX1005NewRx0NYP00005Amoxicillin723500mgq8h x7 days21DR105Dr. Maria Lopez1212121212PHARM05Rite Aid Pharmacy82 Hudson AveAlbany12207USASM10052023-01-19T15:05:002023-01-19Finish all medication
RX1006NewRx0CAP00006Azithromycin310798250mgonce daily x5 days5DR106Dr. William Brown1333444555PHARM06Walgreens Pharmacy98 Park StSan Diego92101USASM10062023-01-20T12:00:002023-01-20Take with food
RX1007NewRx0NYP00007Prednisone864020mgonce daily x5 days5DR107Dr. Hannah Lee1098765432PHARM07CVS Pharmacy333 BroadwayNew York10007USASM10072023-01-22T11:10:002023-01-22Taper dose as instructed
RX1008NewRx5TXP00008Atorvastatin61731420mgonce daily90DR108Dr. Michael Smith1667788990PHARM08Walmart Pharmacy400 Elm StDallas75201USASM10082023-01-23T08:50:002023-01-23Take at bedtime

What the 120 rows show

from the 120-row sample

RefillRequest (script message type) stands out: mean refills is 2.9, against 1.1 for the rest.

  • 1median refills
  • 5dose units
  • 5pharmacy countries
  • 10pharmacy names
  • 14frequencies
  • 23drug names
Mean refills by script_message_type120 rows
0241.2NewRx57 rows2.9Refill…25 rows0.0Cancel…10 rows1.4RxChan…5 rows1.4RxFill23 rows
refills120 rows, in bands of 1
020403727341165036refills →

Median 1, from 0 to 6.

pharmacy_state93 rows with a value · 27 left blank
  1. CA14
  2. TX12
  3. MA8
  4. FL6
  5. ON6
  6. NY5
  7. IL4
  8. WA4
  9. AZ4
  10. GA4
24 columns by typefrom the column list below
  • string 19
  • integer 2
  • float 1
  • date 1
  • datetime 1

Columns

24 columns in three groups
blueprint · 24 columns
columntypedescriptionexample
Text 19 columns
prescription_idstringUnique identifier for each electronic prescription recorduniqueRX1001
patient_idstringUnique identifier for the patient receiving the medicationP00001
drug_namestringName of the prescribed drug or medicationSimvastatin
rxnorm_codestringStandardized RxNorm code for the prescribed medication866350
dose_unitstringUnit of measurement for the dose (e.g., mg, mL, tablet)5 unitsmg
frequencystringHow often the medication should be taken (e.g., 'once daily', 'q8h')once daily
prescriber_idstringUnique identifier for the healthcare provider who prescribed the medicationDR101
prescriber_namestringFull name of the prescriberDr. Richard Adams
prescriber_npistringNational Provider Identifier (NPI) for the prescriberoptional1223344556
pharmacy_idstringUnique identifier for the pharmacy where the prescription is sentPHARM01
pharmacy_namestringName of the pharmacy10 namesCVS Pharmacy
pharmacy_street_addressstringStreet address of the pharmacyoptional123 Main St
pharmacy_citystringCity where the pharmacy is locatedoptionalBoston
pharmacy_statestringState where the pharmacy is locatedoptionalMA
pharmacy_postal_codestringPostal code of the pharmacyoptional02108
pharmacy_countrystringCountry where the pharmacy is located5 countries · optionalUSA
script_message_typestringType of SCRIPT message (e.g., 'NewRx', 'RefillRequest', 'CancelRx', 'RxChangeRequest')NewRx · RefillRequest · CancelRx · RxChangeRequest · RxFillNewRx
script_message_idstringUnique identifier for the SCRIPT messageuniqueSM1001
notesstringAdditional notes or instructions related to the prescriptionoptionalTake on empty stomach
Numbers 3 columns
dose_amountfloatAmount of drug per dose0 or more40
quantityintegerTotal quantity of medication to be dispensed1 or more90
refillsintegerNumber of authorized refills for the prescription0 or more3
Dates and times 2 columns
script_message_datetimedatetimeDate and time when the SCRIPT message was sent2023-01-15T09:45:00
dispense_datedateDate when the medication was dispensed by the pharmacyoptional2023-01-15

Use it for

  • median refills1120 rowsmean refills by scrip…1.2NewRx2.9Refi…0.0Canc…1.4RxCh…

    A healthcare dashboard

    Refills by script_message_type and a breakdown of pharmacy_state. Excel, Power BI or Tableau.

  • Why do the 25 RefillRequest rows have a mean refills of 2.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 prescriptions with patient_id, drug_name and rxnorm_code to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 24 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 dataset120 rows24 columns
Yours1,000 rows24 columnspharmacy_street_address: UK only

blueprint · e-prescribing-and-medication-orders

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 24 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
  • Prescription ID unique per order
  • Drug name and RxNorm code (semantic clinical drug)
  • NDC (National Drug Code) for specific product
  • Strength and dose form (tablet, capsule, liquid)
  • Dose and frequency (e.g., 10mg twice daily)
  • Route of administration: oral, IV, topical, inhaled, etc.
  • Quantity to dispense (e.g., 30 tablets)
  • Refills authorized (0-11 or PRN)
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
e-prescribing-and-medication-orders

More in Healthcare

Browse all
Also in HealthcareDrug Interaction and Clinical Decision Support AlertsPharmacy Inventory OptimizationClaims Denials and Rejection ManagementAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.