Medication Administration Records (MAR)
This dataset provides detailed, event-level records of inpatient medication administration, including drug details, dosing, route, timing, nurse identifiers, and clinical context such as PRN justification, hold reasons, and adverse reactions. It is ideal for quality improvement, medication safety analysis, and clinical workflow optimization in hospital settings.
Sample rows
preview · 8 of 105 rows · all 17 columns| mar_idstring | routestring | medication_dosefloat | hold_flagboolean | dose_unitstring | patient_idstring | encounter_idstring | medication_namestring | time_administereddatetime | administering_nurse_idstring | administering_nurse_namestring | hold_reasonstring | prn_flagboolean | prn_justificationstring | adverse_reaction_flagboolean | adverse_reaction_descriptionstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MAR0001 | oral | 50 | false | mg | PAT0031 | ENC0221 | Metoprolol | 2024-06-01T08:12:00 | NUR004 | Ana Torres | blank | false | blank | false | blank | Vitals checked prior to administration |
| MAR0002 | oral | 1000 | false | mg | PAT0014 | ENC0203 | Acetaminophen | 2024-06-01T09:40:00 | NUR002 | Javier Martinez | blank | true | Patient reported headache | false | blank | Pain score prior: 5/10 |
| MAR0003 | subcutaneous | 14 | false | units | PAT0002 | ENC0201 | Insulin glargine | 2024-06-01T07:20:00 | NUR009 | Katherine Lee | blank | false | blank | false | blank | Blood glucose: 178 mg/dL |
| MAR0004 | subcutaneous | 5000 | false | units | PAT0023 | ENC0222 | Heparin | 2024-06-01T08:30:00 | NUR008 | Ellen Wu | blank | false | blank | false | blank | No bleeding noted |
| MAR0005 | IV | 40 | false | mg | PAT0019 | ENC0218 | Furosemide | 2024-06-01T10:15:00 | NUR003 | Carlos Rivera | blank | false | blank | false | blank | Urine output monitored |
| MAR0006 | IV | 1 | false | mg | PAT0027 | ENC0216 | Hydromorphone | 2024-06-01T11:22:00 | NUR005 | Samantha Chen | blank | true | Severe pain reported | false | blank | Alert and oriented |
| MAR0007 | inhalation | 2.5 | false | mg | PAT0008 | ENC0223 | Albuterol | 2024-06-01T09:00:00 | NUR006 | Rebecca Smith | blank | true | Wheezing observed | false | blank | Improved breath sounds post administration |
| MAR0008 | oral | 5 | false | mg | PAT0022 | ENC0224 | Warfarin | 2024-06-01T08:45:00 | NUR002 | Javier Martinez | blank | false | blank | false | blank | INR checked prior |
| MAR0009 | IV | 4 | false | mg | PAT0012 | ENC0214 | Ondansetron | 2024-06-01T10:50:00 | NUR004 | Ana Torres | blank | true | Nausea reported | false | blank | No vomiting post administration |
| MAR0010 | oral | 500 | false | mg | PAT0010 | ENC0217 | Amoxicillin | 2024-06-01T07:30:00 | NUR008 | Ellen Wu | blank | false | blank | false | blank | First dose of new course |
| MAR0011 | IV | 2 | false | mg | PAT0029 | ENC0212 | Morphine | 2024-06-01T11:44:00 | NUR001 | Linda White | blank | true | Patient pain level 8/10 | true | Mild itching observed | Benadryl considered |
| MAR0012 | IV | 40 | false | mg | PAT0017 | ENC0213 | Pantoprazole | 2024-06-01T07:50:00 | NUR003 | Carlos Rivera | blank | false | blank | false | blank | No adverse effects |
| MAR0013 | oral | 1 | true | mg | PAT0011 | ENC0211 | Lorazepam | 2024-06-01T09:15:00 | NUR005 | Samantha Chen | Patient refused medication | false | blank | false | blank | Patient alert and oriented |
| MAR0014 | IV | 750 | false | mg | PAT0001 | ENC0204 | Levofloxacin | 2024-06-01T10:05:00 | NUR006 | Rebecca Smith | blank | false | blank | false | blank | Signs of infection improving |
| MAR0015 | oral | 20 | false | mg | PAT0026 | ENC0206 | Prednisone | 2024-06-01T08:55:00 | NUR007 | Franklin Yang | blank | false | blank | false | blank | Swallowed without difficulty |
| MAR0016 | IV | 6 | false | mg | PAT0030 | ENC0210 | Dexamethasone | 2024-06-01T07:18:00 | NUR001 | Linda White | blank | false | blank | true | Redness at IV site | Site monitored for swelling |
| MAR0017 | oral | 300 | false | mg | PAT0003 | ENC0209 | Gabapentin | 2024-06-01T09:35:00 | NUR009 | Katherine Lee | blank | true | Neuropathic pain | false | blank | Pain score decreased |
| MAR0018 | subcutaneous | 40 | false | mg | PAT0020 | ENC0208 | Enoxaparin | 2024-06-01T07:58:00 | NUR007 | Franklin Yang | blank | false | blank | false | blank | No bruising noted |
| MAR0019 | oral | 500 | false | mg | PAT0013 | ENC0207 | Metformin | 2024-06-01T09:20:00 | NUR003 | Carlos Rivera | blank | false | blank | false | blank | No GI upset reported |
| MAR0020 | oral | 81 | false | mg | PAT0028 | ENC0205 | Aspirin | 2024-06-01T08:20:00 | NUR002 | Javier Martinez | blank | false | blank | false | blank | No bleeding noted |
What the 105 rows show
from the 105-row sample- 5%hold_
flag = true - 20.0median medication_
dose
Median 20.0, from 0.0 to 5,000.
- string 12
- float 1
- datetime 1
- boolean 3
Columns
17 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
mar_id | string | Unique identifier for each medication administration record eventunique | MAR0001 |
patient_id | string | Unique identifier for the patient receiving the medication | PAT0031 |
encounter_id | string | Unique identifier for the inpatient encounter or admission | ENC0221 |
medication_name | string | Name of the medication administered | Metoprolol |
dose_unit | string | Unit of measurement for the medication dose (e.g., mg, mL)7 units | mg |
route | string | Route of administration (e.g., oral, IV, IM, subcutaneous)7 values | oral |
administering_nurse_id | string | Unique identifier for the nurse who administered the medication | NUR004 |
administering_nurse_name | string | Full name of the nurse who administered the medicationoptional | Ana Torres |
hold_reason | string | Reason for holding the medication (if applicable)4 reasons · optional | Patient NPO for surgery |
prn_justification | string | Justification for PRN administration (if applicable)optional | Severe pain reported |
adverse_reaction_description | string | Description of any adverse reactions observed (if applicable)optional | Mild itching observed |
notes | string | Additional notes or comments related to the administration eventoptional | Pain score prior: 5/10 |
| Numbers 1 column | |||
medication_dose | float | Dose of medication administered0 or more | 50 |
| Dates and times 1 column | |||
time_administered | datetime | Date and time when the medication was administered | 2024-06-01T08:12:00 |
| True or false 3 columns | |||
hold_flag | boolean | Indicates if the medication was held (not administered) | false |
prn_flag | boolean | Indicates if the medication was administered as needed (PRN) | false |
adverse_reaction_flag | boolean | Indicates if any adverse reaction occurred after administration | false |
Use it for
A healthcare dashboard
The hold_
flag rate, medication_ dose by route and a breakdown of dose_ unit. Excel, Power BI or Tableau. Why do 5 of 105 rows have hold_
flag = true? A class exercise
Hand out the rows and one question. Everyone works from the same 105 rows.
- Mars105MAR000150oralMAR00131oralMAR00391IV
A software demo
Believable mars with patient_
id, encounter_ id and medication_ name to fill a screen in front of a buyer.
blueprint · medication-administration-records-mar
Behind this dataset
Same schema. As many rows as you need.
These 105 rows came out of a blueprint — 17 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.
- Administration ID unique per event
- Scheduled vs PRN (as needed) medications
- Five rights: right patient, drug, dose, route, time
- Barcode scanning for patient and medication verification
- Administration time documented
- Administering nurse with credentials
- Held medication requires reason code
- PRN medications require indication/reason
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
- medication-administration-records-mar