Hospital admissions
===================

In-patient admissions across a network of 30 hospitals: specialties, doctors, patients, diagnoses, length of stay, billing and how each stay was paid for. Dengue and malaria admissions rise through the monsoon; government insurance covers a large share of bills.

Category: Healthcare
Licence: CC0-1.0
Synthetic data generated by DataStride. Places and seasons are real; hospitals, doctors and patients are fictional. No real health records were used.
Build: 940aea8e3b2c8169

hsp_hospitals (30 rows)
  hospital_id            INTEGER        [key] Hospital identifier.
  hospital_name          VARCHAR(80)    Hospital name (fictional).
  city                   VARCHAR(40)    City.
  ownership              VARCHAR(12)    Ownership.
  beds                   INTEGER        Licensed beds.

hsp_doctors (250 rows)
  doctor_id              INTEGER        [key] Doctor identifier.
  full_name              VARCHAR(80)    Doctor (fictional).
  hospital_id            INTEGER        -> hsp_hospitals.hospital_id Hospital they admit to.
  specialty              VARCHAR(30)    Specialty.
  years_experience       INTEGER        Years in practice.

hsp_patients (2000 rows)
  patient_id             INTEGER        [key] Patient identifier (pseudonymous).
  age                    INTEGER        Age at first admission (banded midpoints).
  sex                    VARCHAR(1)     Sex.
  home_city              VARCHAR(40)    Home city.
  insurance              VARCHAR(20)    Cover held.

hsp_admissions (4000 rows)
  admission_id           INTEGER        [key] Admission identifier.
  patient_id             INTEGER        -> hsp_patients.patient_id Patient admitted.
  doctor_id              INTEGER        -> hsp_doctors.doctor_id Admitting doctor.
  diagnosis              VARCHAR(40)    Principal diagnosis.
  admitted_on            DATE           Admission date.
  admission_type         VARCHAR(12)    How the patient came in.
  discharged_on          DATE           Discharge date; null if still admitted or died in hospital.
  outcome                VARCHAR(20)    Outcome. LAMA = left against medical advice.
  bill_amount            DECIMAL(12,2)  Final bill, INR.
  readmitted_30d         INTEGER        1 if readmitted within 30 days of discharge.

Deliberate data-quality quirks (clean them before you aggregate):
  hsp_admissions.diagnosis: mixed case
