Physician Orders and CPOE Data
This dataset provides a detailed record of physician orders entered through computerized physician order entry (CPOE) systems, including medications, labs, imaging, consults, nursing orders, and order sets. It captures clinical workflow, decision support triggers, and user actions, enabling robust analysis of ordering patterns, workflow efficiency, and clinical decision support effectiveness. Ideal for healthcare quality improvement, clinical analytics, and workflow optimization.
Sample rows
preview · 8 of 110 rows · all 22 columns| order_idstring | medication_routestring | decision_support_triggeredboolean | imaging_typestring | patient_idstring | physician_idstring | order_typestring | order_statusstring | order_datetimedatetime | order_set_idstring | medication_namestring | medication_dosestring | lab_test_namestring | consult_servicestring | nursing_order_detailstring | decision_support_alert_typestring | decision_support_action_takenstring | order_prioritystring | order_commentsstring | entered_by_user_idstring | entered_by_rolestring | order_completed_datetimedatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ORD00001 | oral | true | blank | PAT00001 | PHY10001 | medication | completed | 2024-05-30T09:14:00 | SET0001 | Metoprolol | 50mg | blank | blank | blank | max_dose_alert | order_modified | routine | Dose adjusted due to alert. | PHY10001 | physician | 2024-05-30T14:18:00 |
| ORD00002 | blank | false | blank | PAT00002 | PHY10002 | lab | pending | 2024-06-05T10:20:00 | blank | blank | blank | CBC | blank | blank | blank | blank | stat | CBC ordered for fever. | NUR90001 | nurse | blank |
| ORD00003 | blank | false | CT | PAT00003 | PHY10003 | imaging | completed | 2024-06-01T12:45:00 | blank | blank | blank | blank | blank | blank | blank | blank | routine | CT scan for abdominal pain. | PHY10003 | physician | 2024-06-01T16:30:00 |
| ORD00004 | blank | false | blank | PAT00004 | PHY10001 | consult | pending | 2024-05-28T13:05:00 | blank | blank | blank | blank | cardiology | blank | blank | blank | urgent | Consult for chest pain. | ADM11001 | other | blank |
| ORD00005 | blank | true | blank | PAT00005 | PHY10004 | nursing | completed | 2024-05-29T11:30:00 | blank | blank | blank | blank | blank | wound care | wound_protocol_alert | order_modified | routine | Protocol applied. | NUR90002 | nurse | 2024-05-29T15:00:00 |
| ORD00006 | oral | true | blank | PAT00006 | PHY10005 | medication | cancelled | 2023-11-15T09:00:00 | blank | Warfarin | 2mg | blank | blank | blank | drug_interaction_alert | order_cancelled | routine | Order cancelled due to interaction. | PHY10005 | physician | blank |
| ORD00007 | blank | false | blank | PAT00007 | PHY10006 | order_set | completed | 2024-05-31T08:00:00 | SET0002 | blank | blank | blank | blank | blank | blank | blank | routine | Admission order set. | ADM11002 | other | 2024-05-31T10:00:00 |
| ORD00008 | subcutaneous | false | blank | PAT00008 | PHY10007 | medication | in-progress | 2024-06-06T14:10:00 | blank | Insulin | 10 units | blank | blank | blank | blank | blank | stat | Insulin for hyperglycemia. | PHR80001 | pharmacist | blank |
| ORD00009 | blank | true | blank | PAT00009 | PHY10002 | lab | completed | 2024-05-27T07:45:00 | blank | blank | blank | CMP | blank | blank | duplicate_order_alert | no_action | routine | Completed. No duplicate found. | NUR90003 | nurse | 2024-05-27T11:00:00 |
| ORD00010 | blank | false | MRI | PAT00010 | PHY10003 | imaging | in-progress | 2024-06-07T15:00:00 | blank | blank | blank | blank | blank | blank | blank | blank | stat | MRI for neuro symptoms. | PHY10003 | physician | blank |
| ORD00011 | blank | false | blank | PAT00011 | PHY10008 | nursing | pending | 2024-05-30T16:40:00 | blank | blank | blank | blank | blank | IV placement | blank | blank | stat | Start IV prior to imaging. | NUR90004 | nurse | blank |
| ORD00012 | oral | false | blank | PAT00012 | PHY10009 | medication | completed | 2024-05-24T10:05:00 | blank | Lisinopril | 20mg | blank | blank | blank | blank | blank | routine | Routine hypertension med. | PHY10009 | physician | 2024-05-24T11:00:00 |
| ORD00013 | blank | true | blank | PAT00013 | PHY10010 | lab | in-progress | 2024-06-02T08:30:00 | blank | blank | blank | Urinalysis | blank | blank | abnormal_value_alert | no_action | urgent | Monitor for infection. | NUR90005 | nurse | blank |
| ORD00014 | blank | false | blank | PAT00014 | PHY10011 | consult | completed | 2024-04-22T09:00:00 | blank | blank | blank | blank | nephrology | blank | blank | blank | routine | Consult for renal function. | ADM11003 | other | 2024-04-22T13:00:00 |
| ORD00015 | oral | true | blank | PAT00015 | PHY10012 | medication | pending | 2024-06-04T09:30:00 | blank | Atorvastatin | 10mg | blank | blank | blank | allergy_alert | order_modified | routine | Statin dose modified. | PHY10012 | physician | blank |
| ORD00016 | blank | false | blank | PAT00016 | PHY10013 | order_set | pending | 2024-05-25T11:15:00 | SET0003 | blank | blank | blank | blank | blank | blank | blank | blank | Preop checklist. | ADM11004 | other | blank |
| ORD00017 | blank | false | blank | PAT00017 | PHY10005 | nursing | completed | 2023-12-08T07:00:00 | blank | blank | blank | blank | blank | catheter care | blank | blank | routine | Catheter care every shift. | NUR90006 | nurse | 2023-12-08T10:00:00 |
| ORD00018 | blank | false | X-ray | PAT00018 | PHY10014 | imaging | completed | 2024-06-05T12:00:00 | blank | blank | blank | blank | blank | blank | blank | blank | routine | X-ray for suspected fracture. | PHY10014 | physician | 2024-06-05T13:30:00 |
| ORD00019 | blank | false | blank | PAT00019 | PHY10015 | lab | in-progress | 2024-06-02T17:25:00 | blank | blank | blank | Electrolytes | blank | blank | blank | blank | urgent | Monitor potassium levels. | NUR90007 | nurse | blank |
| ORD00020 | oral | true | blank | PAT00020 | PHY10016 | medication | completed | 2024-06-04T07:10:00 | SET0004 | Amoxicillin | 500mg | blank | blank | blank | allergy_alert | order_cancelled | stat | Allergy detected, order cancelled. | PHY10016 | physician | 2024-06-04T08:30:00 |
What the 110 rows show
from the 110-row sample- 27%decision_
support_ triggered = true - 3decision support action takens
- 3order priorities
- 4order statuses
- 4entered by roles
- 6order types
- string 19
- datetime 2
- boolean 1
Columns
22 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 19 columns | |||
order_id | string | Unique identifier for the physician orderunique | ORD00001 |
patient_id | string | Unique identifier for the patient receiving the order | PAT00001 |
physician_id | string | Unique identifier for the ordering physician | PHY10001 |
order_type | string | Type of order (e.g., medication, lab, imaging, consult, nursing, order set)6 values | medication |
order_status | string | Current status of the order (e.g., pending, completed, cancelled, in-progress)pending · completed · cancelled · in-progress | completed |
order_set_id | string | Identifier for the order set if the order is part of a predefined set (blank if not applicable)optional | SET0001 |
medication_name | string | Name of the medication ordered (blank if not applicable)optional | Metoprolol |
medication_dose | string | Dose of the medication ordered (blank if not applicable)optional | 50mg |
medication_route | string | Route of administration for the medication (e.g., oral, IV, IM; blank if not applicable)3 routes · optional | oral |
lab_test_name | string | Name of the laboratory test ordered (blank if not applicable)optional | CBC |
imaging_type | string | Type of imaging study ordered (e.g., X-ray, MRI, CT; blank if not applicable)4 types · optional | CT |
consult_service | string | Consulted specialty/service (e.g., cardiology, nephrology; blank if not applicable)7 services · optional | cardiology |
nursing_order_detail | string | Details of the nursing order (e.g., wound care, IV placement; blank if not applicable)optional | wound care |
decision_support_alert_type | string | Type of alert or recommendation provided by decision support (blank if not applicable)optional | max_dose_alert |
decision_support_action_taken | string | Action taken in response to decision support (e.g., order modified, order cancelled, no action; blank if not applicable)order_modified · order_cancelled · no_action · · optional | order_modified |
order_priority | string | Priority of the order (e.g., routine, stat, urgent)routine · stat · urgent · · optional | routine |
order_comments | string | Additional comments or instructions provided by the physicianoptional | CBC ordered for fever. |
entered_by_user_id | string | Identifier for the user who entered the order (could be physician or delegate) | PHY10001 |
entered_by_role | string | Role of the user who entered the order (e.g., physician, nurse, pharmacist)physician · nurse · pharmacist · other | physician |
| Dates and times 2 columns | |||
order_datetime | datetime | Date and time when the order was placed | 2024-05-30T09:14:00 |
order_completed_datetime | datetime | Date and time when the order was completed (blank if not yet completed)optional | 2024-05-30T14:18:00 |
| True or false 1 column | |||
decision_support_triggered | boolean | Indicates if clinical decision support was triggered during order entry | true |
Use it for
A healthcare dashboard
The decision_
support_ triggered rate, decision_ support_ triggered by medication_ route and a breakdown of imaging_ type. Excel, Power BI or Tableau. Why do 30 of 110 rows have decision_
support_ triggered = true? A class exercise
Hand out the rows and one question. Everyone works from the same 110 rows.
- Orders110ORD00001oralORD00002—ORD00005—
A software demo
Believable orders with patient_
id, physician_ id and order_ type to fill a screen in front of a buyer.
blueprint · physician-orders-and-cpoe-data
Behind this dataset
Same schema. As many rows as you need.
These 110 rows came out of a blueprint — 22 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.
- Order ID unique per order
- Order type: medication, lab, imaging, consult, procedure, diet, nursing
- Ordering provider with NPI
- Co-signature required for residents or mid-levels
- Order date/time and start date/time
- Priority: routine, urgent, stat, ASAP
- Order details specific to type (dose for meds, test for labs)
- Indications and reason for order
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
- physician-orders-and-cpoe-data