ping_pong_cooperative_task_observation

Observations from the cooperative ping-pong tasks.

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_2_id = 61

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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_02_15,42,61,99906,1670024837.3269815 exp_2022_12_02_15 42 61 99906 1670024837.3269815 2022-12-02T23:47:17.326982+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_12_02_15,42,61,99906,1670024837.3429136 exp_2022_12_02_15 42 61 99906 1670024837.3429136 2022-12-02T23:47:17.342914+00:00 1 10 1285 725 880 636 880 470 880 747 1660 633 0 0
exp_2022_12_02_15,42,61,99906,1670024837.3591063 exp_2022_12_02_15 42 61 99906 1670024837.3591063 2022-12-02T23:47:17.359106+00:00 1 10 1285 725 880 636 880 470 880 747 1660 645 0 0
exp_2022_12_02_15,42,61,99906,1670024837.375306 exp_2022_12_02_15 42 61 99906 1670024837.375306 2022-12-02T23:47:17.375306+00:00 1 10 1285 725 880 636 880 470 880 747 1660 657 0 0
exp_2022_12_02_15,42,61,99906,1670024837.3915017 exp_2022_12_02_15 42 61 99906 1670024837.3915017 2022-12-02T23:47:17.391502+00:00 1 10 1285 725 880 636 880 470 880 747 1660 657 0 0
exp_2022_12_02_15,42,61,99906,1670024837.4077227 exp_2022_12_02_15 42 61 99906 1670024837.4077227 2022-12-02T23:47:17.407723+00:00 1 10 1285 725 880 636 880 470 880 747 1660 669 0 0
exp_2022_12_02_15,42,61,99906,1670024837.4229147 exp_2022_12_02_15 42 61 99906 1670024837.4229147 2022-12-02T23:47:17.422915+00:00 1 10 1285 725 880 636 880 470 880 747 1660 678 0 0
exp_2022_12_02_15,42,61,99906,1670024837.4391584 exp_2022_12_02_15 42 61 99906 1670024837.4391584 2022-12-02T23:47:17.439158+00:00 1 10 1285 725 880 636 880 470 880 747 1660 682 0 0
exp_2022_12_02_15,42,61,99906,1670024837.455349 exp_2022_12_02_15 42 61 99906 1670024837.455349 2022-12-02T23:47:17.455349+00:00 1 10 1285 725 880 636 880 470 880 747 1660 683 0 0
exp_2022_12_02_15,42,61,99906,1670024837.471538 exp_2022_12_02_15 42 61 99906 1670024837.471538 2022-12-02T23:47:17.471538+00:00 1 10 1285 725 880 636 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.4877293 exp_2022_12_02_15 42 61 99906 1670024837.4877293 2022-12-02T23:47:17.487729+00:00 1 10 1285 725 880 470 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.502931 exp_2022_12_02_15 42 61 99906 1670024837.502931 2022-12-02T23:47:17.502931+00:00 1 10 1285 725 880 470 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.519108 exp_2022_12_02_15 42 61 99906 1670024837.519108 2022-12-02T23:47:17.519108+00:00 1 10 1285 725 880 470 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.5353074 exp_2022_12_02_15 42 61 99906 1670024837.5353074 2022-12-02T23:47:17.535307+00:00 1 10 1285 725 880 470 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.5514903 exp_2022_12_02_15 42 61 99906 1670024837.5514903 2022-12-02T23:47:17.551490+00:00 1 10 1285 725 880 471 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.5676892 exp_2022_12_02_15 42 61 99906 1670024837.5676892 2022-12-02T23:47:17.567689+00:00 1 10 1285 725 880 472 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.582885 exp_2022_12_02_15 42 61 99906 1670024837.582885 2022-12-02T23:47:17.582885+00:00 1 10 1285 725 880 473 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.5990827 exp_2022_12_02_15 42 61 99906 1670024837.5990827 2022-12-02T23:47:17.599083+00:00 1 10 1285 725 880 473 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.6152813 exp_2022_12_02_15 42 61 99906 1670024837.6152813 2022-12-02T23:47:17.615281+00:00 1 10 1285 725 880 473 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.631503 exp_2022_12_02_15 42 61 99906 1670024837.631503 2022-12-02T23:47:17.631503+00:00 1 10 1285 725 880 473 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.6477213 exp_2022_12_02_15 42 61 99906 1670024837.6477213 2022-12-02T23:47:17.647721+00:00 1 10 1285 725 880 473 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.6629183 exp_2022_12_02_15 42 61 99906 1670024837.6629183 2022-12-02T23:47:17.662918+00:00 1 10 1285 725 880 473 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.679106 exp_2022_12_02_15 42 61 99906 1670024837.679106 2022-12-02T23:47:17.679106+00:00 1 10 1285 725 880 473 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.695297 exp_2022_12_02_15 42 61 99906 1670024837.695297 2022-12-02T23:47:17.695297+00:00 1 10 1285 725 880 473 880 470 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.7115262 exp_2022_12_02_15 42 61 99906 1670024837.7115262 2022-12-02T23:47:17.711526+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.727728 exp_2022_12_02_15 42 61 99906 1670024837.727728 2022-12-02T23:47:17.727728+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.7429366 exp_2022_12_02_15 42 61 99906 1670024837.7429366 2022-12-02T23:47:17.742937+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.759134 exp_2022_12_02_15 42 61 99906 1670024837.759134 2022-12-02T23:47:17.759134+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.775309 exp_2022_12_02_15 42 61 99906 1670024837.775309 2022-12-02T23:47:17.775309+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.7915032 exp_2022_12_02_15 42 61 99906 1670024837.7915032 2022-12-02T23:47:17.791503+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.8076987 exp_2022_12_02_15 42 61 99906 1670024837.8076987 2022-12-02T23:47:17.807699+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.8228765 exp_2022_12_02_15 42 61 99906 1670024837.8228765 2022-12-02T23:47:17.822876+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.839074 exp_2022_12_02_15 42 61 99906 1670024837.839074 2022-12-02T23:47:17.839074+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.8552809 exp_2022_12_02_15 42 61 99906 1670024837.8552809 2022-12-02T23:47:17.855281+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.8715 exp_2022_12_02_15 42 61 99906 1670024837.8715 2022-12-02T23:47:17.871500+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.887737 exp_2022_12_02_15 42 61 99906 1670024837.887737 2022-12-02T23:47:17.887737+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.9029377 exp_2022_12_02_15 42 61 99906 1670024837.9029377 2022-12-02T23:47:17.902938+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.919125 exp_2022_12_02_15 42 61 99906 1670024837.919125 2022-12-02T23:47:17.919125+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.9353337 exp_2022_12_02_15 42 61 99906 1670024837.9353337 2022-12-02T23:47:17.935334+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.9515443 exp_2022_12_02_15 42 61 99906 1670024837.9515443 2022-12-02T23:47:17.951544+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.967739 exp_2022_12_02_15 42 61 99906 1670024837.967739 2022-12-02T23:47:17.967739+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.9829311 exp_2022_12_02_15 42 61 99906 1670024837.9829311 2022-12-02T23:47:17.982931+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024837.9991314 exp_2022_12_02_15 42 61 99906 1670024837.9991314 2022-12-02T23:47:17.999131+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.015333 exp_2022_12_02_15 42 61 99906 1670024838.015333 2022-12-02T23:47:18.015333+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.031533 exp_2022_12_02_15 42 61 99906 1670024838.031533 2022-12-02T23:47:18.031533+00:00 1 10 1285 725 880 473 880 875 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.0477445 exp_2022_12_02_15 42 61 99906 1670024838.0477445 2022-12-02T23:47:18.047745+00:00 1 10 1285 725 880 472 880 876 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.0629487 exp_2022_12_02_15 42 61 99906 1670024838.0629487 2022-12-02T23:47:18.062949+00:00 1 10 1285 725 880 471 880 878 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.0791495 exp_2022_12_02_15 42 61 99906 1670024838.0791495 2022-12-02T23:47:18.079149+00:00 1 10 1285 725 880 471 880 879 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.0953457 exp_2022_12_02_15 42 61 99906 1670024838.0953457 2022-12-02T23:47:18.095346+00:00 1 10 1285 725 880 470 880 879 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.1115496 exp_2022_12_02_15 42 61 99906 1670024838.1115496 2022-12-02T23:47:18.111550+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.1277418 exp_2022_12_02_15 42 61 99906 1670024838.1277418 2022-12-02T23:47:18.127742+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.1429439 exp_2022_12_02_15 42 61 99906 1670024838.1429439 2022-12-02T23:47:18.142944+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.1591337 exp_2022_12_02_15 42 61 99906 1670024838.1591337 2022-12-02T23:47:18.159134+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.175348 exp_2022_12_02_15 42 61 99906 1670024838.175348 2022-12-02T23:47:18.175348+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.1916208 exp_2022_12_02_15 42 61 99906 1670024838.1916208 2022-12-02T23:47:18.191621+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.2069042 exp_2022_12_02_15 42 61 99906 1670024838.2069042 2022-12-02T23:47:18.206904+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.2231781 exp_2022_12_02_15 42 61 99906 1670024838.2231781 2022-12-02T23:47:18.223178+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.2393801 exp_2022_12_02_15 42 61 99906 1670024838.2393801 2022-12-02T23:47:18.239380+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.2555392 exp_2022_12_02_15 42 61 99906 1670024838.2555392 2022-12-02T23:47:18.255539+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.2716925 exp_2022_12_02_15 42 61 99906 1670024838.2716925 2022-12-02T23:47:18.271693+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.2868443 exp_2022_12_02_15 42 61 99906 1670024838.2868443 2022-12-02T23:47:18.286844+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.303064 exp_2022_12_02_15 42 61 99906 1670024838.303064 2022-12-02T23:47:18.303064+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.319245 exp_2022_12_02_15 42 61 99906 1670024838.319245 2022-12-02T23:47:18.319245+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.3354297 exp_2022_12_02_15 42 61 99906 1670024838.3354297 2022-12-02T23:47:18.335430+00:00 1 10 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.3516333 exp_2022_12_02_15 42 61 99906 1670024838.3516333 2022-12-02T23:47:18.351633+00:00 1 9 1285 725 880 470 880 880 880 747 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.3668303 exp_2022_12_02_15 42 61 99906 1670024838.3668303 2022-12-02T23:47:18.366830+00:00 1 9 1285 725 880 470 880 880 880 745 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.3829737 exp_2022_12_02_15 42 61 99906 1670024838.3829737 2022-12-02T23:47:18.382974+00:00 1 9 1285 725 880 470 880 880 880 701 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.399189 exp_2022_12_02_15 42 61 99906 1670024838.399189 2022-12-02T23:47:18.399189+00:00 1 9 1285 725 880 470 880 880 880 676 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.415393 exp_2022_12_02_15 42 61 99906 1670024838.415393 2022-12-02T23:47:18.415393+00:00 1 9 1285 725 880 470 880 880 880 669 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.4315715 exp_2022_12_02_15 42 61 99906 1670024838.4315715 2022-12-02T23:47:18.431571+00:00 1 9 1285 725 880 470 880 880 880 662 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.4477699 exp_2022_12_02_15 42 61 99906 1670024838.4477699 2022-12-02T23:47:18.447770+00:00 1 9 1285 725 880 470 880 880 880 658 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.4629312 exp_2022_12_02_15 42 61 99906 1670024838.4629312 2022-12-02T23:47:18.462931+00:00 1 9 1285 725 880 470 880 880 880 657 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.4790895 exp_2022_12_02_15 42 61 99906 1670024838.4790895 2022-12-02T23:47:18.479089+00:00 1 9 1285 725 880 470 880 880 880 657 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.4952753 exp_2022_12_02_15 42 61 99906 1670024838.4952753 2022-12-02T23:47:18.495275+00:00 1 9 1285 725 880 470 880 880 880 657 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.511504 exp_2022_12_02_15 42 61 99906 1670024838.511504 2022-12-02T23:47:18.511504+00:00 1 9 1285 725 880 470 880 880 880 657 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.5277445 exp_2022_12_02_15 42 61 99906 1670024838.5277445 2022-12-02T23:47:18.527745+00:00 1 9 1285 725 880 470 880 876 880 657 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.542956 exp_2022_12_02_15 42 61 99906 1670024838.542956 2022-12-02T23:47:18.542956+00:00 1 9 1285 725 880 470 880 871 880 657 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.559118 exp_2022_12_02_15 42 61 99906 1670024838.559118 2022-12-02T23:47:18.559118+00:00 1 9 1285 725 880 470 880 871 880 657 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.5752962 exp_2022_12_02_15 42 61 99906 1670024838.5752962 2022-12-02T23:47:18.575296+00:00 1 9 1285 725 880 471 880 863 880 658 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.5914786 exp_2022_12_02_15 42 61 99906 1670024838.5914786 2022-12-02T23:47:18.591479+00:00 1 9 1285 725 880 489 880 854 880 658 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.6076722 exp_2022_12_02_15 42 61 99906 1670024838.6076722 2022-12-02T23:47:18.607672+00:00 1 9 1285 725 880 513 880 846 880 658 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.623833 exp_2022_12_02_15 42 61 99906 1670024838.623833 2022-12-02T23:47:18.623833+00:00 1 9 1285 725 880 526 880 839 880 658 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.640034 exp_2022_12_02_15 42 61 99906 1670024838.640034 2022-12-02T23:47:18.640034+00:00 1 9 1285 725 880 544 880 833 880 661 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.6562188 exp_2022_12_02_15 42 61 99906 1670024838.6562188 2022-12-02T23:47:18.656219+00:00 1 9 1285 725 880 560 880 828 880 665 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.6724215 exp_2022_12_02_15 42 61 99906 1670024838.6724215 2022-12-02T23:47:18.672421+00:00 1 9 1285 725 880 592 880 825 880 665 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.688625 exp_2022_12_02_15 42 61 99906 1670024838.688625 2022-12-02T23:47:18.688625+00:00 1 9 1285 725 880 609 880 824 880 671 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.7048123 exp_2022_12_02_15 42 61 99906 1670024838.7048123 2022-12-02T23:47:18.704812+00:00 1 9 1285 725 880 609 880 823 880 678 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.7210042 exp_2022_12_02_15 42 61 99906 1670024838.7210042 2022-12-02T23:47:18.721004+00:00 1 9 1285 725 880 628 880 823 880 687 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.7371895 exp_2022_12_02_15 42 61 99906 1670024838.7371895 2022-12-02T23:47:18.737190+00:00 1 9 1285 725 880 640 880 823 880 693 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.753375 exp_2022_12_02_15 42 61 99906 1670024838.753375 2022-12-02T23:47:18.753375+00:00 1 9 1285 725 880 658 880 823 880 697 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.769561 exp_2022_12_02_15 42 61 99906 1670024838.769561 2022-12-02T23:47:18.769561+00:00 1 9 1285 725 880 665 880 823 880 698 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.7857475 exp_2022_12_02_15 42 61 99906 1670024838.7857475 2022-12-02T23:47:18.785748+00:00 1 9 1285 725 880 668 880 823 880 698 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.8009415 exp_2022_12_02_15 42 61 99906 1670024838.8009415 2022-12-02T23:47:18.800941+00:00 1 9 1285 725 880 660 880 823 880 698 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.8171244 exp_2022_12_02_15 42 61 99906 1670024838.8171244 2022-12-02T23:47:18.817124+00:00 1 9 1285 725 880 646 880 823 880 685 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.8333082 exp_2022_12_02_15 42 61 99906 1670024838.8333082 2022-12-02T23:47:18.833308+00:00 1 9 1285 725 880 630 880 823 880 685 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.8494992 exp_2022_12_02_15 42 61 99906 1670024838.8494992 2022-12-02T23:47:18.849499+00:00 1 9 1285 725 880 630 880 823 880 664 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.865687 exp_2022_12_02_15 42 61 99906 1670024838.865687 2022-12-02T23:47:18.865687+00:00 1 9 1285 725 880 618 880 822 880 656 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.880875 exp_2022_12_02_15 42 61 99906 1670024838.880875 2022-12-02T23:47:18.880875+00:00 1 9 1285 725 880 607 880 821 880 656 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.8970666 exp_2022_12_02_15 42 61 99906 1670024838.8970666 2022-12-02T23:47:18.897067+00:00 1 9 1285 725 880 592 880 818 880 652 1660 684 0 0
exp_2022_12_02_15,42,61,99906,1670024838.9132662 exp_2022_12_02_15 42 61 99906 1670024838.9132662 2022-12-02T23:47:18.913266+00:00 1 9 1285 725 880 574 880 815 880 651 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]);