Export File Type and Format Summary
After downloading exported data from MyDataHelps Designer, you will have a number of data files in either Comma-Separated Value (CSV) or JSON format. Each file contains data from a single project. This article summarizes the data files and how to use them.
Data exports may contain Protected Health Information (PHI), Personally Identifiable Information (PII), and/or other health-related sensitive information, and must be transferred/stored in accordance with your organization’s security policies in order to ensure participant privacy and data security.
Data Files
The following tables describe the data files, and indicate whether they are available in the JSON export, the CSV export, or both. You can select the export format in your project's data export settings.
Most files contain incremental data from activity such as surveys taken, tasks, collected device data, logs, and other events. However some contain complete datasets or static snapshots, particularly participant data, survey versioning, and external accounts, and will be noted as such below.
Participant Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| AllParticipants | ✓ | ✓ | Information about all participants who have joined the project, including both analog and enrolled participants. |
| ParticipantPlatforms | ✓ | ✓ |
Information about all platforms (e.g. iOS, Android) used by participants to access the study. |
| SegmentParticipantHistory | ✓ | ✓ |
Activity log of when participants enter or leave segments. |
| SegmentParticipants | ✓ | ✓ |
A snapshot of which segments participants are currently in. |
Survey Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| SurveyAnswerChangeLog | ✓ | ✓ |
Detailed logs of when survey answers are modified. |
| SurveyConsentSignatureResults | see description | ✓ |
Detailed results for consent review step responses. In the JSON export, this data is contained in the SurveyResults file. |
| SurveyDictionary | ✓ |
Schema of all configured surveys across all versions. |
|
| SurveyDefinitions | ✓ | ✓ |
Details of all versions of all surveys in the workspace. |
| SurveyQuestionResults | see description | ✓ |
Detailed results for question and form step responses from completed surveys. In the JSON export, this data is contained in the SurveyResults file. |
| SurveyResultChangeLog | ✓ | ✓ |
Detailed logs of when a survey was modified. |
| SurveyResults | ✓ | ✓ |
Information about each completed survey. In the JSON export, this file includes step and question results, consent signatures, and task results. |
| SurveyResultsV2 | ✓ | ✓ |
Full nightly export of survey results, including files for combined results and survey answers per survey. |
| SurveyStepResults | see description | ✓ |
Detailed results for every step the participant completed in a survey. In the JSON export, this data is contained in the SurveyResults file. |
| SurveyTasks | ✓ | ✓ |
Lists survey tasks delivered to participants and their completion status. |
Analytics Events Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| CustomEvents | ✓ | ✓ |
Custom-defined events performed by participants in a project. |
| EmailEvents | ✓ | ✓ | Event data representing all email notifications triggered from MyDataHelps. |
| NotificationSent | ✓ | ✓ |
Event data for all notifications sent from MyDataHelps. |
| ParticipantRegistered | ✓ | ✓ |
Event data relating to participants registering for MyDataHelps. |
| ParticipantUpdated | ✓ | ✓ | Event data relating to updating participant information such as through schedules or manually by a coordinator. |
| PushNotification | ✓ | ✓ | Event data representing all push notifications triggered from MyDataHelps. |
| SMSNotification | ✓ | ✓ |
Event data representing all SMS notifications triggered from MyDataHelps. |
| SurveyStepViewed | ✓ | ✓ |
Event data of all survey steps viewed by participants. |
| ViewViewed | ✓ | ✓ |
Event data representing user app opens and interactions. |
Symptom Shark Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| SymptomSharkDailyOverallExperience | ✓ | ✓ | All overall wellbeing scores submitted by participants in Symptom Shark. |
| SymptomSharkSymptomLogs | ✓ | ✓ | Complete log of symptoms and their severity reported by participants in Symptom Shark. |
| SymptomSharkTreatmentLogs | ✓ | ✓ | Complete log of treatments reported by participants i |
All Symptom Shark exports contain all data for the project; they are not limited to the export period.
Active Task Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| HolePegTest | see note below | ✓ | Detailed results from Hole Peg Test active tasks. |
| NormalizedReactionTime | see note below | ✓ | Detailed results from Normalized Reaction Time active tasks. |
| PacedSerialAdditionTest | see note below | ✓ | Detailed results from Paced Serial Addition Test (PSAT) active tasks. |
| RangeOfMotion | see note below | ✓ | Detailed results from Range of Motion active tasks. |
| SpatialSpanMemory | see note below | ✓ | Detailed results from Spatial Span Memory active tasks. |
| Stroop | see note below | ✓ |
Detailed results from Stroop active tasks. |
| TappingInterval | see note below | ✓ |
Detailed results from Tapping Interval active tasks. |
| TimedWalk | see note below | ✓ |
Detailed results from Timed Walk active tasks. |
| ToneAudiometry | see note below | ✓ |
Detailed results from Tone Audiometry active tasks. |
| TowerOfHanoi | see note below | ✓ |
Detailed results from Tower of Hanoi active tasks. |
| Trailmaking | see note below | ✓ |
Detailed results from Trailmaking active tasks. |
When your project uses the CSV export format for Survey Results, data for Active Tasks is exported in separate data files, organized by task type. When your project uses the JSON export format, Active Task data is included in the SurveyResults file.
Apple Device/Wearable Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| AppleLocationVisits | ✓ | ✓ |
Locations that participants have visited. |
| HealthKitV2ActivitySummaries | ✓ | ✓ |
Activity summary data from Apple HealthKit data captured by the Apple Watch. |
| HealthKitV2Characteristics | ✓ | ✓ |
Participant characteristics from Apple HealthKit data that do not typically change over time, like date of birth. |
| HealthKitV2ClinicalRecords | ✓ | ✓ |
Participant clinical data from Apple HealthKit, if they have linked Apple Health to their provider's Electronic Medical Record (EMR) system. |
| HealthKitV2Electrocardiograms | ✓ | ✓ |
Electrocardiogram (ECG) data from Apple HealthKit data captured by the Apple Watch. |
| HealthKitV2Heartbeats | ✓ | ✓ |
Heartbeat readings from Apple HealthKit data captured by the Apple Watch. |
| HealthKitV2Samples | ✓ | ✓ |
Simple quantity or category samples from Apple HealthKit data, like Heart Rate or Sleep Analysis. |
| HealthKitV2Statistics | ✓ | ✓ |
Daily data summary for specific elements such as daily steps from Apple Healthkit. |
| HealthKitV2Workouts | ✓ | ✓ |
Participant workout data from Apple HealthKit, if they track their workouts using an app or device. In the JSON export, this includes detailed event data. |
| HealthKitV2WorkoutEvents | see description | ✓ |
Detailed breakdown of participant workout data. In the JSON export, this data is contained in the HealthKitWorkouts file. |
| SensorKit | ✓ |
SensorKit data generated by a participants iPhone and paired AppleWatch. |
Fitbit Device/Wearable Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| FitbitActivityLogs | ✓ | ✓ | Log of participant activity details. |
| FitbitBodyWeightLogs | ✓ | ✓ | Log of participant-entered body weight data. |
| FitbitDailyData | ✓ | ✓ | Daily summary of a variety of activity and heart rate data. |
| FitbitDevices | ✓ | ✓ | All devices used by participants. |
| FitbitECGData | ✓ | ✓ |
Electrocardiogram (ECG) data collected by Fitbit devices. In the JSON export format, this includes the waveform data. |
| FitbitECGWaveforms | see description | ✓ |
Details of Fitbit Electrocardiogram (ECG) waveform data. In the JSON export, this data is contained in the FitbitECGData. |
| FitbitIntraday | ✓ | Raw data files returned by the Fitbit Intraday endpoint. | |
| FitbitIntradayCombined | ✓ | ✓ | Detailed data returned by the Fitbit Intraday endpoint. |
| FitbitNutrition | ✓ | ✓ | User-reported food logs. |
| FitbitProfiles | ✓ | ✓ | User profile and preferences for all participants. |
| FitbitRestingHeartRates | ✓ | ✓ | Daily participant resting heart rates. |
| FitbitSleepLogs | ✓ | ✓ |
Daily summary of participant sleep patterns. In the JSON export, this includes log detail data. |
| FitbitSleepLogDetails | see description | ✓ |
Detailed breakdown of participant sleep patterns. In the JSON export, this data is contained in the FitbitSleepLogs file. |
Garmin Device/Wearable Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| GarminActivitySummary | ✓ | ✓ | Summary data from discrete fitness activities. |
| GarminActivityDetailsSummary | ✓ | ✓ |
Detailed information about discrete fitness activities. In the JSON export, this includes laps and detailed sample data. |
| GarminActivityDetailsSummaryLaps | see description | ✓ | In the JSON export, this data is contained in the GarminActivityDetailsSummary. |
| GarminActivityDetailsSummarySamples | see description | ✓ | In the JSON export, this data is contained in the GarminActivityDetailsSummary. |
| GarminActivityFITFile | see description | see description | External sensor data collected during fitness activities, in proprietary FIT format. |
| GarminBloodPressureSummary | ✓ | ✓ | Data from blood pressure readings using a connected device or manually uploaded. |
| GarminBodyCompositionSummary | ✓ | ✓ | Biometric data such as weight or BMI. |
| GarminDailySummary | ✓ | ✓ |
Daily high-level summary data, such as steps and heart rate. In the JSON export, this includes detailed sample data. |
| GarminDailySummarySamples | see description | ✓ |
Heart rate samples throughout the day. In the JSON export, this is included in the GarminDailySummary file. |
| GarminEpochSummary | ✓ | ✓ | High-level summary data like steps and heart rate, in 15-minute intervals. |
| GarminHealthSnapshotSummary | ✓ | ✓ |
Data collected during a Health Snapshot on a compatible device. In the JSON export, this contains detailed sample data. |
| GarminHealthSnapshotSummarySamples | see description | ✓ |
Detailed sample data collected during a Health Snapshot on a compatible device. In the JSON export, this data is contained in the GarminHealthSnapshotSummary file. |
| GarminHeartRateVariabilitySummary | ✓ | ✓ |
Heart Rate Variability (HRV) collected during the overnight sleep window. In the JSON export, this includes detailed sample data. |
| GarminHeartRateVariabilitySummarySamples | see description | ✓ |
Details of Heart Rate Variability (HRV) samples. In the JSON export, this data is contained in the GarminHeartRateVariabilitySummary. |
| ✓ | ✓ | Activity data manually entered by the user, not uploaded from a Garmin device. | |
| GarminMoveIQActivitySummary | ✓ | ✓ | Activity data like running or biking automatically detected by a Garmin device, not initiated by the user. |
| GarminPulseOxSummary | ✓ | ✓ |
Daily blood oxygen saturation data. In the JSON export, this contains detailed sample data. |
| GarminPulseOxSummarySamples | see description | ✓ |
Detailed blood oxygen saturation sample data. In the JSON export, this data is contained in the GarminPulseOxSummary. |
| GarminRespirationSummary | ✓ | ✓ |
Daily respiration data collected by compatible devices. In the JSON export, this contains GarminRespirationSummarySamples data. |
| GarminRespirationSummarySamples | see description | ✓ |
Detailed respiration sample data collected by compatible devices. In the JSON export, this data is contained in the GarminRespirationSummary. |
| GarminSkinTempSummary | ✓ | ✓ |
Variation from normal skin temperature during sleep, collected by compatible devices. |
| GarminSleepSummary | ✓ | ✓ |
Daily Summary of sleep data such as levels and duration. In the JSON export, this contains duration, samples, scores, and naps data. |
| GarminSleepSummaryDuration | see description | ✓ |
Details of sleep levels and duration at each level. In the JSON export, this is contained in the GarminSleepSummary. |
| GarminSleepSummarySamples | see description | ✓ |
Respiration data collected during sleep. In the JSON export, this is contained in the GarminSleepSummary. |
| GarminSleepScores | see description | ✓ |
Detailed breakdown of scores for different sleep levels and aspects. In the JSON export, this is contained in the GarminSleepSummary. |
| GarminSleepSummaryNaps | see description | ✓ |
Details of naps recorded by the device. In the JSON export, this is contained in the GarminSleepSummary. |
| GarminStressDetailSummary | ✓ | ✓ |
Daily summary of stress level data. In the JSON export, this contains samples and body battery events data. |
| GarminStressDetailSummarySamples | see description | ✓ |
Detailed samples of stress value data. In the JSON export, this is contained in the GarminStressDetailSummary. |
| GarminBodyBatteryActivityEvents | see description | ✓ |
Discrete events which affect users' Body Battery levels. In the JSON export, this is contained in the GarminStressDetailSummary. |
| GarminUserMetricsSummary | ✓ | ✓ | Calculated user metrics such as VO2Max and Fitness Age. |
Google Fit Device/Wearable Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| Google Fit | ✓ | ✓ | Health and activity data. |
Google Health Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| GoogleHealthDailyData | ✓ | ✓ | Daily high-level summary data such as steps and average heart rate. |
| GoogleHealthDeleted | ✓ | ✓ | Data deleted by participants from Google Health. |
| GoogleHealthExercise | ✓ | ✓ | Data about recorded exercise sessions, such as running or cycling, recorded in Google Health. |
| GoogleHealthExerciseSplits | see description | ✓ |
Data about split time periods or laps within an exercise session. In the JSON export, this is contained in the GoogleHealthExercise file. |
| GoogleHealthExerciseEvents | see description | ✓ |
Data about discrete events within an exercise session, such as the start and end. In the JSON export, this is contained in the GoogleHealthExercise file. |
| GoogleHealthPairedDevices | ✓ | ✓ |
Data about devices paired to a participant's Google Health account, such as trackers and scales. |
| GoogleHealthProfile | ✓ | ✓ |
Data about a participant's Google Health profile, such as age and stride length. |
| GoogleHealthSettings | ✓ | ✓ |
Data about a participant's Google Health account settings, such as unit and locale preferences. |
| GoogleHealthSleep | ✓ | ✓ | Data about participant's sleep sessions recorded from Google Health sources. |
| GoogleHealthSleepStages | see description | ✓ |
Data about participant's time in each stage during sleep sessions. In the JSON export, this is contained in the GoogleHealthSleep file. |
| GoogleHealthSleepOutOfBedSessions | see description | ✓ |
Data about when participants get out of bed during a sleep session. In the JSON export, this is contained in the GoogleHealthSleep file. |
| GoogleHealthSleepRespiratoryRate | ✓ | ✓ | Data about participant's respiratory rate during sleep sessions recorded from Google Health sources. |
| GoogleHealthSleepRespiratoryRateStages | see description | ✓ |
Data about participant's respiratory rate during sleep stages, such as REM or deep. In the JSON export, this is contained in the GoogleHealthSleepRespiratoryRate file. |
| GoogleHealthTimeSeries | ✓ | ✓ |
A series of data files with more frequent sampling or interval data, such as blood glucose, heart rate, and steps. |
Google Health Connect Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| HealthConnectActiveCaloriesBurnedRecords | ✓ | ✓ | Data about calories burned during exercise or activity collected from Health Connect sources. |
| HealthConnectBloodGlucoseRecords | ✓ | ✓ | Discrete blood glucose data collected from Health Connect sources. |
| HealthConnectBloodPressureRecords | ✓ | ✓ | Discrete blood pressure readings collected from Health Connect sources. |
| HealthConnectBodyTemperatureRecords | ✓ | ✓ | Body Temperature data collected from Health Connect sources. |
| HealthConnectDistanceRecords | ✓ | ✓ | Data about user distances traveled over time collected from Health Connect sources. |
| HealthConnectExerciseRecords | ✓ | ✓ | Data about exercise sessions collected from Health Connect Sources |
| HealthConnectExcerciseLaps | see description | ✓ |
Data about the time length of laps during exercise records. In the JSON export, this is contained in the HealthConnectExerciseRecords. |
| HealthConnectExcerciseRoute | see description | ✓ |
Sequences of location and timestamps associated with a Health Connect exercise record. In the JSON export, this is contained in the HealthConnectExerciseRecords. |
| HealthConnectExcerciseSegments | see description | ✓ |
Sub-types of activities within a Health Connect Exercise record. In the JSON export, this is contained in the HealthConnectExerciseRecords. |
| HealthConnectHeartRateRecords | ✓ | ✓ | Heart rate readings collected from Health Connect sources. |
| HealthConnectHeartRateSamples | see description | ✓ |
Detailed samples of recorded heart rate data. In the JSON export, this is contained in the HealthConnectHeartRateRecords. |
| HealthConnectMindfulnessSessionRecords | ✓ | ✓ | Recorded mindfulness sessions shared with Health Connect. |
| HealthConnectNutritionRecords | ✓ | ✓ | Data about recorded meals and nutrition collected from Health Connect sources. |
| HealthConnectNutrients | see description | ✓ |
Details of nutrients consumed as part of Nutrigion Records. In the JSON export, this is contained in the HealthConnectNutritionRecords. |
| HealthConnectOxygenSaturationRecords | ✓ | ✓ |
Discrete SpO2 readings collected from Health Connect sources. |
| HealthConnectRespiratoryRateRecords | ✓ | ✓ | Discrete data about user respiratory rates collected from Health Connect sources. |
| HealthConnectRestingHeartRateRecords | ✓ | ✓ |
Discrete resting heart rate data collected from Health Connect sources. |
| HealthConnectSkinTemperatureRecords | ✓ | ✓ |
Skin temperature data over time collected from Health Connect. |
| HealthConnectSkinTemperatureDeltas | see description | ✓ |
Details sample data from Skin Temperature Records. In the JSON export, this is contained in the HealthConnectSkinTemperatureRecords. |
| HealthConnectSleepRecords | ✓ | ✓ | Sleep session records collected from Health Connect. |
| HealthConnectSleepStages | see description | ✓ |
Details of the stages of sleep within Sleep Records. In the JSON export, this is contained in the HealthConnectSleepRecords. |
| HealthConnectStepsRecords | ✓ | ✓ | Detailed data about steps taken collected from Health Connect. |
| HealthConnectStepsCadenceRecords | ✓ | ✓ |
Detailed data about walking speeds collected from Health Connect. |
| HealthConnectStepsCadenceSamples | see description | ✓ |
Detailed samples within Steps Cadence Records. In the JSON export, this is contained in the HealthConnectStepsCadenceRecords. |
| HealthConnectTotalCaloriesBurnedRecords | ✓ | ✓ |
Interval data about calories burned over time collected from Health Connect. |
| HealthConnectVO2MaxRecords | ✓ | ✓ | Discrete data about participants' aerobic capacity (VO2 max) from Health Connect. |
| HealthConnectWeightRecords | ✓ | ✓ |
Discrete weight data from Health Connect. |
| HealthConnectDeletedRecords | ✓ | ✓ | Metadata indicating Health Connect data which has been deleted by participants. |
| HealthConnectAggregates | ✓ | ✓ |
Aggregate data derived from other Health Connect sources such as daily and hourly steps. |
Oura Device/Wearable Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| OuraDailyActivity | ✓ | ✓ | Summary data from daily activities. |
| OuraDailyActivityMET | see description | ✓ |
Summary of daily activity recorded sample MET item. In the JSON export, this is contained in the OuraDailyActivity. |
| OuraDailyCardiovascularAge | ✓ | ✓ |
Detailed information about daily cardiovascular age. |
| OuraDailyReadiness | ✓ | ✓ | Summary data of how ready the wearer is for the day. |
| OuraDailyResilience | ✓ | ✓ | Detailed data about the wearer's ability to withstand physiological stress. |
| OuraDailySleep | ✓ | ✓ | Summary data about the wearer's sleep period. |
| OuraDailySpO2 | ✓ | ✓ | Daily SpO2 overview data. |
| OuraDailyStress | ✓ | ✓ | Detailed data of the number of daily minutes the wearer spends in high stress and high recovery. |
| OuraEnhancedTag | ✓ | ✓ |
Summary of the tags a wearer enters within the Oura mobile app. Note: Exports will appear empty if a wearer does not enter a tag within the Oura mobile app. |
| OuraHeartRate | ✓ | ✓ |
Detailed time-series heart rate data throughout the day and night. |
| OuraNotifications | ✓ | ✓ | Summary data of webhook notifications when data is created, updated, or deleted. |
| OuraPersonalInfo | ✓ | ✓ |
Personal data about the wearer, including height and weight. |
| OuraRestModePeriod | ✓ | ✓ |
Detailed information about the wearer's rest periods. |
| OuraRestModePeriodEpisodes | see description | ✓ |
Summary of rest mode period recorded sample episode item. In the JSON export, this is contained in the OuraRestModePeriod. |
| OuraRingConfiguration | ✓ | ✓ |
Summary data about the wearer's Oura devices, including model, size, and color. |
| OuraSession | ✓ | ✓ |
Detailed information about the wearer's interactions with guided and unguided sessions within the Oura mobile app. |
| OuraSessionHeartRate | see description | ✓ |
Summary data of the recorded sample session heart rate. In the JSON export, this is contained in the OuraSession. |
| OuraSessionHeartRateVariability | see description | ✓ |
Summary data of the recorded sample session Hrv. In the JSON export, this is contained in the OuraSession. |
| OuraSessionMotionCount | see description | ✓ |
Summary data of the recorded sample session motion count. In the JSON export, this is contained in the OuraSession. |
| ✓ | ✓ | Summary data about the wearer's sleep data within a given timeframe. | |
| OuraSleepTime | ✓ | ✓ | Recommendations for optimal bedtime using previous sleep data. |
| OuraVo2Max | ✓ | ✓ |
Detailed Vo2 Max summary data. |
| OuraWorkout | ✓ | ✓ |
Summary of the wearer's workouts. |
External Accounts Data Exports
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| ElectronicHealthRecords | ✓ | see description | Complete Electronic Health Records (EHR) data from participants' health care providers, in FHIR format. An accompanying CSV maps participants to FHIR providers and records. |
| ExternalAccountsData | ✓ | ✓ | All external accounts linked to participants and their current status. |
Geographic Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| AirQualityIndexData | ✓ | ✓ | Daily air quality index. |
| WeatherData | ✓ | ✓ | Daily weather forecast. |
Additional Data
| File Name | JSON Available? | CSV Available? | Description |
|---|---|---|---|
| AuxiliaryData | ✓ | ✓ |
Auxiliary data files uploaded to individual participants. |
| ProjectDeviceData | ✓ | ✓ | Device data from any non-standard devices. |
| UploadedFiles | ✓ | ✓ | Files uploaded by participants, via surveys or SDK. |
| UserPermissions | ✓ | ✓ | Details on all users who have permission to access this project, such as coordinators. |
CSV Column Names
As new fields are added to MyDataHelps Designer or to the sensor data services, those fields may be added to the data export files as well. Always use the column headers (the first line of each CSV file) to identify which fields appear in each column. The column header names will remain the same even if the column order changes or new columns are added.
JSON Formatting
Exports selected as JSON will be formatted in Newline Delimited JSON (NDJSON) format, unless otherwise noted. NDJSON consists of an array of JSON objects, one per line.
Associating Data Between Files
Whether you're using JSON or CSV exports, your project data will be spread out across multiple files. Identifiers aid you in cross-referencing data between these files.
Cross-Referencing Participant Data
All participants in MyDataHelps are automatically assigned a static, globally unique `ParticipantID` which can be found in the Participant Data export. You'll find the `ParticipantID` referenced in most data files — survey results, sensor data, etc., so all data related to one participant can be associated together.
The capitalization of `ParticipantID` varies by export file, so joining should always be done in a case-insensitive manner.
For example, consider this sample participant data. Chris Smith has ParticipantID ba9c19c4-9938-420f-aba6-d6d6c88c6417:
ParticipantIdentifier,EmailAddress,FirstName,MiddleName,LastName,Gender,DateOfBirth,SecondaryIdentifier,PostalCode,EnrollmentDate,EventDates,CustomFields,UtcOffset,TimeZone,PreferredLanguage,ParticipantID,MobilePhone,UnsubscribedFromEmails,UnsubscribedFromSMS,InsertedDate,WithdrawDate
MDH-1744-6293,abc@example.com,Chris,Jacob,Smith,,8/14/87,,15101,2017-12-05T18:25:59Z,{},"{""Medication1"":""Wafarin""}",-04:00:00,America/New_York,,ba9c19c4-9938-420f-aba6-d6d6c88c6417,(555) 387-9020,,true,2017-12-05T18:15:20Z,
When we look at the survey results data, we'll see that this result entry is also from participant ba9c19c4-9938-420f-aba6-d6d6c88c6417, so we know it's from Chris.
SurveyResultKey,SurveyKey,SurveyName,SurveyVersion,ParticipantIdentifier,SurveyTaskKey,Type,StartDate,EndDate,DevicePlatform,DeviceName,DeviceOSVersion,InsertedDate,ParticipantID,ScheduleID,ScheduleInterval,ScheduleIntervalType,ScheduleName,ScheduleCategory,UserType,User,Locale,Event,Instance,OriginalResultDate
73b25dbd-e9d9-e711-815b-b9576bf93116,dcbede15-67c9-e711-815a-a2abfc96a420,Consent,0,MDH-1744-6293,,Consent,2017-12-05T13:25:47-05:00,2017-12-05T13:25:58-05:00,iOS,"iPhone7,1",10.0,2017-12-05T18:25:59Z,ba9c19c4-9938-420f-aba6-d6d6c88c6417,,,,,,Participant,,,,2017-12-05T13:25:47-05:00
We can also find Chris in the survey tasks data, to see which survey tasks he's been assigned and whether they're completed. This will help you measure survey adherence.
SurveyTaskKey,ParticipantIdentifier,ParticipantID,SurveyKey,SurveyName,Status,DueDate,InsertedDate,CreatedBy,ModifiedDate
9bb25dbd-e9d9-e711-815b-b9576bf93116,MDH-1744-6293,ba9c19c4-9938-420f-aba6-d6d6c88c6417,059966f9-e3a7-e711-8159-cb0f82935acb,Medical History: Cardiovascular Diagnoses,Incomplete,2017-12-19T18:26:00Z,2017-12-05T18:26:00Z,MyDataHelps Designer Survey Scheduler,2017-12-05T18:26:00Z
The `ParticipantIdentifier` field is typically more easily readable but is not static (i.e. this value could be updated during the study), so it is not recommended to cross-reference using this field.
Cross-Referencing Survey Data
Survey results are also linked together with cross-reference keys. The following table shows how you can associate data from different survey result files.
| Survey | SurveyResult | SurveyStepResult | SurveyQuestionResult | |||
|---|---|---|---|---|---|---|
| SurveyKey | ⇄ | SurveyKey | ||||
| SurveyResultKey | ⇄ | SurveyResultKey | ||||
| SurveyStepResultKey | ⇄ | SurveyStepResultKey | ||||
| SurveyQuestionResultKey |
[Legacy] Data Files
The following data files may exist for ongoing and completed projects, but are not available for new projects.
[Legacy] Participant Data
| File Name | Description |
|---|---|
| EnrolledParticipants | Information about participants who have enrolled in the project via MyDataHelps. |
[Legacy] Analytics Events Data
| File Name | Description |
|---|---|
| EmailNotificationSent | Information about email notifications sent to participants. |
| NotificationsData | Information about notifications delivered to participants. |
| SMSNotificationSent | Information about SMS notifications sent to participants. |
[Legacy] Apple Healthkit
| File Name | Description |
|---|---|
| HealthKitCharacteristics | Participant characteristics from Apple HealthKit data that do not typically change over time, like date of birth. |
| HealthKitSamples | Simple quantity or category samples from Apple HealthKit data, like Heart Rate or Sleep Analysis. |
| HealthKitActivitySummaries |
Activity summary data from Apple HealthKit data captured by the Apple Watch. |
| HealthKitWorkouts |
Participant workout data from Apple HealthKit, if they track their workouts using an app or device. |
| HealthKitWorkoutEvents |
Detailed breakdown of participant workout data. In the JSON export, this data is contained in the HealthKitWorkouts file. |
| HealthKitClinicalData | Participant clinical data from Apple HealthKit, if they have linked Apple Health to their provider's Electronic Medical Record (EMR) system. |