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 task = "hands_on_training"

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_2022_09_30_10 leopard 19 23813 hands_on_training 1664565264.2085357 2022-09-30T19:14:24.208536+00:00 output023814.png modification
exp_2022_09_30_10 leopard 19 23814 hands_on_training 1664565264.3085396 2022-09-30T19:14:24.308540+00:00 output023815.png modification
exp_2022_09_30_10 leopard 19 23815 hands_on_training 1664565264.4045434 2022-09-30T19:14:24.404543+00:00 output023816.png modification
exp_2022_09_30_10 leopard 19 23816 hands_on_training 1664565264.5005474 2022-09-30T19:14:24.500547+00:00 output023817.png modification
exp_2022_09_30_10 leopard 19 23817 hands_on_training 1664565264.5885508 2022-09-30T19:14:24.588551+00:00 output023818.png modification
exp_2022_09_30_10 leopard 19 23818 hands_on_training 1664565264.7285564 2022-09-30T19:14:24.728556+00:00 output023819.png modification
exp_2022_09_30_10 leopard 19 23819 hands_on_training 1664565264.8285604 2022-09-30T19:14:24.828560+00:00 output023820.png modification
exp_2022_09_30_10 leopard 19 23820 hands_on_training 1664565264.920564 2022-09-30T19:14:24.920564+00:00 output023821.png modification
exp_2022_09_30_10 leopard 19 23821 hands_on_training 1664565265.0365686 2022-09-30T19:14:25.036569+00:00 output023822.png modification
exp_2022_09_30_10 leopard 19 23822 hands_on_training 1664565265.1285722 2022-09-30T19:14:25.128572+00:00 output023823.png modification
exp_2022_09_30_10 leopard 19 23823 hands_on_training 1664565265.2125757 2022-09-30T19:14:25.212576+00:00 output023824.png modification
exp_2022_09_30_10 leopard 19 23824 hands_on_training 1664565265.3325803 2022-09-30T19:14:25.332580+00:00 output023825.png modification
exp_2022_09_30_10 leopard 19 23825 hands_on_training 1664565265.4405847 2022-09-30T19:14:25.440585+00:00 output023826.png modification
exp_2022_09_30_10 leopard 19 23826 hands_on_training 1664565265.5285883 2022-09-30T19:14:25.528588+00:00 output023827.png modification
exp_2022_09_30_10 leopard 19 23827 hands_on_training 1664565265.624592 2022-09-30T19:14:25.624592+00:00 output023828.png modification
exp_2022_09_30_10 leopard 19 23828 hands_on_training 1664565265.7125955 2022-09-30T19:14:25.712595+00:00 output023829.png modification
exp_2022_09_30_10 leopard 19 23829 hands_on_training 1664565265.796599 2022-09-30T19:14:25.796599+00:00 output023830.png modification
exp_2022_09_30_10 leopard 19 23830 hands_on_training 1664565265.9446049 2022-09-30T19:14:25.944605+00:00 output023831.png modification
exp_2022_09_30_10 leopard 19 23831 hands_on_training 1664565266.0366085 2022-09-30T19:14:26.036608+00:00 output023832.png modification
exp_2022_09_30_10 leopard 19 23832 hands_on_training 1664565266.128612 2022-09-30T19:14:26.128612+00:00 output023833.png modification
exp_2022_09_30_10 leopard 19 23833 hands_on_training 1664565266.2126155 2022-09-30T19:14:26.212615+00:00 output023834.png modification
exp_2022_09_30_10 leopard 19 23834 hands_on_training 1664565266.3086193 2022-09-30T19:14:26.308619+00:00 output023835.png modification
exp_2022_09_30_10 leopard 19 23835 hands_on_training 1664565266.404623 2022-09-30T19:14:26.404623+00:00 output023836.png modification
exp_2022_09_30_10 leopard 19 23836 hands_on_training 1664565266.5406284 2022-09-30T19:14:26.540628+00:00 output023837.png modification
exp_2022_09_30_10 leopard 19 23837 hands_on_training 1664565266.624632 2022-09-30T19:14:26.624632+00:00 output023838.png modification
exp_2022_09_30_10 leopard 19 23838 hands_on_training 1664565266.728636 2022-09-30T19:14:26.728636+00:00 output023839.png modification
exp_2022_09_30_10 leopard 19 23839 hands_on_training 1664565266.8406405 2022-09-30T19:14:26.840641+00:00 output023840.png modification
exp_2022_09_30_10 leopard 19 23840 hands_on_training 1664565266.9606452 2022-09-30T19:14:26.960645+00:00 output023841.png modification
exp_2022_09_30_10 leopard 19 23841 hands_on_training 1664565267.0406485 2022-09-30T19:14:27.040648+00:00 output023842.png modification
exp_2022_09_30_10 leopard 19 23842 hands_on_training 1664565267.1286519 2022-09-30T19:14:27.128652+00:00 output023843.png modification
exp_2022_09_30_10 leopard 19 23843 hands_on_training 1664565267.2486567 2022-09-30T19:14:27.248657+00:00 output023844.png modification
exp_2022_09_30_10 leopard 19 23844 hands_on_training 1664565267.3846622 2022-09-30T19:14:27.384662+00:00 output023845.png modification
exp_2022_09_30_10 leopard 19 23845 hands_on_training 1664565267.4926665 2022-09-30T19:14:27.492666+00:00 output023846.png modification
exp_2022_09_30_10 leopard 19 23846 hands_on_training 1664565267.5686696 2022-09-30T19:14:27.568670+00:00 output023847.png modification
exp_2022_09_30_10 leopard 19 23847 hands_on_training 1664565267.6606731 2022-09-30T19:14:27.660673+00:00 output023848.png modification
exp_2022_09_30_10 leopard 19 23848 hands_on_training 1664565267.7526767 2022-09-30T19:14:27.752677+00:00 output023849.png modification
exp_2022_09_30_10 leopard 19 23849 hands_on_training 1664565267.8406804 2022-09-30T19:14:27.840680+00:00 output023850.png modification
exp_2022_09_30_10 leopard 19 23850 hands_on_training 1664565267.9406843 2022-09-30T19:14:27.940684+00:00 output023851.png modification
exp_2022_09_30_10 leopard 19 23851 hands_on_training 1664565268.0406883 2022-09-30T19:14:28.040688+00:00 output023852.png modification
exp_2022_09_30_10 leopard 19 23852 hands_on_training 1664565268.1286917 2022-09-30T19:14:28.128692+00:00 output023853.png modification
exp_2022_09_30_10 leopard 19 23853 hands_on_training 1664565268.2246957 2022-09-30T19:14:28.224696+00:00 output023854.png modification
exp_2022_09_30_10 leopard 19 23854 hands_on_training 1664565268.3006985 2022-09-30T19:14:28.300699+00:00 output023855.png modification
exp_2022_09_30_10 leopard 19 23855 hands_on_training 1664565268.4447043 2022-09-30T19:14:28.444704+00:00 output023856.png modification
exp_2022_09_30_10 leopard 19 23856 hands_on_training 1664565268.536708 2022-09-30T19:14:28.536708+00:00 output023857.png modification
exp_2022_09_30_10 leopard 19 23857 hands_on_training 1664565268.6287117 2022-09-30T19:14:28.628712+00:00 output023858.png modification
exp_2022_09_30_10 leopard 19 23858 hands_on_training 1664565268.7327158 2022-09-30T19:14:28.732716+00:00 output023859.png modification
exp_2022_09_30_10 leopard 19 23859 hands_on_training 1664565268.8207192 2022-09-30T19:14:28.820719+00:00 output023860.png modification
exp_2022_09_30_10 leopard 19 23860 hands_on_training 1664565268.9287236 2022-09-30T19:14:28.928724+00:00 output023861.png modification
exp_2022_09_30_10 leopard 19 23861 hands_on_training 1664565269.036728 2022-09-30T19:14:29.036728+00:00 output023862.png modification
exp_2022_09_30_10 leopard 19 23862 hands_on_training 1664565269.140732 2022-09-30T19:14:29.140732+00:00 output023863.png modification
exp_2022_09_30_10 leopard 19 23863 hands_on_training 1664565269.2327356 2022-09-30T19:14:29.232736+00:00 output023864.png modification
exp_2022_09_30_10 leopard 19 23864 hands_on_training 1664565269.3207393 2022-09-30T19:14:29.320739+00:00 output023865.png modification
exp_2022_09_30_10 leopard 19 23865 hands_on_training 1664565269.4327438 2022-09-30T19:14:29.432744+00:00 output023866.png modification
exp_2022_09_30_10 leopard 19 23866 hands_on_training 1664565269.5287476 2022-09-30T19:14:29.528748+00:00 output023867.png modification
exp_2022_09_30_10 leopard 19 23867 hands_on_training 1664565269.6047506 2022-09-30T19:14:29.604751+00:00 output023868.png modification
exp_2022_09_30_10 leopard 19 23868 hands_on_training 1664565269.7047546 2022-09-30T19:14:29.704755+00:00 output023869.png modification
exp_2022_09_30_10 leopard 19 23869 hands_on_training 1664565269.812759 2022-09-30T19:14:29.812759+00:00 output023870.png modification
exp_2022_09_30_10 leopard 19 23870 hands_on_training 1664565269.9087627 2022-09-30T19:14:29.908763+00:00 output023871.png modification
exp_2022_09_30_10 leopard 19 23871 hands_on_training 1664565270.0207672 2022-09-30T19:14:30.020767+00:00 output023872.png modification
exp_2022_09_30_10 leopard 19 23872 hands_on_training 1664565270.116771 2022-09-30T19:14:30.116771+00:00 output023873.png modification
exp_2022_09_30_10 leopard 19 23873 hands_on_training 1664565270.2247753 2022-09-30T19:14:30.224775+00:00 output023874.png modification
exp_2022_09_30_10 leopard 19 23874 hands_on_training 1664565270.316779 2022-09-30T19:14:30.316779+00:00 output023875.png modification
exp_2022_09_30_10 leopard 19 23875 hands_on_training 1664565270.4287834 2022-09-30T19:14:30.428783+00:00 output023876.png modification
exp_2022_09_30_10 leopard 19 23876 hands_on_training 1664565270.5247872 2022-09-30T19:14:30.524787+00:00 output023877.png modification
exp_2022_09_30_10 leopard 19 23877 hands_on_training 1664565270.6327915 2022-09-30T19:14:30.632792+00:00 output023878.png modification
exp_2022_09_30_10 leopard 19 23878 hands_on_training 1664565270.7327955 2022-09-30T19:14:30.732795+00:00 output023879.png modification
exp_2022_09_30_10 leopard 19 23879 hands_on_training 1664565270.8327994 2022-09-30T19:14:30.832799+00:00 output023880.png modification
exp_2022_09_30_10 leopard 19 23880 hands_on_training 1664565270.9408038 2022-09-30T19:14:30.940804+00:00 output023881.png modification
exp_2022_09_30_10 leopard 19 23881 hands_on_training 1664565271.0288072 2022-09-30T19:14:31.028807+00:00 output023882.png modification
exp_2022_09_30_10 leopard 19 23882 hands_on_training 1664565271.1088104 2022-09-30T19:14:31.108810+00:00 output023883.png modification
exp_2022_09_30_10 leopard 19 23883 hands_on_training 1664565271.2048142 2022-09-30T19:14:31.204814+00:00 output023884.png modification
exp_2022_09_30_10 leopard 19 23884 hands_on_training 1664565271.3528202 2022-09-30T19:14:31.352820+00:00 output023885.png modification
exp_2022_09_30_10 leopard 19 23885 hands_on_training 1664565271.448824 2022-09-30T19:14:31.448824+00:00 output023886.png modification
exp_2022_09_30_10 leopard 19 23886 hands_on_training 1664565271.552828 2022-09-30T19:14:31.552828+00:00 output023887.png modification
exp_2022_09_30_10 leopard 19 23887 hands_on_training 1664565271.6328313 2022-09-30T19:14:31.632831+00:00 output023888.png modification
exp_2022_09_30_10 leopard 19 23888 hands_on_training 1664565271.7368355 2022-09-30T19:14:31.736835+00:00 output023889.png modification
exp_2022_09_30_10 leopard 19 23889 hands_on_training 1664565271.828839 2022-09-30T19:14:31.828839+00:00 output023890.png modification
exp_2022_09_30_10 leopard 19 23890 hands_on_training 1664565271.920843 2022-09-30T19:14:31.920843+00:00 output023891.png modification
exp_2022_09_30_10 leopard 19 23891 hands_on_training 1664565272.0208468 2022-09-30T19:14:32.020847+00:00 output023892.png modification
exp_2022_09_30_10 leopard 19 23892 hands_on_training 1664565272.1168506 2022-09-30T19:14:32.116851+00:00 output023893.png modification
exp_2022_09_30_10 leopard 19 23893 hands_on_training 1664565272.2168546 2022-09-30T19:14:32.216855+00:00 output023894.png modification
exp_2022_09_30_10 leopard 19 23894 hands_on_training 1664565272.3128583 2022-09-30T19:14:32.312858+00:00 output023895.png modification
exp_2022_09_30_10 leopard 19 23895 hands_on_training 1664565272.4488637 2022-09-30T19:14:32.448864+00:00 output023896.png modification
exp_2022_09_30_10 leopard 19 23896 hands_on_training 1664565272.5408676 2022-09-30T19:14:32.540868+00:00 output023897.png modification
exp_2022_09_30_10 leopard 19 23897 hands_on_training 1664565272.6368713 2022-09-30T19:14:32.636871+00:00 output023898.png modification
exp_2022_09_30_10 leopard 19 23898 hands_on_training 1664565272.732875 2022-09-30T19:14:32.732875+00:00 output023899.png modification
exp_2022_09_30_10 leopard 19 23899 hands_on_training 1664565272.8248787 2022-09-30T19:14:32.824879+00:00 output023900.png modification
exp_2022_09_30_10 leopard 19 23900 hands_on_training 1664565272.9208827 2022-09-30T19:14:32.920883+00:00 output023901.png modification
exp_2022_09_30_10 leopard 19 23901 hands_on_training 1664565273.0128863 2022-09-30T19:14:33.012886+00:00 output023902.png modification
exp_2022_09_30_10 leopard 19 23902 hands_on_training 1664565273.1448915 2022-09-30T19:14:33.144892+00:00 output023903.png modification
exp_2022_09_30_10 leopard 19 23903 hands_on_training 1664565273.2448955 2022-09-30T19:14:33.244895+00:00 output023904.png modification
exp_2022_09_30_10 leopard 19 23904 hands_on_training 1664565273.3448994 2022-09-30T19:14:33.344899+00:00 output023905.png modification
exp_2022_09_30_10 leopard 19 23905 hands_on_training 1664565273.4449034 2022-09-30T19:14:33.444903+00:00 output023906.png modification
exp_2022_09_30_10 leopard 19 23906 hands_on_training 1664565273.532907 2022-09-30T19:14:33.532907+00:00 output023907.png modification
exp_2022_09_30_10 leopard 19 23907 hands_on_training 1664565273.6369112 2022-09-30T19:14:33.636911+00:00 output023908.png modification
exp_2022_09_30_10 leopard 19 23908 hands_on_training 1664565273.7409153 2022-09-30T19:14:33.740915+00:00 output023909.png modification
exp_2022_09_30_10 leopard 19 23909 hands_on_training 1664565273.832919 2022-09-30T19:14:33.832919+00:00 output023910.png modification
exp_2022_09_30_10 leopard 19 23910 hands_on_training 1664565273.9289227 2022-09-30T19:14:33.928923+00:00 output023911.png modification
exp_2022_09_30_10 leopard 19 23911 hands_on_training 1664565274.0289266 2022-09-30T19:14:34.028927+00:00 output023912.png modification
exp_2022_09_30_10 leopard 19 23912 hands_on_training 1664565274.1449313 2022-09-30T19:14:34.144931+00:00 output023913.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]);