Fake Patient Data: Free Healthcare Test Data for Patients, Visits and Lab Results

Healthcare software, dashboards and SQL practice all need patient-shaped data, but real patient records are off limits. Generate fake patients, visits, lab results and vitals in your browser and download them.

Open the Data Generator

What you can generate

Four linked datasets cover most healthcare test needs. Patients has a patient id, medical record number, name, gender, date of birth, blood type, height, weight, allergy, insurance plan, city and registration date. Hospital visits has the encounter, visit date, visit type, department, doctor, provider NPI, ICD-10 diagnosis code and name, procedure and charges. Lab results has the test, value, unit, reference range and a Low, Normal or High flag. Patient vitals has heart rate, blood pressure, temperature, oxygen saturation, weight and BMI.

Patient ids run from 100001, and the datasets are linked. After you generate Patients, the panel under the download buttons offers Hospital visits, Lab results, Patient vitals and Prescriptions with matching ids, in one ZIP. Every patient_id in those files exists in your Patients file, so joins work at any size.

Values that make sense together

The diagnosis code and the diagnosis name come from the same entry, so E11.9 always sits next to "Type 2 diabetes mellitus without complications". The lab test, its unit, its reference range and its flag also agree with each other: a Hemoglobin of 10.2 g/dL is flagged Low, and a value inside the range is Normal. Vital signs follow bell curves around typical adult values, so most heart rates fall between 60 and 90 and a few are high or low, as in real data.

The provider NPI has a valid check digit, so it passes the format checks that validation code uses.

A quick query to try

Load the visits in SQL on Your Files and run: SELECT diagnosis_name, COUNT(*) AS visits, ROUND(AVG(charges), 2) AS avg_charge FROM hospital_visits GROUP BY diagnosis_name ORDER BY visits DESC; You get the most common diagnoses with their average charge, a typical report to build and test.

What to use it for

Use it to test an EHR import, load a demo database, build a Power BI or Tableau dashboard, practise healthcare analytics in SQL or pandas, or check that a form accepts an ICD-10 code. For pipelines, download Parquet or CSV and run the same file through your tests every time.

What it is not

Every value is random. The diagnoses, drugs and ranges use real public terms so the data looks right, but nothing describes a real person, and the data is not clinically meaningful. Only a few columns are tied together (diagnosis code and name, lab test, unit, range and flag); department, diagnosis, procedure and visit type are independent, so a visit can pair an unlikely department with a diagnosis. Do not use it for research results, billing, or any decision about care. If you need data that follows the statistics of your own file, see GDPR-safe test data, and read test data without production data for how to avoid copying real records into test systems. Check your own privacy rules; this is not legal advice.

Open the Data Generator

Related tool pages

  • Fake Data Generator: Generate realistic fake data online: names, emails, addresses, dates and more, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
  • Test Data Generator: Generate test data for databases and apps: names, emails, addresses, dates and numbers, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
  • Student Data Generator: Fake Student Records: Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
  • Student Marks Dataset Generator: Create a student marks dataset by student, subject and exam for SQL, Excel pivot tables and charts. Free, in your browser.
  • Sample Data for SQL Practice: Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
  • Dummy Data for Excel Practice: Generate dummy sales, student or employee data and download Excel to practise filters, pivot tables and VLOOKUP. Free.

Also try

How to use the Data Generator: step by step

  1. Open the Data Generator and pick Patients, Hospital visits, Lab results or Patient vitals.
  2. Choose the number of rows.
  3. Pick CSV, Excel, JSON or Parquet.
  4. Download the file and load it where you need it.

When to use the Data Generator

  • Test an EHR or patient portal import
  • Build a hospital dashboard with realistic fields
  • Practise healthcare SQL joins on patient_id
  • Demo an app without real patient data

Example

Input: Dataset: Customers, 3 rows

Output: id,name,email 1,Maya Patel,maya.patel@example.com 2,Leo Fischer,leo.fischer@example.com

Frequently asked questions

Is this fake patient data safe to use?

Yes for testing and demos. Every row is random and no value describes a real person. It is not clinical data, so do not use it for research results, billing or care decisions.

Do the diagnosis codes match the diagnosis names?

Yes. The ICD-10 code and the diagnosis name in the same row come from the same entry, so the pair is always consistent.

Can I join patients to visits and lab results?

Yes. After you generate Patients, the related datasets panel creates visits, lab results, vitals and prescriptions that only use the patient ids in your Patients file, so a join on patient_id always matches.

Tip: Generate Patients first, then tick the related datasets under the download buttons and download them as one ZIP. Their patient ids always match the Patients file.