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

View and edit SQL

Suggested facets: station, participant, timestamp_iso8601 (date)

Link group_session station participant id task timestamp_unix timestamp_iso8601 filename url timestamp_origin
exp_2023_05_03_10 leopard 166 409 rest_state 1683136935.9997494 2023-05-03T18:02:15.999749+00:00 000410_2023-05-03_18-02-26.456.PM~211.png lsl
exp_2023_05_03_10 leopard 166 410 rest_state 1683136936.2173893 2023-05-03T18:02:16.217389+00:00 000411_2023-05-03_18-02-26.667.PM~211.png lsl
exp_2023_05_03_10 leopard 166 411 rest_state 1683136936.4350293 2023-05-03T18:02:16.435029+00:00 000412_2023-05-03_18-02-26.880.PM~213.png lsl
exp_2023_05_03_10 leopard 166 412 rest_state 1683136936.6526692 2023-05-03T18:02:16.652669+00:00 000413_2023-05-03_18-02-27.089.PM~209.png lsl
exp_2023_05_03_10 leopard 166 413 rest_state 1683136936.8703094 2023-05-03T18:02:16.870309+00:00 000414_2023-05-03_18-02-27.295.PM~206.png lsl
exp_2023_05_03_10 leopard 166 414 rest_state 1683136937.0879493 2023-05-03T18:02:17.087949+00:00 000415_2023-05-03_18-02-27.527.PM~232.png lsl
exp_2023_05_03_10 leopard 166 415 rest_state 1683136937.3055892 2023-05-03T18:02:17.305589+00:00 000416_2023-05-03_18-02-27.736.PM~209.png lsl
exp_2023_05_03_10 leopard 166 416 rest_state 1683136937.5232291 2023-05-03T18:02:17.523229+00:00 000417_2023-05-03_18-02-27.947.PM~211.png lsl
exp_2023_05_03_10 leopard 166 417 rest_state 1683136937.7408693 2023-05-03T18:02:17.740869+00:00 000418_2023-05-03_18-02-28.158.PM~211.png lsl
exp_2023_05_03_10 leopard 166 418 rest_state 1683136937.9585092 2023-05-03T18:02:17.958509+00:00 000419_2023-05-03_18-02-28.367.PM~209.png lsl
exp_2023_05_03_10 leopard 166 419 rest_state 1683136938.1761491 2023-05-03T18:02:18.176149+00:00 000420_2023-05-03_18-02-28.579.PM~212.png lsl
exp_2023_05_03_10 leopard 166 420 rest_state 1683136938.393789 2023-05-03T18:02:18.393789+00:00 000421_2023-05-03_18-02-28.785.PM~206.png lsl
exp_2023_05_03_10 leopard 166 421 rest_state 1683136938.6114292 2023-05-03T18:02:18.611429+00:00 000422_2023-05-03_18-02-28.997.PM~212.png lsl
exp_2023_05_03_10 leopard 166 422 rest_state 1683136938.8290691 2023-05-03T18:02:18.829069+00:00 000423_2023-05-03_18-02-29.204.PM~207.png lsl
exp_2023_05_03_10 leopard 166 423 rest_state 1683136939.046709 2023-05-03T18:02:19.046709+00:00 000424_2023-05-03_18-02-29.409.PM~205.png lsl
exp_2023_05_03_10 leopard 166 424 rest_state 1683136939.2643492 2023-05-03T18:02:19.264349+00:00 000425_2023-05-03_18-02-29.611.PM~202.png lsl
exp_2023_05_03_10 leopard 166 425 rest_state 1683136939.4819891 2023-05-03T18:02:19.481989+00:00 000426_2023-05-03_18-02-29.814.PM~203.png lsl
exp_2023_05_03_10 leopard 166 426 rest_state 1683136939.699629 2023-05-03T18:02:19.699629+00:00 000427_2023-05-03_18-02-30.023.PM~209.png lsl
exp_2023_05_03_10 leopard 166 427 rest_state 1683136939.917269 2023-05-03T18:02:19.917269+00:00 000428_2023-05-03_18-02-30.236.PM~213.png lsl
exp_2023_05_03_10 leopard 166 428 rest_state 1683136940.1349092 2023-05-03T18:02:20.134909+00:00 000429_2023-05-03_18-02-30.441.PM~205.png lsl
exp_2023_05_03_10 leopard 166 429 rest_state 1683136940.352549 2023-05-03T18:02:20.352549+00:00 000430_2023-05-03_18-02-30.650.PM~209.png lsl
exp_2023_05_03_10 leopard 166 430 rest_state 1683136940.570189 2023-05-03T18:02:20.570189+00:00 000431_2023-05-03_18-02-30.862.PM~212.png lsl
exp_2023_05_03_10 leopard 166 431 rest_state 1683136940.787829 2023-05-03T18:02:20.787829+00:00 000432_2023-05-03_18-02-31.073.PM~211.png lsl
exp_2023_05_03_10 leopard 166 432 rest_state 1683136941.005469 2023-05-03T18:02:21.005469+00:00 000433_2023-05-03_18-02-31.278.PM~205.png lsl
exp_2023_05_03_10 leopard 166 433 rest_state 1683136941.223109 2023-05-03T18:02:21.223109+00:00 000434_2023-05-03_18-02-31.487.PM~209.png lsl
exp_2023_05_03_10 leopard 166 434 rest_state 1683136941.440749 2023-05-03T18:02:21.440749+00:00 000435_2023-05-03_18-02-31.691.PM~204.png lsl
exp_2023_05_03_10 leopard 166 435 rest_state 1683136941.6583889 2023-05-03T18:02:21.658389+00:00 000436_2023-05-03_18-02-31.899.PM~208.png lsl
exp_2023_05_03_10 leopard 166 436 rest_state 1683136941.876029 2023-05-03T18:02:21.876029+00:00 000437_2023-05-03_18-02-32.110.PM~211.png lsl
exp_2023_05_03_10 leopard 166 437 rest_state 1683136942.093669 2023-05-03T18:02:22.093669+00:00 000438_2023-05-03_18-02-32.321.PM~211.png lsl
exp_2023_05_03_10 leopard 166 438 rest_state 1683136942.3113089 2023-05-03T18:02:22.311309+00:00 000439_2023-05-03_18-02-32.533.PM~212.png lsl
exp_2023_05_03_10 leopard 166 439 rest_state 1683136942.5289488 2023-05-03T18:02:22.528949+00:00 000440_2023-05-03_18-02-32.736.PM~203.png lsl
exp_2023_05_03_10 leopard 166 440 rest_state 1683136942.746589 2023-05-03T18:02:22.746589+00:00 000441_2023-05-03_18-02-32.938.PM~202.png lsl
exp_2023_05_03_10 leopard 166 441 rest_state 1683136942.9642289 2023-05-03T18:02:22.964229+00:00 000442_2023-05-03_18-02-33.141.PM~203.png lsl
exp_2023_05_03_10 leopard 166 442 rest_state 1683136943.1818688 2023-05-03T18:02:23.181869+00:00 000443_2023-05-03_18-02-33.349.PM~208.png lsl
exp_2023_05_03_10 leopard 166 443 rest_state 1683136943.399509 2023-05-03T18:02:23.399509+00:00 000444_2023-05-03_18-02-33.555.PM~206.png lsl
exp_2023_05_03_10 leopard 166 444 rest_state 1683136943.6171489 2023-05-03T18:02:23.617149+00:00 000445_2023-05-03_18-02-33.758.PM~203.png lsl
exp_2023_05_03_10 leopard 166 445 rest_state 1683136943.8347888 2023-05-03T18:02:23.834789+00:00 000446_2023-05-03_18-02-33.964.PM~206.png lsl
exp_2023_05_03_10 leopard 166 446 rest_state 1683136944.0524287 2023-05-03T18:02:24.052429+00:00 000447_2023-05-03_18-02-34.173.PM~209.png lsl
exp_2023_05_03_10 leopard 166 447 rest_state 1683136944.270069 2023-05-03T18:02:24.270069+00:00 000448_2023-05-03_18-02-34.380.PM~207.png lsl
exp_2023_05_03_10 leopard 166 448 rest_state 1683136944.4877088 2023-05-03T18:02:24.487709+00:00 000449_2023-05-03_18-02-34.593.PM~213.png lsl
exp_2023_05_03_10 leopard 166 449 rest_state 1683136944.7053487 2023-05-03T18:02:24.705349+00:00 000450_2023-05-03_18-02-34.803.PM~210.png lsl
exp_2023_05_03_10 leopard 166 450 rest_state 1683136944.9229887 2023-05-03T18:02:24.922989+00:00 000451_2023-05-03_18-02-35.012.PM~209.png lsl
exp_2023_05_03_10 leopard 166 451 rest_state 1683136945.1406288 2023-05-03T18:02:25.140629+00:00 000452_2023-05-03_18-02-35.223.PM~211.png lsl
exp_2023_05_03_10 leopard 166 452 rest_state 1683136945.3582687 2023-05-03T18:02:25.358269+00:00 000453_2023-05-03_18-02-35.432.PM~209.png lsl
exp_2023_05_03_10 leopard 166 453 rest_state 1683136945.5759087 2023-05-03T18:02:25.575909+00:00 000454_2023-05-03_18-02-35.635.PM~203.png lsl
exp_2023_05_03_10 leopard 166 454 rest_state 1683136945.7935486 2023-05-03T18:02:25.793549+00:00 000455_2023-05-03_18-02-35.838.PM~203.png lsl
exp_2023_05_03_10 leopard 166 455 rest_state 1683136946.0111887 2023-05-03T18:02:26.011189+00:00 000456_2023-05-03_18-02-36.049.PM~211.png lsl
exp_2023_05_03_10 leopard 166 456 rest_state 1683136946.2288287 2023-05-03T18:02:26.228829+00:00 000457_2023-05-03_18-02-36.263.PM~214.png lsl
exp_2023_05_03_10 leopard 166 457 rest_state 1683136946.4464686 2023-05-03T18:02:26.446469+00:00 000458_2023-05-03_18-02-36.474.PM~211.png lsl
exp_2023_05_03_10 leopard 166 458 rest_state 1683136946.6641088 2023-05-03T18:02:26.664109+00:00 000459_2023-05-03_18-02-36.688.PM~214.png lsl
exp_2023_05_03_10 leopard 166 459 rest_state 1683136946.8817487 2023-05-03T18:02:26.881749+00:00 000460_2023-05-03_18-02-36.892.PM~204.png lsl
exp_2023_05_03_10 leopard 166 460 rest_state 1683136947.0993886 2023-05-03T18:02:27.099389+00:00 000461_2023-05-03_18-02-37.100.PM~208.png lsl
exp_2023_05_03_10 leopard 166 461 rest_state 1683136947.3170285 2023-05-03T18:02:27.317029+00:00 000462_2023-05-03_18-02-37.305.PM~205.png lsl
exp_2023_05_03_10 leopard 166 462 rest_state 1683136947.5346687 2023-05-03T18:02:27.534669+00:00 000463_2023-05-03_18-02-37.517.PM~212.png lsl
exp_2023_05_03_10 leopard 166 463 rest_state 1683136947.7523086 2023-05-03T18:02:27.752309+00:00 000464_2023-05-03_18-02-37.719.PM~202.png lsl
exp_2023_05_03_10 leopard 166 464 rest_state 1683136947.9699485 2023-05-03T18:02:27.969949+00:00 000465_2023-05-03_18-02-37.935.PM~216.png lsl
exp_2023_05_03_10 leopard 166 465 rest_state 1683136948.1875885 2023-05-03T18:02:28.187588+00:00 000466_2023-05-03_18-02-38.142.PM~207.png lsl
exp_2023_05_03_10 leopard 166 466 rest_state 1683136948.4052286 2023-05-03T18:02:28.405229+00:00 000467_2023-05-03_18-02-38.355.PM~213.png lsl
exp_2023_05_03_10 leopard 166 467 rest_state 1683136948.6228685 2023-05-03T18:02:28.622869+00:00 000468_2023-05-03_18-02-38.562.PM~207.png lsl
exp_2023_05_03_10 leopard 166 468 rest_state 1683136948.8405085 2023-05-03T18:02:28.840508+00:00 000469_2023-05-03_18-02-38.765.PM~203.png lsl
exp_2023_05_03_10 leopard 166 469 rest_state 1683136949.0581484 2023-05-03T18:02:29.058148+00:00 000470_2023-05-03_18-02-38.975.PM~210.png lsl
exp_2023_05_03_10 leopard 166 470 rest_state 1683136949.2757885 2023-05-03T18:02:29.275789+00:00 000471_2023-05-03_18-02-39.184.PM~209.png lsl
exp_2023_05_03_10 leopard 166 471 rest_state 1683136949.4934285 2023-05-03T18:02:29.493428+00:00 000472_2023-05-03_18-02-39.392.PM~208.png lsl
exp_2023_05_03_10 leopard 166 472 rest_state 1683136949.7110684 2023-05-03T18:02:29.711068+00:00 000473_2023-05-03_18-02-39.600.PM~208.png lsl
exp_2023_05_03_10 leopard 166 473 rest_state 1683136949.9287086 2023-05-03T18:02:29.928709+00:00 000474_2023-05-03_18-02-39.811.PM~211.png lsl
exp_2023_05_03_10 leopard 166 474 rest_state 1683136950.1463485 2023-05-03T18:02:30.146348+00:00 000475_2023-05-03_18-02-40.020.PM~209.png lsl
exp_2023_05_03_10 leopard 166 475 rest_state 1683136950.3639884 2023-05-03T18:02:30.363988+00:00 000476_2023-05-03_18-02-40.230.PM~210.png lsl
exp_2023_05_03_10 leopard 166 476 rest_state 1683136950.5816283 2023-05-03T18:02:30.581628+00:00 000477_2023-05-03_18-02-40.438.PM~208.png lsl
exp_2023_05_03_10 leopard 166 477 rest_state 1683136950.7992685 2023-05-03T18:02:30.799268+00:00 000478_2023-05-03_18-02-40.645.PM~207.png lsl
exp_2023_05_03_10 leopard 166 478 rest_state 1683136951.0169084 2023-05-03T18:02:31.016908+00:00 000479_2023-05-03_18-02-40.850.PM~205.png lsl
exp_2023_05_03_10 leopard 166 479 rest_state 1683136951.2345483 2023-05-03T18:02:31.234548+00:00 000480_2023-05-03_18-02-41.055.PM~205.png lsl
exp_2023_05_03_10 leopard 166 480 rest_state 1683136951.4521883 2023-05-03T18:02:31.452188+00:00 000481_2023-05-03_18-02-41.269.PM~214.png lsl
exp_2023_05_03_10 leopard 166 481 rest_state 1683136951.6698284 2023-05-03T18:02:31.669828+00:00 000482_2023-05-03_18-02-41.472.PM~203.png lsl
exp_2023_05_03_10 leopard 166 482 rest_state 1683136951.8874683 2023-05-03T18:02:31.887468+00:00 000483_2023-05-03_18-02-41.675.PM~203.png lsl
exp_2023_05_03_10 leopard 166 483 rest_state 1683136952.1051083 2023-05-03T18:02:32.105108+00:00 000484_2023-05-03_18-02-41.877.PM~202.png lsl
exp_2023_05_03_10 leopard 166 484 rest_state 1683136952.3227482 2023-05-03T18:02:32.322748+00:00 000485_2023-05-03_18-02-42.084.PM~207.png lsl
exp_2023_05_03_10 leopard 166 485 rest_state 1683136952.5403883 2023-05-03T18:02:32.540388+00:00 000486_2023-05-03_18-02-42.296.PM~212.png lsl
exp_2023_05_03_10 leopard 166 486 rest_state 1683136952.7580283 2023-05-03T18:02:32.758028+00:00 000487_2023-05-03_18-02-42.506.PM~210.png lsl
exp_2023_05_03_10 leopard 166 487 rest_state 1683136952.9756682 2023-05-03T18:02:32.975668+00:00 000488_2023-05-03_18-02-42.719.PM~213.png lsl
exp_2023_05_03_10 leopard 166 488 rest_state 1683136953.193308 2023-05-03T18:02:33.193308+00:00 000489_2023-05-03_18-02-42.923.PM~204.png lsl
exp_2023_05_03_10 leopard 166 489 rest_state 1683136953.4109483 2023-05-03T18:02:33.410948+00:00 000490_2023-05-03_18-02-43.134.PM~211.png lsl
exp_2023_05_03_10 leopard 166 490 rest_state 1683136953.6285882 2023-05-03T18:02:33.628588+00:00 000491_2023-05-03_18-02-43.339.PM~205.png lsl
exp_2023_05_03_10 leopard 166 491 rest_state 1683136953.8462281 2023-05-03T18:02:33.846228+00:00 000492_2023-05-03_18-02-43.552.PM~213.png lsl
exp_2023_05_03_10 leopard 166 492 rest_state 1683136954.0638683 2023-05-03T18:02:34.063868+00:00 000493_2023-05-03_18-02-43.758.PM~206.png lsl
exp_2023_05_03_10 leopard 166 493 rest_state 1683136954.2815082 2023-05-03T18:02:34.281508+00:00 000494_2023-05-03_18-02-43.967.PM~209.png lsl
exp_2023_05_03_10 leopard 166 494 rest_state 1683136954.4991481 2023-05-03T18:02:34.499148+00:00 000495_2023-05-03_18-02-44.173.PM~206.png lsl
exp_2023_05_03_10 leopard 166 495 rest_state 1683136954.716788 2023-05-03T18:02:34.716788+00:00 000496_2023-05-03_18-02-44.379.PM~206.png lsl
exp_2023_05_03_10 leopard 166 496 rest_state 1683136954.9344282 2023-05-03T18:02:34.934428+00:00 000497_2023-05-03_18-02-44.586.PM~207.png lsl
exp_2023_05_03_10 leopard 166 497 rest_state 1683136955.1520681 2023-05-03T18:02:35.152068+00:00 000498_2023-05-03_18-02-44.798.PM~212.png lsl
exp_2023_05_03_10 leopard 166 498 rest_state 1683136955.369708 2023-05-03T18:02:35.369708+00:00 000499_2023-05-03_18-02-45.006.PM~208.png lsl
exp_2023_05_03_10 leopard 166 499 rest_state 1683136955.587348 2023-05-03T18:02:35.587348+00:00 000500_2023-05-03_18-02-45.209.PM~203.png lsl
exp_2023_05_03_10 leopard 166 500 rest_state 1683136955.8049881 2023-05-03T18:02:35.804988+00:00 000501_2023-05-03_18-02-45.413.PM~204.png lsl
exp_2023_05_03_10 leopard 166 501 rest_state 1683136956.022628 2023-05-03T18:02:36.022628+00:00 000502_2023-05-03_18-02-45.624.PM~211.png lsl
exp_2023_05_03_10 leopard 166 502 rest_state 1683136956.240268 2023-05-03T18:02:36.240268+00:00 000503_2023-05-03_18-02-45.830.PM~206.png lsl
exp_2023_05_03_10 leopard 166 503 rest_state 1683136956.457908 2023-05-03T18:02:36.457908+00:00 000504_2023-05-03_18-02-46.032.PM~202.png lsl
exp_2023_05_03_10 leopard 166 504 rest_state 1683136956.675548 2023-05-03T18:02:36.675548+00:00 000505_2023-05-03_18-02-46.240.PM~208.png lsl
exp_2023_05_03_10 leopard 166 505 rest_state 1683136956.893188 2023-05-03T18:02:36.893188+00:00 000506_2023-05-03_18-02-46.445.PM~205.png lsl
exp_2023_05_03_10 leopard 166 506 rest_state 1683136957.110828 2023-05-03T18:02:37.110828+00:00 000507_2023-05-03_18-02-46.649.PM~204.png lsl
exp_2023_05_03_10 leopard 166 507 rest_state 1683136957.328468 2023-05-03T18:02:37.328468+00:00 000508_2023-05-03_18-02-46.862.PM~213.png lsl
exp_2023_05_03_10 leopard 166 508 rest_state 1683136957.546108 2023-05-03T18:02:37.546108+00:00 000509_2023-05-03_18-02-47.073.PM~211.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]);