Patient Encounters and Visits
This dataset provides comprehensive records of patient encounters, including admission/discharge dates, encounter types, chief complaints, attending physicians, diagnosis and procedure codes, and encounter status for care coordination. It enables detailed tracking of patient visits, supports clinical analytics, and facilitates care management workflows for healthcare organizations.
Sample rows
preview · 8 of 100 rows · all 19 columns| encounter_idstring | encounter_statusstring | care_coordinator_idstring | patient_idstring | admission_datedate | discharge_datedate | encounter_typestring | chief_complaintstring | attending_physician_idstring | attending_physician_namestring | diagnosis_code_1string | diagnosis_code_2string | diagnosis_code_3string | procedure_code_1string | procedure_code_2string | procedure_code_3string | care_coordinator_namestring | created_atdatetime | updated_atdatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ENC00001 | completed | CC1001 | PAT00012 | 2023-05-12 | 2023-05-15 | inpatient | Severe abdominal pain | PHY001 | Dr. Jennifer Lee | K35.80 | R10.9 | blank | 44970 | blank | blank | Samita Patel | 2023-05-12T09:14:23 | 2023-05-15T17:42:01 |
| ENC00002 | completed | blank | PAT00007 | 2024-01-21 | 2024-01-21 | outpatient | Persistent headache | PHY005 | Dr. Michael Chen | G44.1 | blank | blank | 99214 | blank | blank | blank | 2024-01-21T13:02:11 | 2024-01-21T14:16:43 |
| ENC00003 | completed | CC1022 | PAT00029 | blank | blank | telehealth | Seasonal allergies | PHY003 | Dr. Rachel Kim | J30.1 | R05 | blank | 99443 | blank | blank | Joseph Wright | 2024-03-25T10:29:06 | 2024-03-25T11:20:44 |
| ENC00004 | completed | CC1009 | PAT00001 | 2023-11-07 | 2023-11-08 | emergency | Shortness of breath | PHY002 | Dr. John Nguyen | J45.909 | R06.02 | blank | 93010 | 94010 | blank | Linda Ross | 2023-11-07T19:24:10 | 2023-11-08T10:13:55 |
| ENC00005 | completed | blank | PAT00015 | blank | blank | other | Routine annual check | PHY005 | Dr. Michael Chen | Z00.00 | blank | blank | blank | blank | blank | blank | 2024-04-02T08:06:32 | 2024-04-02T08:28:45 |
| ENC00006 | completed | CC1016 | PAT00009 | 2023-09-19 | 2023-09-21 | inpatient | Chest pain | PHY004 | Dr. Sarah Jones | I20.9 | blank | blank | 92950 | 93010 | blank | Gina Frank | 2023-09-19T15:33:41 | 2023-09-21T09:27:08 |
| ENC00007 | active | CC1018 | PAT00018 | 2024-02-03 | 2024-02-04 | inpatient | High fever | PHY001 | Dr. Jennifer Lee | A41.9 | R50.9 | blank | 96372 | blank | blank | Hugo Martinez | 2024-02-03T11:24:39 | 2024-02-04T07:12:12 |
| ENC00008 | completed | CC1012 | PAT00003 | blank | blank | telehealth | Medication review | PHY003 | Dr. Rachel Kim | Z79.899 | blank | blank | 99442 | blank | blank | Blake Simmons | 2023-12-11T09:58:25 | 2023-12-11T10:21:19 |
| ENC00009 | completed | CC1010 | PAT00024 | 2023-07-23 | 2023-07-23 | emergency | Head injury | PHY002 | Dr. John Nguyen | S06.0X0A | blank | blank | 99285 | blank | blank | Olivia Carter | 2023-07-23T02:16:44 | 2023-07-23T03:41:53 |
| ENC00010 | active | blank | PAT00013 | blank | blank | outpatient | Skin rash | PHY005 | Dr. Michael Chen | L20.82 | blank | blank | 99213 | blank | blank | blank | 2024-03-17T13:15:02 | 2024-03-17T13:15:02 |
| ENC00011 | completed | CC1008 | PAT00027 | 2023-06-02 | 2023-06-04 | inpatient | Fractured wrist | PHY004 | Dr. Sarah Jones | S52.501A | R29.891 | blank | 25600 | blank | blank | Vincent Scott | 2023-06-02T17:36:12 | 2023-06-04T13:22:50 |
| ENC00012 | completed | CC1014 | PAT00005 | blank | blank | telehealth | Follow up for hypertension | PHY001 | Dr. Jennifer Lee | I10 | R03.0 | blank | 99444 | blank | blank | Amara Singh | 2024-05-04T08:42:53 | 2024-05-04T09:05:10 |
| ENC00013 | completed | CC1017 | PAT00022 | 2023-10-15 | 2023-10-17 | inpatient | Pneumonia symptoms | PHY002 | Dr. John Nguyen | J18.9 | R05 | R50.9 | 94010 | 71020 | blank | Shirley Barnes | 2023-10-15T10:03:26 | 2023-10-17T16:10:32 |
| ENC00014 | active | CC1002 | PAT00020 | 2024-04-11 | 2024-04-12 | inpatient | Complicated UTI | PHY005 | Dr. Michael Chen | N39.0 | blank | blank | 81001 | blank | blank | Karen Lim | 2024-04-11T12:22:21 | 2024-04-12T08:59:40 |
| ENC00015 | active | blank | PAT00016 | blank | blank | outpatient | Diabetes management | PHY003 | Dr. Rachel Kim | E11.9 | R73.9 | blank | 99214 | blank | blank | blank | 2024-02-10T15:44:31 | 2024-02-10T15:44:31 |
| ENC00016 | completed | CC1020 | PAT00010 | 2023-12-28 | 2023-12-31 | inpatient | Stroke evaluation | PHY004 | Dr. Sarah Jones | I63.9 | blank | blank | 70450 | 93010 | blank | Ellen Fong | 2023-12-28T19:57:03 | 2023-12-31T09:23:09 |
| ENC00017 | completed | blank | PAT00019 | blank | blank | outpatient | Blood pressure check | PHY002 | Dr. John Nguyen | R03.0 | blank | blank | 99212 | blank | blank | blank | 2023-08-18T09:31:17 | 2023-08-18T09:51:10 |
| ENC00018 | completed | CC1003 | PAT00002 | 2024-03-04 | 2024-03-08 | inpatient | Severe dehydration | PHY003 | Dr. Rachel Kim | E86.0 | R63.4 | blank | 96360 | blank | blank | Marcus Lee | 2024-03-04T10:09:15 | 2024-03-08T16:45:20 |
| ENC00019 | completed | blank | PAT00021 | blank | blank | telehealth | Review lab results | PHY005 | Dr. Michael Chen | R79.9 | blank | blank | 99441 | blank | blank | blank | 2024-04-18T16:03:12 | 2024-04-18T16:15:27 |
| ENC00020 | active | CC1009 | PAT00006 | 2023-08-14 | blank | emergency | Acute asthma attack | PHY002 | Dr. John Nguyen | J45.901 | R06.2 | blank | 94010 | blank | blank | Linda Ross | 2023-08-14T20:48:50 | 2023-08-14T23:02:18 |
What the 100 rows show
from the 100-row sample- 5encounter types
- 17attending physicians
- 17attending physician names
- string 15
- date 2
- datetime 2
Columns
19 columns in two groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
encounter_id | string | Unique identifier for each patient encounter or visitunique | ENC00001 |
patient_id | string | Unique identifier for the patient involved in the encounter | PAT00012 |
encounter_type | string | Type of encounter (e.g., inpatient, outpatient, emergency, telehealth)inpatient · outpatient · emergency · telehealth · other | inpatient |
chief_complaint | string | Primary reason for the patient's visit as stated by the patientoptional | Severe abdominal pain |
attending_physician_id | string | Unique identifier for the attending physician responsible for the encounter | PHY001 |
attending_physician_name | string | Full name of the attending physicianoptional | Dr. Jennifer Lee |
diagnosis_code_1 | string | Primary diagnosis code (e.g., ICD-10) assigned to the encounter | K35.80 |
diagnosis_code_2 | string | Secondary diagnosis code assigned to the encounter (if applicable)optional | R10.9 |
diagnosis_code_3 | string | Tertiary diagnosis code assigned to the encounter (if applicable)optional | R50.9 |
procedure_code_1 | string | Primary procedure code (e.g., CPT) performed during the encounteroptional | 44970 |
procedure_code_2 | string | Secondary procedure code performed during the encounter (if applicable)8 2s · optional | 94010 |
procedure_code_3 | string | Tertiary procedure code performed during the encounter (if applicable)optional | |
encounter_status | string | Current status of the encounter (e.g., active, completed, cancelled, pending)active · completed · cancelled · pending | completed |
care_coordinator_id | string | Unique identifier for the care coordinator assigned to the encounter (if any)optional | CC1001 |
care_coordinator_name | string | Full name of the care coordinator assigned to the encounter (if any)optional | Samita Patel |
| Dates and times 4 columns | |||
admission_date | date | Date the patient was admitted for the encounteroptional | 2023-05-12 |
discharge_date | date | Date the patient was discharged from the encounteroptional | 2023-05-15 |
created_at | datetime | Timestamp when the encounter record was created | 2023-05-12T09:14:23 |
updated_at | datetime | Timestamp when the encounter record was last updatedoptional | 2023-05-15T17:42:01 |
Use it for
A healthcare dashboard
A breakdown of care_
coordinator_ id. Excel, Power BI or Tableau. What pattern can you find in 100 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 100 rows.
- Encounters100ENC00001completedENC00002completedENC00003completed
A software demo
Believable encounters with patient_
id, admission_ date and discharge_ date to fill a screen in front of a buyer.
blueprint · patient-encounters-and-visits
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.
- Encounter ID unique per visit
- Encounter type: outpatient, inpatient, emergency, observation, telehealth
- Admission date/time and discharge date/time for inpatient
- Chief complaint documented at triage
- Attending physician and consulting physicians
- Primary diagnosis and secondary diagnoses (ICD-10)
- DRG (Diagnosis Related Group) for inpatient
- Length of stay calculated for inpatient encounters
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
- patient-encounters-and-visits