Data Extraction Scripts
Extraction Formats: CSV
Passive Data
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 |
Active Data
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 |