Data Export - Research Data Set
Research Data Set (questionnaire-based)
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
Most people should use the Outcomes export instead. The research sets are wide, specialist files built for formal research and statistical analysis, and they take more work to interpret. For routine reporting on treatment progress and effectiveness, Outcomes is already analysis-ready and easier to work with. Choose this research set only when you specifically need item-level research data.
A research-oriented export with one row per questionnaire response, including demographics, appointment and respondent details, plus extra columns holding the answer value for each question. This is the item-level research set and can be very wide depending on the measures taken.
Example questions this export can answer
- Build an item-level research dataset keyed by response
- Analyze answers alongside demographics and session number
- Prepare data for statistical analysis of measures over time
| Property | Name | Field Type | Notes | |||||
|---|---|---|---|---|---|---|---|---|
| instituteid | Institute Id | identifier | ||||||
| instituteShortcode | Institute Shortcode | String | ||||||
| questionnaireResponseId | Questionnaire Response ID | identifier | Questionnaire Response | |||||
| questionnaireStatus | Questionnaire Status | enum | registered | partial | preliminary | final | |||
| subjectMrn | Subject MRN | identifier | Patient | |||||
| subjectLegalFirstName | Subject Legal First Name | string | ||||||
| subjectLegalLastName | Subject Legal Last Name | string | ||||||
| subjectLegalName | Subject Legal Name | string | ||||||
| subjectPreferredFirstName | Subject Preferred First Name | string | ||||||
| subjectPreferredLastName | Subject Preferred Last Name | string | ||||||
| subjectPreferredName | Subject Preferred Name | string | ||||||
| subjectPreferredPronouns | Subject Preferred Pronouns | string | ||||||
| subjectGender | Subject Gender | string | ||||||
| subjectDob | Subject DOB | date | ||||||
| subjectBirthYear | Subject Birth Year | date | ||||||
| subjectMirahId | Subject Mirah ID | identifier | ID of the patient or related person | |||||
| organizationId | Organization ID | Identifier | Organization | |||||
| organizationName | Organization Name | string | ||||||
| appointmentDate | Appointment Date | timestamp | ||||||
| appointmentLocalDate | Appointment Local Date | timestamp | ||||||
| practitionerID | Practitioner ID | identifier | ||||||
| practitionerName | Practitioner Name | string | ||||||
| begunDate | Begun Date | timestamp | ||||||
| completionDate | Completion Date | timestamp | ||||||
| daysFromIntake | Days From Intake | string | Field inactive. Will always return 0. | |||||
| sessionNumber | Session Number | string | ||||||
| performerFirstName | Performer First Name | string | ||||||
| performerLastName | Performer Last Name | string | ||||||
| performerRelation | Performer Relation | enum | patient | provider | guardian | teacher | mother | father | child |
| [scales] | These columns will contain answer values for each question where there is a saved response.There are rare instances where multiple answer values can exist for a question. Some questions are multi-select, some scales with multiple respondents, and some behavior edge-cases will create two answers. |