Participant Data Export Format
The AllParticipants export contains all participants on the project.
Data Fields
Sample CSV Export
ParticipantIdentifier,EmailAddress,FirstName,MiddleName,LastName,Gender,DateOfBirth,SecondaryIdentifier,PostalCode,EnrollmentDate,EventDates,CustomFields,UtcOffset,TimeZone,PreferredLanguage,ParticipantID,MobilePhone,UnsubscribedFromEmails,UnsubscribedFromSMS,InsertedDate,WithdrawDate
MDH-5826-3273,abc@example.com,John,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,
MDH-6392-8549,def@example.com,Allen,Jack,Smith,,1/12/98,,,2018-01-29T15:58:19Z,{},{},-05:00:00,America/Chicago,en,820c2f2d-43fc-47d2-a6a9-08886f5818ba,,false,,2018-01-24T19:12:04Z,2020-09-13T11:48:33Z
MDH-3043-1966,ghi@example.com,Jim,Bob,Smith,M,8/14/87,,,2018-03-22T21:41:28Z,{},"{""DischargeDate"":""2018-11-03""",5:30:00,Asia/Kolkata,es,d30c9752-2da3-45a6-878a-757ea36252b4,(555) 424-1234,,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": "Wafarin"
},
"UtcOffset": "-04:00:00",
"TimeZone": "America/New_York",
"ParticipantID": "ba9c19c4-9938-420f-aba6-d6d6c88c6417",
"MobilePhone": "(555) 387-9020",
"UnsubscribedFromSMS": "true",
"InstertedDate": "2017-12-05T18:15:20Z"
}
{
"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",
"InsertedDate": "2018-01-24T19:12:04Z",
"WithdrawDate": "2020-09-13T11:48:33Z"
}
{
"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",
"UnsubscribedFromSMS": "false",
"InsertedDate": "2018-03-22T09:35:47Z"
}