BigQuery schema: user_trials
The BigQuery table gse-roar-assessment:assessment.user_trials
conforms to the following schema.
Field name | Data type | Key type | Description |
---|---|---|---|
trial_id | STRING | PK | The unique trial ID |
run_id | STRING | FK | The ID of the run that this trial belongs to |
roar_uid | STRING | FK | The user's unique ID in the ROAR system |
document_name | STRING | UK | The database document path |
timestamp | TIMESTAMP | A timestamp indicating when the database document was last modified | |
assessment_stage | STRING | Indicates the type of trial, either "practice_response" or "test_response" | |
audio_feedback | STRING | ||
block | STRING | ||
block_id | STRING | ||
button_response | INTEGER | Indicates the button that the participant clicked on | |
corpus_id | STRING | ||
correct | INTEGER | Indicates whether the response was correct | |
correct_response | STRING | Indicates the expected correct response | |
difficulty | STRING | Item difficulty parameter | |
goal | STRING | ||
internal_node_id | STRING | The internal node ID of this trial in the jsPsych timeline | |
item | STRING | ||
item_id | STRING | ||
keyboard_response | STRING | Indicates the keyboard button that the participant pressed | |
realpseudo | STRING | ||
response | STRING | ||
response_input | STRING | ||
response_source | STRING | ||
rt | INTEGER | Reaction time in milliseconds | |
save_trial | BOOLEAN | Always true | |
server_timestamp | TIMESTAMP | A timestamp indicating when this trials was saved to Firestore | |
start_time | STRING | Indicates the start time of the run | |
start_time_unix | INTEGER | Indicates the start time of the run as measured by the number of non-leap second since the Unix epoch | |
stim | STRING | ||
stimulus | STRING | The stimulus that was presented to the participant | |
stimulus_rule | STRING | ||
story | BOOLEAN | ||
subtask | STRING | ||
task_id | STRING | The ID of the task to which this trial belongs | |
theta_estimate | FLOAT | Ability estimate | |
theta_estimate_2 | FLOAT | A second ability estimate | |
theta_std_err | FLOAT | The standard error in the ability estimate | |
theat_std_err_2 | FLOAT | The standard error in the second ability estimate | |
time_elapsed | INTEGER | Time elapsed since the beginning of the run | |
timezone | STRING | The timezone in which this trial was completed | |
trial_num_block | INTEGER | ||
trial_num_total | INTEGER | ||
trial_index | INTEGER | ||
trial_type | STRING | ||
truefalse | STRING | ||
word | STRING | ||
meta_data | STRING | A serialized (a.k.a. stringified) JSON object containing all other trial data |