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.
Sample rows
preview · 8 of 200 rows · all 27 columns| adherence_idstring | adherence_statusstring | adherence_scorefloat | outcome_improvement_flagboolean | pharmacy_countrystring | patient_idstring | patient_first_namestring | patient_last_namestring | patient_date_of_birthdate | patient_genderstring | prescription_idstring | medication_namestring | medication_dosagestring | medication_frequencystring | prescribing_physician_idstring | prescribing_physician_namestring | pharmacy_idstring | pharmacy_namestring | pharmacy_street_addressstring | pharmacy_citystring | pharmacy_statestring | pharmacy_postal_codestring | fill_datedate | refill_numberinteger | days_supplyinteger | next_refill_due_datedate | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ADH-0001 | adherent | 0.91 | true | USA | PAT-0001 | Robert | Miller | 1951-03-22 | male | RX-0001 | Atorvastatin | 20mg | once daily | PHY-0001 | Dr. Lauren Chen | PHARM-0001 | CVS Pharmacy | 123 Main St | Boston | MA | 02118 | 2024-02-12 | 0 | 30 | 2024-03-13 | Patient receives app reminders for medication. |
| ADH-0002 | adherent | 0.84 | false | USA | PAT-0002 | Priya | Singh | 1976-08-06 | female | RX-0002 | Metformin | 500mg | twice daily | PHY-0002 | Dr. Martin Lopez | PHARM-0002 | Walgreens | 456 Oak Ave | Chicago | IL | 60616 | 2024-03-01 | 0 | 60 | 2024-04-30 | Patient joined local diabetes support group. |
| ADH-0003 | unknown | blank | false | UK | PAT-0003 | James | Nguyen | 2009-10-15 | male | RX-0003 | Amoxicillin | 250mg | as needed | PHY-0003 | Dr. Emily Foster | PHARM-0003 | Boots Pharmacy | 22 High St | London | Greater London | EC1A 1BB | 2024-04-05 | 0 | 7 | blank | Parent provided education on antibiotic course. |
| ADH-0004 | adherent | 0.88 | true | Mexico | PAT-0004 | Maria | Gonzalez | 1984-12-04 | female | RX-0004 | Lisinopril | 10mg | once daily | PHY-0004 | Dr. Sarah Wu | PHARM-0004 | Farmacias Guadalajara | 789 Calle Juarez | Guadalajara | Jalisco | 44100 | 2024-03-18 | 0 | 30 | 2024-04-17 | Patient receives SMS reminders. |
| ADH-0005 | non-adherent | 0.33 | true | Oman | PAT-0005 | Ahmed | Al-Farsi | 1959-11-11 | male | RX-0005 | Amlodipine | 5mg | once daily | PHY-0005 | Dr. Hassan Farouk | PHARM-0005 | Al Shifa Pharmacy | 101 Sultan Rd | Muscat | Muscat | 112 | 2024-02-28 | 0 | 60 | 2024-04-28 | Case manager performed phone intervention. |
| ADH-0006 | adherent | 0.97 | false | Canada | PAT-0006 | Lucy | Dawson | 1970-09-21 | female | RX-0006 | Levothyroxine | 50mcg | once daily | PHY-0006 | Dr. Robert Grant | PHARM-0006 | Shoppers Drug Mart | 212 King St W | Toronto | ON | M5H 1K6 | 2024-03-07 | 0 | 90 | 2024-06-05 | Patient has routine lab monitoring. |
| ADH-0007 | unknown | blank | true | Spain | PAT-0007 | Sofia | Martinez | 2014-06-10 | female | RX-0007 | Albuterol Inhaler | 2puffs | as needed | PHY-0007 | Dr. Juan Perez | PHARM-0007 | Farmacia del Sol | 34 Calle Rio | Madrid | Madrid | 28012 | 2024-03-15 | 0 | 30 | blank | Parent attended asthma education session. |
| ADH-0008 | adherent | 0.89 | false | USA | PAT-0008 | Thomas | Brown | 1947-02-02 | male | RX-0008 | Warfarin | 2mg | once daily | PHY-0008 | Dr. Anna Lee | PHARM-0008 | Rite Aid | 88 Market St | San Francisco | CA | 94107 | 2024-03-10 | 0 | 60 | 2024-05-09 | Home health nurse visits weekly. |
| ADH-0009 | adherent | 0.92 | true | UK | PAT-0009 | Chloe | Evans | 1988-05-23 | female | RX-0009 | Sertraline | 50mg | once daily | PHY-0009 | Dr. Mark Harris | PHARM-0009 | Lloyds Pharmacy | 18 Church Rd | Manchester | Greater Manchester | M23 9PW | 2024-03-21 | 0 | 30 | 2024-04-20 | Patient uses medication tracking app. |
| ADH-0010 | non-adherent | 0.27 | true | Singapore | PAT-0010 | Wei | Chen | 1964-07-19 | other | RX-0010 | Glimepiride | 4mg | once daily | PHY-0010 | Dr. Jessica Park | PHARM-0010 | Guardian Pharmacy | 55 Orchard Rd | Singapore | Central | 238863 | 2024-01-28 | 0 | 30 | 2024-02-27 | Patient received counseling for missed doses. |
| ADH-0011 | adherent | 0.87 | false | Russia | PAT-0011 | Elena | Ivanova | 1992-09-09 | female | RX-0011 | Lamotrigine | 100mg | twice daily | PHY-0011 | Dr. Dmitry Petrov | PHARM-0011 | Apteka 36.6 | 11 Pushkin St | Moscow | Moscow | 101000 | 2024-03-03 | 0 | 60 | 2024-05-02 | Patient attends epilepsy support group. |
| ADH-0012 | adherent | 0.98 | true | USA | PAT-0012 | John | O'Brien | 1955-11-02 | male | RX-0012 | Simvastatin | 40mg | once daily | PHY-0012 | Dr. Alice Murphy | PHARM-0012 | CVS Pharmacy | 500 Park Ave | New York | NY | 10022 | 2024-03-13 | 1 | 30 | 2024-04-12 | Patient receives weekly medication reminders. |
| ADH-0013 | adherent | 0.81 | false | Portugal | PAT-0013 | Isabel | Santos | 1961-05-30 | female | RX-0013 | Bisoprolol | 5mg | once daily | PHY-0013 | blank | PHARM-0013 | Farmacia Central | 12 Rua de Lisboa | Lisbon | Lisboa | 1100-001 | 2024-02-25 | 0 | 60 | 2024-04-25 | Patient tracks doses with pill box. |
| ADH-0014 | non-adherent | 0.14 | true | Saudi Arabia | PAT-0014 | Mohammed | Al Saeed | 1980-12-18 | male | RX-0014 | Losartan | 50mg | once daily | PHY-0014 | Dr. Fatima Abbas | PHARM-0014 | Al Noor Pharmacy | 78 King Fahd Rd | Riyadh | Riyadh | 11564 | 2024-03-20 | 0 | 90 | 2024-06-18 | Patient missed several doses, counseled. |
| ADH-0015 | adherent | 0.79 | true | USA | PAT-0015 | Ava | Thompson | 2010-07-25 | female | RX-0015 | Azithromycin | 250mg | once daily | PHY-0015 | Dr. Grace Kim | PHARM-0015 | CVS Pharmacy | 789 Elm St | Houston | TX | 77002 | 2024-03-25 | 0 | 5 | 2024-03-30 | Parent received antibiotic adherence handout. |
| ADH-0016 | adherent | 0.95 | false | USA | PAT-0016 | Charles | Wilson | 1978-07-14 | male | RX-0016 | Rosuvastatin | 10mg | once daily | PHY-0016 | Dr. Jennifer Lee | PHARM-0016 | CVS Pharmacy | 300 Main St | Seattle | WA | 98101 | 2024-01-20 | 1 | 30 | 2024-02-19 | Patient enrolled in medication reminder program. |
| ADH-0017 | adherent | 0.93 | false | India | PAT-0017 | Maya | Patel | 1987-04-28 | female | RX-0017 | Insulin Glargine | 20units | once daily | PHY-0017 | Dr. Sunil Rao | PHARM-0017 | Apollo Pharmacy | 45 MG Road | Bangalore | Karnataka | 560001 | 2024-02-14 | 0 | 60 | 2024-04-14 | Patient receives monthly diabetes education. |
| ADH-0018 | adherent | 0.89 | false | Russia | PAT-0018 | Olga | Kuznetsova | 1973-03-11 | female | RX-0018 | Enalapril | 10mg | once daily | PHY-0018 | Dr. Ivan Smirnov | PHARM-0018 | Apteka 36.6 | 25 Tverskaya St | Moscow | Moscow | 101001 | 2024-03-06 | 0 | 90 | 2024-06-04 | Patient has regular blood pressure monitoring. |
| ADH-0019 | adherent | 0.86 | false | USA | PAT-0019 | Emily | Clark | 1938-09-30 | female | RX-0019 | Furosemide | 40mg | twice daily | PHY-0019 | Dr. William Barton | PHARM-0019 | Walgreens | 21 Maple St | St. Louis | MO | 63108 | 2024-02-18 | 0 | 30 | 2024-03-19 | Home visits scheduled for medication support. |
| ADH-0020 | non-adherent | 0.32 | true | USA | PAT-0020 | Samuel | Johnson | 2005-12-11 | male | RX-0020 | Clarithromycin | 500mg | twice daily | PHY-0020 | Dr. Linda Carter | PHARM-0020 | CVS Pharmacy | 222 Pine St | San Diego | CA | 92101 | 2024-03-16 | 0 | 7 | blank | Parent did not complete recommended antibiotic course. |
What the 200 rows show
from the 200-row sampleAdherent (adherence status) stands out: mean adherence_
- 51%outcome_
improvement_ flag = true - 0.88median adherence_
score - 4patient genders
- 5medication frequencies
- 33medication dosages
- 54medication names
Median 0.88, from 0.03 to 0.99.
- string 20
- integer 2
- float 1
- date 3
- boolean 1
Columns
27 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
adherence_id | string | Unique identifier for each prescription adherence recordunique | ADH-0001 |
patient_id | string | Unique identifier for the patient | PAT-0001 |
patient_first_name | string | Patient's first name | Robert |
patient_last_name | string | Patient's last name | Miller |
patient_gender | string | Patient's gendermale · female · other · unknown · optional | male |
prescription_id | string | Unique identifier for the prescription | RX-0001 |
medication_name | string | Name of the prescribed medication | Atorvastatin |
medication_dosage | string | Dosage of the medication (e.g., 10mg) | 20mg |
medication_frequency | string | Frequency of medication intake (e.g., once daily)5 frequencies | once daily |
prescribing_physician_id | string | Unique identifier for the prescribing physician | PHY-0001 |
prescribing_physician_name | string | Name of the prescribing physicianoptional | Dr. Lauren Chen |
pharmacy_id | string | Unique identifier for the pharmacy | PHARM-0001 |
pharmacy_name | string | Name of the pharmacyoptional | CVS Pharmacy |
pharmacy_street_address | string | Street address of the pharmacyoptional | 123 Main St |
pharmacy_city | string | City where the pharmacy is locatedoptional | Boston |
pharmacy_state | string | State where the pharmacy is locatedoptional | MA |
pharmacy_postal_code | string | Postal code of the pharmacyoptional | 02118 |
pharmacy_country | string | Country where the pharmacy is locatedoptional | USA |
adherence_status | string | Status indicating if the patient is adherent, non-adherent, or unknown for this filladherent · non-adherent · unknown | adherent |
notes | string | Additional notes or comments related to adherence or interventionsoptional | Patient receives app remi… |
| Numbers 3 columns | |||
refill_number | integer | Refill sequence number for the prescription (0 for initial fill)0 or more | 0 |
days_supply | integer | Number of days the medication supply is expected to last1 or more | 30 |
adherence_score | float | Calculated adherence score for this fill (0.0 to 1.0)0 to 1 · optional | 0.91 |
| Dates and times 3 columns | |||
patient_date_of_birth | date | Patient's date of birth | 1951-03-22 |
fill_date | date | Date when the prescription was filled | 2024-02-12 |
next_refill_due_date | date | Date when the next refill is due based on days supplyoptional | 2024-03-13 |
| True or false 1 column | |||
outcome_improvement_flag | boolean | Indicates if an outcome improvement strategy was applied for this patient/prescriptionoptional | true |
Use it for
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.
- Adherences200ADH-00010.91adherentADH-00020.84adherentADH-00040.88adherent
A software demo
Believable adherences with patient_
id, patient_ first_ name and patient_ last_ name to fill a screen in front of a buyer.
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.
- Medication type and dosage recorded
- Missed refills flagged
- Patient demographics included
- Adherence rates calculated monthly
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