Prescription Adherence Tracking

This dataset provides comprehensive tracking of patient prescription fills and refills, capturing detailed adherence metrics, patient demographics, medication details, and pharmacy information. It enables robust analysis of medication adherence patterns and supports outcome improvement strategies for healthcare providers and researchers.

  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Medication adherence analysis for clinical studies

Sample rows

preview · 8 of 200 rows · all 27 columns
adherence_idstringadherence_statusstringadherence_scorefloatoutcome_improvement_flagbooleanpharmacy_countrystringpatient_idstringpatient_first_namestringpatient_last_namestringpatient_date_of_birthdatepatient_genderstringprescription_idstringmedication_namestringmedication_dosagestringmedication_frequencystringprescribing_physician_idstringprescribing_physician_namestringpharmacy_idstringpharmacy_namestringpharmacy_street_addressstringpharmacy_citystringpharmacy_statestringpharmacy_postal_codestringfill_datedaterefill_numberintegerdays_supplyintegernext_refill_due_datedatenotesstring
ADH-0001adherent0.91trueUSAPAT-0001RobertMiller1951-03-22maleRX-0001Atorvastatin20mgonce dailyPHY-0001Dr. Lauren ChenPHARM-0001CVS Pharmacy123 Main StBostonMA021182024-02-120302024-03-13Patient receives app reminders for medication.
ADH-0002adherent0.84falseUSAPAT-0002PriyaSingh1976-08-06femaleRX-0002Metformin500mgtwice dailyPHY-0002Dr. Martin LopezPHARM-0002Walgreens456 Oak AveChicagoIL606162024-03-010602024-04-30Patient joined local diabetes support group.
ADH-0003unknownblankfalseUKPAT-0003JamesNguyen2009-10-15maleRX-0003Amoxicillin250mgas neededPHY-0003Dr. Emily FosterPHARM-0003Boots Pharmacy22 High StLondonGreater LondonEC1A 1BB2024-04-0507blankParent provided education on antibiotic course.
ADH-0004adherent0.88trueMexicoPAT-0004MariaGonzalez1984-12-04femaleRX-0004Lisinopril10mgonce dailyPHY-0004Dr. Sarah WuPHARM-0004Farmacias Guadalajara789 Calle JuarezGuadalajaraJalisco441002024-03-180302024-04-17Patient receives SMS reminders.
ADH-0005non-adherent0.33trueOmanPAT-0005AhmedAl-Farsi1959-11-11maleRX-0005Amlodipine5mgonce dailyPHY-0005Dr. Hassan FaroukPHARM-0005Al Shifa Pharmacy101 Sultan RdMuscatMuscat1122024-02-280602024-04-28Case manager performed phone intervention.
ADH-0006adherent0.97falseCanadaPAT-0006LucyDawson1970-09-21femaleRX-0006Levothyroxine50mcgonce dailyPHY-0006Dr. Robert GrantPHARM-0006Shoppers Drug Mart212 King St WTorontoONM5H 1K62024-03-070902024-06-05Patient has routine lab monitoring.
ADH-0007unknownblanktrueSpainPAT-0007SofiaMartinez2014-06-10femaleRX-0007Albuterol Inhaler2puffsas neededPHY-0007Dr. Juan PerezPHARM-0007Farmacia del Sol34 Calle RioMadridMadrid280122024-03-15030blankParent attended asthma education session.
ADH-0008adherent0.89falseUSAPAT-0008ThomasBrown1947-02-02maleRX-0008Warfarin2mgonce dailyPHY-0008Dr. Anna LeePHARM-0008Rite Aid88 Market StSan FranciscoCA941072024-03-100602024-05-09Home health nurse visits weekly.

What the 200 rows show

from the 200-row sample

Adherent (adherence status) stands out: mean adherence_score is 0.89, against 0.29 for the rest.

  • 51%outcome_improvement_flag = true
  • 0.88median adherence_score
  • 4patient genders
  • 5medication frequencies
  • 33medication dosages
  • 54medication names
Mean adherence_score by adherence_status171 rows
00.510.89adherent149 rows0.29non-adherent22 rows
adherence_score171 rows, in bands of 0.1
0459015564102826500.51adherence_score →

Median 0.88, from 0.03 to 0.99.

pharmacy_country200 rows · top 10 of 34 values
  1. USA60
  2. UK23
  3. Mexico12
  4. Canada10
  5. India9
  6. Germany9
  7. Russia7
  8. Brazil6
  9. France6
  10. Spain5
27 columns by typefrom the column list below
  • string 20
  • integer 2
  • float 1
  • date 3
  • boolean 1

Columns

27 columns in four groups
blueprint · 27 columns
columntypedescriptionexample
Text 20 columns
adherence_idstringUnique identifier for each prescription adherence recorduniqueADH-0001
patient_idstringUnique identifier for the patientPAT-0001
patient_first_namestringPatient's first nameRobert
patient_last_namestringPatient's last nameMiller
patient_genderstringPatient's gendermale · female · other · unknown · optionalmale
prescription_idstringUnique identifier for the prescriptionRX-0001
medication_namestringName of the prescribed medicationAtorvastatin
medication_dosagestringDosage of the medication (e.g., 10mg)20mg
medication_frequencystringFrequency of medication intake (e.g., once daily)5 frequenciesonce daily
prescribing_physician_idstringUnique identifier for the prescribing physicianPHY-0001
prescribing_physician_namestringName of the prescribing physicianoptionalDr. Lauren Chen
pharmacy_idstringUnique identifier for the pharmacyPHARM-0001
pharmacy_namestringName of the pharmacyoptionalCVS 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 pharmacyoptional02118
pharmacy_countrystringCountry where the pharmacy is locatedoptionalUSA
adherence_statusstringStatus indicating if the patient is adherent, non-adherent, or unknown for this filladherent · non-adherent · unknownadherent
notesstringAdditional notes or comments related to adherence or interventionsoptionalPatient receives app remi…
Numbers 3 columns
refill_numberintegerRefill sequence number for the prescription (0 for initial fill)0 or more0
days_supplyintegerNumber of days the medication supply is expected to last1 or more30
adherence_scorefloatCalculated adherence score for this fill (0.0 to 1.0)0 to 1 · optional0.91
Dates and times 3 columns
patient_date_of_birthdatePatient's date of birth1951-03-22
fill_datedateDate when the prescription was filled2024-02-12
next_refill_due_datedateDate when the next refill is due based on days supplyoptional2024-03-13
True or false 1 column
outcome_improvement_flagbooleanIndicates if an outcome improvement strategy was applied for this patient/prescriptionoptionaltrue

Use it for

  • outcome improv…51%102 of 200 rowsmean adherence score …0.89adhere…0.29non-ad…

    A healthcare dashboard

    The outcome_improvement_flag rate, adherence_score by adherence_status and a breakdown of pharmacy_country. Excel, Power BI or Tableau.

  • Why do the 149 adherent rows have a mean adherence_score of 0.89?

    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 adherences with patient_id, patient_first_name and patient_last_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 27 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 rows27 columns
Yours1,000 rows27 columnspharmacy_street_address: UK only

blueprint · prescription-adherence-tracking

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 27 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
  • Medication type and dosage recorded
  • Missed refills flagged
  • Patient demographics included
  • Adherence rates calculated monthly
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-adherence-tracking

What should your data show?

Preview 20 rows free
No signup. No card.