Prescription Adherence Monitoring
This dataset provides detailed tracking of patient prescription refills, medication details, and adherence assessments, enabling healthcare providers to identify and intervene with at-risk patients. It includes patient demographics, prescription and refill information, adherence scoring, and provider/pharmacy details, supporting comprehensive analysis of medication adherence patterns and outcomes.
Sample rows
preview · 8 of 80 rows · all 21 columns| adherence_idstring | adherence_statusstring | adherence_scorefloat | intervention_flagboolean | medication_dosestring | patient_idstring | patient_birth_datedate | patient_genderstring | prescription_idstring | medication_namestring | medication_frequencystring | prescription_start_datedate | prescription_end_datedate | prescribing_provider_idstring | pharmacy_idstring | refill_numberinteger | refill_datedate | days_supplyinteger | expected_next_refill_datedate | actual_next_refill_datedate | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ADH-001 | on-time | 1 | false | 500mg | PAT-1001 | 1963-07-14 | female | RX-4001 | Metformin | twice daily | 2023-10-01 | 2024-10-01 | PRV-2001 | PHM-3001 | 0 | 2023-10-01 | 30 | 2023-10-31 | 2023-10-31 | Initial fill, patient instructed on adherence |
| ADH-002 | late | 0.78 | true | 10mg | PAT-1002 | 1980-01-22 | male | RX-4002 | Lisinopril | once daily | 2023-09-15 | 2024-09-15 | PRV-2002 | PHM-3002 | 0 | 2023-09-15 | 30 | 2023-10-15 | 2023-10-17 | Patient notified about late refill |
| ADH-003 | early | 0.95 | false | 20mg | PAT-1003 | 1956-11-02 | female | RX-4003 | Atorvastatin | once nightly | 2023-06-10 | 2024-06-10 | PRV-2003 | PHM-3003 | 1 | 2023-07-10 | 30 | 2023-08-09 | 2023-08-07 | Refilled two days early |
| ADH-004 | late | 0.75 | true | 75mcg | PAT-1004 | 1972-03-30 | male | RX-4004 | Levothyroxine | once daily | 2023-03-01 | 2024-03-01 | PRV-2004 | PHM-3004 | 2 | 2023-05-01 | 90 | 2023-07-30 | 2023-08-10 | Late refill, flagged for follow-up |
| ADH-005 | on-time | 0.98 | false | 500mg | PAT-1001 | 1963-07-14 | female | RX-4001 | Metformin | twice daily | 2023-10-01 | 2024-10-01 | PRV-2001 | PHM-3005 | 1 | 2023-10-31 | 30 | 2023-11-30 | 2023-11-30 | Good adherence, no issues |
| ADH-006 | late | 0.79 | true | 5mg | PAT-1005 | 1990-05-12 | male | RX-4005 | Amlodipine | once daily | 2023-12-01 | 2024-12-01 | PRV-2005 | PHM-3001 | 0 | 2023-12-01 | 30 | 2023-12-31 | 2024-01-01 | 1 day late; patient reported travel |
| ADH-007 | on-time | 0.99 | false | 50mg | PAT-1006 | 2002-08-19 | female | RX-4006 | Sertraline | once daily | 2023-11-10 | 2024-11-10 | PRV-2006 | PHM-3002 | 0 | 2023-11-10 | 30 | 2023-12-10 | 2023-12-09 | Consistent with therapy |
| ADH-008 | late | 0.74 | true | 20mg | PAT-1007 | 1975-02-14 | male | RX-4007 | Simvastatin | once daily | 2023-04-10 | 2024-04-10 | PRV-2007 | PHM-3003 | 1 | 2023-05-10 | 30 | 2023-06-09 | 2023-06-17 | Late refill; discussed with patient |
| ADH-009 | missed | 0 | true | 0.25mg | PAT-1008 | 1968-12-05 | female | RX-4008 | Alprazolam | twice daily | 2023-07-01 | 2023-08-15 | PRV-2008 | PHM-3004 | 0 | 2023-07-01 | 45 | 2023-08-15 | blank | No refill; provider to contact patient |
| ADH-010 | late | 0.76 | true | 50mg | PAT-1009 | 1987-11-21 | other | RX-4009 | Metoprolol | twice daily | 2023-05-22 | 2024-05-22 | PRV-2009 | PHM-3005 | 3 | 2023-09-22 | 30 | 2023-10-22 | 2023-10-25 | Patient running out before refill |
| ADH-011 | on-time | 1 | false | 100mg | PAT-1010 | 1995-04-06 | male | RX-4010 | Losartan | once daily | 2023-01-15 | 2024-01-15 | PRV-2010 | PHM-3001 | 2 | 2023-07-15 | 90 | 2023-10-13 | 2023-10-13 | Patient self-managing refills well |
| ADH-012 | on-time | 0.98 | false | 25mg | PAT-1011 | 1979-01-28 | female | RX-4011 | Hydrochlorothiazide | once daily | 2023-08-20 | 2024-08-20 | PRV-2011 | PHM-3002 | 0 | 2023-08-20 | 30 | 2023-09-19 | 2023-09-18 | blank |
| ADH-013 | late | 0.75 | true | 20mg | PAT-1012 | 1959-09-10 | male | RX-4012 | Omeprazole | once daily | 2023-07-05 | 2024-07-05 | PRV-2012 | PHM-3003 | 1 | 2023-08-04 | 30 | 2023-09-03 | 2023-09-10 | Late refill attributed to pharmacy delay |
| ADH-014 | missed | 0 | true | 300mg | PAT-1013 | 1965-10-23 | female | RX-4013 | Gabapentin | three times daily | 2023-05-20 | 2024-05-20 | PRV-2013 | PHM-3004 | 2 | 2023-09-20 | 90 | 2023-12-19 | blank | No refill; possible non-adherence |
| ADH-015 | early | 0.96 | false | 2mg | PAT-1014 | 1978-06-03 | male | RX-4014 | Warfarin | once daily | 2023-11-12 | 2024-11-12 | PRV-2014 | PHM-3005 | 0 | 2023-11-12 | 30 | 2023-12-12 | 2023-12-10 | Refilled early due to travel |
| ADH-016 | late | 0.79 | true | 10 units | PAT-1015 | 1948-12-28 | female | RX-4015 | Insulin Glargine | once daily | 2023-01-01 | 2024-01-01 | PRV-2015 | PHM-3001 | 5 | 2023-10-01 | 28 | 2023-10-29 | 2023-11-01 | Late refill; patient education provided |
| ADH-017 | on-time | 0.99 | false | 10mg | PAT-1016 | 2000-02-12 | unknown | RX-4016 | Escitalopram | once daily | 2023-12-09 | 2024-12-09 | PRV-2016 | PHM-3002 | 0 | 2023-12-09 | 30 | 2024-01-08 | 2024-01-06 | blank |
| ADH-018 | on-time | 0.97 | false | 75mg | PAT-1017 | 1945-05-06 | male | RX-4017 | Clopidogrel | once daily | 2023-06-18 | 2024-06-18 | PRV-2017 | PHM-3003 | 3 | 2023-09-18 | 90 | 2023-12-17 | 2023-12-15 | Patient adherent |
| ADH-019 | late | 0.77 | true | 100mg | PAT-1018 | 1983-03-13 | female | RX-4018 | Sertraline | once daily | 2023-08-01 | 2024-08-01 | PRV-2018 | PHM-3004 | 2 | 2023-12-01 | 30 | 2023-12-31 | 2024-01-02 | Late refill due to holidays |
| ADH-020 | on-time | 1 | false | 40mg | PAT-1019 | 1971-09-27 | male | RX-4019 | Omeprazole | once daily | 2023-11-01 | 2024-11-01 | PRV-2019 | PHM-3005 | 0 | 2023-11-01 | 30 | 2023-12-01 | 2023-11-29 | Patient compliant |
What the 80 rows show
from the 80-row sampleMissed (adherence status) stands out: mean adherence_
- 51%intervention_
flag = true - 0.81median adherence_
score - 4patient genders
- 6medication frequencies
- 30median days_
supply
Every row with adherence_
- string 11
- integer 2
- float 1
- date 6
- boolean 1
Columns
21 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
adherence_id | string | Unique identifier for each prescription adherence recordunique | ADH-001 |
patient_id | string | Unique identifier for the patient | PAT-1001 |
patient_gender | string | Patient's gendermale · female · other · unknown | female |
prescription_id | string | Unique identifier for the prescription | RX-4001 |
medication_name | string | Name of the prescribed medication | Metformin |
medication_dose | string | Dosage of the medication as prescribed (e.g., 10mg, 1 tablet) | 500mg |
medication_frequency | string | Frequency of medication intake (e.g., once daily, twice daily)6 frequencies | twice daily |
prescribing_provider_id | string | Unique identifier for the prescribing healthcare provider | PRV-2001 |
pharmacy_id | string | Unique identifier for the pharmacy where the prescription is filled | PHM-3001 |
adherence_status | string | Assessment of adherence for this refill (on-time, late, early, missed)on-time · late · early · missed | on-time |
notes | string | Additional notes or comments from provider or pharmacistoptional | Refilled two days early |
| Numbers 3 columns | |||
refill_number | integer | The sequential number of the refill (0 for initial fill, 1 for first refill, etc.)0 or more | 0 |
days_supply | integer | Number of days the refill is expected to last1 or more | 30 |
adherence_score | float | Quantitative adherence score (e.g., proportion of days covered, between 0 and 1)0 to 1 · optional | 1 |
| Dates and times 6 columns | |||
patient_birth_date | date | Patient's date of birth | 1963-07-14 |
prescription_start_date | date | Date when the prescription was first issued | 2023-10-01 |
prescription_end_date | date | Date when the prescription is scheduled to endoptional | 2024-10-01 |
refill_date | date | Date when the prescription was refilled | 2023-10-01 |
expected_next_refill_date | date | Calculated date when the next refill is due based on days_supply | 2023-10-31 |
actual_next_refill_date | date | Actual date when the next refill was obtained (if available)optional | 2023-10-31 |
| True or false 1 column | |||
intervention_flag | boolean | Indicates if provider intervention is recommended for this patient/prescription | false |
Use it for
A healthcare dashboard
The intervention_
flag rate, adherence_ score by adherence_ status and a breakdown of medication_ dose. Excel, Power BI or Tableau. Why do the 12 missed rows have a mean adherence_
score of 0.34? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Adherences80ADH-0011on-timeADH-0020.78lateADH-0040.75late
A software demo
Believable adherences with patient_
id, patient_ birth_ date and patient_ gender to fill a screen in front of a buyer.
This dataset80 rows21 columns
Yours1,000 rows21 columns
blueprint · prescription-adherence-monitoring
Behind this dataset
Same schema. As many rows as you need.
These 80 rows came out of a blueprint — 21 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
- Record refill date and scheduled refill date
- Mark refills delayed by over 7 days as non-adherent
- Capture medication type and dosage
- Link patient demographics to refill history
- Flag non-adherence for clinician follow-up
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-monitoring