Prescription Records

This dataset provides comprehensive prescription records, detailing medication names, dosages, refill counts, prescribing doctors, and pharmacy information. It enables robust tracking of medication dispensing, supports compliance auditing, and facilitates analysis of prescribing patterns and pharmacy utilization. Ideal for healthcare providers, researchers, and pharmacy management systems.

  • opened 5 times
  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Medication adherence and refill tracking

Sample rows

preview · 8 of 200 rows · all 22 columns
prescription_idstringdosage_amountfloatis_genericbooleanfrequencystringpatient_idstringdrug_namestringdosage_unitstringquantity_prescribedintegerrefills_allowedintegerrefills_remainingintegerprescription_datedatedoctor_idstringdoctor_namestringdoctor_license_numberstringpharmacy_idstringpharmacy_namestringpharmacy_street_addressstringpharmacy_citystringpharmacy_statestringpharmacy_postal_codestringpharmacy_countrystringnotesstring
RX0001-2021500truetwice dailyPT493820Metformin Hydrochloridemg60662021-03-17DR23715Dr. Judith ThompsonLIC-USA-938271PH1023CVS Pharmacy310 Market StSan JoseCA95112USATake with evening meal. Monitor blood sugar.
RX0002-2019250trueonce dailyPT284692Azithromycinmg5002019-11-02DR48176Dr. Marcus EllisonLIC-USA-472818PH2097Walgreens4418 Sunset BlvdLos AngelesCA90027USAFinish all medication. No alcohol while taking.
RX0003-202275trueonce dailyPT593124Levothyroxine Sodiummcg30322022-02-10DR19237Dr. Emily WuLIC-USA-731028PH1007Rite Aid98 Lincoln AvePhiladelphiaPA19123USATake on empty stomach in morning.
RX0004-202040falseonce dailyPT410987Lipitormg30222020-06-21DR27316Dr. Daniel LeeLIC-USA-829173PH1094Target Pharmacy245 King StSan FranciscoCA94107USAAvoid grapefruit and grapefruit juice.
RX0005-2018875truetwice dailyPT202785Amoxicillinmg14002018-12-03DR55923Dr. Samantha ClarkLIC-USA-347281PH1087Walmart Pharmacy1200 Ridge RdCheyenneWY82009USATake with food. May cause upset stomach.
RX0006-202210trueonce dailyPT604828Lisinoprilmg30442022-07-28DR38219Dr. Brian PatelLIC-USA-692054PH1048Kroger Pharmacy200 Elm StHoustonTX77002USAMonitor blood pressure regularly.
RX0007-202350falsereplace every 72 hoursPT298176Fentanylpatch10112023-01-11DR28531Dr. Jonathan SmithLIC-USA-385720PH1124CVS Pharmacy875 Oak DrDallasTX75201USAApply to clean dry skin. Keep away from heat.
RX0008-201940trueonce dailyPT100923Enoxaparinmg7002019-08-30DR40927Dr. Olivia ChenLIC-USA-512389PH1099Safeway Pharmacy1760 BroadwayDenverCO80202USAInject subcutaneously. Rotate injection sites.

What the 200 rows show

from the 200-row sample
  • 83%is_generic = true
  • 40.0median dosage_amount
  • 10dosage units
  • 12pharmacy countries
  • 46pharmacy states
  • 59pharmacy names
dosage_amount200 rows, in bands of 1,000
010020019430000000305,00010kdosage_amount →

Median 40.0, from 0.07 to 10,000.

frequency200 rows · top 10 of 34 values
  1. once daily93
  2. twice daily23
  3. once daily at bedtime10
  4. every 6 hours as needed8
  5. three times daily7
  6. at bedtime6
  7. replace every 72 hours5
  8. once daily before breakfast4
  9. once daily in morning4
  10. once daily for 7 days3
22 columns by typefrom the column list below
  • string 16
  • integer 3
  • float 1
  • date 1
  • boolean 1

Columns

22 columns in four groups
blueprint · 22 columns
columntypedescriptionexample
Text 16 columns
prescription_idstringUnique identifier for each prescription recorduniqueRX0001-2021
patient_idstringUnique identifier for the patient receiving the prescriptionPT493820
drug_namestringName of the prescribed medicationMetformin Hydrochloride
dosage_unitstringUnit of dosage (e.g., mg, ml, tablet)8 valuesmg
frequencystringHow often the medication should be taken (e.g., twice daily, every 8 hours)twice daily
doctor_idstringUnique identifier for the prescribing doctorDR23715
doctor_namestringFull name of the prescribing doctorDr. Judith Thompson
doctor_license_numberstringMedical license number of the prescribing doctorLIC-USA-938271
pharmacy_idstringUnique identifier for the pharmacy dispensing the medicationPH1023
pharmacy_namestringName of the pharmacyCVS Pharmacy
pharmacy_street_addressstringStreet address of the pharmacy310 Market St
pharmacy_citystringCity where the pharmacy is locatedSan Jose
pharmacy_statestringState where the pharmacy is locatedCA
pharmacy_postal_codestringPostal code of the pharmacy95112
pharmacy_countrystringCountry where the pharmacy is located12 countriesUSA
notesstringAdditional notes or instructions related to the prescriptionoptionalTake before breakfast.
Numbers 4 columns
dosage_amountfloatAmount of medication per dose (e.g., 500)0.01 or more500
quantity_prescribedintegerTotal quantity of medication prescribed1 or more60
refills_allowedintegerNumber of refills permitted for this prescription0 or more6
refills_remainingintegerNumber of refills still available0 or more6
Dates and times 1 column
prescription_datedateDate the prescription was issued2021-03-17
True or false 1 column
is_genericbooleanIndicates if the prescribed drug is a generic equivalenttrue

Use it for

  • is generic83%165 of 200 rows

    A healthcare dashboard

    The is_generic rate, dosage_amount and a breakdown of frequency. Excel, Power BI or Tableau.

  • Why do 165 of 200 rows have is_generic = true?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

    Believable prescriptions with patient_id, drug_name and dosage_amount 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 dataset200 rows22 columns
Yours1,000 rows22 columnspharmacy_street_address: UK only

blueprint · prescription-records

Behind this dataset

Same schema. As many rows as you need.

These 200 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
  • Prescription number unique per script
  • Dosage and frequency specified
  • Refills remaining and total authorized
  • Prescribing physician DEA number
  • Expiration date for prescription validity
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
prescription-records

More in Healthcare

Browse all
Also in HealthcareHealthcare Medication Adherence DatasetEmergency Department Triage PatternsHealthcare-Insurance Claims IntegrationAll 1,966 datasets
In collectionsPharmacy and Prescription Datasets

What should your data show?

Preview 20 rows free
No signup. No card.