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

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_05_01_13 leopard 163 505 rest_state 1682975400.4892766 2023-05-01T21:10:00.489277+00:00 000506_2023-05-01_21-10-11.397.PM~210.png lsl
exp_2023_05_01_13 leopard 163 506 rest_state 1682975400.7128036 2023-05-01T21:10:00.712804+00:00 000507_2023-05-01_21-10-11.605.PM~208.png lsl
exp_2023_05_01_13 leopard 163 507 rest_state 1682975400.9363303 2023-05-01T21:10:00.936330+00:00 000508_2023-05-01_21-10-11.810.PM~205.png lsl
exp_2023_05_01_13 leopard 163 508 rest_state 1682975401.1598573 2023-05-01T21:10:01.159857+00:00 000509_2023-05-01_21-10-12.024.PM~214.png lsl
exp_2023_05_01_13 leopard 163 509 rest_state 1682975401.3833842 2023-05-01T21:10:01.383384+00:00 000510_2023-05-01_21-10-12.230.PM~206.png lsl
exp_2023_05_01_13 leopard 163 510 rest_state 1682975401.6069112 2023-05-01T21:10:01.606911+00:00 000511_2023-05-01_21-10-12.437.PM~207.png lsl
exp_2023_05_01_13 leopard 163 511 rest_state 1682975401.8304381 2023-05-01T21:10:01.830438+00:00 000512_2023-05-01_21-10-12.651.PM~214.png lsl
exp_2023_05_01_13 leopard 163 512 rest_state 1682975402.053965 2023-05-01T21:10:02.053965+00:00 000513_2023-05-01_21-10-12.862.PM~211.png lsl
exp_2023_05_01_13 leopard 163 513 rest_state 1682975402.277492 2023-05-01T21:10:02.277492+00:00 000514_2023-05-01_21-10-13.065.PM~203.png lsl
exp_2023_05_01_13 leopard 163 514 rest_state 1682975402.501019 2023-05-01T21:10:02.501019+00:00 000515_2023-05-01_21-10-13.274.PM~209.png lsl
exp_2023_05_01_13 leopard 163 515 rest_state 1682975402.724546 2023-05-01T21:10:02.724546+00:00 000516_2023-05-01_21-10-13.483.PM~209.png lsl
exp_2023_05_01_13 leopard 163 516 rest_state 1682975402.948073 2023-05-01T21:10:02.948073+00:00 000517_2023-05-01_21-10-13.691.PM~208.png lsl
exp_2023_05_01_13 leopard 163 517 rest_state 1682975403.1715999 2023-05-01T21:10:03.171600+00:00 000518_2023-05-01_21-10-13.905.PM~214.png lsl
exp_2023_05_01_13 leopard 163 518 rest_state 1682975403.3951268 2023-05-01T21:10:03.395127+00:00 000519_2023-05-01_21-10-14.126.PM~221.png lsl
exp_2023_05_01_13 leopard 163 519 rest_state 1682975403.6186538 2023-05-01T21:10:03.618654+00:00 000520_2023-05-01_21-10-14.340.PM~214.png lsl
exp_2023_05_01_13 leopard 163 520 rest_state 1682975403.8421807 2023-05-01T21:10:03.842181+00:00 000521_2023-05-01_21-10-14.545.PM~205.png lsl
exp_2023_05_01_13 leopard 163 521 rest_state 1682975404.0657077 2023-05-01T21:10:04.065708+00:00 000522_2023-05-01_21-10-14.749.PM~204.png lsl
exp_2023_05_01_13 leopard 163 522 rest_state 1682975404.2892346 2023-05-01T21:10:04.289235+00:00 000523_2023-05-01_21-10-14.956.PM~207.png lsl
exp_2023_05_01_13 leopard 163 523 rest_state 1682975404.5127616 2023-05-01T21:10:04.512762+00:00 000524_2023-05-01_21-10-15.176.PM~220.png lsl
exp_2023_05_01_13 leopard 163 524 rest_state 1682975404.7362885 2023-05-01T21:10:04.736289+00:00 000525_2023-05-01_21-10-15.396.PM~220.png lsl
exp_2023_05_01_13 leopard 163 525 rest_state 1682975404.9598155 2023-05-01T21:10:04.959816+00:00 000526_2023-05-01_21-10-15.607.PM~211.png lsl
exp_2023_05_01_13 leopard 163 526 rest_state 1682975405.1833425 2023-05-01T21:10:05.183342+00:00 000527_2023-05-01_21-10-15.855.PM~248.png lsl
exp_2023_05_01_13 leopard 163 527 rest_state 1682975405.4068694 2023-05-01T21:10:05.406869+00:00 000528_2023-05-01_21-10-16.070.PM~215.png lsl
exp_2023_05_01_13 leopard 163 528 rest_state 1682975405.6303964 2023-05-01T21:10:05.630396+00:00 000529_2023-05-01_21-10-16.278.PM~208.png lsl
exp_2023_05_01_13 leopard 163 529 rest_state 1682975405.8539233 2023-05-01T21:10:05.853923+00:00 000530_2023-05-01_21-10-16.503.PM~225.png lsl
exp_2023_05_01_13 leopard 163 530 rest_state 1682975406.0774503 2023-05-01T21:10:06.077450+00:00 000531_2023-05-01_21-10-16.706.PM~203.png lsl
exp_2023_05_01_13 leopard 163 531 rest_state 1682975406.300977 2023-05-01T21:10:06.300977+00:00 000532_2023-05-01_21-10-16.935.PM~229.png lsl
exp_2023_05_01_13 leopard 163 532 rest_state 1682975406.524504 2023-05-01T21:10:06.524504+00:00 000533_2023-05-01_21-10-17.149.PM~214.png lsl
exp_2023_05_01_13 leopard 163 533 rest_state 1682975406.748031 2023-05-01T21:10:06.748031+00:00 000534_2023-05-01_21-10-17.371.PM~222.png lsl
exp_2023_05_01_13 leopard 163 534 rest_state 1682975406.9715579 2023-05-01T21:10:06.971558+00:00 000535_2023-05-01_21-10-17.581.PM~210.png lsl
exp_2023_05_01_13 leopard 163 535 rest_state 1682975407.1950848 2023-05-01T21:10:07.195085+00:00 000536_2023-05-01_21-10-17.796.PM~215.png lsl
exp_2023_05_01_13 leopard 163 536 rest_state 1682975407.4186118 2023-05-01T21:10:07.418612+00:00 000537_2023-05-01_21-10-18.008.PM~212.png lsl
exp_2023_05_01_13 leopard 163 537 rest_state 1682975407.6421387 2023-05-01T21:10:07.642139+00:00 000538_2023-05-01_21-10-18.225.PM~217.png lsl
exp_2023_05_01_13 leopard 163 538 rest_state 1682975407.8656657 2023-05-01T21:10:07.865666+00:00 000539_2023-05-01_21-10-18.437.PM~212.png lsl
exp_2023_05_01_13 leopard 163 539 rest_state 1682975408.0891926 2023-05-01T21:10:08.089193+00:00 000540_2023-05-01_21-10-18.650.PM~213.png lsl
exp_2023_05_01_13 leopard 163 540 rest_state 1682975408.3127196 2023-05-01T21:10:08.312720+00:00 000541_2023-05-01_21-10-18.865.PM~215.png lsl
exp_2023_05_01_13 leopard 163 541 rest_state 1682975408.5362465 2023-05-01T21:10:08.536247+00:00 000542_2023-05-01_21-10-19.072.PM~207.png lsl
exp_2023_05_01_13 leopard 163 542 rest_state 1682975408.7597735 2023-05-01T21:10:08.759773+00:00 000543_2023-05-01_21-10-19.287.PM~215.png lsl
exp_2023_05_01_13 leopard 163 543 rest_state 1682975408.9833004 2023-05-01T21:10:08.983300+00:00 000544_2023-05-01_21-10-19.500.PM~213.png lsl
exp_2023_05_01_13 leopard 163 544 rest_state 1682975409.2068274 2023-05-01T21:10:09.206827+00:00 000545_2023-05-01_21-10-19.711.PM~211.png lsl
exp_2023_05_01_13 leopard 163 545 rest_state 1682975409.4303544 2023-05-01T21:10:09.430354+00:00 000546_2023-05-01_21-10-19.930.PM~219.png lsl
exp_2023_05_01_13 leopard 163 546 rest_state 1682975409.6538813 2023-05-01T21:10:09.653881+00:00 000547_2023-05-01_21-10-20.147.PM~217.png lsl
exp_2023_05_01_13 leopard 163 547 rest_state 1682975409.8774083 2023-05-01T21:10:09.877408+00:00 000548_2023-05-01_21-10-20.359.PM~212.png lsl
exp_2023_05_01_13 leopard 163 548 rest_state 1682975410.1009352 2023-05-01T21:10:10.100935+00:00 000549_2023-05-01_21-10-20.580.PM~221.png lsl
exp_2023_05_01_13 leopard 163 549 rest_state 1682975410.3244622 2023-05-01T21:10:10.324462+00:00 000550_2023-05-01_21-10-20.783.PM~203.png lsl
exp_2023_05_01_13 leopard 163 550 rest_state 1682975410.5479891 2023-05-01T21:10:10.547989+00:00 000551_2023-05-01_21-10-20.989.PM~206.png lsl
exp_2023_05_01_13 leopard 163 551 rest_state 1682975410.771516 2023-05-01T21:10:10.771516+00:00 000552_2023-05-01_21-10-21.203.PM~214.png lsl
exp_2023_05_01_13 leopard 163 552 rest_state 1682975410.995043 2023-05-01T21:10:10.995043+00:00 000553_2023-05-01_21-10-21.423.PM~220.png lsl
exp_2023_05_01_13 leopard 163 553 rest_state 1682975411.21857 2023-05-01T21:10:11.218570+00:00 000554_2023-05-01_21-10-21.640.PM~217.png lsl
exp_2023_05_01_13 leopard 163 554 rest_state 1682975411.4420967 2023-05-01T21:10:11.442097+00:00 000555_2023-05-01_21-10-21.850.PM~210.png lsl
exp_2023_05_01_13 leopard 163 555 rest_state 1682975411.6656237 2023-05-01T21:10:11.665624+00:00 000556_2023-05-01_21-10-22.067.PM~217.png lsl
exp_2023_05_01_13 leopard 163 556 rest_state 1682975411.8891506 2023-05-01T21:10:11.889151+00:00 000557_2023-05-01_21-10-22.278.PM~211.png lsl
exp_2023_05_01_13 leopard 163 557 rest_state 1682975412.1126776 2023-05-01T21:10:12.112678+00:00 000558_2023-05-01_21-10-22.488.PM~210.png lsl
exp_2023_05_01_13 leopard 163 558 rest_state 1682975412.3362045 2023-05-01T21:10:12.336205+00:00 000559_2023-05-01_21-10-22.709.PM~221.png lsl
exp_2023_05_01_13 leopard 163 559 rest_state 1682975412.5597315 2023-05-01T21:10:12.559731+00:00 000560_2023-05-01_21-10-22.926.PM~217.png lsl
exp_2023_05_01_13 leopard 163 560 rest_state 1682975412.7832584 2023-05-01T21:10:12.783258+00:00 000561_2023-05-01_21-10-23.142.PM~216.png lsl
exp_2023_05_01_13 leopard 163 561 rest_state 1682975413.0067854 2023-05-01T21:10:13.006785+00:00 000562_2023-05-01_21-10-23.370.PM~228.png lsl
exp_2023_05_01_13 leopard 163 562 rest_state 1682975413.2303123 2023-05-01T21:10:13.230312+00:00 000563_2023-05-01_21-10-23.594.PM~224.png lsl
exp_2023_05_01_13 leopard 163 563 rest_state 1682975413.4538393 2023-05-01T21:10:13.453839+00:00 000564_2023-05-01_21-10-23.806.PM~212.png lsl
exp_2023_05_01_13 leopard 163 564 rest_state 1682975413.6773663 2023-05-01T21:10:13.677366+00:00 000565_2023-05-01_21-10-24.028.PM~222.png lsl
exp_2023_05_01_13 leopard 163 565 rest_state 1682975413.9008932 2023-05-01T21:10:13.900893+00:00 000566_2023-05-01_21-10-24.249.PM~221.png lsl
exp_2023_05_01_13 leopard 163 566 rest_state 1682975414.1244202 2023-05-01T21:10:14.124420+00:00 000567_2023-05-01_21-10-24.462.PM~213.png lsl
exp_2023_05_01_13 leopard 163 567 rest_state 1682975414.3479471 2023-05-01T21:10:14.347947+00:00 000568_2023-05-01_21-10-24.673.PM~211.png lsl
exp_2023_05_01_13 leopard 163 568 rest_state 1682975414.571474 2023-05-01T21:10:14.571474+00:00 000569_2023-05-01_21-10-24.884.PM~211.png lsl
exp_2023_05_01_13 leopard 163 569 rest_state 1682975414.795001 2023-05-01T21:10:14.795001+00:00 000570_2023-05-01_21-10-25.094.PM~210.png lsl
exp_2023_05_01_13 leopard 163 570 rest_state 1682975415.018528 2023-05-01T21:10:15.018528+00:00 000571_2023-05-01_21-10-25.313.PM~219.png lsl
exp_2023_05_01_13 leopard 163 571 rest_state 1682975415.242055 2023-05-01T21:10:15.242055+00:00 000572_2023-05-01_21-10-25.518.PM~205.png lsl
exp_2023_05_01_13 leopard 163 572 rest_state 1682975415.465582 2023-05-01T21:10:15.465582+00:00 000573_2023-05-01_21-10-25.763.PM~245.png lsl
exp_2023_05_01_13 leopard 163 573 rest_state 1682975415.6891088 2023-05-01T21:10:15.689109+00:00 000574_2023-05-01_21-10-25.977.PM~214.png lsl
exp_2023_05_01_13 leopard 163 574 rest_state 1682975415.9126358 2023-05-01T21:10:15.912636+00:00 000575_2023-05-01_21-10-26.184.PM~207.png lsl
exp_2023_05_01_13 leopard 163 575 rest_state 1682975416.1361628 2023-05-01T21:10:16.136163+00:00 000576_2023-05-01_21-10-26.398.PM~214.png lsl
exp_2023_05_01_13 leopard 163 576 rest_state 1682975416.3596897 2023-05-01T21:10:16.359690+00:00 000577_2023-05-01_21-10-26.610.PM~212.png lsl
exp_2023_05_01_13 leopard 163 577 rest_state 1682975416.5832167 2023-05-01T21:10:16.583217+00:00 000578_2023-05-01_21-10-26.822.PM~212.png lsl
exp_2023_05_01_13 leopard 163 578 rest_state 1682975416.8067434 2023-05-01T21:10:16.806743+00:00 000579_2023-05-01_21-10-27.027.PM~205.png lsl
exp_2023_05_01_13 leopard 163 579 rest_state 1682975417.0302703 2023-05-01T21:10:17.030270+00:00 000580_2023-05-01_21-10-27.239.PM~212.png lsl
exp_2023_05_01_13 leopard 163 580 rest_state 1682975417.2537973 2023-05-01T21:10:17.253797+00:00 000581_2023-05-01_21-10-27.463.PM~224.png lsl
exp_2023_05_01_13 leopard 163 581 rest_state 1682975417.4773242 2023-05-01T21:10:17.477324+00:00 000582_2023-05-01_21-10-27.685.PM~222.png lsl
exp_2023_05_01_13 leopard 163 582 rest_state 1682975417.7008512 2023-05-01T21:10:17.700851+00:00 000583_2023-05-01_21-10-27.901.PM~216.png lsl
exp_2023_05_01_13 leopard 163 583 rest_state 1682975417.9243782 2023-05-01T21:10:17.924378+00:00 000584_2023-05-01_21-10-28.115.PM~214.png lsl
exp_2023_05_01_13 leopard 163 584 rest_state 1682975418.147905 2023-05-01T21:10:18.147905+00:00 000585_2023-05-01_21-10-28.324.PM~209.png lsl
exp_2023_05_01_13 leopard 163 585 rest_state 1682975418.371432 2023-05-01T21:10:18.371432+00:00 000586_2023-05-01_21-10-28.543.PM~219.png lsl
exp_2023_05_01_13 leopard 163 586 rest_state 1682975418.594959 2023-05-01T21:10:18.594959+00:00 000587_2023-05-01_21-10-28.758.PM~215.png lsl
exp_2023_05_01_13 leopard 163 587 rest_state 1682975418.818486 2023-05-01T21:10:18.818486+00:00 000588_2023-05-01_21-10-28.984.PM~226.png lsl
exp_2023_05_01_13 leopard 163 588 rest_state 1682975419.042013 2023-05-01T21:10:19.042013+00:00 000589_2023-05-01_21-10-29.206.PM~222.png lsl
exp_2023_05_01_13 leopard 163 589 rest_state 1682975419.26554 2023-05-01T21:10:19.265540+00:00 000590_2023-05-01_21-10-29.426.PM~220.png lsl
exp_2023_05_01_13 leopard 163 590 rest_state 1682975419.4890668 2023-05-01T21:10:19.489067+00:00 000591_2023-05-01_21-10-29.649.PM~223.png lsl
exp_2023_05_01_13 leopard 163 591 rest_state 1682975419.7125938 2023-05-01T21:10:19.712594+00:00 000592_2023-05-01_21-10-29.882.PM~233.png lsl
exp_2023_05_01_13 leopard 163 592 rest_state 1682975419.9361207 2023-05-01T21:10:19.936121+00:00 000593_2023-05-01_21-10-30.100.PM~218.png lsl
exp_2023_05_01_13 leopard 163 593 rest_state 1682975420.1596477 2023-05-01T21:10:20.159648+00:00 000594_2023-05-01_21-10-30.313.PM~213.png lsl
exp_2023_05_01_13 leopard 163 594 rest_state 1682975420.3831747 2023-05-01T21:10:20.383175+00:00 000595_2023-05-01_21-10-30.547.PM~234.png lsl
exp_2023_05_01_13 leopard 163 595 rest_state 1682975420.6067016 2023-05-01T21:10:20.606702+00:00 000596_2023-05-01_21-10-30.770.PM~223.png lsl
exp_2023_05_01_13 leopard 163 596 rest_state 1682975420.8302286 2023-05-01T21:10:20.830229+00:00 000597_2023-05-01_21-10-30.996.PM~226.png lsl
exp_2023_05_01_13 leopard 163 597 rest_state 1682975421.0537555 2023-05-01T21:10:21.053756+00:00 000598_2023-05-01_21-10-31.209.PM~213.png lsl
exp_2023_05_01_13 leopard 163 598 rest_state 1682975421.2772825 2023-05-01T21:10:21.277282+00:00 000599_2023-05-01_21-10-31.420.PM~211.png lsl
exp_2023_05_01_13 leopard 163 599 rest_state 1682975421.5008094 2023-05-01T21:10:21.500809+00:00 000600_2023-05-01_21-10-31.649.PM~229.png lsl
exp_2023_05_01_13 leopard 163 600 rest_state 1682975421.7243364 2023-05-01T21:10:21.724336+00:00 000601_2023-05-01_21-10-31.862.PM~213.png lsl
exp_2023_05_01_13 leopard 163 601 rest_state 1682975421.947863 2023-05-01T21:10:21.947863+00:00 000602_2023-05-01_21-10-32.099.PM~237.png lsl
exp_2023_05_01_13 leopard 163 602 rest_state 1682975422.17139 2023-05-01T21:10:22.171390+00:00 000603_2023-05-01_21-10-32.308.PM~209.png lsl
exp_2023_05_01_13 leopard 163 603 rest_state 1682975422.394917 2023-05-01T21:10:22.394917+00:00 000604_2023-05-01_21-10-32.525.PM~217.png lsl
exp_2023_05_01_13 leopard 163 604 rest_state 1682975422.618444 2023-05-01T21:10:22.618444+00:00 000605_2023-05-01_21-10-32.747.PM~222.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]);