Column descriptions

group_session
The group session ID
player_1_id
Player 1's participant ID
player_2_id
Player 2's participant ID
player_3_id
Player 3's participant ID
timestamp_unix
Unix timestamp of the observation
timestamp_iso8601
ISO-8601 timestamp of the observation.
task_started
Whether the task has started (1) or not (0).
seconds
The number of seconds left in the game (not shown to participants).
ball_position_x
The x-coordinate of the ball.
ball_position_y
The y-coordinate of the ball.
player_1_paddle_position_x
The x-coordinate of the pixel at the top left corner of player 1's paddle.
player_1_paddle_position_y
The y-coordinate of the pixel at the top left corner of player 1's paddle.
player_2_paddle_position_x
The x-coordinate of the pixel at the top left corner of player 2's paddle.
player_2_paddle_position_y
The y-coordinate of the pixel at the top left corner of player 2's paddle.
player_3_paddle_position_x
The x-coordinate of the pixel at the top left corner of player 3's paddle.
player_3_paddle_position_y
The y-coordinate of the pixel at the top left corner of player 3's paddle.
ai_paddle_position_x
The x-coordinate of the pixel at the top left corner of the AI player's paddle.
ai_paddle_position_y
The y-coordinate of the pixel at the top left corner of the AI player's paddle.
team_score
The team's score.
ai_score
The score of the AI player.

where player_1_id = 134

View and edit SQL

Suggested facets: task_started, team_score, ai_score, timestamp_iso8601 (date)

