Clinical Trial Drug Administration and Compliance
This dataset provides detailed records of drug administration, dosing schedules, compliance, dose modifications, drug accountability, and concomitant medication use for participants in clinical trials. It enables comprehensive monitoring of protocol adherence, supports safety and efficacy analyses, and facilitates regulatory reporting for pharmaceutical research.
Sample rows
preview · 8 of 100 rows · all 18 columns| trial_idstring | dose_unitstring | drug_dosefloat | dose_modificationboolean | concomitant_medication_namestring | subject_idstring | visit_datedate | drug_namestring | dosing_schedulestring | modification_reasonstring | compliance_percentagefloat | missed_dosesinteger | drug_accountability_returnedinteger | drug_accountability_dispensedinteger | concomitant_medication_start_datedate | concomitant_medication_end_datedate | protocol_adherenceboolean | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TRIAL-101-A | mg | 10 | false | Metformin | SUBJ-001 | 2023-03-14 | Lisinopril | once daily | blank | 96.7 | 1 | 0 | 30 | 2023-03-12 | 2023-04-10 | true | Excellent compliance |
| TRIAL-101-A | mg | 20 | true | blank | SUBJ-002 | 2023-03-17 | Lisinopril | once daily | Increased due to high blood pressure | 89 | 3 | 2 | 30 | blank | blank | false | Dose increased at this visit |
| TRIAL-101-A | mg | 10 | false | Atorvastatin | SUBJ-003 | 2023-03-21 | Lisinopril | once daily | blank | 100 | 0 | 0 | 30 | 2023-03-18 | 2023-04-15 | true | No missed doses |
| TRIAL-101-A | mg | 5 | true | blank | SUBJ-004 | 2023-03-25 | Lisinopril | once daily | Reduced due to dizziness | 92.3 | 2 | 1 | 30 | blank | blank | true | Dose reduced after adverse event |
| TRIAL-101-A | mg | 10 | false | Amlodipine | SUBJ-005 | 2023-03-28 | Lisinopril | once daily | blank | 95 | 2 | 2 | 30 | 2023-03-27 | 2023-04-20 | true | Missed doses due to travel |
| TRIAL-102-B | mg | 500 | false | blank | SUBJ-006 | 2023-04-02 | Metformin | twice daily | blank | 97.5 | 1 | 1 | 60 | blank | blank | true | High compliance |
| TRIAL-102-B | mg | 1000 | true | Simvastatin | SUBJ-007 | 2023-04-04 | Metformin | twice daily | Dose increased for better glycemic control | 85 | 5 | 4 | 60 | 2023-04-03 | 2023-04-30 | false | Compliance below target |
| TRIAL-102-B | mg | 500 | false | Aspirin | SUBJ-008 | 2023-04-10 | Metformin | twice daily | blank | 98.3 | 1 | 0 | 60 | 2023-04-09 | 2023-05-07 | true | No issues |
| TRIAL-102-B | mg | 850 | true | blank | SUBJ-009 | 2023-04-14 | Metformin | twice daily | GI upset, dose reduced | 91.6 | 3 | 3 | 60 | blank | blank | true | Dose reduced after adverse event |
| TRIAL-102-B | mg | 1000 | false | Lisinopril | SUBJ-010 | 2023-04-18 | Metformin | twice daily | blank | 99.2 | 0 | 0 | 60 | 2023-04-15 | 2023-05-12 | true | No missed doses |
| TRIAL-103-C | mg | 20 | false | blank | SUBJ-011 | 2023-05-02 | Atorvastatin | once daily | blank | 97 | 1 | 0 | 30 | blank | blank | true | Good compliance |
| TRIAL-103-C | mg | 40 | true | Amlodipine | SUBJ-012 | 2023-05-04 | Atorvastatin | once daily | Dose increased due to high LDL | 88.5 | 3 | 2 | 30 | 2023-05-03 | 2023-05-30 | false | Dose increased this cycle |
| TRIAL-103-C | mg | 20 | false | blank | SUBJ-013 | 2023-05-07 | Atorvastatin | once daily | blank | 94.2 | 2 | 2 | 30 | blank | blank | true | Minor nonadherence |
| TRIAL-103-C | mg | 10 | true | Metformin | SUBJ-014 | 2023-05-10 | Atorvastatin | once daily | Reduced due to muscle pain | 95.7 | 1 | 1 | 30 | 2023-05-09 | 2023-06-05 | true | Dose reduced |
| TRIAL-103-C | mg | 20 | false | blank | SUBJ-015 | 2023-05-13 | Atorvastatin | once daily | blank | 92 | 2 | 2 | 30 | blank | blank | true | Missed doses due to travel |
| TRIAL-104-D | mg | 5 | false | Metformin | SUBJ-016 | 2023-06-02 | Amlodipine | once daily | blank | 96.5 | 1 | 0 | 30 | 2023-06-01 | 2023-06-30 | true | Good compliance |
| TRIAL-104-D | mg | 10 | true | blank | SUBJ-017 | 2023-06-05 | Amlodipine | once daily | Dose increased for blood pressure control | 90.8 | 3 | 2 | 30 | blank | blank | false | BP control issue |
| TRIAL-104-D | mg | 5 | false | Aspirin | SUBJ-018 | 2023-06-09 | Amlodipine | once daily | blank | 98.2 | 0 | 0 | 30 | 2023-06-08 | 2023-07-05 | true | No missed doses |
| TRIAL-104-D | mg | 5 | true | blank | SUBJ-019 | 2023-06-12 | Amlodipine | once daily | Reduced due to edema | 93.4 | 2 | 2 | 30 | blank | blank | true | Dose reduced |
| TRIAL-104-D | mg | 10 | false | Lisinopril | SUBJ-020 | 2023-06-16 | Amlodipine | once daily | blank | 94 | 2 | 1 | 30 | 2023-06-15 | 2023-07-12 | true | Missed doses due to illness |
What the 100 rows show
from the 100-row sampleIU (dose unit) stands out: mean drug_
- 34%dose_
modification = true - 20.0median drug_
dose - 12dosing schedules
- 95.0median compliance_
percentage - 1median missed_
doses - 1median drug_
accountability_ returned
Median 20.0, from 0.25 to 12,000.
- string 8
- integer 3
- float 2
- date 3
- boolean 2
Columns
18 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
trial_id | string | Unique identifier for the clinical trial | TRIAL-101-A |
subject_id | string | Unique identifier for the study participant | SUBJ-001 |
drug_name | string | Name of the study drug dispensed | Lisinopril |
dose_unit | string | Unit of measurement for the drug dose (e.g., mg, mL)mg · g · mL · IU · other | mg |
dosing_schedule | string | Description of the dosing schedule (e.g., once daily, twice weekly)12 schedules | once daily |
modification_reason | string | Reason for dose modification, if applicableoptional | Reduced due to dizziness |
concomitant_medication_name | string | Name of concomitant medication taken during the periodoptional | Metformin |
notes | string | Additional notes or comments by study staffoptional | Excellent compliance |
| Numbers 5 columns | |||
drug_dose | float | Amount of drug dispensed per administration (in mg or appropriate unit)0 or more | 10 |
compliance_percentage | float | Percentage of doses taken as prescribed during the period0 to 100 | 96.7 |
missed_doses | integer | Number of doses missed during the period0 or more | 1 |
drug_accountability_returned | integer | Number of unused drug units returned by the participant0 or more | 0 |
drug_accountability_dispensed | integer | Number of drug units dispensed to the participant0 or more | 30 |
| Dates and times 3 columns | |||
visit_date | date | Date of the participant's study visit | 2023-03-14 |
concomitant_medication_start_date | date | Start date of concomitant medicationoptional | 2023-03-12 |
concomitant_medication_end_date | date | End date of concomitant medicationoptional | 2023-04-10 |
| True or false 2 columns | |||
dose_modification | boolean | Indicates if the dose was modified from the protocol | false |
protocol_adherence | boolean | Indicates if the participant adhered to the protocol during this period | true |
Use it for
A healthcare dashboard
The dose_
modification rate, drug_ dose by dose_ unit and a breakdown of concomitant_ medication_ name. Excel, Power BI or Tableau. Why do the 12 IU rows have a mean drug_
dose of 3,675? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Trials100TRIAL-101-A10mgTRIAL-101-A20mgTRIAL-101-A5mg
A software demo
Believable trials with subject_
id, visit_ date and drug_ name to fill a screen in front of a buyer.
blueprint · clinical-trial-drug-administration-and-compliance
Behind this dataset
Same schema. As many rows as you need.
These 100 rows came out of a blueprint — 18 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.
- Dispensing ID unique per drug supply
- Subject ID and visit date
- Study drug lot number and expiration
- Dose level and frequency
- Actual dose administered or dispensed
- Dose modifications: reduction, delay, hold
- Reason for modification: toxicity, AE, patient request
- Compliance: pill counts, diary cards, drug levels
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
- clinical-trial-drug-administration-and-compliance