Data Extraction
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 | per record, source timestamp note this will be the same as value.timeReceived for phone sensors e.g. 1536703200, |
| value.timeReceived | per 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 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 (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.timeCompleted | Completion time for the questionnaire. 1530782859.527 |
| value.name | The name of the aRMT, e.g. PHQ8 questionnaire |
| value.version | The schema version: e.g. 0.1.8 |
| value.answers.0.questionId | the Question ID: phq8_1 |
| value.answers.0.value | The answer value for the first PHQ8 question (question=0 | phq8_1) 0 |
| value.answers.0.startTime | start time for the first question: e.g. 1530782796.034 |
| value.answers.0.endTime | end time for the first question: e.g. 1530782806.676 |