Link group_session player_1_id player_2_id player_3_id timestamp_unix timestamp_iso8601 task_started seconds ball_position_x ball_position_y player_1_paddle_position_x player_1_paddle_position_y player_2_paddle_position_x player_2_paddle_position_y player_3_paddle_position_x player_3_paddle_position_y ai_paddle_position_x ai_paddle_position_y team_score ai_score
exp_2023_04_18_14 134 136 137 1681857634.6139696 2023-04-18T22:40:34.613970+00:00 0 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_04_18_14 134 136 137 1681857634.629883 2023-04-18T22:40:34.629883+00:00 0 10 1285 725 880 470 880 880 880 474 1660 476 0 0
exp_2023_04_18_14 134 136 137 1681857634.6460495 2023-04-18T22:40:34.646049+00:00 0 10 1285 725 880 470 880 880 880 474 1660 488 0 0
exp_2023_04_18_14 134 136 137 1681857634.6622822 2023-04-18T22:40:34.662282+00:00 0 10 1285 725 880 470 880 880 880 474 1660 500 0 0
exp_2023_04_18_14 134 136 137 1681857634.6785214 2023-04-18T22:40:34.678521+00:00 0 10 1285 725 880 470 880 880 880 474 1660 500 0 0
exp_2023_04_18_14 134 136 137 1681857634.6937518 2023-04-18T22:40:34.693752+00:00 0 10 1285 725 880 470 880 880 880 474 1660 512 0 0
exp_2023_04_18_14 134 136 137 1681857634.7099855 2023-04-18T22:40:34.709985+00:00 0 10 1285 725 880 470 880 880 880 474 1660 524 0 0
exp_2023_04_18_14 134 136 137 1681857634.726195 2023-04-18T22:40:34.726195+00:00 0 10 1285 725 880 470 880 880 880 474 1660 536 0 0
exp_2023_04_18_14 134 136 137 1681857634.7424145 2023-04-18T22:40:34.742414+00:00 0 10 1285 725 880 470 880 880 880 474 1660 548 0 0
exp_2023_04_18_14 134 136 137 1681857634.7586415 2023-04-18T22:40:34.758641+00:00 0 10 1285 725 880 470 880 880 880 474 1660 560 0 0
exp_2023_04_18_14 134 136 137 1681857634.774863 2023-04-18T22:40:34.774863+00:00 0 10 1285 725 880 470 880 880 880 474 1660 572 0 0
exp_2023_04_18_14 134 136 137 1681857634.7910557 2023-04-18T22:40:34.791056+00:00 0 10 1285 725 880 470 880 880 880 474 1660 584 0 0
exp_2023_04_18_14 134 136 137 1681857634.807254 2023-04-18T22:40:34.807254+00:00 0 10 1285 725 880 470 880 880 880 474 1660 584 0 0
exp_2023_04_18_14 134 136 137 1681857634.8234725 2023-04-18T22:40:34.823472+00:00 0 10 1285 725 880 470 880 880 880 474 1660 596 0 0
exp_2023_04_18_14 134 136 137 1681857634.8386705 2023-04-18T22:40:34.838670+00:00 0 10 1285 725 880 470 880 880 880 474 1660 608 0 0
exp_2023_04_18_14 134 136 137 1681857634.8548827 2023-04-18T22:40:34.854883+00:00 0 10 1285 725 880 470 880 880 880 474 1660 620 0 0
exp_2023_04_18_14 134 136 137 1681857634.871113 2023-04-18T22:40:34.871113+00:00 0 10 1285 725 880 470 880 880 880 474 1660 632 0 0
exp_2023_04_18_14 134 136 137 1681857634.8873672 2023-04-18T22:40:34.887367+00:00 0 10 1285 725 880 470 880 880 880 474 1660 644 0 0
exp_2023_04_18_14 134 136 137 1681857634.9036376 2023-04-18T22:40:34.903638+00:00 0 10 1285 725 880 470 880 880 880 474 1660 656 0 0
exp_2023_04_18_14 134 136 137 1681857634.919872 2023-04-18T22:40:34.919872+00:00 0 10 1285 725 880 470 880 880 880 474 1660 656 0 0
exp_2023_04_18_14 134 136 137 1681857634.936088 2023-04-18T22:40:34.936088+00:00 0 10 1285 725 880 470 880 880 880 474 1660 668 0 0
exp_2023_04_18_14 134 136 137 1681857634.9523022 2023-04-18T22:40:34.952302+00:00 0 10 1285 725 880 470 880 880 880 474 1660 678 0 0
exp_2023_04_18_14 134 136 137 1681857634.9685495 2023-04-18T22:40:34.968549+00:00 0 10 1285 725 880 470 880 880 880 474 1660 682 0 0
exp_2023_04_18_14 134 136 137 1681857634.9837759 2023-04-18T22:40:34.983776+00:00 0 10 1285 725 880 470 880 880 880 474 1660 683 0 0
exp_2023_04_18_14 134 136 137 1681857634.99996 2023-04-18T22:40:34.999960+00:00 0 10 1285 725 880 470 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.0162065 2023-04-18T22:40:35.016207+00:00 0 10 1285 725 880 470 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.0324364 2023-04-18T22:40:35.032436+00:00 0 10 1285 725 880 473 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.0477242 2023-04-18T22:40:35.047724+00:00 0 10 1285 725 880 474 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.0639493 2023-04-18T22:40:35.063949+00:00 0 10 1285 725 880 474 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.080174 2023-04-18T22:40:35.080174+00:00 0 10 1285 725 880 476 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.0963905 2023-04-18T22:40:35.096390+00:00 0 10 1285 725 880 477 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.1126184 2023-04-18T22:40:35.112618+00:00 0 10 1285 725 880 481 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.1288471 2023-04-18T22:40:35.128847+00:00 0 10 1285 725 880 482 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.1450498 2023-04-18T22:40:35.145050+00:00 0 10 1285 725 880 485 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.1612709 2023-04-18T22:40:35.161271+00:00 0 10 1285 725 880 489 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.1774912 2023-04-18T22:40:35.177491+00:00 0 10 1285 725 880 489 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.1926966 2023-04-18T22:40:35.192697+00:00 0 10 1285 725 880 490 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.208913 2023-04-18T22:40:35.208913+00:00 0 10 1285 725 880 490 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.225141 2023-04-18T22:40:35.225141+00:00 0 10 1285 725 880 490 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.241347 2023-04-18T22:40:35.241347+00:00 0 10 1285 725 880 490 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.2575734 2023-04-18T22:40:35.257573+00:00 0 10 1285 725 880 490 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.2728212 2023-04-18T22:40:35.272821+00:00 0 10 1285 725 880 491 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.2890236 2023-04-18T22:40:35.289024+00:00 0 10 1285 725 880 491 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.3052294 2023-04-18T22:40:35.305229+00:00 0 10 1285 725 880 491 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.321433 2023-04-18T22:40:35.321433+00:00 0 10 1285 725 880 491 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.3376482 2023-04-18T22:40:35.337648+00:00 0 10 1285 725 880 491 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.3539188 2023-04-18T22:40:35.353919+00:00 0 10 1285 725 880 491 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.3701403 2023-04-18T22:40:35.370140+00:00 0 10 1285 725 880 491 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.3863678 2023-04-18T22:40:35.386368+00:00 0 10 1285 725 880 491 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.4026318 2023-04-18T22:40:35.402632+00:00 0 10 1285 725 880 491 880 880 880 474 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.4188006 2023-04-18T22:40:35.418801+00:00 0 10 1285 725 880 491 880 880 880 475 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.4350085 2023-04-18T22:40:35.435009+00:00 0 10 1285 725 880 491 880 880 880 477 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.4512148 2023-04-18T22:40:35.451215+00:00 0 10 1285 725 880 491 880 880 880 477 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.4674304 2023-04-18T22:40:35.467430+00:00 0 10 1285 725 880 492 880 880 880 478 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.4836433 2023-04-18T22:40:35.483643+00:00 0 10 1285 725 880 492 880 880 880 478 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.4998653 2023-04-18T22:40:35.499865+00:00 0 10 1285 725 880 493 880 880 880 481 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.5161138 2023-04-18T22:40:35.516114+00:00 0 10 1285 725 880 498 880 880 880 481 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.5323536 2023-04-18T22:40:35.532354+00:00 0 10 1285 725 880 501 880 880 880 485 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.5486512 2023-04-18T22:40:35.548651+00:00 0 10 1285 725 880 509 880 880 880 492 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.5648837 2023-04-18T22:40:35.564884+00:00 0 10 1285 725 880 511 880 880 880 501 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.5811162 2023-04-18T22:40:35.581116+00:00 0 10 1285 725 880 516 880 880 880 514 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.5973513 2023-04-18T22:40:35.597351+00:00 0 10 1285 725 880 523 880 880 880 524 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.6135669 2023-04-18T22:40:35.613567+00:00 0 10 1285 725 880 532 880 880 880 531 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.6287868 2023-04-18T22:40:35.628787+00:00 0 9 1285 725 880 532 880 880 880 539 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.6450431 2023-04-18T22:40:35.645043+00:00 0 9 1285 725 880 545 880 880 880 546 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.6612554 2023-04-18T22:40:35.661255+00:00 0 9 1285 725 880 545 880 880 880 558 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.6774743 2023-04-18T22:40:35.677474+00:00 0 9 1285 725 880 554 880 880 880 564 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.692721 2023-04-18T22:40:35.692721+00:00 0 9 1285 725 880 570 880 880 880 564 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.7089338 2023-04-18T22:40:35.708934+00:00 0 9 1285 725 880 582 880 880 880 573 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.7251503 2023-04-18T22:40:35.725150+00:00 0 9 1285 725 880 593 880 880 880 578 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.7413867 2023-04-18T22:40:35.741387+00:00 0 9 1285 725 880 594 880 880 880 582 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.757689 2023-04-18T22:40:35.757689+00:00 0 9 1285 725 880 597 880 880 880 582 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.7739272 2023-04-18T22:40:35.773927+00:00 0 9 1285 725 880 601 880 880 880 582 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.7901566 2023-04-18T22:40:35.790157+00:00 0 9 1285 725 880 601 880 880 880 582 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.806398 2023-04-18T22:40:35.806398+00:00 0 9 1285 725 880 601 880 880 880 582 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.8226209 2023-04-18T22:40:35.822621+00:00 0 9 1285 725 880 601 880 880 880 582 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.8378437 2023-04-18T22:40:35.837844+00:00 0 9 1285 725 880 602 880 880 880 582 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.8540545 2023-04-18T22:40:35.854054+00:00 0 9 1285 725 880 603 880 880 880 582 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.8702826 2023-04-18T22:40:35.870283+00:00 0 9 1285 725 880 604 880 880 880 581 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.8865063 2023-04-18T22:40:35.886506+00:00 0 9 1285 725 880 605 880 880 880 577 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.9017372 2023-04-18T22:40:35.901737+00:00 0 9 1285 725 880 607 880 880 880 571 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.9180098 2023-04-18T22:40:35.918010+00:00 0 9 1285 725 880 608 880 880 880 562 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.934289 2023-04-18T22:40:35.934289+00:00 0 9 1285 725 880 611 880 880 880 561 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.9505463 2023-04-18T22:40:35.950546+00:00 0 9 1285 725 880 613 880 880 880 561 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.9657924 2023-04-18T22:40:35.965792+00:00 0 9 1285 725 880 613 880 880 880 561 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.982082 2023-04-18T22:40:35.982082+00:00 0 9 1285 725 880 615 880 880 880 561 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857635.998409 2023-04-18T22:40:35.998409+00:00 0 9 1285 725 880 616 880 880 880 568 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.0146723 2023-04-18T22:40:36.014672+00:00 0 9 1285 725 880 617 880 880 880 568 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.0309398 2023-04-18T22:40:36.030940+00:00 0 9 1285 725 880 617 880 880 880 577 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.0471714 2023-04-18T22:40:36.047171+00:00 0 9 1285 725 880 617 880 876 880 587 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.0633807 2023-04-18T22:40:36.063381+00:00 0 9 1285 725 880 617 880 866 880 596 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.0796068 2023-04-18T22:40:36.079607+00:00 0 9 1285 725 880 617 880 847 880 604 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.0948296 2023-04-18T22:40:36.094830+00:00 0 9 1285 725 880 617 880 847 880 611 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.111066 2023-04-18T22:40:36.111066+00:00 0 9 1285 725 880 617 880 834 880 616 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.1272745 2023-04-18T22:40:36.127275+00:00 0 9 1285 725 880 617 880 821 880 619 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.143485 2023-04-18T22:40:36.143485+00:00 0 9 1285 725 880 617 880 795 880 619 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.1587229 2023-04-18T22:40:36.158723+00:00 0 9 1285 725 880 617 880 795 880 619 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.1749547 2023-04-18T22:40:36.174955+00:00 0 9 1285 725 880 617 880 782 880 619 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.1911871 2023-04-18T22:40:36.191187+00:00 0 9 1285 725 880 617 880 769 880 616 1660 684 0 0
exp_2023_04_18_14 134 136 137 1681857636.2074184 2023-04-18T22:40:36.207418+00:00 0 9 1285 725 880 617 880 756 880 610 1660 684 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "ping_pong_cooperative_task_observation" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [player_1_id] INTEGER REFERENCES [participant]([id]),
   [player_2_id] INTEGER REFERENCES [participant]([id]),
   [player_3_id] INTEGER REFERENCES [participant]([id]),
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [task_started] INTEGER,
   [seconds] INTEGER,
   [ball_position_x] INTEGER,
   [ball_position_y] INTEGER,
   [player_1_paddle_position_x] INTEGER,
   [player_1_paddle_position_y] INTEGER,
   [player_2_paddle_position_x] INTEGER,
   [player_2_paddle_position_y] INTEGER,
   [player_3_paddle_position_x] INTEGER,
   [player_3_paddle_position_y] INTEGER,
   [ai_paddle_position_x] INTEGER,
   [ai_paddle_position_y] INTEGER,
   [team_score] INTEGER,
   [ai_score] INTEGER,
   PRIMARY KEY ([group_session], [player_1_id], [player_2_id], [player_3_id], [timestamp_unix])
);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_3_id]
    ON [ping_pong_cooperative_task_observation] ([player_3_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_2_id]
    ON [ping_pong_cooperative_task_observation] ([player_2_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_1_id]
    ON [ping_pong_cooperative_task_observation] ([player_1_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_group_session]
    ON [ping_pong_cooperative_task_observation] ([group_session]);