EHR Patient Demographics and Registration
This dataset provides comprehensive patient demographic and registration data for healthcare organizations, including unique identifiers, contact details, emergency contacts, insurance information, and race/ethnicity. Designed for master patient indexing, it supports accurate patient identification, care coordination, and regulatory reporting, making it invaluable for clinical workflows and analytics.
Sample rows
preview · 8 of 100 rows · all 27 columns| patient_idstring | genderstring | emergency_contact_relationshipstring | first_namestring | middle_namestring | last_namestring | date_of_birthdate | address_streetstring | address_citystring | address_statestring | address_postal_codestring | address_countrystring | phone_primarystring | phone_secondarystring | emailstring | emergency_contact_namestring | emergency_contact_phonestring | insurance_providerstring | insurance_policy_numberstring | insurance_group_numberstring | preferred_languagestring | racestring | ethnicitystring | ssnstring | medical_record_numberstring | registration_datedatetime | active_statusboolean |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PAT-10001 | female | Spouse | Linda | Anne | Simmons | 1980-05-17 | 321 Oak St | Seattle | WA | 98101 | USA | +1-206-555-1482 | +1-206-555-2482 | linda.simmons80@ | Paul Simmons | +1-206-555-6482 | UnitedHealthcare | UHC5748392A | GRP-99824 | English | White | Non-Hispanic | 537-24-1948 | MRN-3200101 | 2023-11-18T13:22:15 | true |
| PAT-10002 | male | Mother | Miguel | blank | Hernandez | 1992-08-02 | 401 Pine Ave | San Diego | CA | 92103 | USA | +1-619-555-0034 | blank | miguel.hernandez92@ | Maria Hernandez | +1-619-555-1034 | Blue Cross Blue Shield | BCBS838273 | BCBS-10029 | Spanish | White | Hispanic | 637-56-9932 | MRN-3200102 | 2024-02-07T10:09:45 | true |
| PAT-10003 | female | Brother | Aisha | Fatima | Ali | 1975-03-22 | 1123 Maple Dr | Houston | TX | 77005 | USA | +1-713-555-0291 | +1-713-555-1291 | aisha.ali75@ | Imran Ali | +1-713-555-2291 | Aetna | AET-750223 | AETN-12209 | English | Asian | Non-Hispanic | 451-71-2047 | MRN-3200103 | 2024-03-19T15:20:36 | true |
| PAT-10004 | male | Wife | David | Michael | Jones | 1962-11-13 | 89 Elm St | Denver | CO | 80203 | USA | +1-303-555-4902 | blank | davidmjones62@ | Susan Jones | +1-303-555-5902 | blank | blank | blank | English | White | Non-Hispanic | 101-65-3928 | MRN-3200104 | 2024-04-10T09:11:12 | true |
| PAT-10005 | female | Father | Grace | Elizabeth | Kim | 1988-06-29 | 1870 Willow Rd | Portland | OR | 97210 | USA | +1-503-555-0192 | +1-503-555-1192 | gracekim88@ | Daniel Kim | +1-503-555-2192 | Kaiser Permanente | KP-2201384 | KP-80132 | Korean | Asian | Non-Hispanic | 352-44-1087 | MRN-3200105 | 2024-04-05T17:25:15 | true |
| PAT-10006 | male | blank | Brandon | blank | Nguyen | 2002-01-19 | 530 Birch Ave | Sacramento | CA | 95814 | USA | +1-916-555-3982 | blank | brandon.nguyen02@ | blank | blank | Cigna | CGN-4209921 | CGN-30492 | Vietnamese | Asian | Non-Hispanic | 642-23-2911 | MRN-3200106 | 2024-02-15T11:43:22 | true |
| PAT-10007 | male | Daughter | Samuel | Lee | Peterson | 1955-04-08 | 212 Cherry Ln | Minneapolis | MN | 55401 | USA | +1-612-555-8820 | blank | sam.peterson1955@ | Karen Peterson | +1-612-555-9820 | Medicare | MED-8820321 | MED-20032 | English | White | Non-Hispanic | 278-90-1045 | MRN-3200107 | 2023-12-03T16:44:11 | true |
| PAT-10008 | female | Mother | Emily | Rose | Clark | 1999-09-10 | 822 Aspen Rd | Boston | MA | 02110 | USA | +1-617-555-2108 | +1-617-555-3108 | emilyrclark99@ | Sarah Clark | +1-617-555-4108 | Harvard Pilgrim | HP-1092341 | HP-80210 | English | White | Non-Hispanic | 202-44-7890 | MRN-3200108 | 2023-11-01T14:10:22 | true |
| PAT-10009 | male | Sister | Jamal | blank | Washington | 1983-07-23 | 451 Cedar St | Atlanta | GA | 30303 | USA | +1-404-555-7234 | blank | jamal.washington83@ | Monica Washington | +1-404-555-8234 | Humana | HUM-8039843 | HUM-20039 | English | Black | Non-Hispanic | 546-21-8312 | MRN-3200109 | 2024-01-16T13:16:14 | true |
| PAT-10010 | female | Father | Sophia | Marie | Martinez | 2005-02-14 | 1789 Spruce Blvd | Phoenix | AZ | 85016 | USA | +1-602-555-4081 | blank | sophia.martinez05@ | Carlos Martinez | +1-602-555-5081 | Blue Cross Blue Shield | BCBS-524981 | BCBS-15039 | Spanish | White | Hispanic | 298-77-1402 | MRN-3200110 | 2024-04-03T10:54:33 | true |
| PAT-10011 | male | Wife | Raj | Kumar | Patel | 1978-12-30 | 291 Oak Hill Dr | Dallas | TX | 75204 | USA | +1-214-555-4201 | +1-214-555-5201 | rajpatel78@ | Priya Patel | +1-214-555-6201 | Aetna | AET-791234 | AETN-40192 | Hindi | Asian | Non-Hispanic | 409-85-2019 | MRN-3200111 | 2024-02-12T12:09:31 | true |
| PAT-10012 | female | Mother | Courtney | Ava | Foster | 1996-10-07 | 67 Magnolia Blvd | Columbus | OH | 43215 | USA | +1-614-555-8219 | blank | courtney.foster96@ | Lauren Foster | +1-614-555-9219 | Anthem | ANT-821496 | ANT-11029 | English | White | Non-Hispanic | 320-21-4908 | MRN-3200112 | 2024-03-03T16:33:21 | true |
| PAT-10013 | male | Wife | James | Henry | Miller | 1950-07-12 | 901 Ridge Dr | Chicago | IL | 60610 | USA | +1-312-555-6712 | blank | james.miller1950@ | Linda Miller | +1-312-555-7712 | Medicare | MED-671200 | MED-10100 | English | White | Non-Hispanic | 103-82-5091 | MRN-3200113 | 2024-02-19T10:52:02 | true |
| PAT-10014 | female | Father | Yolanda | Maria | Garcia | 1987-04-19 | 1445 Cypress Ct | Miami | FL | 33130 | USA | +1-305-555-0914 | +1-305-555-1914 | yolanda.garcia87@ | Juan Garcia | +1-305-555-2914 | Florida Blue | FB-091487 | FB-41032 | Spanish | White | Hispanic | 312-94-8831 | MRN-3200114 | 2024-04-12T09:50:49 | true |
| PAT-10015 | male | Brother | Tyler | Joseph | White | 1990-01-25 | 612 Main St | Indianapolis | IN | 46204 | USA | +1-317-555-6125 | blank | tyler.white90@ | Jason White | +1-317-555-7125 | blank | blank | blank | English | White | Non-Hispanic | 499-21-2901 | MRN-3200115 | 2024-02-28T12:22:00 | true |
| PAT-10016 | male | Spouse | Anthony | Paul | Johnson | 1971-09-30 | 3804 Cedar St | Charlotte | NC | 28202 | USA | +1-704-555-3804 | blank | anthony.johnson71@ | Sharon Johnson | +1-704-555-4804 | Cigna | CGN-380471 | CGN-20117 | English | Black | Non-Hispanic | 227-11-7832 | MRN-3200116 | 2024-03-13T11:11:49 | true |
| PAT-10017 | female | Mother | Olivia | Grace | Moore | 2010-07-03 | 142 Spruce St | Austin | TX | 78701 | USA | +1-512-555-0142 | blank | olivia.moore10@ | Jessica Moore | +1-512-555-1142 | Aetna | AET-014210 | AETN-12014 | English | White | Non-Hispanic | blank | MRN-3200117 | 2024-04-13T10:15:21 | true |
| PAT-10018 | male | Mother | Eric | William | Brown | 1994-12-05 | 2710 Lakeview Dr | Cleveland | OH | 44113 | USA | +1-216-555-2710 | blank | ericbrown94@ | Nancy Brown | +1-216-555-3710 | Anthem | ANT-271094 | ANT-11027 | English | Black | Non-Hispanic | 287-48-9210 | MRN-3200118 | 2024-03-09T15:19:08 | true |
| PAT-10019 | male | Wife | Matthew | Scott | Evans | 1986-06-11 | 872 Willow Ct | Salt Lake City | UT | 84111 | USA | +1-801-555-8720 | +1-801-555-9720 | matthew.evans86@ | Kelly Evans | +1-801-555-0720 | blank | blank | blank | English | White | Non-Hispanic | 198-52-3321 | MRN-3200119 | 2024-01-24T17:42:05 | true |
| PAT-10020 | female | Mother | Hailey | Jane | Stewart | 2001-04-15 | 34 Poplar Ave | Kansas City | MO | 64108 | USA | +1-816-555-0034 | blank | hailey.stewart01@ | Rebecca Stewart | +1-816-555-1034 | Cigna | CGN-003401 | CGN-20034 | English | White | Non-Hispanic | 321-90-1208 | MRN-3200120 | 2024-03-27T14:01:29 | true |
What the 100 rows show
from the 100-row sample- 4races
- 4ethnicities
- 7preferred languages
- string 24
- date 1
- datetime 1
- boolean 1
Columns
27 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 24 columns | |||
patient_id | string | Master patient index unique identifier for each patientunique | PAT-10001 |
first_name | string | Patient's legal first name | Linda |
middle_name | string | Patient's middle nameoptional | Anne |
last_name | string | Patient's legal last name | Simmons |
gender | string | Patient's gender identitymale · female · other · unknown | female |
address_street | string | Patient's residential street address | 321 Oak St |
address_city | string | Patient's residential city | Seattle |
address_state | string | Patient's residential state or province | WA |
address_postal_code | string | Patient's residential postal or ZIP code | 98101 |
address_country | string | Patient's country of residence | USA |
phone_primary | string | Patient's primary contact phone number | +1-206-555-1482 |
phone_secondary | string | Patient's secondary contact phone numberoptional | +1-206-555-2482 |
email | string | Patient's email addressoptional | aisha.ali75@ |
emergency_contact_name | string | Full name of patient's emergency contactoptional | Paul Simmons |
emergency_contact_relationship | string | Relationship of emergency contact to patient9 relationships · optional | Spouse |
emergency_contact_phone | string | Phone number of emergency contactoptional | +1-206-555-6482 |
insurance_provider | string | Name of patient's primary insurance provideroptional | UnitedHealthcare |
insurance_policy_number | string | Patient's insurance policy numberoptional | UHC5748392A |
insurance_group_number | string | Patient's insurance group numberoptional | GRP-99824 |
preferred_language | string | Patient's preferred language for communication7 languages · optional | English |
race | string | Patient's self-identified race4 races · optional | White |
ethnicity | string | Patient's self-identified ethnicity4 ethnicities · optional | Non-Hispanic |
ssn | string | Patient's Social Security Number (if applicable)unique · optional | 537-24-1948 |
medical_record_number | string | Patient's medical record number (MRN)unique · optional | MRN-3200101 |
| Dates and times 2 columns | |||
date_of_birth | date | Patient's date of birth | 1980-05-17 |
registration_date | datetime | Date and time when patient was registered | 2023-11-18T13:22:15 |
| True or false 1 column | |||
active_status | boolean | Indicates if the patient is currently active in the system | true |
Use it for
A healthcare dashboard
A breakdown of emergency_
contact_ relationship. 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.
- Patients100PAT-10001femalePAT-10002malePAT-10003female
A software demo
Believable patients with first_
name, middle_ name and last_ name to fill a screen in front of a buyer.
blueprint · ehr-patient-demographics-and-registration
Behind this dataset
Same schema. As many rows as you need.
These 100 rows came out of a blueprint — 27 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.
- Medical Record Number (MRN) unique per facility or health system
- Patient name: legal first, middle, last, suffix
- Date of birth required for age calculation
- Social Security Number (SSN) optional, used for identity verification
- Gender: male, female, other, unknown, decline to state
- Race and ethnicity per OMB categories for meaningful use
- Preferred language for interpreter services
- Primary insurance and secondary insurance details
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
- ehr-patient-demographics-and-registration