Participant Data Export Format
The AllParticipants export contains all participants on the project.
Data Fields
| Field | Description |
|---|---|
ParticipantIdentifier |
A unique identifier for the participant in this project. This can be set up via the invitation sent to the user, or will be auto-generated if the identifier was not specified in the invitation. |
EmailAddress |
The email address of the participant. |
FirstName |
The first name of the participant. |
MiddleName |
The middle name of the participant. |
LastName |
The last name of the participant. |
Gender |
The gender of the participant. |
DateOfBirth |
The date of birth of the participant. |
SecondaryIdentifier |
Deprecated; a custom field can be used if you require a fully custom participant identifier. |
PostalCode |
The zip/postal code of the participant. |
EnrollmentDate |
The date/time the participant enrolled in this project, in ISO 8601 format. |
EventDates |
Deprecated; participant events are now included in CustomFields. |
CustomFields |
Lists any custom fields associated with the participant, formatted as a JSON string. For example: { "Medication1": "Warfarin","SurgeryDate": "2018-11-01" } |
UtcOffset |
The UTC offset of the participant. |
TimeZone |
The time zone of the participant. |
PreferredLanguage |
The preferred language of the participant. |
ParticipantID |
The stable, automatically generated, internal system identifier for this participant. Universally unique identifier (UUID). |
MobilePhone |
The mobile phone number of the participant. |
UnsubscribedFromEmails |
Whether the participant has unsubscribed from email communications related to this project. |
UnsubscribedFromSMS |
Whether the participant has unsubscribed from SMS communications related to this project. |
InsertedDate |
The date the participant was first created in your project, in ISO 8601 format. |
WithdrawDate |
The date the participant was withdrawn from the project, in ISO 8601 format. |
InstitutionCode |
The code assigned to the participant's institution. |
InstitutionName |
The name of the participant's institution. |
Street1 |
The participant's first address line, from their demographics. |
Street2 |
The participant's second address line, from their demographics. |
City |
The participant's city, from their demographics. |
State |
The participant's state, from their demographics. |
UtcOffset and TimeZone are initially populated when a participant completes a survey via recruitment survey link or email invitation or upon their first login to MyDataHelps.
Sample CSV Export
ParticipantIdentifier,EmailAddress,FirstName,MiddleName,LastName,Gender,DateOfBirth,SecondaryIdentifier,PostalCode,EnrollmentDate,EventDates,CustomFields,UtcOffset,TimeZone,PreferredLanguage,ParticipantID,MobilePhone,UnsubscribedFromEmails,UnsubscribedFromSMS,InsertedDate,WithdrawDate,InstitutionCode,InstitutionName,Street1,Street2,City,State
MDH-5826-3273,abc@example.com,John,Jacob,Smith,,1987-08-14,,15101,2017-12-05T18:25:59Z,{},"{""Medication1"":""Warfarin""}",-04:00:00,America/New_York,,ba9c19c4-9938-420f-aba6-d6d6c88c6417,(555) 387-9020,false,true,2017-12-05T18:15:20Z,,,,123 Sesame,Apt 1,New York,NY
MDH-6392-8549,def@example.com,Allen,Jack,Smith,,1998-01-12,,,2018-01-29T15:58:19Z,{},{},-05:00:00,America/Chicago,en,820c2f2d-43fc-47d2-a6a9-08886f5818ba,,false,false,2018-01-24T19:12:04Z,2020-09-13T11:48:33Z,UA123,University A,,,,
MDH-3043-1966,ghi@example.com,Jim,Bob,Smith,M,1987-08-14,,,2018-03-22T21:41:28Z,{},"{""DischargeDate"":""2018-11-03"",""SurgeryDate"":""2018-11-01""}",05:30:00,Asia/Kolkata,es,d30c9752-2da3-45a6-878a-757ea36252b4,(555) 424-1234,false,false,2018-03-22T09:35:47Z,,,,,,,
Sample JSON Export
{
"ParticipantIdentifier": "MDH-5826-3273",
"EmailAddress": "abc@example.com",
"FirstName": "John",
"MiddleName": "Jacob",
"LastName": "Smith",
"DateOfBirth": "1987-08-14",
"PostalCode": "15101",
"EnrollmentDate": "2017-12-05T18:25:59Z",
"EventDates": {},
"CustomFields": {
"Medication1": "Warfarin"
},
"UtcOffset": "-04:00:00",
"TimeZone": "America/New_York",
"ParticipantID": "ba9c19c4-9938-420f-aba6-d6d6c88c6417",
"MobilePhone": "(555) 387-9020",
"UnsubscribedFromEmails": "false",
"UnsubscribedFromSMS": "true",
"InsertedDate": "2017-12-05T18:15:20Z",
"Street1": "123 Sesame",
"Street2": "Apt 1",
"City": "New York",
"State": "NY"
}
{
"ParticipantIdentifier": "MDH-6392-8549",
"EmailAddress": "def@example.com",
"FirstName": "Allen",
"MiddleName": "Jack",
"LastName": "Smith",
"DateOfBirth": "1998-01-12",
"EnrollmentDate": "2018-01-29T15:58:19Z",
"EventDates": {},
"CustomFields": {},
"UtcOffset": "-05:00:00",
"TimeZone": "America/Chicago",
"PreferredLanguage": "en",
"ParticipantID": "820c2f2d-43fc-47d2-a6a9-08886f5818ba",
"UnsubscribedFromEmails": "false",
"UnsubscribedFromSMS": "false",
"InsertedDate": "2018-01-24T19:12:04Z",
"WithdrawDate": "2020-09-13T11:48:33Z",
"InstitutionCode": "UA123",
"InstitutionName": "University A"
}
{
"ParticipantIdentifier": "MDH-3043-1966",
"EmailAddress": "ghi@example.com",
"FirstName": "Jim",
"MiddleName": "Bob",
"LastName": "Smith",
"Gender": "M",
"DateOfBirth": "1987-08-14",
"EnrollmentDate": "2018-03-22T21:41:28Z",
"EventDates": {},
"CustomFields": {
"DischargeDate":"2018-11-03",
"SurgeryDate":"2018-11-01"
},
"UtcOffset": "05:30:00",
"TimeZone": "Asia/Kolkata",
"PreferredLanguage": "es",
"ParticipantID": "d30c9752-2da3-45a6-878a-757ea36252b4",
"MobilePhone": "(555) 424-1234",
"UnsubscribedFromEmails": "false",
"UnsubscribedFromSMS": "false",
"InsertedDate": "2018-03-22T09:35:47Z"
}