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_3_id = 159

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_24_13 151 153 159 1682371799.4664845 2023-04-24T21:29:59.466485+00:00 0 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_04_24_13 151 153 159 1682371799.4818645 2023-04-24T21:29:59.481864+00:00 0 10 1285 725 880 588 880 837 880 563 1660 470 0 0
exp_2023_04_24_13 151 153 159 1682371799.4980214 2023-04-24T21:29:59.498021+00:00 0 10 1285 725 880 588 880 837 880 563 1660 482 0 0
exp_2023_04_24_13 151 153 159 1682371799.5142365 2023-04-24T21:29:59.514236+00:00 0 10 1285 725 880 588 880 837 880 563 1660 494 0 0
exp_2023_04_24_13 151 153 159 1682371799.530466 2023-04-24T21:29:59.530466+00:00 0 10 1285 725 880 588 880 837 880 563 1660 506 0 0
exp_2023_04_24_13 151 153 159 1682371799.5467348 2023-04-24T21:29:59.546735+00:00 0 10 1285 725 880 588 880 837 880 563 1660 518 0 0
exp_2023_04_24_13 151 153 159 1682371799.5619438 2023-04-24T21:29:59.561944+00:00 0 10 1285 725 880 588 880 837 880 563 1660 530 0 0
exp_2023_04_24_13 151 153 159 1682371799.5781527 2023-04-24T21:29:59.578153+00:00 0 10 1285 725 880 588 880 837 880 563 1660 542 0 0
exp_2023_04_24_13 151 153 159 1682371799.5943687 2023-04-24T21:29:59.594369+00:00 0 10 1285 725 880 588 880 837 880 563 1660 542 0 0
exp_2023_04_24_13 151 153 159 1682371799.6105847 2023-04-24T21:29:59.610585+00:00 0 10 1285 725 880 588 880 837 880 563 1660 554 0 0
exp_2023_04_24_13 151 153 159 1682371799.626795 2023-04-24T21:29:59.626795+00:00 0 10 1285 725 880 588 880 837 880 563 1660 566 0 0
exp_2023_04_24_13 151 153 159 1682371799.642001 2023-04-24T21:29:59.642001+00:00 0 10 1285 725 880 588 880 837 880 563 1660 578 0 0
exp_2023_04_24_13 151 153 159 1682371799.6582265 2023-04-24T21:29:59.658226+00:00 0 10 1285 725 880 588 880 837 880 563 1660 590 0 0
exp_2023_04_24_13 151 153 159 1682371799.6744359 2023-04-24T21:29:59.674436+00:00 0 10 1285 725 880 588 880 836 880 563 1660 602 0 0
exp_2023_04_24_13 151 153 159 1682371799.6907248 2023-04-24T21:29:59.690725+00:00 0 10 1285 725 880 588 880 836 880 563 1660 614 0 0
exp_2023_04_24_13 151 153 159 1682371799.705944 2023-04-24T21:29:59.705944+00:00 0 10 1285 725 880 588 880 834 880 563 1660 626 0 0
exp_2023_04_24_13 151 153 159 1682371799.722142 2023-04-24T21:29:59.722142+00:00 0 10 1285 725 880 588 880 831 880 563 1660 638 0 0
exp_2023_04_24_13 151 153 159 1682371799.7383614 2023-04-24T21:29:59.738361+00:00 0 10 1285 725 880 588 880 831 880 563 1660 650 0 0
exp_2023_04_24_13 151 153 159 1682371799.7545822 2023-04-24T21:29:59.754582+00:00 0 10 1285 725 880 588 880 830 880 563 1660 662 0 0
exp_2023_04_24_13 151 153 159 1682371799.7708037 2023-04-24T21:29:59.770804+00:00 0 10 1285 725 880 588 880 830 880 563 1660 674 0 0
exp_2023_04_24_13 151 153 159 1682371799.7860236 2023-04-24T21:29:59.786024+00:00 0 10 1285 725 880 588 880 830 880 563 1660 680 0 0
exp_2023_04_24_13 151 153 159 1682371799.8022282 2023-04-24T21:29:59.802228+00:00 0 10 1285 725 880 588 880 830 880 563 1660 683 0 0
exp_2023_04_24_13 151 153 159 1682371799.8184485 2023-04-24T21:29:59.818449+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371799.8346894 2023-04-24T21:29:59.834689+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371799.8499568 2023-04-24T21:29:59.849957+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371799.8661962 2023-04-24T21:29:59.866196+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371799.882426 2023-04-24T21:29:59.882426+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371799.8986514 2023-04-24T21:29:59.898651+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371799.914866 2023-04-24T21:29:59.914866+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371799.9310687 2023-04-24T21:29:59.931069+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371799.9473052 2023-04-24T21:29:59.947305+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371799.9635565 2023-04-24T21:29:59.963557+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371799.979798 2023-04-24T21:29:59.979798+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371799.9950342 2023-04-24T21:29:59.995034+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.0112584 2023-04-24T21:30:00.011258+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.0274556 2023-04-24T21:30:00.027456+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.0436387 2023-04-24T21:30:00.043639+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.0598748 2023-04-24T21:30:00.059875+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.076112 2023-04-24T21:30:00.076112+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.0923328 2023-04-24T21:30:00.092333+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.1085823 2023-04-24T21:30:00.108582+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.124827 2023-04-24T21:30:00.124827+00:00 0 10 1285 725 880 588 880 830 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.1400282 2023-04-24T21:30:00.140028+00:00 0 10 1285 725 880 588 880 829 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.1562896 2023-04-24T21:30:00.156290+00:00 0 10 1285 725 880 588 880 827 880 563 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.1724904 2023-04-24T21:30:00.172490+00:00 0 10 1285 725 880 588 880 823 880 564 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.1887133 2023-04-24T21:30:00.188713+00:00 0 10 1285 725 880 588 880 817 880 564 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.2039607 2023-04-24T21:30:00.203961+00:00 0 10 1285 725 880 588 880 809 880 565 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.2202492 2023-04-24T21:30:00.220249+00:00 0 10 1285 725 880 588 880 796 880 568 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.2364926 2023-04-24T21:30:00.236493+00:00 0 10 1285 725 880 588 880 770 880 571 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.2527516 2023-04-24T21:30:00.252752+00:00 0 10 1285 725 880 588 880 760 880 575 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.2680342 2023-04-24T21:30:00.268034+00:00 0 10 1285 725 880 588 880 757 880 579 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.2842553 2023-04-24T21:30:00.284255+00:00 0 10 1285 725 880 588 880 755 880 582 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.3004785 2023-04-24T21:30:00.300478+00:00 0 10 1285 725 880 588 880 755 880 584 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.316698 2023-04-24T21:30:00.316698+00:00 0 10 1285 725 880 588 880 755 880 585 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.3319306 2023-04-24T21:30:00.331931+00:00 0 10 1285 725 880 588 880 755 880 585 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.3481495 2023-04-24T21:30:00.348150+00:00 0 10 1285 725 880 588 880 755 880 586 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.364367 2023-04-24T21:30:00.364367+00:00 0 10 1285 725 880 588 880 755 880 586 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.380599 2023-04-24T21:30:00.380599+00:00 0 10 1285 725 880 588 880 762 880 586 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.396814 2023-04-24T21:30:00.396814+00:00 0 10 1285 725 880 588 880 772 880 587 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.4120307 2023-04-24T21:30:00.412031+00:00 0 10 1285 725 880 588 880 785 880 588 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.4282522 2023-04-24T21:30:00.428252+00:00 0 10 1285 725 880 588 880 800 880 591 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.4444876 2023-04-24T21:30:00.444488+00:00 0 10 1285 725 880 588 880 833 880 594 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.4607613 2023-04-24T21:30:00.460761+00:00 0 10 1285 725 880 588 880 833 880 595 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.4760392 2023-04-24T21:30:00.476039+00:00 0 10 1285 725 880 588 880 845 880 595 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.4922736 2023-04-24T21:30:00.492274+00:00 0 9 1285 725 880 588 880 848 880 596 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.5085497 2023-04-24T21:30:00.508550+00:00 0 9 1285 725 880 588 880 848 880 597 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.524765 2023-04-24T21:30:00.524765+00:00 0 9 1285 725 880 588 880 841 880 598 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.5400426 2023-04-24T21:30:00.540043+00:00 0 9 1285 725 880 588 880 822 880 599 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.5562654 2023-04-24T21:30:00.556265+00:00 0 9 1285 725 880 588 880 797 880 600 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.57248 2023-04-24T21:30:00.572480+00:00 0 9 1285 725 880 588 880 768 880 602 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.5887036 2023-04-24T21:30:00.588704+00:00 0 9 1285 725 880 588 880 746 880 603 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.6039484 2023-04-24T21:30:00.603948+00:00 0 9 1285 725 880 588 880 728 880 604 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.6201663 2023-04-24T21:30:00.620166+00:00 0 9 1285 725 880 588 880 718 880 605 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.6363888 2023-04-24T21:30:00.636389+00:00 0 9 1285 725 880 588 880 717 880 606 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.6526296 2023-04-24T21:30:00.652630+00:00 0 9 1285 725 880 588 880 717 880 607 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.668853 2023-04-24T21:30:00.668853+00:00 0 9 1285 725 880 588 880 721 880 608 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.6840732 2023-04-24T21:30:00.684073+00:00 0 9 1285 725 880 588 880 790 880 610 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.7003057 2023-04-24T21:30:00.700306+00:00 0 9 1285 725 880 588 880 839 880 612 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.7164807 2023-04-24T21:30:00.716481+00:00 0 9 1285 725 880 588 880 878 880 614 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.7327328 2023-04-24T21:30:00.732733+00:00 0 9 1285 725 880 588 880 880 880 615 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.7480552 2023-04-24T21:30:00.748055+00:00 0 9 1285 725 880 588 880 880 880 618 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.7643821 2023-04-24T21:30:00.764382+00:00 0 9 1285 725 880 588 880 880 880 621 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.7806313 2023-04-24T21:30:00.780631+00:00 0 9 1285 725 880 588 880 880 880 621 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.796869 2023-04-24T21:30:00.796869+00:00 0 9 1285 725 880 588 880 880 880 622 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.813106 2023-04-24T21:30:00.813106+00:00 0 9 1285 725 880 588 880 871 880 623 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.8293514 2023-04-24T21:30:00.829351+00:00 0 9 1285 725 880 588 880 852 880 624 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.845585 2023-04-24T21:30:00.845585+00:00 0 9 1285 725 880 588 880 824 880 625 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.861821 2023-04-24T21:30:00.861821+00:00 0 9 1285 725 880 588 880 777 880 626 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.877059 2023-04-24T21:30:00.877059+00:00 0 9 1285 725 880 588 880 726 880 627 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.8932896 2023-04-24T21:30:00.893290+00:00 0 9 1285 725 880 588 880 684 880 628 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.9095275 2023-04-24T21:30:00.909528+00:00 0 9 1285 725 880 588 880 666 880 629 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.9257681 2023-04-24T21:30:00.925768+00:00 0 9 1285 725 880 588 880 663 880 631 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.941009 2023-04-24T21:30:00.941009+00:00 0 9 1285 725 880 588 880 663 880 633 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.9572518 2023-04-24T21:30:00.957252+00:00 0 9 1285 725 880 588 880 678 880 635 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.973501 2023-04-24T21:30:00.973501+00:00 0 9 1285 725 880 588 880 704 880 638 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371800.9897568 2023-04-24T21:30:00.989757+00:00 0 9 1285 725 880 588 880 704 880 642 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371801.00502 2023-04-24T21:30:01.005020+00:00 0 9 1285 725 880 588 880 740 880 643 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371801.0212336 2023-04-24T21:30:01.021234+00:00 0 9 1285 725 880 588 880 771 880 649 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371801.0374732 2023-04-24T21:30:01.037473+00:00 0 9 1285 725 880 588 880 792 880 652 1660 684 0 0
exp_2023_04_24_13 151 153 159 1682371801.0537245 2023-04-24T21:30:01.053725+00:00 0 9 1285 725 880 588 880 808 880 652 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]);