Skip to main content
The patient table contains information on patients, including demographic information such as birth date and gender. Note: The name, address, and telecom fields in this table are from the first indices of the corresponding Patient resource FHIR arrays. To see the full set of demographics, see the patient name, patient address, and patient telecom tables. Primary Keys:
  • patient_id
ColumnData TypeDescription
patient_idvarcharUnique identifier for the patient
first_namevarcharFirst given name
last_namevarcharFamily name (last name)
gendervarcharGender at birth
birth_datedateDate of birth
addressvarcharFirst and second address lines concatenated
cityvarcharCity name
statevarcharState or province code
zip_codevarcharZIP or postal code
emailvarcharEmail address
phonevarcharPhone number
data_sourcevarcharSource of the patient data