Column descriptions

where group_session = "exp_2022_11_01_10"

View and edit SQL

Suggested facets: event_type, countdown_timer, lion_spacebar_pressed, tiger_spacebar_pressed, leopard_spacebar_pressed, timestamp_iso8601 (date)

Link group_session timestamp_unix timestamp_iso8601 event_type countdown_timer lion_spacebar_pressed tiger_spacebar_pressed leopard_spacebar_pressed
exp_2022_11_01_10 1667327249.972287 2022-11-01T18:27:29.972287+00:00 start_fingertapping_task        
exp_2022_11_01_10 1667327259.9908943 2022-11-01T18:27:39.990894+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.0070703 2022-11-01T18:27:40.007070+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.0232012 2022-11-01T18:27:40.023201+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.0393524 2022-11-01T18:27:40.039352+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.055494 2022-11-01T18:27:40.055494+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.0716636 2022-11-01T18:27:40.071664+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.0878077 2022-11-01T18:27:40.087808+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.1039681 2022-11-01T18:27:40.103968+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.1201437 2022-11-01T18:27:40.120144+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.1364024 2022-11-01T18:27:40.136402+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.152647 2022-11-01T18:27:40.152647+00:00 individual 10 0 1 0
exp_2022_11_01_10 1667327260.1688368 2022-11-01T18:27:40.168837+00:00 individual 10 0 1 0
exp_2022_11_01_10 1667327260.1850374 2022-11-01T18:27:40.185037+00:00 individual 10 0 1 0
exp_2022_11_01_10 1667327260.201225 2022-11-01T18:27:40.201225+00:00 individual 10 0 1 0
exp_2022_11_01_10 1667327260.2164316 2022-11-01T18:27:40.216432+00:00 individual 10 0 1 0
exp_2022_11_01_10 1667327260.232644 2022-11-01T18:27:40.232644+00:00 individual 10 0 1 0
exp_2022_11_01_10 1667327260.2488325 2022-11-01T18:27:40.248832+00:00 individual 10 0 1 0
exp_2022_11_01_10 1667327260.2649941 2022-11-01T18:27:40.264994+00:00 individual 10 0 1 0
exp_2022_11_01_10 1667327260.2811692 2022-11-01T18:27:40.281169+00:00 individual 10 0 1 0
exp_2022_11_01_10 1667327260.2973306 2022-11-01T18:27:40.297331+00:00 individual 10 0 1 1
exp_2022_11_01_10 1667327260.3135095 2022-11-01T18:27:40.313509+00:00 individual 10 0 1 1
exp_2022_11_01_10 1667327260.329677 2022-11-01T18:27:40.329677+00:00 individual 10 0 1 1
exp_2022_11_01_10 1667327260.3458393 2022-11-01T18:27:40.345839+00:00 individual 10 0 1 1
exp_2022_11_01_10 1667327260.3620055 2022-11-01T18:27:40.362005+00:00 individual 10 0 0 1
exp_2022_11_01_10 1667327260.3781826 2022-11-01T18:27:40.378183+00:00 individual 10 0 0 1
exp_2022_11_01_10 1667327260.394359 2022-11-01T18:27:40.394359+00:00 individual 10 0 0 1
exp_2022_11_01_10 1667327260.4105167 2022-11-01T18:27:40.410517+00:00 individual 10 0 0 1
exp_2022_11_01_10 1667327260.426666 2022-11-01T18:27:40.426666+00:00 individual 10 0 0 1
exp_2022_11_01_10 1667327260.4428442 2022-11-01T18:27:40.442844+00:00 individual 10 0 0 1
exp_2022_11_01_10 1667327260.4590492 2022-11-01T18:27:40.459049+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.4752746 2022-11-01T18:27:40.475275+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.490526 2022-11-01T18:27:40.490526+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.506713 2022-11-01T18:27:40.506713+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.5229847 2022-11-01T18:27:40.522985+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.5392196 2022-11-01T18:27:40.539220+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.5553622 2022-11-01T18:27:40.555362+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.5715168 2022-11-01T18:27:40.571517+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.5876806 2022-11-01T18:27:40.587681+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.6038384 2022-11-01T18:27:40.603838+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.6200786 2022-11-01T18:27:40.620079+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.6363099 2022-11-01T18:27:40.636310+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.6515527 2022-11-01T18:27:40.651553+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.6678083 2022-11-01T18:27:40.667808+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.6840403 2022-11-01T18:27:40.684040+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.7002556 2022-11-01T18:27:40.700256+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.715431 2022-11-01T18:27:40.715431+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.7316144 2022-11-01T18:27:40.731614+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.7478566 2022-11-01T18:27:40.747857+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.7640932 2022-11-01T18:27:40.764093+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.780346 2022-11-01T18:27:40.780346+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.7956035 2022-11-01T18:27:40.795604+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.8118608 2022-11-01T18:27:40.811861+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.828095 2022-11-01T18:27:40.828095+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.8443422 2022-11-01T18:27:40.844342+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.8595598 2022-11-01T18:27:40.859560+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.8757405 2022-11-01T18:27:40.875741+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.8919322 2022-11-01T18:27:40.891932+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.908155 2022-11-01T18:27:40.908155+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.9243991 2022-11-01T18:27:40.924399+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.940656 2022-11-01T18:27:40.940656+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.9568992 2022-11-01T18:27:40.956899+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.973134 2022-11-01T18:27:40.973134+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327260.9893868 2022-11-01T18:27:40.989387+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327261.0056605 2022-11-01T18:27:41.005661+00:00 individual 10 0 0 0
exp_2022_11_01_10 1667327261.0219176 2022-11-01T18:27:41.021918+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.0381937 2022-11-01T18:27:41.038194+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.0534658 2022-11-01T18:27:41.053466+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.0697205 2022-11-01T18:27:41.069721+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.085986 2022-11-01T18:27:41.085986+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.102257 2022-11-01T18:27:41.102257+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.117514 2022-11-01T18:27:41.117514+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.1338058 2022-11-01T18:27:41.133806+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.1500757 2022-11-01T18:27:41.150076+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.1663377 2022-11-01T18:27:41.166338+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.1815925 2022-11-01T18:27:41.181592+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.1978245 2022-11-01T18:27:41.197824+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.2139752 2022-11-01T18:27:41.213975+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.23012 2022-11-01T18:27:41.230120+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.246272 2022-11-01T18:27:41.246272+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.2624204 2022-11-01T18:27:41.262420+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.2785492 2022-11-01T18:27:41.278549+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.2946906 2022-11-01T18:27:41.294691+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.310843 2022-11-01T18:27:41.310843+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.3269978 2022-11-01T18:27:41.326998+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.3431442 2022-11-01T18:27:41.343144+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.3592935 2022-11-01T18:27:41.359293+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.375426 2022-11-01T18:27:41.375426+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.391573 2022-11-01T18:27:41.391573+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.4077263 2022-11-01T18:27:41.407726+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.4238663 2022-11-01T18:27:41.423866+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.4400158 2022-11-01T18:27:41.440016+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.456166 2022-11-01T18:27:41.456166+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.4723084 2022-11-01T18:27:41.472308+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.4874606 2022-11-01T18:27:41.487461+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.503627 2022-11-01T18:27:41.503627+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.519789 2022-11-01T18:27:41.519789+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.5359507 2022-11-01T18:27:41.535951+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.5521173 2022-11-01T18:27:41.552117+00:00 individual 9 0 0 0
exp_2022_11_01_10 1667327261.5682752 2022-11-01T18:27:41.568275+00:00 individual 9 0 0 0

Next page

Advanced export

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

CSV options:

CREATE TABLE "finger_tapping_task_observation" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [event_type] TEXT,
   [countdown_timer] INTEGER,
   [lion_spacebar_pressed] INTEGER,
   [tiger_spacebar_pressed] INTEGER,
   [leopard_spacebar_pressed] INTEGER,
   PRIMARY KEY ([group_session], [timestamp_unix])
);
CREATE INDEX [idx_finger_tapping_task_observation_group_session]
    ON [finger_tapping_task_observation] ([group_session]);