Skip to main content

Data Export - Outcomes Data

Outcomes Export​

Generated by the Bulk Data Export system

The order of columns is subject to change. When parsing files, please ensure to use headers rather than positional parsing to ensure you are reading the data correctly.

What this export contains​

The analysis-ready outcomes file: one row per episode of care per scale, with the intake (baseline) value, the current value, severity categories and progress indicators like delta from intake and trend. It already includes patient, provider, organization and questionnaire names, so it is usable on its own without extra joins. This is the fastest export for treatment-effectiveness reporting.

Example questions this export can answer​

  • Report improvement rates, for example the share of patients whose PHQ-9 dropped below a threshold
  • Show average change from baseline by provider, site or measure
  • Identify patients who are deteriorating or not responding to treatment
  • Build program effectiveness summaries for payers or leadership
PropertyNameField TypeNotes
instituteidInstitute Ididentifier
instituteShortcodeInstitute ShortcodeString
idIdidentifier
patient_idPatient Ididentifier
patient_first_namePatient First Namestring
patient_last_namePatient Last Namestring
organization_idOrganization Ididentifer
organization_nameOrganization Namestring
practitioner_idPractitioner Ididentifier
practitioner_first_namePractitioner First Namestring
practitioner_last_namePractitioner Last Namestring
care_episode_idEpisode of Care Ididentifier
diagnostic_report_idDiagnostic Report Ididentifier
user_idRespondent IdidentifierUser who took the assessment
user_first_nameRespondent First Namestring
user_last_nameRespondent Last Namestring
questionnaire_idQuestionnaire Ididentifier
questionnaire_mnemonicQuestionnaire Unique Codestring
questionnaire_nameQuestionnaire Namestring
score_domainScore Typeraw | normedinterpreted
population_idPopulation IdidentifierOnly used when score_domain is "normed", and represents which population the scale is normed on
population_namePopulation namestringOnly used when score_domain is "normed", and represents which population the scale is normed on
treatment_start_dateTreatment Start DatedatetimeThe start of the care episode. This may be earlier than the first measurement if the respondent did not complete a scale at the start of treatment
days_between_treatment_start_and_baselineDays Between Treatment Start and BaselineintegerThe number of calendar days between when treatment started and when a baseline measure was filled for this scale
baseline_dateBaseline DatedatetimeThe date the first baseline measure was completed for this scale
baseline_severity_categoryBaseline Severity Categorynot_specified | mildmoderatesevereinvalidnot_supportedThe clinical value of the baseline measurement
baseline_severityBaseline SeveritystringDepends on scale - e.g. 'Mild Depression'
baseline_valueBaseline ValuenumberThe numerical raw value for the scale
encounter_target_dateEncounter DatedatetimeThe encounter date for this measurement
session_numberSession NumberintegerThe measurement number for this measurement
days_since_treatment_startDays Since Treatment StartintegerCalendar days between treatment start and this measure administration
weeks_since_treatment_startWeeks Since Treatment StartintegerNumber of rounded-up weeks between treatment start and this measurement
last_measurement_of_weekIs Last Measurement of Week?booleantrue if this measurement is the last measurement of this particular week. This can be used to get a unique measurement per patient per week of care
months_since_treatment_startMonths Since Treatment StartintegerNumber of elapsed calendar months between treatment start and this measurement
last_measurement_of_monthIs Last Measurement of Month?booleantrue if this measurement is the last measurement taken in that month of treatment
is_first_measurementIs First Measurement?booleantrue if this is the first time this scale has been taken by this user
is_last_measurementIs Last Measurementbooleantrue if this is the last measurement on file for this user and episode of care
is_first_of_severityIs First Of Severity?booleantrue if this is the first time this severity has been recorded. E.g. if a patient is severe and moves to 'moderate', the first time they register moderate this column will be 'true'
is_first_of_trendIs First of Trend?booleantrue if this is the first measurement where a change of trend in treatment has been observed
valueValuenumberthe numerical score for this administration
severity_categorySeverity Categorynot_specified | mildmoderatesevereinvalidnot_supportedthe severity category for this administration
severitySeveritystringThe severity for this value, e.g. 'Mild Depression'
trendTrendimproving | stabledecliningnot_supportedWhether the scale is showing a trend according to the psychometrics of the instrument
deltaDeltanumberThe numerical change between baseline and this measurement
severity_better_than_intakeSeverity Better Than Intake?booleanWhether the severity at the current measurement is better than that of intake
severity_worse_than_intakeSeverity Worse Than Intake?booleanWhether the severity at the current measurement is worse than that of intake