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

View and edit SQL

Suggested facets: station, participant, task, timestamp_iso8601 (date)

Link group_session station participant id task timestamp_unix timestamp_iso8601 filename url timestamp_origin
exp_2023_04_18_14 leopard 137 382 rest_state 1681855964.6559558 2023-04-18T22:12:44.655956+00:00 000383_2023-04-18_22-12-57.172.PM~212.png lsl
exp_2023_04_18_14 leopard 137 383 rest_state 1681855964.8906796 2023-04-18T22:12:44.890680+00:00 000384_2023-04-18_22-12-57.386.PM~214.png lsl
exp_2023_04_18_14 leopard 137 384 rest_state 1681855965.1254034 2023-04-18T22:12:45.125403+00:00 000385_2023-04-18_22-12-57.592.PM~206.png lsl
exp_2023_04_18_14 leopard 137 385 rest_state 1681855965.360127 2023-04-18T22:12:45.360127+00:00 000386_2023-04-18_22-12-57.807.PM~215.png lsl
exp_2023_04_18_14 leopard 137 386 rest_state 1681855965.5948508 2023-04-18T22:12:45.594851+00:00 000387_2023-04-18_22-12-58.030.PM~223.png lsl
exp_2023_04_18_14 leopard 137 387 rest_state 1681855965.8295746 2023-04-18T22:12:45.829575+00:00 000388_2023-04-18_22-12-58.234.PM~204.png lsl
exp_2023_04_18_14 leopard 137 388 rest_state 1681855966.0642984 2023-04-18T22:12:46.064298+00:00 000389_2023-04-18_22-12-58.437.PM~203.png lsl
exp_2023_04_18_14 leopard 137 389 rest_state 1681855966.299022 2023-04-18T22:12:46.299022+00:00 000390_2023-04-18_22-12-58.651.PM~214.png lsl
exp_2023_04_18_14 leopard 137 390 rest_state 1681855966.5337458 2023-04-18T22:12:46.533746+00:00 000391_2023-04-18_22-12-58.862.PM~211.png lsl
exp_2023_04_18_14 leopard 137 391 rest_state 1681855966.7684696 2023-04-18T22:12:46.768470+00:00 000392_2023-04-18_22-12-59.074.PM~212.png lsl
exp_2023_04_18_14 leopard 137 392 rest_state 1681855967.0031934 2023-04-18T22:12:47.003193+00:00 000393_2023-04-18_22-12-59.285.PM~211.png lsl
exp_2023_04_18_14 leopard 137 393 rest_state 1681855967.237917 2023-04-18T22:12:47.237917+00:00 000394_2023-04-18_22-12-59.492.PM~207.png lsl
exp_2023_04_18_14 leopard 137 394 rest_state 1681855967.4726408 2023-04-18T22:12:47.472641+00:00 000395_2023-04-18_22-12-59.697.PM~205.png lsl
exp_2023_04_18_14 leopard 137 395 rest_state 1681855967.7073646 2023-04-18T22:12:47.707365+00:00 000396_2023-04-18_22-12-59.909.PM~212.png lsl
exp_2023_04_18_14 leopard 137 396 rest_state 1681855967.9420884 2023-04-18T22:12:47.942088+00:00 000397_2023-04-18_22-13-00.114.PM~205.png lsl
exp_2023_04_18_14 leopard 137 397 rest_state 1681855968.176812 2023-04-18T22:12:48.176812+00:00 000398_2023-04-18_22-13-00.324.PM~210.png lsl
exp_2023_04_18_14 leopard 137 398 rest_state 1681855968.4115357 2023-04-18T22:12:48.411536+00:00 000399_2023-04-18_22-13-00.538.PM~214.png lsl
exp_2023_04_18_14 leopard 137 399 rest_state 1681855968.6462595 2023-04-18T22:12:48.646260+00:00 000400_2023-04-18_22-13-00.749.PM~211.png lsl
exp_2023_04_18_14 leopard 137 400 rest_state 1681855968.8809834 2023-04-18T22:12:48.880983+00:00 000401_2023-04-18_22-13-00.957.PM~208.png lsl
exp_2023_04_18_14 leopard 137 401 rest_state 1681855969.115707 2023-04-18T22:12:49.115707+00:00 000402_2023-04-18_22-13-01.173.PM~216.png lsl
exp_2023_04_18_14 leopard 137 402 rest_state 1681855969.3504307 2023-04-18T22:12:49.350431+00:00 000403_2023-04-18_22-13-01.381.PM~208.png lsl
exp_2023_04_18_14 leopard 137 403 rest_state 1681855969.5851545 2023-04-18T22:12:49.585155+00:00 000404_2023-04-18_22-13-01.595.PM~214.png lsl
exp_2023_04_18_14 leopard 137 404 rest_state 1681855969.8198783 2023-04-18T22:12:49.819878+00:00 000405_2023-04-18_22-13-01.800.PM~205.png lsl
exp_2023_04_18_14 leopard 137 405 rest_state 1681855970.0546021 2023-04-18T22:12:50.054602+00:00 000406_2023-04-18_22-13-02.008.PM~208.png lsl
exp_2023_04_18_14 leopard 137 406 rest_state 1681855970.2893257 2023-04-18T22:12:50.289326+00:00 000407_2023-04-18_22-13-02.216.PM~208.png lsl
exp_2023_04_18_14 leopard 137 407 rest_state 1681855970.5240495 2023-04-18T22:12:50.524050+00:00 000408_2023-04-18_22-13-02.426.PM~210.png lsl
exp_2023_04_18_14 leopard 137 408 rest_state 1681855970.7587733 2023-04-18T22:12:50.758773+00:00 000409_2023-04-18_22-13-02.635.PM~209.png lsl
exp_2023_04_18_14 leopard 137 409 rest_state 1681855970.9934971 2023-04-18T22:12:50.993497+00:00 000410_2023-04-18_22-13-02.864.PM~229.png lsl
exp_2023_04_18_14 leopard 137 410 rest_state 1681855971.2282207 2023-04-18T22:12:51.228221+00:00 000411_2023-04-18_22-13-03.072.PM~208.png lsl
exp_2023_04_18_14 leopard 137 411 rest_state 1681855971.4629445 2023-04-18T22:12:51.462945+00:00 000412_2023-04-18_22-13-03.281.PM~209.png lsl
exp_2023_04_18_14 leopard 137 412 rest_state 1681855971.6976683 2023-04-18T22:12:51.697668+00:00 000413_2023-04-18_22-13-03.495.PM~214.png lsl
exp_2023_04_18_14 leopard 137 413 rest_state 1681855971.9323921 2023-04-18T22:12:51.932392+00:00 000414_2023-04-18_22-13-03.726.PM~231.png lsl
exp_2023_04_18_14 leopard 137 414 rest_state 1681855972.1671157 2023-04-18T22:12:52.167116+00:00 000415_2023-04-18_22-13-03.953.PM~227.png lsl
exp_2023_04_18_14 leopard 137 415 rest_state 1681855972.4018395 2023-04-18T22:12:52.401839+00:00 000416_2023-04-18_22-13-04.170.PM~217.png lsl
exp_2023_04_18_14 leopard 137 416 rest_state 1681855972.6365633 2023-04-18T22:12:52.636563+00:00 000417_2023-04-18_22-13-04.398.PM~228.png lsl
exp_2023_04_18_14 leopard 137 417 rest_state 1681855972.871287 2023-04-18T22:12:52.871287+00:00 000418_2023-04-18_22-13-04.636.PM~238.png lsl
exp_2023_04_18_14 leopard 137 418 rest_state 1681855973.1060107 2023-04-18T22:12:53.106011+00:00 000419_2023-04-18_22-13-04.863.PM~227.png lsl
exp_2023_04_18_14 leopard 137 419 rest_state 1681855973.3407345 2023-04-18T22:12:53.340734+00:00 000420_2023-04-18_22-13-05.087.PM~224.png lsl
exp_2023_04_18_14 leopard 137 420 rest_state 1681855973.5754583 2023-04-18T22:12:53.575458+00:00 000421_2023-04-18_22-13-05.303.PM~216.png lsl
exp_2023_04_18_14 leopard 137 421 rest_state 1681855973.810182 2023-04-18T22:12:53.810182+00:00 000422_2023-04-18_22-13-05.523.PM~220.png lsl
exp_2023_04_18_14 leopard 137 422 rest_state 1681855974.0449057 2023-04-18T22:12:54.044906+00:00 000423_2023-04-18_22-13-05.741.PM~218.png lsl
exp_2023_04_18_14 leopard 137 423 rest_state 1681855974.2796295 2023-04-18T22:12:54.279629+00:00 000424_2023-04-18_22-13-05.970.PM~229.png lsl
exp_2023_04_18_14 leopard 137 424 rest_state 1681855974.5143533 2023-04-18T22:12:54.514353+00:00 000425_2023-04-18_22-13-06.204.PM~234.png lsl
exp_2023_04_18_14 leopard 137 425 rest_state 1681855974.749077 2023-04-18T22:12:54.749077+00:00 000426_2023-04-18_22-13-06.431.PM~227.png lsl
exp_2023_04_18_14 leopard 137 426 rest_state 1681855974.9838006 2023-04-18T22:12:54.983801+00:00 000427_2023-04-18_22-13-06.651.PM~220.png lsl
exp_2023_04_18_14 leopard 137 427 rest_state 1681855975.2185245 2023-04-18T22:12:55.218524+00:00 000428_2023-04-18_22-13-06.881.PM~230.png lsl
exp_2023_04_18_14 leopard 137 428 rest_state 1681855975.4532483 2023-04-18T22:12:55.453248+00:00 000429_2023-04-18_22-13-07.102.PM~221.png lsl
exp_2023_04_18_14 leopard 137 429 rest_state 1681855975.687972 2023-04-18T22:12:55.687972+00:00 000430_2023-04-18_22-13-07.320.PM~218.png lsl
exp_2023_04_18_14 leopard 137 430 rest_state 1681855975.9226959 2023-04-18T22:12:55.922696+00:00 000431_2023-04-18_22-13-07.546.PM~226.png lsl
exp_2023_04_18_14 leopard 137 431 rest_state 1681855976.1574194 2023-04-18T22:12:56.157419+00:00 000432_2023-04-18_22-13-07.781.PM~235.png lsl
exp_2023_04_18_14 leopard 137 432 rest_state 1681855976.3921432 2023-04-18T22:12:56.392143+00:00 000433_2023-04-18_22-13-08.020.PM~239.png lsl
exp_2023_04_18_14 leopard 137 433 rest_state 1681855976.626867 2023-04-18T22:12:56.626867+00:00 000434_2023-04-18_22-13-08.248.PM~228.png lsl
exp_2023_04_18_14 leopard 137 434 rest_state 1681855976.8615909 2023-04-18T22:12:56.861591+00:00 000435_2023-04-18_22-13-08.465.PM~217.png lsl
exp_2023_04_18_14 leopard 137 435 rest_state 1681855977.0963144 2023-04-18T22:12:57.096314+00:00 000436_2023-04-18_22-13-08.685.PM~220.png lsl
exp_2023_04_18_14 leopard 137 436 rest_state 1681855977.3310382 2023-04-18T22:12:57.331038+00:00 000437_2023-04-18_22-13-08.909.PM~224.png lsl
exp_2023_04_18_14 leopard 137 437 rest_state 1681855977.565762 2023-04-18T22:12:57.565762+00:00 000438_2023-04-18_22-13-09.125.PM~216.png lsl
exp_2023_04_18_14 leopard 137 438 rest_state 1681855977.8004858 2023-04-18T22:12:57.800486+00:00 000439_2023-04-18_22-13-09.333.PM~208.png lsl
exp_2023_04_18_14 leopard 137 439 rest_state 1681855978.0352094 2023-04-18T22:12:58.035209+00:00 000440_2023-04-18_22-13-09.548.PM~215.png lsl
exp_2023_04_18_14 leopard 137 440 rest_state 1681855978.2699332 2023-04-18T22:12:58.269933+00:00 000441_2023-04-18_22-13-09.771.PM~223.png lsl
exp_2023_04_18_14 leopard 137 441 rest_state 1681855978.504657 2023-04-18T22:12:58.504657+00:00 000442_2023-04-18_22-13-09.993.PM~222.png lsl
exp_2023_04_18_14 leopard 137 442 rest_state 1681855978.7393808 2023-04-18T22:12:58.739381+00:00 000443_2023-04-18_22-13-10.213.PM~220.png lsl
exp_2023_04_18_14 leopard 137 443 rest_state 1681855978.9741044 2023-04-18T22:12:58.974104+00:00 000444_2023-04-18_22-13-10.434.PM~221.png lsl
exp_2023_04_18_14 leopard 137 444 rest_state 1681855979.2088282 2023-04-18T22:12:59.208828+00:00 000445_2023-04-18_22-13-10.660.PM~226.png lsl
exp_2023_04_18_14 leopard 137 445 rest_state 1681855979.443552 2023-04-18T22:12:59.443552+00:00 000446_2023-04-18_22-13-10.881.PM~221.png lsl
exp_2023_04_18_14 leopard 137 446 rest_state 1681855979.6782758 2023-04-18T22:12:59.678276+00:00 000447_2023-04-18_22-13-11.100.PM~219.png lsl
exp_2023_04_18_14 leopard 137 447 rest_state 1681855979.9129994 2023-04-18T22:12:59.912999+00:00 000448_2023-04-18_22-13-11.324.PM~224.png lsl
exp_2023_04_18_14 leopard 137 448 rest_state 1681855980.1477232 2023-04-18T22:13:00.147723+00:00 000449_2023-04-18_22-13-11.544.PM~220.png lsl
exp_2023_04_18_14 leopard 137 449 rest_state 1681855980.382447 2023-04-18T22:13:00.382447+00:00 000450_2023-04-18_22-13-11.759.PM~215.png lsl
exp_2023_04_18_14 leopard 137 450 rest_state 1681855980.6171708 2023-04-18T22:13:00.617171+00:00 000451_2023-04-18_22-13-11.974.PM~215.png lsl
exp_2023_04_18_14 leopard 137 451 rest_state 1681855980.8518946 2023-04-18T22:13:00.851895+00:00 000452_2023-04-18_22-13-12.200.PM~226.png lsl
exp_2023_04_18_14 leopard 137 452 rest_state 1681855981.0866182 2023-04-18T22:13:01.086618+00:00 000453_2023-04-18_22-13-12.418.PM~218.png lsl
exp_2023_04_18_14 leopard 137 453 rest_state 1681855981.321342 2023-04-18T22:13:01.321342+00:00 000454_2023-04-18_22-13-12.638.PM~220.png lsl
exp_2023_04_18_14 leopard 137 454 rest_state 1681855981.5560658 2023-04-18T22:13:01.556066+00:00 000455_2023-04-18_22-13-12.847.PM~209.png lsl
exp_2023_04_18_14 leopard 137 455 rest_state 1681855981.7907896 2023-04-18T22:13:01.790790+00:00 000456_2023-04-18_22-13-13.062.PM~215.png lsl
exp_2023_04_18_14 leopard 137 456 rest_state 1681855982.0255132 2023-04-18T22:13:02.025513+00:00 000457_2023-04-18_22-13-13.300.PM~238.png lsl
exp_2023_04_18_14 leopard 137 457 rest_state 1681855982.260237 2023-04-18T22:13:02.260237+00:00 000458_2023-04-18_22-13-13.515.PM~215.png lsl
exp_2023_04_18_14 leopard 137 458 rest_state 1681855982.4949608 2023-04-18T22:13:02.494961+00:00 000459_2023-04-18_22-13-13.738.PM~223.png lsl
exp_2023_04_18_14 leopard 137 459 rest_state 1681855982.7296846 2023-04-18T22:13:02.729685+00:00 000460_2023-04-18_22-13-13.966.PM~228.png lsl
exp_2023_04_18_14 leopard 137 460 rest_state 1681855982.9644082 2023-04-18T22:13:02.964408+00:00 000461_2023-04-18_22-13-14.210.PM~244.png lsl
exp_2023_04_18_14 leopard 137 461 rest_state 1681855983.199132 2023-04-18T22:13:03.199132+00:00 000462_2023-04-18_22-13-14.436.PM~226.png lsl
exp_2023_04_18_14 leopard 137 462 rest_state 1681855983.4338558 2023-04-18T22:13:03.433856+00:00 000463_2023-04-18_22-13-14.650.PM~214.png lsl
exp_2023_04_18_14 leopard 137 463 rest_state 1681855983.6685796 2023-04-18T22:13:03.668580+00:00 000464_2023-04-18_22-13-14.882.PM~232.png lsl
exp_2023_04_18_14 leopard 137 464 rest_state 1681855983.9033031 2023-04-18T22:13:03.903303+00:00 000465_2023-04-18_22-13-15.106.PM~224.png lsl
exp_2023_04_18_14 leopard 137 465 rest_state 1681855984.138027 2023-04-18T22:13:04.138027+00:00 000466_2023-04-18_22-13-15.338.PM~232.png lsl
exp_2023_04_18_14 leopard 137 466 rest_state 1681855984.3727508 2023-04-18T22:13:04.372751+00:00 000467_2023-04-18_22-13-15.556.PM~218.png lsl
exp_2023_04_18_14 leopard 137 467 rest_state 1681855984.6074746 2023-04-18T22:13:04.607475+00:00 000468_2023-04-18_22-13-15.767.PM~211.png lsl
exp_2023_04_18_14 leopard 137 468 rest_state 1681855984.8421981 2023-04-18T22:13:04.842198+00:00 000469_2023-04-18_22-13-15.980.PM~213.png lsl
exp_2023_04_18_14 leopard 137 469 rest_state 1681855985.076922 2023-04-18T22:13:05.076922+00:00 000470_2023-04-18_22-13-16.203.PM~223.png lsl
exp_2023_04_18_14 leopard 137 470 rest_state 1681855985.3116457 2023-04-18T22:13:05.311646+00:00 000471_2023-04-18_22-13-16.422.PM~219.png lsl
exp_2023_04_18_14 leopard 137 471 rest_state 1681855985.5463696 2023-04-18T22:13:05.546370+00:00 000472_2023-04-18_22-13-16.642.PM~220.png lsl
exp_2023_04_18_14 leopard 137 472 rest_state 1681855985.7810934 2023-04-18T22:13:05.781093+00:00 000473_2023-04-18_22-13-16.867.PM~225.png lsl
exp_2023_04_18_14 leopard 137 473 rest_state 1681855986.015817 2023-04-18T22:13:06.015817+00:00 000474_2023-04-18_22-13-17.095.PM~228.png lsl
exp_2023_04_18_14 leopard 137 474 rest_state 1681855986.2505407 2023-04-18T22:13:06.250541+00:00 000475_2023-04-18_22-13-17.318.PM~223.png lsl
exp_2023_04_18_14 leopard 137 475 rest_state 1681855986.4852645 2023-04-18T22:13:06.485265+00:00 000476_2023-04-18_22-13-17.534.PM~216.png lsl
exp_2023_04_18_14 leopard 137 476 rest_state 1681855986.7199883 2023-04-18T22:13:06.719988+00:00 000477_2023-04-18_22-13-17.756.PM~222.png lsl
exp_2023_04_18_14 leopard 137 477 rest_state 1681855986.954712 2023-04-18T22:13:06.954712+00:00 000478_2023-04-18_22-13-17.981.PM~225.png lsl
exp_2023_04_18_14 leopard 137 478 rest_state 1681855987.1894357 2023-04-18T22:13:07.189436+00:00 000479_2023-04-18_22-13-18.205.PM~224.png lsl
exp_2023_04_18_14 leopard 137 479 rest_state 1681855987.4241595 2023-04-18T22:13:07.424160+00:00 000480_2023-04-18_22-13-18.418.PM~213.png lsl
exp_2023_04_18_14 leopard 137 480 rest_state 1681855987.6588833 2023-04-18T22:13:07.658883+00:00 000481_2023-04-18_22-13-18.628.PM~210.png lsl
exp_2023_04_18_14 leopard 137 481 rest_state 1681855987.893607 2023-04-18T22:13:07.893607+00:00 000482_2023-04-18_22-13-18.849.PM~221.png lsl

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