Data Extraction


Data Extraction Scripts






Extraction Formats: CSV

Passive Data

CSV ColumnNameDescription
key.projectIdA Management Portal attribute. The "Human-readable-identifier" if using REDCap is populated into the is field, if using REDCap for study management e.g. RADAR-MSDis-OSR-s1
key.userIdThe Study ID field, the principle patient identifier used to link all the data e.g. c4d44114-f813-45a3-872b-f52dcd9fb1ca
key.sourceIdIdentifier for the specific datasource e.g. d391c43e-7136-4f5e-8ac7-12hf3485eb4b
value.timeper record, source timestamp note this will be the same as value.timeReceived for phone sensors e.g. 1536703200,
value.timeReceivedper record, phone timestamp 


Data Source Specific definitions and values

see

individual schemas for each data source in the git repository https://github.com/RADAR-base/RADAR-Schemas/tree/master/commons

individual specification (e.g. sampling rate, units etc) for each data source in the git repository https://github.com/RADAR-base/RADAR-Schemas/tree/master/specifications

e.g. for acceleration,


value.x

value.y

value.z

acceleration in values in each of the 3 axes

Active Data

CSV ColumnNameDescription
key.projectIdA Management Portal attribute. The "Human-readable-identifier" if using REDCap is populated into the is field, if using REDCap for study management e.g. RADAR-MSDis-OSR-s1
key.userIdThe Study ID field, the principle patient identifier used to link all the data e.g. c4d44114-f813-45a3-872b-f52dcd9fb1ca
key.sourceIdIdentifier for the specific datasource e.g. d391c43e-7136-4f5e-8ac7-12hf3485eb4b
value.timesource timestamp (which as this is always the phone device, we omit value.timeReceived from the schema for aRMT)


Active Data Source Spe

See

individual schemas https://github.com/RADAR-base/RADAR-Schemas/tree/master/commons/active

individual specifications https://github.com/RADAR-base/RADAR-Schemas/tree/master/specifications/active

e.g. for PHQ8




value.timeCompletedCompletion time for the questionnaire. 1530782859.527
value.nameThe name of the aRMT, e.g. PHQ8 questionnaire
value.versionThe schema version: e.g. 0.1.8
value.answers.0.questionIdthe Question ID: phq8_1
value.answers.0.valueThe answer value for the first PHQ8 question (question=0 | phq8_1) 0
value.answers.0.startTimestart time for the first question: e.g. 1530782796.034
value.answers.0.endTimeend time for the first question: e.g. 1530782806.676