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
meta_sourcevarcharSource document filename from FHIR meta.source
data_sourcevarcharDeprecated. Use meta_source instead.
data_source_extvarcharIntegration source of the data, derived from FHIR extension