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 = 85

View and edit SQL

Suggested facets: 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_2022_12_05_12 85 90 99908 1670273216.1664147 2022-12-05T20:46:56.166415+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_12_05_12 85 90 99908 1670273216.1831949 2022-12-05T20:46:56.183195+00:00 1 10 1285 725 880 523 880 582 880 776 1660 645 0 0
exp_2022_12_05_12 85 90 99908 1670273216.1983776 2022-12-05T20:46:56.198378+00:00 1 10 1285 725 880 523 880 582 880 776 1660 657 0 0
exp_2022_12_05_12 85 90 99908 1670273216.2145636 2022-12-05T20:46:56.214564+00:00 1 10 1285 725 880 523 880 582 880 776 1660 669 0 0
exp_2022_12_05_12 85 90 99908 1670273216.2307556 2022-12-05T20:46:56.230756+00:00 1 10 1285 725 880 523 880 582 880 776 1660 678 0 0
exp_2022_12_05_12 85 90 99908 1670273216.2469437 2022-12-05T20:46:56.246944+00:00 1 10 1285 725 880 523 880 582 880 776 1660 682 0 0
exp_2022_12_05_12 85 90 99908 1670273216.2631094 2022-12-05T20:46:56.263109+00:00 1 10 1285 725 880 523 880 582 880 776 1660 683 0 0
exp_2022_12_05_12 85 90 99908 1670273216.2792935 2022-12-05T20:46:56.279294+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.29449 2022-12-05T20:46:56.294490+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.3106751 2022-12-05T20:46:56.310675+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.3268628 2022-12-05T20:46:56.326863+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.343046 2022-12-05T20:46:56.343046+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.3592439 2022-12-05T20:46:56.359244+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.3744113 2022-12-05T20:46:56.374411+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.390593 2022-12-05T20:46:56.390593+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.406766 2022-12-05T20:46:56.406766+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.4229217 2022-12-05T20:46:56.422922+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.4391184 2022-12-05T20:46:56.439118+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.4553041 2022-12-05T20:46:56.455304+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.4714985 2022-12-05T20:46:56.471498+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.4877028 2022-12-05T20:46:56.487703+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.5038974 2022-12-05T20:46:56.503897+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.520089 2022-12-05T20:46:56.520089+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.536278 2022-12-05T20:46:56.536278+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.5514646 2022-12-05T20:46:56.551465+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.5676289 2022-12-05T20:46:56.567629+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.5838177 2022-12-05T20:46:56.583818+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.599991 2022-12-05T20:46:56.599991+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.6161473 2022-12-05T20:46:56.616147+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.6323264 2022-12-05T20:46:56.632326+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.648524 2022-12-05T20:46:56.648524+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.6646934 2022-12-05T20:46:56.664693+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.6808631 2022-12-05T20:46:56.680863+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.6970627 2022-12-05T20:46:56.697063+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.7132316 2022-12-05T20:46:56.713232+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.728412 2022-12-05T20:46:56.728412+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.7445958 2022-12-05T20:46:56.744596+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.7607608 2022-12-05T20:46:56.760761+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.7769585 2022-12-05T20:46:56.776958+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.7931488 2022-12-05T20:46:56.793149+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.8093266 2022-12-05T20:46:56.809327+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.8254895 2022-12-05T20:46:56.825490+00:00 1 10 1285 725 880 523 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.8416767 2022-12-05T20:46:56.841677+00:00 1 10 1285 725 880 571 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.8578436 2022-12-05T20:46:56.857844+00:00 1 10 1285 725 880 571 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.8740246 2022-12-05T20:46:56.874025+00:00 1 10 1285 725 880 574 880 582 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.8902183 2022-12-05T20:46:56.890218+00:00 1 10 1285 725 880 575 880 581 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.9054053 2022-12-05T20:46:56.905405+00:00 1 10 1285 725 880 580 880 581 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.92157 2022-12-05T20:46:56.921570+00:00 1 10 1285 725 880 584 880 581 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.9377627 2022-12-05T20:46:56.937763+00:00 1 10 1285 725 880 588 880 588 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.9539642 2022-12-05T20:46:56.953964+00:00 1 10 1285 725 880 591 880 597 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.9701412 2022-12-05T20:46:56.970141+00:00 1 10 1285 725 880 595 880 606 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273216.9863048 2022-12-05T20:46:56.986305+00:00 1 10 1285 725 880 598 880 615 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.0014975 2022-12-05T20:46:57.001498+00:00 1 10 1285 725 880 598 880 631 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.0176876 2022-12-05T20:46:57.017688+00:00 1 10 1285 725 880 598 880 640 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.0338757 2022-12-05T20:46:57.033876+00:00 1 10 1285 725 880 598 880 647 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.050066 2022-12-05T20:46:57.050066+00:00 1 10 1285 725 880 598 880 654 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.0662448 2022-12-05T20:46:57.066245+00:00 1 10 1285 725 880 598 880 654 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.081409 2022-12-05T20:46:57.081409+00:00 1 10 1285 725 880 598 880 661 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.097595 2022-12-05T20:46:57.097595+00:00 1 10 1285 725 880 598 880 665 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.1137488 2022-12-05T20:46:57.113749+00:00 1 10 1285 725 880 598 880 669 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.129904 2022-12-05T20:46:57.129904+00:00 1 10 1285 725 880 598 880 671 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.146107 2022-12-05T20:46:57.146107+00:00 1 10 1285 725 880 598 880 672 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.1622877 2022-12-05T20:46:57.162288+00:00 1 10 1285 725 880 598 880 677 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.1774485 2022-12-05T20:46:57.177449+00:00 1 10 1285 725 880 598 880 677 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.193633 2022-12-05T20:46:57.193633+00:00 1 9 1285 725 880 598 880 683 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.209788 2022-12-05T20:46:57.209788+00:00 1 9 1285 725 880 599 880 690 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.2259388 2022-12-05T20:46:57.225939+00:00 1 9 1285 725 880 602 880 696 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.2421503 2022-12-05T20:46:57.242150+00:00 1 9 1285 725 880 608 880 697 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.2583349 2022-12-05T20:46:57.258335+00:00 1 9 1285 725 880 612 880 697 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.2735295 2022-12-05T20:46:57.273530+00:00 1 9 1285 725 880 619 880 697 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.289724 2022-12-05T20:46:57.289724+00:00 1 9 1285 725 880 626 880 697 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.305925 2022-12-05T20:46:57.305925+00:00 1 9 1285 725 880 633 880 697 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.3221016 2022-12-05T20:46:57.322102+00:00 1 9 1285 725 880 640 880 697 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.3382978 2022-12-05T20:46:57.338298+00:00 1 9 1285 725 880 653 880 697 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.3534892 2022-12-05T20:46:57.353489+00:00 1 9 1285 725 880 653 880 696 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.3696663 2022-12-05T20:46:57.369666+00:00 1 9 1285 725 880 659 880 690 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.385826 2022-12-05T20:46:57.385826+00:00 1 9 1285 725 880 662 880 678 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.4020112 2022-12-05T20:46:57.402011+00:00 1 9 1285 725 880 663 880 671 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.4181962 2022-12-05T20:46:57.418196+00:00 1 9 1285 725 880 663 880 662 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.4343646 2022-12-05T20:46:57.434365+00:00 1 9 1285 725 880 663 880 662 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.4505563 2022-12-05T20:46:57.450556+00:00 1 9 1285 725 880 663 880 655 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.4667404 2022-12-05T20:46:57.466740+00:00 1 9 1285 725 880 663 880 652 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.482925 2022-12-05T20:46:57.482925+00:00 1 9 1285 725 880 663 880 647 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.4991102 2022-12-05T20:46:57.499110+00:00 1 9 1285 725 880 663 880 644 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.5152636 2022-12-05T20:46:57.515264+00:00 1 9 1285 725 880 663 880 638 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.5304148 2022-12-05T20:46:57.530415+00:00 1 9 1285 725 880 656 880 635 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.546607 2022-12-05T20:46:57.546607+00:00 1 9 1285 725 880 649 880 635 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.5627842 2022-12-05T20:46:57.562784+00:00 1 9 1285 725 880 640 880 631 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.5789392 2022-12-05T20:46:57.578939+00:00 1 9 1285 725 880 623 880 629 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.5951252 2022-12-05T20:46:57.595125+00:00 1 9 1285 725 880 581 880 626 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.6112888 2022-12-05T20:46:57.611289+00:00 1 9 1285 725 880 553 880 623 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.6264646 2022-12-05T20:46:57.626465+00:00 1 9 1285 725 880 553 880 618 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.6426497 2022-12-05T20:46:57.642650+00:00 1 9 1285 725 880 526 880 617 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.6588118 2022-12-05T20:46:57.658812+00:00 1 9 1285 725 880 496 880 614 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.6750016 2022-12-05T20:46:57.675002+00:00 1 9 1285 725 880 474 880 612 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.6911926 2022-12-05T20:46:57.691193+00:00 1 9 1285 725 880 470 880 610 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.7073832 2022-12-05T20:46:57.707383+00:00 1 9 1285 725 880 470 880 608 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.7235641 2022-12-05T20:46:57.723564+00:00 1 9 1285 725 880 470 880 606 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.7397463 2022-12-05T20:46:57.739746+00:00 1 9 1285 725 880 470 880 604 880 776 1660 684 0 0
exp_2022_12_05_12 85 90 99908 1670273217.7559288 2022-12-05T20:46:57.755929+00:00 1 9 1285 725 880 470 880 604 880 776 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]);