Data Extraction Scripts

Extraction Formats: CSV

CSV ColumnName	Description
key.projectId	A 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.userId	The Study ID field, the principle patient identifier used to link all the data e.g. c4d44114-f813-45a3-872b-f52dcd9fb1ca
key.sourceId	Identifier for the specific datasource e.g. d391c43e-7136-4f5e-8ac7-12hf3485eb4b
value.time	source timestamp note this will be the same as value.timeReceived for phone sensors e.g. 1536703200,
value.timeReceived	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

CSV ColumnName	Description
key.projectId	A 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.userId	The Study ID field, the principle patient identifier used to link all the data e.g. c4d44114-f813-45a3-872b-f52dcd9fb1ca
key.sourceId	Identifier for the specific datasource e.g. d391c43e-7136-4f5e-8ac7-12hf3485eb4b
value.time	source timestamp note this will be the same as









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.timeCompleted	value.name	value.version	value.answers.0.questionId	value.answers.0.value	value.answers.0.startTime	value.answers.0.endTime
1530782859.527	PHQ8	0.1.8	phq8_1	0	1530782796.034	1530782806.676