Column descriptions

group_session
Group session ID
task
Task ID.
station
The iMac that the participant was stationed at.
participant
Participant ID. A participant ID of -1 indicates an unknown participant. All rows that do not have values for the `task` column will have their participant ID set to -1. In the future, we will label some of these inter/pre/post task rows with the correct participant ID.
timestamp_unix
The Unix timestamp of the event.
timestamp_iso8601
The ISO-8601 timestamp of the event.
filename
Name of the screenshot file.
timestamp_origin
The source of the timestamp. The priority is precision-driven. LSL time are used if available, otherwise, creation time is used if available. Modification time is used as last resort.

where group_session = "exp_2023_02_06_13"

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session station participant id task timestamp_unix timestamp_iso8601 filename url timestamp_origin
exp_2023_02_06_13 leopard 99909 3632 rest_state 1675718226.566825 2023-02-06T21:17:06.566825+00:00 2023-02-06T21_17_06.566825033Z.png creation
exp_2023_02_06_13 leopard 99909 3633 rest_state 1675718226.674829 2023-02-06T21:17:06.674829+00:00 2023-02-06T21_17_06.674829295Z.png creation
exp_2023_02_06_13 leopard 99909 3634 rest_state 1675718226.746832 2023-02-06T21:17:06.746832+00:00 2023-02-06T21_17_06.746832134Z.png creation
exp_2023_02_06_13 leopard 99909 3635 rest_state 1675718226.858836 2023-02-06T21:17:06.858836+00:00 2023-02-06T21_17_06.858836554Z.png creation
exp_2023_02_06_13 leopard 99909 3636 rest_state 1675718226.978841 2023-02-06T21:17:06.978841+00:00 2023-02-06T21_17_06.978841287Z.png creation
exp_2023_02_06_13 leopard 99909 3637 rest_state 1675718227.046843 2023-02-06T21:17:07.046843+00:00 2023-02-06T21_17_07.046843970Z.png creation
exp_2023_02_06_13 leopard 99909 3638 rest_state 1675718227.150848 2023-02-06T21:17:07.150848+00:00 2023-02-06T21_17_07.150848074Z.png creation
exp_2023_02_06_13 leopard 99909 3639 rest_state 1675718227.262852 2023-02-06T21:17:07.262852+00:00 2023-02-06T21_17_07.262852492Z.png creation
exp_2023_02_06_13 leopard 99909 3640 rest_state 1675718227.366856 2023-02-06T21:17:07.366856+00:00 2023-02-06T21_17_07.366856595Z.png creation
exp_2023_02_06_13 leopard 99909 3641 rest_state 1675718227.45886 2023-02-06T21:17:07.458860+00:00 2023-02-06T21_17_07.458860226Z.png creation
exp_2023_02_06_13 leopard 99909 3642 rest_state 1675718227.566864 2023-02-06T21:17:07.566864+00:00 2023-02-06T21_17_07.566864485Z.png creation
exp_2023_02_06_13 leopard 99909 3643 rest_state 1675718227.642867 2023-02-06T21:17:07.642867+00:00 2023-02-06T21_17_07.642867484Z.png creation
exp_2023_02_06_13 leopard 99909 3644 rest_state 1675718227.754871 2023-02-06T21:17:07.754871+00:00 2023-02-06T21_17_07.754871902Z.png creation
exp_2023_02_06_13 leopard 99909 3645 rest_state 1675718227.854875 2023-02-06T21:17:07.854875+00:00 2023-02-06T21_17_07.854875848Z.png creation
exp_2023_02_06_13 leopard 99909 3646 rest_state 1675718227.946879 2023-02-06T21:17:07.946879+00:00 2023-02-06T21_17_07.946879478Z.png creation
exp_2023_02_06_13 leopard 99909 3647 rest_state 1675718228.058883 2023-02-06T21:17:08.058883+00:00 2023-02-06T21_17_08.058883896Z.png creation
exp_2023_02_06_13 leopard 99909 3648 rest_state 1675718228.186888 2023-02-06T21:17:08.186888+00:00 2023-02-06T21_17_08.186888947Z.png creation
exp_2023_02_06_13 leopard 99909 3649 rest_state 1675718228.274892 2023-02-06T21:17:08.274892+00:00 2023-02-06T21_17_08.274892417Z.png creation
exp_2023_02_06_13 leopard 99909 3650 rest_state 1675718228.398897 2023-02-06T21:17:08.398897+00:00 2023-02-06T21_17_08.398897310Z.png creation
exp_2023_02_06_13 leopard 99909 3651 rest_state 1675718228.4789 2023-02-06T21:17:08.478900+00:00 2023-02-06T21_17_08.478900465Z.png creation
exp_2023_02_06_13 leopard 99909 3652 rest_state 1675718228.562903 2023-02-06T21:17:08.562903+00:00 2023-02-06T21_17_08.562903780Z.png creation
exp_2023_02_06_13 leopard 99909 3653 rest_state 1675718228.654907 2023-02-06T21:17:08.654907+00:00 2023-02-06T21_17_08.654907410Z.png creation
exp_2023_02_06_13 leopard 99909 3654 rest_state 1675718228.782912 2023-02-06T21:17:08.782912+00:00 2023-02-06T21_17_08.782912459Z.png creation
exp_2023_02_06_13 leopard 99909 3655 rest_state 1675718228.870915 2023-02-06T21:17:08.870915+00:00 2023-02-06T21_17_08.870915932Z.png creation
exp_2023_02_06_13 leopard 99909 3656 rest_state 1675718228.962919 2023-02-06T21:17:08.962919+00:00 2023-02-06T21_17_08.962919560Z.png creation
exp_2023_02_06_13 leopard 99909 3657 rest_state 1675718229.086924 2023-02-06T21:17:09.086924+00:00 2023-02-06T21_17_09.086924453Z.png creation
exp_2023_02_06_13 leopard 99909 3658 rest_state 1675718229.170927 2023-02-06T21:17:09.170927+00:00 2023-02-06T21_17_09.170927768Z.png creation
exp_2023_02_06_13 leopard 99909 3659 rest_state 1675718229.298932 2023-02-06T21:17:09.298932+00:00 2023-02-06T21_17_09.298932817Z.png creation
exp_2023_02_06_13 leopard 99909 3660 rest_state 1675718229.382936 2023-02-06T21:17:09.382936+00:00 2023-02-06T21_17_09.382936131Z.png creation
exp_2023_02_06_13 leopard 99909 3661 rest_state 1675718229.470939 2023-02-06T21:17:09.470939+00:00 2023-02-06T21_17_09.470939602Z.png creation
exp_2023_02_06_13 leopard 99909 3662 rest_state 1675718229.590944 2023-02-06T21:17:09.590944+00:00 2023-02-06T21_17_09.590944337Z.png creation
exp_2023_02_06_13 leopard 99909 3663 rest_state 1675718229.662947 2023-02-06T21:17:09.662947+00:00 2023-02-06T21_17_09.662947178Z.png creation
exp_2023_02_06_13 leopard 99909 3664 rest_state 1675718229.806952 2023-02-06T21:17:09.806952+00:00 2023-02-06T21_17_09.806952859Z.png creation
exp_2023_02_06_13 leopard 99909 3665 rest_state 1675718229.882955 2023-02-06T21:17:09.882955+00:00 2023-02-06T21_17_09.882955857Z.png creation
exp_2023_02_06_13 leopard 99909 3666 rest_state 1675718229.958958 2023-02-06T21:17:09.958958+00:00 2023-02-06T21_17_09.958958855Z.png creation
exp_2023_02_06_13 leopard 99909 3667 rest_state 1675718230.094964 2023-02-06T21:17:10.094964+00:00 2023-02-06T21_17_10.094964221Z.png creation
exp_2023_02_06_13 leopard 99909 3668 rest_state 1675718230.186967 2023-02-06T21:17:10.186967+00:00 2023-02-06T21_17_10.186967851Z.png creation
exp_2023_02_06_13 leopard 99909 3669 rest_state 1675718230.278971 2023-02-06T21:17:10.278971+00:00 2023-02-06T21_17_10.278971480Z.png creation
exp_2023_02_06_13 leopard 99909 3670 rest_state 1675718230.354974 2023-02-06T21:17:10.354974+00:00 2023-02-06T21_17_10.354974479Z.png creation
exp_2023_02_06_13 leopard 99909 3671 rest_state 1675718230.438977 2023-02-06T21:17:10.438977+00:00 2023-02-06T21_17_10.438977794Z.png creation
exp_2023_02_06_13 leopard 99909 3672 rest_state 1675718230.562982 2023-02-06T21:17:10.562982+00:00 2023-02-06T21_17_10.562982684Z.png creation
exp_2023_02_06_13 leopard 99909 3673 rest_state 1675718230.646985 2023-02-06T21:17:10.646985+00:00 2023-02-06T21_17_10.646985999Z.png creation
exp_2023_02_06_13 leopard 99909 3674 rest_state 1675718230.726989 2023-02-06T21:17:10.726989+00:00 2023-02-06T21_17_10.726989154Z.png creation
exp_2023_02_06_13 leopard 99909 3675 rest_state 1675718230.846993 2023-02-06T21:17:10.846993+00:00 2023-02-06T21_17_10.846993889Z.png creation
exp_2023_02_06_13 leopard 99909 3676 rest_state 1675718230.958998 2023-02-06T21:17:10.958998+00:00 2023-02-06T21_17_10.958998307Z.png creation
exp_2023_02_06_13 leopard 99909 3677 rest_state 1675718231.043001 2023-02-06T21:17:11.043001+00:00 2023-02-06T21_17_11.043001621Z.png creation
exp_2023_02_06_13 leopard 99909 3678 rest_state 1675718231.127004 2023-02-06T21:17:11.127004+00:00 2023-02-06T21_17_11.127004936Z.png creation
exp_2023_02_06_13 leopard 99909 3679 rest_state 1675718231.251009 2023-02-06T21:17:11.251009+00:00 2023-02-06T21_17_11.251009827Z.png creation
exp_2023_02_06_13 leopard 99909 3680 rest_state 1675718231.331012 2023-02-06T21:17:11.331012+00:00 2023-02-06T21_17_11.331012984Z.png creation
exp_2023_02_06_13 leopard 99909 3681 rest_state 1675718231.459018 2023-02-06T21:17:11.459018+00:00 2023-02-06T21_17_11.459018033Z.png creation
exp_2023_02_06_13 leopard 99909 3682 rest_state 1675718231.543021 2023-02-06T21:17:11.543021+00:00 2023-02-06T21_17_11.543021348Z.png creation
exp_2023_02_06_13 leopard 99909 3683 rest_state 1675718231.631024 2023-02-06T21:17:11.631024+00:00 2023-02-06T21_17_11.631024820Z.png creation
exp_2023_02_06_13 leopard 99909 3684 rest_state 1675718231.759029 2023-02-06T21:17:11.759029+00:00 2023-02-06T21_17_11.759029869Z.png creation
exp_2023_02_06_13 leopard 99909 3685 rest_state 1675718231.847033 2023-02-06T21:17:11.847033+00:00 2023-02-06T21_17_11.847033341Z.png creation
exp_2023_02_06_13 leopard 99909 3686 rest_state 1675718231.927036 2023-02-06T21:17:11.927036+00:00 2023-02-06T21_17_11.927036496Z.png creation
exp_2023_02_06_13 leopard 99909 3687 rest_state 1675718232.03904 2023-02-06T21:17:12.039040+00:00 2023-02-06T21_17_12.039040916Z.png creation
exp_2023_02_06_13 leopard 99909 3688 rest_state 1675718232.171046 2023-02-06T21:17:12.171046+00:00 2023-02-06T21_17_12.171046125Z.png creation
exp_2023_02_06_13 leopard 99909 3689 rest_state 1675718232.263049 2023-02-06T21:17:12.263049+00:00 2023-02-06T21_17_12.263049753Z.png creation
exp_2023_02_06_13 leopard 99909 3690 rest_state 1675718232.343052 2023-02-06T21:17:12.343052+00:00 2023-02-06T21_17_12.343052910Z.png creation
exp_2023_02_06_13 leopard 99909 3691 rest_state 1675718232.423056 2023-02-06T21:17:12.423056+00:00 2023-02-06T21_17_12.423056065Z.png creation
exp_2023_02_06_13 leopard 99909 3692 rest_state 1675718232.53906 2023-02-06T21:17:12.539060+00:00 2023-02-06T21_17_12.539060642Z.png creation
exp_2023_02_06_13 leopard 99909 3693 rest_state 1675718232.663065 2023-02-06T21:17:12.663065+00:00 2023-02-06T21_17_12.663065535Z.png creation
exp_2023_02_06_13 leopard 99909 3694 rest_state 1675718232.739068 2023-02-06T21:17:12.739068+00:00 2023-02-06T21_17_12.739068532Z.png creation
exp_2023_02_06_13 leopard 99909 3695 rest_state 1675718232.867073 2023-02-06T21:17:12.867073+00:00 2023-02-06T21_17_12.867073583Z.png creation
exp_2023_02_06_13 leopard 99909 3696 rest_state 1675718232.935076 2023-02-06T21:17:12.935076+00:00 2023-02-06T21_17_12.935076264Z.png creation
exp_2023_02_06_13 leopard 99909 3697 rest_state 1675718233.059081 2023-02-06T21:17:13.059081+00:00 2023-02-06T21_17_13.059081157Z.png creation
exp_2023_02_06_13 leopard 99909 3698 rest_state 1675718233.151084 2023-02-06T21:17:13.151084+00:00 2023-02-06T21_17_13.151084788Z.png creation
exp_2023_02_06_13 leopard 99909 3699 rest_state 1675718233.235088 2023-02-06T21:17:13.235088+00:00 2023-02-06T21_17_13.235088100Z.png creation
exp_2023_02_06_13 leopard 99909 3700 rest_state 1675718233.359092 2023-02-06T21:17:13.359092+00:00 2023-02-06T21_17_13.359092993Z.png creation
exp_2023_02_06_13 leopard 99909 3701 rest_state 1675718233.439096 2023-02-06T21:17:13.439096+00:00 2023-02-06T21_17_13.439096148Z.png creation
exp_2023_02_06_13 leopard 99909 3702 rest_state 1675718233.535099 2023-02-06T21:17:13.535099+00:00 2023-02-06T21_17_13.535099936Z.png creation
exp_2023_02_06_13 leopard 99909 3703 rest_state 1675718233.659104 2023-02-06T21:17:13.659104+00:00 2023-02-06T21_17_13.659104828Z.png creation
exp_2023_02_06_13 leopard 99909 3704 rest_state 1675718233.743108 2023-02-06T21:17:13.743108+00:00 2023-02-06T21_17_13.743108142Z.png creation
exp_2023_02_06_13 leopard 99909 3705 rest_state 1675718233.875113 2023-02-06T21:17:13.875113+00:00 2023-02-06T21_17_13.875113351Z.png creation
exp_2023_02_06_13 leopard 99909 3706 rest_state 1675718233.955116 2023-02-06T21:17:13.955116+00:00 2023-02-06T21_17_13.955116506Z.png creation
exp_2023_02_06_13 leopard 99909 3707 rest_state 1675718234.043119 2023-02-06T21:17:14.043119+00:00 2023-02-06T21_17_14.043119978Z.png creation
exp_2023_02_06_13 leopard 99909 3708 rest_state 1675718234.159124 2023-02-06T21:17:14.159124+00:00 2023-02-06T21_17_14.159124554Z.png creation
exp_2023_02_06_13 leopard 99909 3709 rest_state 1675718234.251128 2023-02-06T21:17:14.251128+00:00 2023-02-06T21_17_14.251128184Z.png creation
exp_2023_02_06_13 leopard 99909 3710 rest_state 1675718234.335131 2023-02-06T21:17:14.335131+00:00 2023-02-06T21_17_14.335131499Z.png creation
exp_2023_02_06_13 leopard 99909 3711 rest_state 1675718234.463136 2023-02-06T21:17:14.463136+00:00 2023-02-06T21_17_14.463136548Z.png creation
exp_2023_02_06_13 leopard 99909 3712 rest_state 1675718234.55114 2023-02-06T21:17:14.551140+00:00 2023-02-06T21_17_14.551140020Z.png creation
exp_2023_02_06_13 leopard 99909 3713 rest_state 1675718234.635143 2023-02-06T21:17:14.635143+00:00 2023-02-06T21_17_14.635143335Z.png creation
exp_2023_02_06_13 leopard 99909 3714 rest_state 1675718234.727146 2023-02-06T21:17:14.727146+00:00 2023-02-06T21_17_14.727146963Z.png creation
exp_2023_02_06_13 leopard 99909 3715 rest_state 1675718234.851151 2023-02-06T21:17:14.851151+00:00 2023-02-06T21_17_14.851151856Z.png creation
exp_2023_02_06_13 leopard 99909 3716 rest_state 1675718234.943155 2023-02-06T21:17:14.943155+00:00 2023-02-06T21_17_14.943155485Z.png creation
exp_2023_02_06_13 leopard 99909 3717 rest_state 1675718235.06316 2023-02-06T21:17:15.063160+00:00 2023-02-06T21_17_15.063160220Z.png creation
exp_2023_02_06_13 leopard 99909 3718 rest_state 1675718235.143163 2023-02-06T21:17:15.143163+00:00 2023-02-06T21_17_15.143163375Z.png creation
exp_2023_02_06_13 leopard 99909 3719 rest_state 1675718235.267168 2023-02-06T21:17:15.267168+00:00 2023-02-06T21_17_15.267168268Z.png creation
exp_2023_02_06_13 leopard 99909 3720 rest_state 1675718235.343171 2023-02-06T21:17:15.343171+00:00 2023-02-06T21_17_15.343171267Z.png creation
exp_2023_02_06_13 leopard 99909 3721 rest_state 1675718235.471176 2023-02-06T21:17:15.471176+00:00 2023-02-06T21_17_15.471176316Z.png creation
exp_2023_02_06_13 leopard 99909 3722 rest_state 1675718235.551179 2023-02-06T21:17:15.551179+00:00 2023-02-06T21_17_15.551179472Z.png creation
exp_2023_02_06_13 leopard 99909 3723 rest_state 1675718235.631182 2023-02-06T21:17:15.631182+00:00 2023-02-06T21_17_15.631182627Z.png creation
exp_2023_02_06_13 leopard 99909 3724 rest_state 1675718235.759187 2023-02-06T21:17:15.759187+00:00 2023-02-06T21_17_15.759187678Z.png creation
exp_2023_02_06_13 leopard 99909 3725 rest_state 1675718235.83519 2023-02-06T21:17:15.835190+00:00 2023-02-06T21_17_15.835190677Z.png creation
exp_2023_02_06_13 leopard 99909 3726 rest_state 1675718235.927194 2023-02-06T21:17:15.927194+00:00 2023-02-06T21_17_15.927194306Z.png creation
exp_2023_02_06_13 leopard 99909 3727 rest_state 1675718236.047199 2023-02-06T21:17:16.047199+00:00 2023-02-06T21_17_16.047199041Z.png creation
exp_2023_02_06_13 leopard 99909 3728 rest_state 1675718236.167203 2023-02-06T21:17:16.167203+00:00 2023-02-06T21_17_16.167203774Z.png creation
exp_2023_02_06_13 leopard 99909 3729 rest_state 1675718236.251207 2023-02-06T21:17:16.251207+00:00 2023-02-06T21_17_16.251207089Z.png creation
exp_2023_02_06_13 leopard 99909 3730 rest_state 1675718236.367211 2023-02-06T21:17:16.367211+00:00 2023-02-06T21_17_16.367211664Z.png creation
exp_2023_02_06_13 leopard 99909 3731 rest_state 1675718236.459215 2023-02-06T21:17:16.459215+00:00 2023-02-06T21_17_16.459215294Z.png creation

Next page

Advanced export

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

CSV options:

CREATE TABLE "screen_capture" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [station] TEXT REFERENCES [station]([id]),
   [participant] INTEGER REFERENCES [participant]([id]),
   [id] INTEGER,
   [task] TEXT REFERENCES [task]([id]),
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [filename] TEXT,
   [url] TEXT,
   [timestamp_origin] TEXT,
   PRIMARY KEY ([group_session], [station], [participant], [id], [timestamp_unix])
);
CREATE INDEX [idx_screen_capture_task]
    ON [screen_capture] ([task]);
CREATE INDEX [idx_screen_capture_participant]
    ON [screen_capture] ([participant]);
CREATE INDEX [idx_screen_capture_station]
    ON [screen_capture] ([station]);
CREATE INDEX [idx_screen_capture_group_session]
    ON [screen_capture] ([group_session]);