SQL Playground

One fictional patient.

• patient_idINTEGERPK

  Patient key

• first_nameTEXT

  Fictional given name

• last_nameTEXT

  Fictional family name

• sexTEXT

  F or M (as recorded at registration)

• birth_dateTEXT

  Date of birth

• cityTEXT

  Home city

• stateTEXT

  Home state

• insurance_typeTEXT

  commercial, medicare, medicaid or self_pay

• deceased_dateTEXT · nullable

  Date of death; NULL if alive at the end of the data

One clinician.

• provider_idINTEGERPK

  Provider key

• full_nameTEXT

  Fictional name

• specialtyTEXT

  Clinical specialty

• clinic_nameTEXT

  Practice or facility

• cityTEXT

  Practice city

• stateTEXT

  Practice state

One patient visit (clinic, telehealth, urgent care, emergency, or hospital stay).

• encounter_idINTEGERPK

  Encounter key

• patient_idINTEGER→ patients

  Patient

• provider_idINTEGER→ providers

  Attending provider

• encounter_classTEXT

  wellness, ambulatory, telehealth, urgent_care, emergency or inpatient

• start_atTEXT

  Visit start (local time)

• end_atTEXT

  Visit end or discharge (local time)

• reason_codeTEXT · nullable

  Diagnosis code for the visit reason; NULL for routine wellness visits

• total_costREAL

  Billed amount in USD

• payer_paidREAL

  Amount covered by insurance in USD

One booked appointment. Completed appointments link to the visit they produced.

• appointment_idINTEGERPK

  Appointment key

• patient_idINTEGER→ patients

  Patient

• provider_idINTEGER→ providers

  Provider booked

• booked_atTEXT

  When the appointment was made

• scheduled_startTEXT

  Appointment time

• statusTEXT

  completed, cancelled, no_show or scheduled (future)

• encounter_idINTEGER · nullable→ encounters

  Resulting encounter for completed appointments; NULL otherwise

One diagnosis recorded for a patient. Chronic conditions have no resolved date.

• condition_idINTEGERPK

  Condition key

• patient_idINTEGER→ patients

  Patient

• encounter_idINTEGER→ encounters

  Encounter where it was recorded

• codeTEXT

  Diagnosis code

• descriptionTEXT

  Diagnosis

• onset_dateTEXT

  Onset date

• resolved_dateTEXT · nullable

  Resolution date; NULL for ongoing conditions

One prescription fill period. Repeat fills of the same drug can overlap or leave gaps.

• medication_idINTEGERPK

  Prescription key

• patient_idINTEGER→ patients

  Patient

• encounter_idINTEGER · nullable→ encounters

  Prescribing encounter

• medication_nameTEXT

  Generic drug, strength and form

• start_dateTEXT

  First day of supply

• stop_dateTEXT · nullable

  First day the fill no longer covers; NULL if still open

• days_supplyINTEGER · nullable

  Days of medication dispensed

• costREAL

  Dispensed cost in USD

One measurement: vital sign or lab result.

• observation_idINTEGERPK

  Observation key

• patient_idINTEGER→ patients

  Patient

• encounter_idINTEGER→ encounters

  Encounter

• observed_atTEXT

  Measurement time

• codeTEXT

  Measurement code (for example BP_SYS, HR, BMI, A1C)

• descriptionTEXT

  Measurement name

• valueREAL · nullable

  Result; NULL when the measurement was attempted but not obtained

• unitTEXT

  Unit of measure

One procedure, test or vaccination performed during an encounter.

• procedure_idINTEGERPK

  Procedure key

• patient_idINTEGER→ patients

  Patient

• encounter_idINTEGER→ encounters

  Encounter

• performed_atTEXT

  Time performed

• codeTEXT

  Procedure code

• descriptionTEXT

  Procedure

• costREAL

  Billed amount in USD