patients.csv
This file contains patient information extracted from the FHIR bundle. There will be one row per document in the set.
Columns
patient_id
string
The unique patient ID from the FHIR bundle field patient.id. This may have been set in one of the previous convert operations. See Patient Identifiers.
identifier
string
The first business identifier from the FHIR bundle field patient.identifier where the use type is usual. This may have been set in one of the previous convert operations. See Patient Identifiers.
firstname
string
The patient’s first name.
middlename
string
The patient’s middle name.
birthdate
date
The patient’s date of birth in YYYY-MM-DD format.
race_code, race_display, and race_string
string
The patient’s race. If race information is present in the FHIR bundle as a coded concept (from the CDC Race And Ethnicity code system), code and display are present; otherwise, race_string is populated from any free-text race information available in the bundle.
ethnicity_code, ethnicity_display, and ethnicity_string
string
The patient’s ethnicity. If ethnicity information is present in the FHIR bundle as a coded concept (from the CDC Race And Ethnicity code system), code and display are present; otherwise, ethnicity_string is populated from any free-text ethnicity information available in the bundle.
postalcode
string
The postal code of the patient’s address.
primarycareprovider_npi, primarycareprovider_lastname, primarycareprovider_firstname, primarycareprovider_local_identifier, and primarycareprovider_id
string
The NPI, last name, first name, business identifier, and unique identifier (from providers.csv) of the primary care provider for the patient.
metadata_id
string
Reflects the origin of the data. Uniquely identifies a row in metadata.csv.