Medication Reconciliation Records
This dataset provides detailed records of medication reconciliation during patient care transitions, capturing home, admission, and discharge medication lists, discrepancy identification and resolution, and clinician/facility details. It enables robust patient safety monitoring, process optimization, and compliance reporting in healthcare settings.
Sample rows
preview · 8 of 100 rows · all 19 columns| record_idstring | facility_idstring | discharge_medications_countinteger | discrepancy_typesstring | patient_idstring | patient_first_namestring | patient_last_namestring | date_of_birthdate | care_transition_typestring | transition_datetimedatetime | reconciler_idstring | reconciler_namestring | home_medications_countinteger | admission_medications_countinteger | discrepancy_countinteger | discrepancy_resolution_statusstring | resolution_datetimedatetime | notesstring | facility_namestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| REC10001 | FAC9002 | 0 | omission | PAT202301 | James | Holloway | 1953-07-18 | admission | 2024-04-01T08:15:00 | CLN5008 | Dr. Wendy Tran | 3 | 2 | 1 | resolved | 2024-04-01T10:10:00 | Patient forgot to mention aspirin use at home. | North Valley Hospital |
| REC10002 | FAC9001 | 5 | blank | PAT202302 | Maria | Castro | 1978-11-22 | discharge | 2024-05-10T15:42:00 | CLN5013 | Dr. Alan Yates | 5 | 4 | 0 | resolved | 2024-05-10T15:42:00 | No discrepancies found. | St. Francis Medical Center |
| REC10003 | FAC9003 | 0 | commission | PAT202303 | Ethan | Morris | 1965-03-03 | transfer | 2024-05-04T17:30:00 | CLN5002 | Nurse Carla Benson | 2 | 2 | 1 | pending | blank | Unclear if beta blocker should be continued post-transfer. | Eastside Community Clinic |
| REC10004 | FAC9002 | 0 | blank | PAT202304 | Olivia | Nguyen | 1992-01-09 | admission | 2024-03-29T09:05:00 | CLN5010 | Dr. Priya Shah | 1 | 1 | 0 | resolved | 2024-03-29T09:05:00 | No home medication discrepancies. | North Valley Hospital |
| REC10005 | FAC9004 | 6 | dosage error,omission | PAT202305 | Samuel | King | 1945-04-16 | discharge | 2024-04-30T10:50:00 | CLN5014 | Dr. Lila Foster | 4 | 5 | 2 | resolved | 2024-04-30T12:16:00 | Dosage of simvastatin corrected; missing antihypertensive added. | Westside Medical Pavilion |
| REC10006 | FAC9001 | 0 | blank | PAT202306 | Katherine | Sullivan | 1988-09-27 | admission | 2024-05-07T13:00:00 | CLN5003 | Nurse Miguel Torres | 0 | 2 | 0 | resolved | 2024-05-07T13:00:00 | Patient not on any home meds prior to admission. | St. Francis Medical Center |
| REC10007 | FAC9003 | 1 | omission | PAT202307 | Abigail | Clark | 2000-06-10 | transfer | 2024-05-09T15:45:00 | CLN5011 | Dr. Vijay Menon | 2 | 2 | 1 | pending | blank | Antidepressant not listed in transfer orders. | Eastside Community Clinic |
| REC10008 | FAC9001 | 0 | dosage error | PAT202308 | Benjamin | Lee | 1970-02-17 | admission | 2024-04-08T08:30:00 | CLN5007 | Nurse Karen Fox | 4 | 3 | 1 | resolved | 2024-04-08T09:20:00 | Incorrect dose of metformin corrected. | St. Francis Medical Center |
| REC10009 | FAC9002 | 3 | blank | PAT202309 | Diana | Hernandez | 1962-12-05 | discharge | 2024-05-15T11:05:00 | CLN5005 | Dr. Kevin Chu | 3 | 3 | 0 | resolved | 2024-05-15T11:05:00 | All medications reconciled; no issues. | North Valley Hospital |
| REC10010 | FAC9004 | 0 | blank | PAT202310 | Michael | Evans | 1999-11-30 | transfer | 2024-05-12T16:00:00 | CLN5012 | Dr. Janice Kim | 1 | 1 | 0 | resolved | 2024-05-12T16:00:00 | No discrepancies in transition. | Westside Medical Pavilion |
| REC10011 | FAC9001 | 0 | omission,dosage error | PAT202311 | Linda | Moore | 1957-05-21 | admission | 2024-04-02T07:50:00 | CLN5006 | Nurse Peter Young | 6 | 5 | 2 | resolved | 2024-04-02T08:40:00 | Diuretic omitted; statin dose corrected. | St. Francis Medical Center |
| REC10012 | FAC9003 | 5 | commission | PAT202312 | Joshua | White | 1982-08-15 | discharge | 2024-05-02T13:25:00 | CLN5015 | Dr. Emily Park | 3 | 4 | 1 | resolved | 2024-05-02T14:10:00 | Unnecessary antacid discontinued at discharge. | Eastside Community Clinic |
| REC10013 | FAC9002 | 0 | blank | PAT202313 | Emily | Watson | 1951-03-13 | admission | 2024-04-11T10:15:00 | CLN5001 | Dr. Marcus Lee | 2 | 2 | 0 | resolved | 2024-04-11T10:15:00 | No discrepancies. | North Valley Hospital |
| REC10014 | FAC9004 | 1 | dosage error | PAT202314 | William | Reed | 1976-12-25 | transfer | 2024-04-27T17:20:00 | CLN5009 | Nurse Sophie Lin | 5 | 3 | 1 | resolved | 2024-04-27T17:50:00 | Insulin dose adjusted for new facility protocol. | Westside Medical Pavilion |
| REC10015 | FAC9001 | 0 | blank | PAT202315 | Sophia | Green | 1986-02-28 | admission | 2024-03-31T08:05:00 | CLN5014 | Dr. Lila Foster | 3 | 2 | 0 | resolved | 2024-03-31T08:05:00 | No home medication issues identified. | St. Francis Medical Center |
| REC10016 | FAC9002 | 5 | omission,commission | PAT202316 | David | Lopez | 1969-05-17 | discharge | 2024-05-18T10:30:00 | CLN5008 | Dr. Wendy Tran | 4 | 4 | 2 | resolved | 2024-05-18T11:10:00 | Antihypertensive omitted, duplicate statin order. | North Valley Hospital |
| REC10017 | FAC9003 | 0 | blank | PAT202317 | Grace | Baker | 1995-10-06 | admission | 2024-04-04T09:00:00 | CLN5013 | Dr. Alan Yates | 1 | 1 | 0 | resolved | 2024-04-04T09:00:00 | Patient only on oral contraceptive. | Eastside Community Clinic |
| REC10018 | FAC9004 | 1 | commission | PAT202318 | John | Stewart | 1959-07-29 | transfer | 2024-05-05T14:35:00 | CLN5005 | Dr. Kevin Chu | 2 | 2 | 1 | pending | blank | Unnecessary antacid started at transfer. | Westside Medical Pavilion |
| REC10019 | FAC9001 | 4 | blank | PAT202319 | Charlotte | Perry | 1972-10-30 | discharge | 2024-05-19T16:20:00 | CLN5001 | Dr. Marcus Lee | 3 | 3 | 0 | resolved | 2024-05-19T16:20:00 | No discrepancies in discharge medications. | St. Francis Medical Center |
| REC10020 | FAC9002 | 0 | omission | PAT202320 | Ryan | Peterson | 1984-08-19 | admission | 2024-04-09T07:30:00 | CLN5004 | Nurse Anna Hughes | 2 | 2 | 1 | resolved | 2024-04-09T08:10:00 | Forgot to record vitamin D supplement. | North Valley Hospital |
What the 100 rows show
from the 100-row sampleFAC102 (facility id) stands out: mean discharge_
- 2median discharge_
medications_ count - 2discrepancy resolution statuses
- 4care transition types
- 8facility names
- 3median home_
medications_ count - 3median admission_
medications_ count
Median 2, from 0 to 8.
- string 12
- integer 4
- date 1
- datetime 2
Columns
19 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
record_id | string | Unique identifier for each medication reconciliation recordunique | REC10001 |
patient_id | string | Unique identifier for the patient | PAT202301 |
patient_first_name | string | Patient's first nameoptional | James |
patient_last_name | string | Patient's last nameoptional | Holloway |
care_transition_type | string | Type of care transition (e.g., admission, discharge, transfer)admission · discharge · transfer · other | admission |
reconciler_id | string | Unique identifier for the clinician performing reconciliation | CLN5008 |
reconciler_name | string | Name of the clinician performing reconciliationoptional | Dr. Wendy Tran |
discrepancy_types | string | Comma-separated list of discrepancy types identified (e.g., omission, commission, dosage error)optional | omission |
discrepancy_resolution_status | string | Status of discrepancy resolution (e.g., resolved, unresolved, pending)resolved · unresolved · pending | resolved |
notes | string | Additional notes or comments regarding the reconciliation processoptional | No discrepancies found. |
facility_id | string | Unique identifier for the healthcare facility8 facilities | FAC9002 |
facility_name | string | Name of the healthcare facility8 names · optional | North Valley Hospital |
| Numbers 4 columns | |||
home_medications_count | integer | Number of medications reported as home medications0 or more | 3 |
admission_medications_count | integer | Number of medications ordered at admission0 or more | 2 |
discharge_medications_count | integer | Number of medications prescribed at discharge0 or more | 0 |
discrepancy_count | integer | Number of discrepancies identified during reconciliation0 or more | 1 |
| Dates and times 3 columns | |||
date_of_birth | date | Patient's date of birthoptional | 1953-07-18 |
transition_datetime | datetime | Date and time of the care transition | 2024-04-01T08:15:00 |
resolution_datetime | datetime | Date and time when discrepancies were resolvedoptional | 2024-04-01T10:10:00 |
Use it for
A healthcare dashboard
Discharge_
medications_ count by facility_ id and a breakdown of discrepancy_ types. Excel, Power BI or Tableau. Why do the 13 FAC102 rows have a mean discharge_
medications_ count of 4.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Records100REC100010FAC9002REC100025FAC9001REC100030FAC9003
A software demo
Believable records with patient_
id, patient_ first_ name and patient_ last_ name to fill a screen in front of a buyer.
This dataset100 rows19 columns
Yours1,000 rows19 columns
blueprint · medication-reconciliation-records
Behind this dataset
Same schema. As many rows as you need.
These 100 rows came out of a blueprint — 19 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
- Reconciliation ID unique per event
- Reconciliation timepoint: admission, transfer, discharge
- Home medication list from patient or pharmacy
- Active medications with dose, frequency, last fill date
- Over-the-counter and herbal supplements
- Discrepancies identified: omission, dose error, duplication
- Reason for discrepancy: intentional change vs error
- Discrepancy resolution documented
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
- medication-reconciliation-records