Hospital Patient Records Dataset
Healthcare
Intermediate
CSVXLSXSQL
CategoryHealthcare
DifficultyIntermediate
Rows56K (55,500)
Columns9
File Size7.8 MB
FormatsCSV, XLSX, SQL
LicenseFree for commercial & personal use
Downloads9,640+
Last Updated12 Jun 2026
CreatorDataVix
About this dataset
The Hospital Patient Records Dataset models a hospital’s operational data: patient admissions, diagnoses, treating department, length of stay, discharge outcome and billing amount. It’s built for healthcare analytics practice — measure bed occupancy, analyse length-of-stay by department, track readmissions and build an operational hospital dashboard. All records are synthetic and privacy-safe.
Dataset Contents
The tables included in this dataset and what each one holds.
| Table | Description | Rows |
|---|---|---|
Admissions |
One row per admission with dates, department and outcome. | 56K |
Patients |
De-identified patient demographics. | 21K |
Diagnoses |
Diagnosis codes per admission. | 71K |
Billing |
Charges and payer per admission. | 56K |
Columns Included
Key columns with their datatypes and meaning.
| Column | Datatype | Description |
|---|---|---|
admission_id |
VARCHAR | Unique admission identifier. |
patient_id |
VARCHAR | De-identified patient key. |
admit_date |
DATE | Admission date. |
discharge_date |
DATE | Discharge date. |
department |
VARCHAR | Treating department. |
diagnosis |
VARCHAR | Primary diagnosis category. |
length_of_stay |
INT | Days between admit and discharge. |
outcome |
VARCHAR | Recovered, Referred, Readmitted… |
billing_amount |
DECIMAL | Total billed amount. |
Skills You Can Practice
Power BI Dashboard
SQL Queries
Excel Analysis
Python Pandas
Data Cleaning
KPIs
Length-of-Stay Analysis
Readmission Analysis
Capacity Planning
Operational Analytics
Recommended Projects
01
Hospital Operations Dashboard
02
Length-of-Stay Report
03
Readmission Analysis
04
Department Utilisation
05
Billing Overview
06
Bed Occupancy Trends
Preview
Click any image to enlarge.
Related Datasets
Frequently Asked Questions
Is this dataset free to download?
Yes. Every dataset on DataVix is 100% free to download — no signup, no paywall, no hidden cost. Just click “Download Dataset”.
How do I download the files?
Click the green “Download Dataset” button. Your download starts instantly as a single package containing all included file formats (CSV, XLSX, SQL).
Can I use this dataset for commercial projects?
Free for commercial & personal use. You’re free to use it in your portfolio, client work, YouTube tutorials, blog posts and courses — attribution to DataVix is appreciated but not required.
Which tools does this dataset work with?
It’s ready for Power BI, SQL, Excel, Python. The CSV/XLSX files import directly into Excel, Power BI, Python (pandas) and any SQL database.
Is this real or synthetic data?
It’s realistic, analysis-ready practice data modelled on real-world business scenarios and cleaned for learning — safe to share publicly with no personal or confidential information.