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 participant = 57

View and edit SQL

Suggested facets: task, timestamp_iso8601 (date)

Link group_session station participant id task timestamp_unix timestamp_iso8601 filename url timestamp_origin
exp_2022_10_28_10 tiger 57 1963 rest_state 1666980652.6156511 2022-10-28T18:10:52.615651+00:00 output001964.png modification
exp_2022_10_28_10 tiger 57 1964 rest_state 1666980652.7236552 2022-10-28T18:10:52.723655+00:00 output001965.png modification
exp_2022_10_28_10 tiger 57 1965 rest_state 1666980652.8316596 2022-10-28T18:10:52.831660+00:00 output001966.png modification
exp_2022_10_28_10 tiger 57 1966 rest_state 1666980652.9316635 2022-10-28T18:10:52.931664+00:00 output001967.png modification
exp_2022_10_28_10 tiger 57 1967 rest_state 1666980653.019667 2022-10-28T18:10:53.019667+00:00 output001968.png modification
exp_2022_10_28_10 tiger 57 1968 rest_state 1666980653.127671 2022-10-28T18:10:53.127671+00:00 output001969.png modification
exp_2022_10_28_10 tiger 57 1969 rest_state 1666980653.2196746 2022-10-28T18:10:53.219675+00:00 output001970.png modification
exp_2022_10_28_10 tiger 57 1970 rest_state 1666980653.327679 2022-10-28T18:10:53.327679+00:00 output001971.png modification
exp_2022_10_28_10 tiger 57 1971 rest_state 1666980653.407682 2022-10-28T18:10:53.407682+00:00 output001972.png modification
exp_2022_10_28_10 tiger 57 1972 rest_state 1666980653.507686 2022-10-28T18:10:53.507686+00:00 output001973.png modification
exp_2022_10_28_10 tiger 57 1973 rest_state 1666980653.6236904 2022-10-28T18:10:53.623690+00:00 output001974.png modification
exp_2022_10_28_10 tiger 57 1974 rest_state 1666980653.7236943 2022-10-28T18:10:53.723694+00:00 output001975.png modification
exp_2022_10_28_10 tiger 57 1975 rest_state 1666980653.8276985 2022-10-28T18:10:53.827698+00:00 output001976.png modification
exp_2022_10_28_10 tiger 57 1976 rest_state 1666980653.919702 2022-10-28T18:10:53.919702+00:00 output001977.png modification
exp_2022_10_28_10 tiger 57 1977 rest_state 1666980654.0237062 2022-10-28T18:10:54.023706+00:00 output001978.png modification
exp_2022_10_28_10 tiger 57 1978 rest_state 1666980654.12371 2022-10-28T18:10:54.123710+00:00 output001979.png modification
exp_2022_10_28_10 tiger 57 1979 rest_state 1666980654.227714 2022-10-28T18:10:54.227714+00:00 output001980.png modification
exp_2022_10_28_10 tiger 57 1980 rest_state 1666980654.3237178 2022-10-28T18:10:54.323718+00:00 output001981.png modification
exp_2022_10_28_10 tiger 57 1981 rest_state 1666980654.4437225 2022-10-28T18:10:54.443722+00:00 output001982.png modification
exp_2022_10_28_10 tiger 57 1982 rest_state 1666980654.5157254 2022-10-28T18:10:54.515725+00:00 output001983.png modification
exp_2022_10_28_10 tiger 57 1983 rest_state 1666980654.6317298 2022-10-28T18:10:54.631730+00:00 output001984.png modification
exp_2022_10_28_10 tiger 57 1984 rest_state 1666980654.7197332 2022-10-28T18:10:54.719733+00:00 output001985.png modification
exp_2022_10_28_10 tiger 57 1985 rest_state 1666980654.839738 2022-10-28T18:10:54.839738+00:00 output001986.png modification
exp_2022_10_28_10 tiger 57 1986 rest_state 1666980654.9557426 2022-10-28T18:10:54.955743+00:00 output001987.png modification
exp_2022_10_28_10 tiger 57 1987 rest_state 1666980655.0397458 2022-10-28T18:10:55.039746+00:00 output001988.png modification
exp_2022_10_28_10 tiger 57 1988 rest_state 1666980655.1197488 2022-10-28T18:10:55.119749+00:00 output001989.png modification
exp_2022_10_28_10 tiger 57 1989 rest_state 1666980655.2357535 2022-10-28T18:10:55.235754+00:00 output001990.png modification
exp_2022_10_28_10 tiger 57 1990 rest_state 1666980655.3197567 2022-10-28T18:10:55.319757+00:00 output001991.png modification
exp_2022_10_28_10 tiger 57 1991 rest_state 1666980655.4357612 2022-10-28T18:10:55.435761+00:00 output001992.png modification
exp_2022_10_28_10 tiger 57 1992 rest_state 1666980655.5557659 2022-10-28T18:10:55.555766+00:00 output001993.png modification
exp_2022_10_28_10 tiger 57 1993 rest_state 1666980655.6357691 2022-10-28T18:10:55.635769+00:00 output001994.png modification
exp_2022_10_28_10 tiger 57 1994 rest_state 1666980655.7437732 2022-10-28T18:10:55.743773+00:00 output001995.png modification
exp_2022_10_28_10 tiger 57 1995 rest_state 1666980655.867778 2022-10-28T18:10:55.867778+00:00 output001996.png modification
exp_2022_10_28_10 tiger 57 1996 rest_state 1666980655.9437811 2022-10-28T18:10:55.943781+00:00 output001997.png modification
exp_2022_10_28_10 tiger 57 1997 rest_state 1666980656.0277843 2022-10-28T18:10:56.027784+00:00 output001998.png modification
exp_2022_10_28_10 tiger 57 1998 rest_state 1666980656.1477892 2022-10-28T18:10:56.147789+00:00 output001999.png modification
exp_2022_10_28_10 tiger 57 1999 rest_state 1666980656.2277923 2022-10-28T18:10:56.227792+00:00 output002000.png modification
exp_2022_10_28_10 tiger 57 2000 rest_state 1666980656.3437967 2022-10-28T18:10:56.343797+00:00 output002001.png modification
exp_2022_10_28_10 tiger 57 2001 rest_state 1666980656.4197998 2022-10-28T18:10:56.419800+00:00 output002002.png modification
exp_2022_10_28_10 tiger 57 2002 rest_state 1666980656.4918027 2022-10-28T18:10:56.491803+00:00 output002003.png modification
exp_2022_10_28_10 tiger 57 2003 rest_state 1666980656.6078072 2022-10-28T18:10:56.607807+00:00 output002004.png modification
exp_2022_10_28_10 tiger 57 2004 rest_state 1666980656.731812 2022-10-28T18:10:56.731812+00:00 output002005.png modification
exp_2022_10_28_10 tiger 57 2005 rest_state 1666980656.8078148 2022-10-28T18:10:56.807815+00:00 output002006.png modification
exp_2022_10_28_10 tiger 57 2006 rest_state 1666980656.9318197 2022-10-28T18:10:56.931820+00:00 output002007.png modification
exp_2022_10_28_10 tiger 57 2007 rest_state 1666980657.0078228 2022-10-28T18:10:57.007823+00:00 output002008.png modification
exp_2022_10_28_10 tiger 57 2008 rest_state 1666980657.119827 2022-10-28T18:10:57.119827+00:00 output002009.png modification
exp_2022_10_28_10 tiger 57 2009 rest_state 1666980657.2078307 2022-10-28T18:10:57.207831+00:00 output002010.png modification
exp_2022_10_28_10 tiger 57 2010 rest_state 1666980657.3318355 2022-10-28T18:10:57.331836+00:00 output002011.png modification
exp_2022_10_28_10 tiger 57 2011 rest_state 1666980657.4078383 2022-10-28T18:10:57.407838+00:00 output002012.png modification
exp_2022_10_28_10 tiger 57 2012 rest_state 1666980657.4878416 2022-10-28T18:10:57.487842+00:00 output002013.png modification
exp_2022_10_28_10 tiger 57 2013 rest_state 1666980657.6158466 2022-10-28T18:10:57.615847+00:00 output002014.png modification
exp_2022_10_28_10 tiger 57 2014 rest_state 1666980657.6958497 2022-10-28T18:10:57.695850+00:00 output002015.png modification
exp_2022_10_28_10 tiger 57 2015 rest_state 1666980657.8118541 2022-10-28T18:10:57.811854+00:00 output002016.png modification
exp_2022_10_28_10 tiger 57 2016 rest_state 1666980657.9278588 2022-10-28T18:10:57.927859+00:00 output002017.png modification
exp_2022_10_28_10 tiger 57 2017 rest_state 1666980658.0038617 2022-10-28T18:10:58.003862+00:00 output002018.png modification
exp_2022_10_28_10 tiger 57 2018 rest_state 1666980658.1238663 2022-10-28T18:10:58.123866+00:00 output002019.png modification
exp_2022_10_28_10 tiger 57 2019 rest_state 1666980658.2078698 2022-10-28T18:10:58.207870+00:00 output002020.png modification
exp_2022_10_28_10 tiger 57 2020 rest_state 1666980658.3238742 2022-10-28T18:10:58.323874+00:00 output002021.png modification
exp_2022_10_28_10 tiger 57 2021 rest_state 1666980658.4118776 2022-10-28T18:10:58.411878+00:00 output002022.png modification
exp_2022_10_28_10 tiger 57 2022 rest_state 1666980658.4878807 2022-10-28T18:10:58.487881+00:00 output002023.png modification
exp_2022_10_28_10 tiger 57 2023 rest_state 1666980658.6078854 2022-10-28T18:10:58.607885+00:00 output002024.png modification
exp_2022_10_28_10 tiger 57 2024 rest_state 1666980658.72789 2022-10-28T18:10:58.727890+00:00 output002025.png modification
exp_2022_10_28_10 tiger 57 2025 rest_state 1666980658.8118932 2022-10-28T18:10:58.811893+00:00 output002026.png modification
exp_2022_10_28_10 tiger 57 2026 rest_state 1666980658.927898 2022-10-28T18:10:58.927898+00:00 output002027.png modification
exp_2022_10_28_10 tiger 57 2027 rest_state 1666980659.0039008 2022-10-28T18:10:59.003901+00:00 output002028.png modification
exp_2022_10_28_10 tiger 57 2028 rest_state 1666980659.1239054 2022-10-28T18:10:59.123905+00:00 output002029.png modification
exp_2022_10_28_10 tiger 57 2029 rest_state 1666980659.2039087 2022-10-28T18:10:59.203909+00:00 output002030.png modification
exp_2022_10_28_10 tiger 57 2030 rest_state 1666980659.3279135 2022-10-28T18:10:59.327914+00:00 output002031.png modification
exp_2022_10_28_10 tiger 57 2031 rest_state 1666980659.3999162 2022-10-28T18:10:59.399916+00:00 output002032.png modification
exp_2022_10_28_10 tiger 57 2032 rest_state 1666980659.5279212 2022-10-28T18:10:59.527921+00:00 output002033.png modification
exp_2022_10_28_10 tiger 57 2033 rest_state 1666980659.6119246 2022-10-28T18:10:59.611925+00:00 output002034.png modification
exp_2022_10_28_10 tiger 57 2034 rest_state 1666980659.727929 2022-10-28T18:10:59.727929+00:00 output002035.png modification
exp_2022_10_28_10 tiger 57 2035 rest_state 1666980659.799932 2022-10-28T18:10:59.799932+00:00 output002036.png modification
exp_2022_10_28_10 tiger 57 2036 rest_state 1666980659.9279368 2022-10-28T18:10:59.927937+00:00 output002037.png modification
exp_2022_10_28_10 tiger 57 2037 rest_state 1666980660.00794 2022-10-28T18:11:00.007940+00:00 output002038.png modification
exp_2022_10_28_10 tiger 57 2038 rest_state 1666980660.1239445 2022-10-28T18:11:00.123945+00:00 output002039.png modification
exp_2022_10_28_10 tiger 57 2039 rest_state 1666980660.207948 2022-10-28T18:11:00.207948+00:00 output002040.png modification
exp_2022_10_28_10 tiger 57 2040 rest_state 1666980660.3279526 2022-10-28T18:11:00.327953+00:00 output002041.png modification
exp_2022_10_28_10 tiger 57 2041 rest_state 1666980660.3959553 2022-10-28T18:11:00.395955+00:00 output002042.png modification
exp_2022_10_28_10 tiger 57 2042 rest_state 1666980660.5119598 2022-10-28T18:11:00.511960+00:00 output002043.png modification
exp_2022_10_28_10 tiger 57 2043 rest_state 1666980660.6279643 2022-10-28T18:11:00.627964+00:00 output002044.png modification
exp_2022_10_28_10 tiger 57 2044 rest_state 1666980660.695967 2022-10-28T18:11:00.695967+00:00 output002045.png modification
exp_2022_10_28_10 tiger 57 2045 rest_state 1666980660.803971 2022-10-28T18:11:00.803971+00:00 output002046.png modification
exp_2022_10_28_10 tiger 57 2046 rest_state 1666980660.927976 2022-10-28T18:11:00.927976+00:00 output002047.png modification
exp_2022_10_28_10 tiger 57 2047 rest_state 1666980660.9959786 2022-10-28T18:11:00.995979+00:00 output002048.png modification
exp_2022_10_28_10 tiger 57 2048 rest_state 1666980661.1199834 2022-10-28T18:11:01.119983+00:00 output002049.png modification
exp_2022_10_28_10 tiger 57 2049 rest_state 1666980661.1959865 2022-10-28T18:11:01.195987+00:00 output002050.png modification
exp_2022_10_28_10 tiger 57 2050 rest_state 1666980661.3079908 2022-10-28T18:11:01.307991+00:00 output002051.png modification
exp_2022_10_28_10 tiger 57 2051 rest_state 1666980661.387994 2022-10-28T18:11:01.387994+00:00 output002052.png modification
exp_2022_10_28_10 tiger 57 2052 rest_state 1666980661.5039985 2022-10-28T18:11:01.503999+00:00 output002053.png modification
exp_2022_10_28_10 tiger 57 2053 rest_state 1666980661.6240032 2022-10-28T18:11:01.624003+00:00 output002054.png modification
exp_2022_10_28_10 tiger 57 2054 rest_state 1666980661.7040064 2022-10-28T18:11:01.704006+00:00 output002055.png modification
exp_2022_10_28_10 tiger 57 2055 rest_state 1666980661.8280113 2022-10-28T18:11:01.828011+00:00 output002056.png modification
exp_2022_10_28_10 tiger 57 2056 rest_state 1666980661.904014 2022-10-28T18:11:01.904014+00:00 output002057.png modification
exp_2022_10_28_10 tiger 57 2057 rest_state 1666980662.0200188 2022-10-28T18:11:02.020019+00:00 output002058.png modification
exp_2022_10_28_10 tiger 57 2058 rest_state 1666980662.1240227 2022-10-28T18:11:02.124023+00:00 output002059.png modification
exp_2022_10_28_10 tiger 57 2059 rest_state 1666980662.2280269 2022-10-28T18:11:02.228027+00:00 output002060.png modification
exp_2022_10_28_10 tiger 57 2060 rest_state 1666980662.3040297 2022-10-28T18:11:02.304030+00:00 output002061.png modification
exp_2022_10_28_10 tiger 57 2061 rest_state 1666980662.4200344 2022-10-28T18:11:02.420034+00:00 output002062.png modification
exp_2022_10_28_10 tiger 57 2062 rest_state 1666980662.4960372 2022-10-28T18:11:02.496037+00:00 output002063.png modification

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]);