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_20_01"

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_20_01 leopard 118 857 rest_state 1676927678.335578 2023-02-20T21:14:38.335578+00:00 2023-02-20T21_14_38.335578708Z.png creation
exp_2023_02_20_01 leopard 118 858 rest_state 1676927678.431582 2023-02-20T21:14:38.431582+00:00 2023-02-20T21_14_38.431582656Z.png creation
exp_2023_02_20_01 leopard 118 859 rest_state 1676927678.555587 2023-02-20T21:14:38.555587+00:00 2023-02-20T21_14_38.555587755Z.png creation
exp_2023_02_20_01 leopard 118 860 rest_state 1676927678.643591 2023-02-20T21:14:38.643591+00:00 2023-02-20T21_14_38.643591374Z.png creation
exp_2023_02_20_01 leopard 118 861 rest_state 1676927678.739595 2023-02-20T21:14:38.739595+00:00 2023-02-20T21_14_38.739595322Z.png creation
exp_2023_02_20_01 leopard 118 862 rest_state 1676927678.831599 2023-02-20T21:14:38.831599+00:00 2023-02-20T21_14_38.831599106Z.png creation
exp_2023_02_20_01 leopard 118 863 rest_state 1676927678.927603 2023-02-20T21:14:38.927603+00:00 2023-02-20T21_14_38.927603054Z.png creation
exp_2023_02_20_01 leopard 118 864 rest_state 1676927679.019606 2023-02-20T21:14:39.019606+00:00 2023-02-20T21_14_39.019606836Z.png creation
exp_2023_02_20_01 leopard 118 865 rest_state 1676927679.147612 2023-02-20T21:14:39.147612+00:00 2023-02-20T21_14_39.147612101Z.png creation
exp_2023_02_20_01 leopard 118 866 rest_state 1676927679.239615 2023-02-20T21:14:39.239615+00:00 2023-02-20T21_14_39.239615885Z.png creation
exp_2023_02_20_01 leopard 118 867 rest_state 1676927679.34362 2023-02-20T21:14:39.343620+00:00 2023-02-20T21_14_39.343620162Z.png creation
exp_2023_02_20_01 leopard 118 868 rest_state 1676927679.435623 2023-02-20T21:14:39.435623+00:00 2023-02-20T21_14_39.435623944Z.png creation
exp_2023_02_20_01 leopard 118 869 rest_state 1676927679.535628 2023-02-20T21:14:39.535628+00:00 2023-02-20T21_14_39.535628057Z.png creation
exp_2023_02_20_01 leopard 118 870 rest_state 1676927679.635632 2023-02-20T21:14:39.635632+00:00 2023-02-20T21_14_39.635632170Z.png creation
exp_2023_02_20_01 leopard 118 871 rest_state 1676927679.735636 2023-02-20T21:14:39.735636+00:00 2023-02-20T21_14_39.735636281Z.png creation
exp_2023_02_20_01 leopard 118 872 rest_state 1676927679.83564 2023-02-20T21:14:39.835640+00:00 2023-02-20T21_14_39.835640394Z.png creation
exp_2023_02_20_01 leopard 118 873 rest_state 1676927679.935644 2023-02-20T21:14:39.935644+00:00 2023-02-20T21_14_39.935644505Z.png creation
exp_2023_02_20_01 leopard 118 874 rest_state 1676927680.07165 2023-02-20T21:14:40.071650+00:00 2023-02-20T21_14_40.071650098Z.png creation
exp_2023_02_20_01 leopard 118 875 rest_state 1676927680.179654 2023-02-20T21:14:40.179654+00:00 2023-02-20T21_14_40.179654540Z.png creation
exp_2023_02_20_01 leopard 118 876 rest_state 1676927680.251657 2023-02-20T21:14:40.251657+00:00 2023-02-20T21_14_40.251657502Z.png creation
exp_2023_02_20_01 leopard 118 877 rest_state 1676927680.363662 2023-02-20T21:14:40.363662+00:00 2023-02-20T21_14_40.363662107Z.png creation
exp_2023_02_20_01 leopard 118 878 rest_state 1676927680.447665 2023-02-20T21:14:40.447665+00:00 2023-02-20T21_14_40.447665561Z.png creation
exp_2023_02_20_01 leopard 118 879 rest_state 1676927680.531669 2023-02-20T21:14:40.531669+00:00 2023-02-20T21_14_40.531669014Z.png creation
exp_2023_02_20_01 leopard 118 880 rest_state 1676927680.643673 2023-02-20T21:14:40.643673+00:00 2023-02-20T21_14_40.643673622Z.png creation
exp_2023_02_20_01 leopard 118 881 rest_state 1676927680.771678 2023-02-20T21:14:40.771678+00:00 2023-02-20T21_14_40.771678884Z.png creation
exp_2023_02_20_01 leopard 118 882 rest_state 1676927680.875683 2023-02-20T21:14:40.875683+00:00 2023-02-20T21_14_40.875683160Z.png creation
exp_2023_02_20_01 leopard 118 883 rest_state 1676927680.951686 2023-02-20T21:14:40.951686+00:00 2023-02-20T21_14_40.951686288Z.png creation
exp_2023_02_20_01 leopard 118 884 rest_state 1676927681.067691 2023-02-20T21:14:41.067691+00:00 2023-02-20T21_14_41.067691056Z.png creation
exp_2023_02_20_01 leopard 118 885 rest_state 1676927681.147694 2023-02-20T21:14:41.147694+00:00 2023-02-20T21_14_41.147694346Z.png creation
exp_2023_02_20_01 leopard 118 886 rest_state 1676927681.239698 2023-02-20T21:14:41.239698+00:00 2023-02-20T21_14_41.239698129Z.png creation
exp_2023_02_20_01 leopard 118 887 rest_state 1676927681.351702 2023-02-20T21:14:41.351702+00:00 2023-02-20T21_14_41.351702736Z.png creation
exp_2023_02_20_01 leopard 118 888 rest_state 1676927681.479707 2023-02-20T21:14:41.479707+00:00 2023-02-20T21_14_41.479707998Z.png creation
exp_2023_02_20_01 leopard 118 889 rest_state 1676927681.54771 2023-02-20T21:14:41.547710+00:00 2023-02-20T21_14_41.547710795Z.png creation
exp_2023_02_20_01 leopard 118 890 rest_state 1676927681.675716 2023-02-20T21:14:41.675716+00:00 2023-02-20T21_14_41.675716059Z.png creation
exp_2023_02_20_01 leopard 118 891 rest_state 1676927681.739718 2023-02-20T21:14:41.739718+00:00 2023-02-20T21_14_41.739718690Z.png creation
exp_2023_02_20_01 leopard 118 892 rest_state 1676927681.855723 2023-02-20T21:14:41.855723+00:00 2023-02-20T21_14_41.855723461Z.png creation
exp_2023_02_20_01 leopard 118 893 rest_state 1676927681.975728 2023-02-20T21:14:41.975728+00:00 2023-02-20T21_14_41.975728394Z.png creation
exp_2023_02_20_01 leopard 118 894 rest_state 1676927682.039731 2023-02-20T21:14:42.039731+00:00 2023-02-20T21_14_42.039731028Z.png creation
exp_2023_02_20_01 leopard 118 895 rest_state 1676927682.131734 2023-02-20T21:14:42.131734+00:00 2023-02-20T21_14_42.131734810Z.png creation
exp_2023_02_20_01 leopard 118 896 rest_state 1676927682.251739 2023-02-20T21:14:42.251739+00:00 2023-02-20T21_14_42.251739744Z.png creation
exp_2023_02_20_01 leopard 118 897 rest_state 1676927682.371744 2023-02-20T21:14:42.371744+00:00 2023-02-20T21_14_42.371744680Z.png creation
exp_2023_02_20_01 leopard 118 898 rest_state 1676927682.487749 2023-02-20T21:14:42.487749+00:00 2023-02-20T21_14_42.487749448Z.png creation
exp_2023_02_20_01 leopard 118 899 rest_state 1676927682.567752 2023-02-20T21:14:42.567752+00:00 2023-02-20T21_14_42.567752738Z.png creation
exp_2023_02_20_01 leopard 118 900 rest_state 1676927682.675757 2023-02-20T21:14:42.675757+00:00 2023-02-20T21_14_42.675757180Z.png creation
exp_2023_02_20_01 leopard 118 901 rest_state 1676927682.75176 2023-02-20T21:14:42.751760+00:00 2023-02-20T21_14_42.751760305Z.png creation
exp_2023_02_20_01 leopard 118 902 rest_state 1676927682.839763 2023-02-20T21:14:42.839763+00:00 2023-02-20T21_14_42.839763922Z.png creation
exp_2023_02_20_01 leopard 118 903 rest_state 1676927682.963769 2023-02-20T21:14:42.963769+00:00 2023-02-20T21_14_42.963769021Z.png creation
exp_2023_02_20_01 leopard 118 904 rest_state 1676927683.051772 2023-02-20T21:14:43.051772+00:00 2023-02-20T21_14_43.051772640Z.png creation
exp_2023_02_20_01 leopard 118 905 rest_state 1676927683.167777 2023-02-20T21:14:43.167777+00:00 2023-02-20T21_14_43.167777411Z.png creation
exp_2023_02_20_01 leopard 118 906 rest_state 1676927683.279782 2023-02-20T21:14:43.279782+00:00 2023-02-20T21_14_43.279782016Z.png creation
exp_2023_02_20_01 leopard 118 907 rest_state 1676927683.347784 2023-02-20T21:14:43.347784+00:00 2023-02-20T21_14_43.347784813Z.png creation
exp_2023_02_20_01 leopard 118 908 rest_state 1676927683.471789 2023-02-20T21:14:43.471789+00:00 2023-02-20T21_14_43.471789912Z.png creation
exp_2023_02_20_01 leopard 118 909 rest_state 1676927683.543792 2023-02-20T21:14:43.543792+00:00 2023-02-20T21_14_43.543792872Z.png creation
exp_2023_02_20_01 leopard 118 910 rest_state 1676927683.663797 2023-02-20T21:14:43.663797+00:00 2023-02-20T21_14_43.663797805Z.png creation
exp_2023_02_20_01 leopard 118 911 rest_state 1676927683.751801 2023-02-20T21:14:43.751801+00:00 2023-02-20T21_14_43.751801424Z.png creation
exp_2023_02_20_01 leopard 118 912 rest_state 1676927683.859805 2023-02-20T21:14:43.859805+00:00 2023-02-20T21_14_43.859805864Z.png creation
exp_2023_02_20_01 leopard 118 913 rest_state 1676927683.97581 2023-02-20T21:14:43.975810+00:00 2023-02-20T21_14_43.975810634Z.png creation
exp_2023_02_20_01 leopard 118 914 rest_state 1676927684.047813 2023-02-20T21:14:44.047813+00:00 2023-02-20T21_14_44.047813596Z.png creation
exp_2023_02_20_01 leopard 118 915 rest_state 1676927684.163818 2023-02-20T21:14:44.163818+00:00 2023-02-20T21_14_44.163818365Z.png creation
exp_2023_02_20_01 leopard 118 916 rest_state 1676927684.235821 2023-02-20T21:14:44.235821+00:00 2023-02-20T21_14_44.235821327Z.png creation
exp_2023_02_20_01 leopard 118 917 rest_state 1676927684.343825 2023-02-20T21:14:44.343825+00:00 2023-02-20T21_14_44.343825766Z.png creation
exp_2023_02_20_01 leopard 118 918 rest_state 1676927684.46783 2023-02-20T21:14:44.467830+00:00 2023-02-20T21_14_44.467830866Z.png creation
exp_2023_02_20_01 leopard 118 919 rest_state 1676927684.571835 2023-02-20T21:14:44.571835+00:00 2023-02-20T21_14_44.571835142Z.png creation
exp_2023_02_20_01 leopard 118 920 rest_state 1676927684.651838 2023-02-20T21:14:44.651838+00:00 2023-02-20T21_14_44.651838430Z.png creation
exp_2023_02_20_01 leopard 118 921 rest_state 1676927684.763843 2023-02-20T21:14:44.763843+00:00 2023-02-20T21_14_44.763843035Z.png creation
exp_2023_02_20_01 leopard 118 922 rest_state 1676927684.847846 2023-02-20T21:14:44.847846+00:00 2023-02-20T21_14_44.847846489Z.png creation
exp_2023_02_20_01 leopard 118 923 rest_state 1676927684.967851 2023-02-20T21:14:44.967851+00:00 2023-02-20T21_14_44.967851425Z.png creation
exp_2023_02_20_01 leopard 118 924 rest_state 1676927685.051854 2023-02-20T21:14:45.051854+00:00 2023-02-20T21_14_45.051854879Z.png creation
exp_2023_02_20_01 leopard 118 925 rest_state 1676927685.17986 2023-02-20T21:14:45.179860+00:00 2023-02-20T21_14_45.179860141Z.png creation
exp_2023_02_20_01 leopard 118 926 rest_state 1676927685.263863 2023-02-20T21:14:45.263863+00:00 2023-02-20T21_14_45.263863595Z.png creation
exp_2023_02_20_01 leopard 118 927 rest_state 1676927685.347867 2023-02-20T21:14:45.347867+00:00 2023-02-20T21_14_45.347867049Z.png creation
exp_2023_02_20_01 leopard 118 928 rest_state 1676927685.463871 2023-02-20T21:14:45.463871+00:00 2023-02-20T21_14_45.463871819Z.png creation
exp_2023_02_20_01 leopard 118 929 rest_state 1676927685.555875 2023-02-20T21:14:45.555875+00:00 2023-02-20T21_14_45.555875602Z.png creation
exp_2023_02_20_01 leopard 118 930 rest_state 1676927685.659879 2023-02-20T21:14:45.659879+00:00 2023-02-20T21_14_45.659879878Z.png creation
exp_2023_02_20_01 leopard 118 931 rest_state 1676927685.739883 2023-02-20T21:14:45.739883+00:00 2023-02-20T21_14_45.739883167Z.png creation
exp_2023_02_20_01 leopard 118 932 rest_state 1676927685.867888 2023-02-20T21:14:45.867888+00:00 2023-02-20T21_14_45.867888429Z.png creation
exp_2023_02_20_01 leopard 118 933 rest_state 1676927685.947891 2023-02-20T21:14:45.947891+00:00 2023-02-20T21_14_45.947891720Z.png creation
exp_2023_02_20_01 leopard 118 934 rest_state 1676927686.075896 2023-02-20T21:14:46.075896+00:00 2023-02-20T21_14_46.075896982Z.png creation
exp_2023_02_20_01 leopard 118 935 rest_state 1676927686.139899 2023-02-20T21:14:46.139899+00:00 2023-02-20T21_14_46.139899613Z.png creation
exp_2023_02_20_01 leopard 118 936 rest_state 1676927686.259904 2023-02-20T21:14:46.259904+00:00 2023-02-20T21_14_46.259904547Z.png creation
exp_2023_02_20_01 leopard 118 937 rest_state 1676927686.371909 2023-02-20T21:14:46.371909+00:00 2023-02-20T21_14_46.371909152Z.png creation
exp_2023_02_20_01 leopard 118 938 rest_state 1676927686.443912 2023-02-20T21:14:46.443912+00:00 2023-02-20T21_14_46.443912114Z.png creation
exp_2023_02_20_01 leopard 118 939 rest_state 1676927686.571917 2023-02-20T21:14:46.571917+00:00 2023-02-20T21_14_46.571917376Z.png creation
exp_2023_02_20_01 leopard 118 940 rest_state 1676927686.63992 2023-02-20T21:14:46.639920+00:00 2023-02-20T21_14_46.639920173Z.png creation
exp_2023_02_20_01 leopard 118 941 rest_state 1676927686.755924 2023-02-20T21:14:46.755924+00:00 2023-02-20T21_14_46.755924941Z.png creation
exp_2023_02_20_01 leopard 118 942 rest_state 1676927686.875929 2023-02-20T21:14:46.875929+00:00 2023-02-20T21_14_46.875929875Z.png creation
exp_2023_02_20_01 leopard 118 943 rest_state 1676927686.951933 2023-02-20T21:14:46.951933+00:00 2023-02-20T21_14_46.951933000Z.png creation
exp_2023_02_20_01 leopard 118 944 rest_state 1676927687.075938 2023-02-20T21:14:47.075938+00:00 2023-02-20T21_14_47.075938099Z.png creation
exp_2023_02_20_01 leopard 118 945 rest_state 1676927687.13994 2023-02-20T21:14:47.139940+00:00 2023-02-20T21_14_47.139940731Z.png creation
exp_2023_02_20_01 leopard 118 946 rest_state 1676927687.255945 2023-02-20T21:14:47.255945+00:00 2023-02-20T21_14_47.255945499Z.png creation
exp_2023_02_20_01 leopard 118 947 rest_state 1676927687.37595 2023-02-20T21:14:47.375950+00:00 2023-02-20T21_14_47.375950433Z.png creation
exp_2023_02_20_01 leopard 118 948 rest_state 1676927687.451953 2023-02-20T21:14:47.451953+00:00 2023-02-20T21_14_47.451953558Z.png creation
exp_2023_02_20_01 leopard 118 949 rest_state 1676927687.567958 2023-02-20T21:14:47.567958+00:00 2023-02-20T21_14_47.567958328Z.png creation
exp_2023_02_20_01 leopard 118 950 rest_state 1676927687.647961 2023-02-20T21:14:47.647961+00:00 2023-02-20T21_14_47.647961617Z.png creation
exp_2023_02_20_01 leopard 118 951 rest_state 1676927687.779967 2023-02-20T21:14:47.779967+00:00 2023-02-20T21_14_47.779967045Z.png creation
exp_2023_02_20_01 leopard 118 952 rest_state 1676927687.85197 2023-02-20T21:14:47.851970+00:00 2023-02-20T21_14_47.851970005Z.png creation
exp_2023_02_20_01 leopard 118 953 rest_state 1676927687.979975 2023-02-20T21:14:47.979975+00:00 2023-02-20T21_14_47.979975267Z.png creation
exp_2023_02_20_01 leopard 118 954 rest_state 1676927688.047978 2023-02-20T21:14:48.047978+00:00 2023-02-20T21_14_48.047978064Z.png creation
exp_2023_02_20_01 leopard 118 955 rest_state 1676927688.183983 2023-02-20T21:14:48.183983+00:00 2023-02-20T21_14_48.183983655Z.png creation
exp_2023_02_20_01 leopard 118 956 rest_state 1676927688.255986 2023-02-20T21:14:48.255986+00:00 2023-02-20T21_14_48.255986614Z.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]);