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 participant = 140

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_04_17_13 leopard 140 465 rest_state 1681766683.7971568 2023-04-17T21:24:43.797157+00:00 000466_2023-04-17_21-24-55.092.PM~237.png lsl
exp_2023_04_17_13 leopard 140 466 rest_state 1681766684.0294747 2023-04-17T21:24:44.029475+00:00 000467_2023-04-17_21-24-55.323.PM~231.png lsl
exp_2023_04_17_13 leopard 140 467 rest_state 1681766684.2617924 2023-04-17T21:24:44.261792+00:00 000468_2023-04-17_21-24-55.559.PM~236.png lsl
exp_2023_04_17_13 leopard 140 468 rest_state 1681766684.49411 2023-04-17T21:24:44.494110+00:00 000469_2023-04-17_21-24-55.790.PM~231.png lsl
exp_2023_04_17_13 leopard 140 469 rest_state 1681766684.7264278 2023-04-17T21:24:44.726428+00:00 000470_2023-04-17_21-24-56.008.PM~218.png lsl
exp_2023_04_17_13 leopard 140 470 rest_state 1681766684.9587455 2023-04-17T21:24:44.958745+00:00 000471_2023-04-17_21-24-56.230.PM~222.png lsl
exp_2023_04_17_13 leopard 140 471 rest_state 1681766685.1910634 2023-04-17T21:24:45.191063+00:00 000472_2023-04-17_21-24-56.448.PM~218.png lsl
exp_2023_04_17_13 leopard 140 472 rest_state 1681766685.423381 2023-04-17T21:24:45.423381+00:00 000473_2023-04-17_21-24-56.671.PM~223.png lsl
exp_2023_04_17_13 leopard 140 473 rest_state 1681766685.6556988 2023-04-17T21:24:45.655699+00:00 000474_2023-04-17_21-24-56.909.PM~238.png lsl
exp_2023_04_17_13 leopard 140 474 rest_state 1681766685.8880165 2023-04-17T21:24:45.888016+00:00 000475_2023-04-17_21-24-57.136.PM~227.png lsl
exp_2023_04_17_13 leopard 140 475 rest_state 1681766686.1203341 2023-04-17T21:24:46.120334+00:00 000476_2023-04-17_21-24-57.358.PM~222.png lsl
exp_2023_04_17_13 leopard 140 476 rest_state 1681766686.352652 2023-04-17T21:24:46.352652+00:00 000477_2023-04-17_21-24-57.586.PM~228.png lsl
exp_2023_04_17_13 leopard 140 477 rest_state 1681766686.5849698 2023-04-17T21:24:46.584970+00:00 000478_2023-04-17_21-24-57.810.PM~224.png lsl
exp_2023_04_17_13 leopard 140 478 rest_state 1681766686.8172874 2023-04-17T21:24:46.817287+00:00 000479_2023-04-17_21-24-58.045.PM~235.png lsl
exp_2023_04_17_13 leopard 140 479 rest_state 1681766687.0496051 2023-04-17T21:24:47.049605+00:00 000480_2023-04-17_21-24-58.286.PM~241.png lsl
exp_2023_04_17_13 leopard 140 480 rest_state 1681766687.2819228 2023-04-17T21:24:47.281923+00:00 000481_2023-04-17_21-24-58.516.PM~230.png lsl
exp_2023_04_17_13 leopard 140 481 rest_state 1681766687.5142405 2023-04-17T21:24:47.514241+00:00 000482_2023-04-17_21-24-58.742.PM~226.png lsl
exp_2023_04_17_13 leopard 140 482 rest_state 1681766687.7465584 2023-04-17T21:24:47.746558+00:00 000483_2023-04-17_21-24-58.970.PM~228.png lsl
exp_2023_04_17_13 leopard 140 483 rest_state 1681766687.978876 2023-04-17T21:24:47.978876+00:00 000484_2023-04-17_21-24-59.199.PM~229.png lsl
exp_2023_04_17_13 leopard 140 484 rest_state 1681766688.2111938 2023-04-17T21:24:48.211194+00:00 000485_2023-04-17_21-24-59.432.PM~233.png lsl
exp_2023_04_17_13 leopard 140 485 rest_state 1681766688.4435115 2023-04-17T21:24:48.443511+00:00 000486_2023-04-17_21-24-59.657.PM~225.png lsl
exp_2023_04_17_13 leopard 140 486 rest_state 1681766688.6758292 2023-04-17T21:24:48.675829+00:00 000487_2023-04-17_21-24-59.884.PM~227.png lsl
exp_2023_04_17_13 leopard 140 487 rest_state 1681766688.908147 2023-04-17T21:24:48.908147+00:00 000488_2023-04-17_21-25-00.110.PM~226.png lsl
exp_2023_04_17_13 leopard 140 488 rest_state 1681766689.1404648 2023-04-17T21:24:49.140465+00:00 000489_2023-04-17_21-25-00.333.PM~223.png lsl
exp_2023_04_17_13 leopard 140 489 rest_state 1681766689.3727825 2023-04-17T21:24:49.372782+00:00 000490_2023-04-17_21-25-00.577.PM~244.png lsl
exp_2023_04_17_13 leopard 140 490 rest_state 1681766689.6051002 2023-04-17T21:24:49.605100+00:00 000491_2023-04-17_21-25-00.796.PM~219.png lsl
exp_2023_04_17_13 leopard 140 491 rest_state 1681766689.8374178 2023-04-17T21:24:49.837418+00:00 000492_2023-04-17_21-25-01.025.PM~229.png lsl
exp_2023_04_17_13 leopard 140 492 rest_state 1681766690.0697358 2023-04-17T21:24:50.069736+00:00 000493_2023-04-17_21-25-01.252.PM~227.png lsl
exp_2023_04_17_13 leopard 140 493 rest_state 1681766690.3020535 2023-04-17T21:24:50.302053+00:00 000494_2023-04-17_21-25-01.481.PM~229.png lsl
exp_2023_04_17_13 leopard 140 494 rest_state 1681766690.5343711 2023-04-17T21:24:50.534371+00:00 000495_2023-04-17_21-25-01.723.PM~242.png lsl
exp_2023_04_17_13 leopard 140 495 rest_state 1681766690.7666888 2023-04-17T21:24:50.766689+00:00 000496_2023-04-17_21-25-01.968.PM~245.png lsl
exp_2023_04_17_13 leopard 140 496 rest_state 1681766690.9990065 2023-04-17T21:24:50.999007+00:00 000497_2023-04-17_21-25-02.211.PM~243.png lsl
exp_2023_04_17_13 leopard 140 497 rest_state 1681766691.2313242 2023-04-17T21:24:51.231324+00:00 000498_2023-04-17_21-25-02.447.PM~236.png lsl
exp_2023_04_17_13 leopard 140 498 rest_state 1681766691.4636421 2023-04-17T21:24:51.463642+00:00 000499_2023-04-17_21-25-02.680.PM~233.png lsl
exp_2023_04_17_13 leopard 140 499 rest_state 1681766691.6959598 2023-04-17T21:24:51.695960+00:00 000500_2023-04-17_21-25-02.907.PM~227.png lsl
exp_2023_04_17_13 leopard 140 500 rest_state 1681766691.9282775 2023-04-17T21:24:51.928277+00:00 000501_2023-04-17_21-25-03.134.PM~227.png lsl
exp_2023_04_17_13 leopard 140 501 rest_state 1681766692.1605952 2023-04-17T21:24:52.160595+00:00 000502_2023-04-17_21-25-03.378.PM~244.png lsl
exp_2023_04_17_13 leopard 140 502 rest_state 1681766692.3929129 2023-04-17T21:24:52.392913+00:00 000503_2023-04-17_21-25-03.609.PM~231.png lsl
exp_2023_04_17_13 leopard 140 503 rest_state 1681766692.6252308 2023-04-17T21:24:52.625231+00:00 000504_2023-04-17_21-25-03.850.PM~241.png lsl
exp_2023_04_17_13 leopard 140 504 rest_state 1681766692.8575485 2023-04-17T21:24:52.857548+00:00 000505_2023-04-17_21-25-04.081.PM~231.png lsl
exp_2023_04_17_13 leopard 140 505 rest_state 1681766693.0898662 2023-04-17T21:24:53.089866+00:00 000506_2023-04-17_21-25-04.333.PM~252.png lsl
exp_2023_04_17_13 leopard 140 506 rest_state 1681766693.3221838 2023-04-17T21:24:53.322184+00:00 000507_2023-04-17_21-25-04.562.PM~229.png lsl
exp_2023_04_17_13 leopard 140 507 rest_state 1681766693.5545015 2023-04-17T21:24:53.554502+00:00 000508_2023-04-17_21-25-04.789.PM~227.png lsl
exp_2023_04_17_13 leopard 140 508 rest_state 1681766693.7868195 2023-04-17T21:24:53.786819+00:00 000509_2023-04-17_21-25-05.015.PM~226.png lsl
exp_2023_04_17_13 leopard 140 509 rest_state 1681766694.0191371 2023-04-17T21:24:54.019137+00:00 000510_2023-04-17_21-25-05.240.PM~225.png lsl
exp_2023_04_17_13 leopard 140 510 rest_state 1681766694.2514548 2023-04-17T21:24:54.251455+00:00 000511_2023-04-17_21-25-05.467.PM~227.png lsl
exp_2023_04_17_13 leopard 140 511 rest_state 1681766694.4837725 2023-04-17T21:24:54.483773+00:00 000512_2023-04-17_21-25-05.695.PM~228.png lsl
exp_2023_04_17_13 leopard 140 512 rest_state 1681766694.7160902 2023-04-17T21:24:54.716090+00:00 000513_2023-04-17_21-25-05.920.PM~225.png lsl
exp_2023_04_17_13 leopard 140 513 rest_state 1681766694.948408 2023-04-17T21:24:54.948408+00:00 000514_2023-04-17_21-25-06.151.PM~231.png lsl
exp_2023_04_17_13 leopard 140 514 rest_state 1681766695.1807258 2023-04-17T21:24:55.180726+00:00 000515_2023-04-17_21-25-06.377.PM~226.png lsl
exp_2023_04_17_13 leopard 140 515 rest_state 1681766695.4130435 2023-04-17T21:24:55.413043+00:00 000516_2023-04-17_21-25-06.613.PM~236.png lsl
exp_2023_04_17_13 leopard 140 516 rest_state 1681766695.6453612 2023-04-17T21:24:55.645361+00:00 000517_2023-04-17_21-25-06.853.PM~240.png lsl
exp_2023_04_17_13 leopard 140 517 rest_state 1681766695.8776789 2023-04-17T21:24:55.877679+00:00 000518_2023-04-17_21-25-07.085.PM~232.png lsl
exp_2023_04_17_13 leopard 140 518 rest_state 1681766696.1099966 2023-04-17T21:24:56.109997+00:00 000519_2023-04-17_21-25-07.318.PM~233.png lsl
exp_2023_04_17_13 leopard 140 519 rest_state 1681766696.3423145 2023-04-17T21:24:56.342314+00:00 000520_2023-04-17_21-25-07.541.PM~223.png lsl
exp_2023_04_17_13 leopard 140 520 rest_state 1681766696.5746322 2023-04-17T21:24:56.574632+00:00 000521_2023-04-17_21-25-07.762.PM~221.png lsl
exp_2023_04_17_13 leopard 140 521 rest_state 1681766696.8069499 2023-04-17T21:24:56.806950+00:00 000522_2023-04-17_21-25-07.987.PM~225.png lsl
exp_2023_04_17_13 leopard 140 522 rest_state 1681766697.0392675 2023-04-17T21:24:57.039268+00:00 000523_2023-04-17_21-25-08.208.PM~221.png lsl
exp_2023_04_17_13 leopard 140 523 rest_state 1681766697.2715852 2023-04-17T21:24:57.271585+00:00 000524_2023-04-17_21-25-08.433.PM~225.png lsl
exp_2023_04_17_13 leopard 140 524 rest_state 1681766697.5039032 2023-04-17T21:24:57.503903+00:00 000525_2023-04-17_21-25-08.663.PM~230.png lsl
exp_2023_04_17_13 leopard 140 525 rest_state 1681766697.7362208 2023-04-17T21:24:57.736221+00:00 000526_2023-04-17_21-25-08.896.PM~233.png lsl
exp_2023_04_17_13 leopard 140 526 rest_state 1681766697.9685385 2023-04-17T21:24:57.968539+00:00 000527_2023-04-17_21-25-09.129.PM~233.png lsl
exp_2023_04_17_13 leopard 140 527 rest_state 1681766698.2008562 2023-04-17T21:24:58.200856+00:00 000528_2023-04-17_21-25-09.365.PM~236.png lsl
exp_2023_04_17_13 leopard 140 528 rest_state 1681766698.433174 2023-04-17T21:24:58.433174+00:00 000529_2023-04-17_21-25-09.589.PM~224.png lsl
exp_2023_04_17_13 leopard 140 529 rest_state 1681766698.6654918 2023-04-17T21:24:58.665492+00:00 000530_2023-04-17_21-25-09.819.PM~230.png lsl
exp_2023_04_17_13 leopard 140 530 rest_state 1681766698.8978095 2023-04-17T21:24:58.897810+00:00 000531_2023-04-17_21-25-10.063.PM~244.png lsl
exp_2023_04_17_13 leopard 140 531 rest_state 1681766699.1301272 2023-04-17T21:24:59.130127+00:00 000532_2023-04-17_21-25-10.299.PM~236.png lsl
exp_2023_04_17_13 leopard 140 532 rest_state 1681766699.3624449 2023-04-17T21:24:59.362445+00:00 000533_2023-04-17_21-25-10.532.PM~233.png lsl
exp_2023_04_17_13 leopard 140 533 rest_state 1681766699.5947626 2023-04-17T21:24:59.594763+00:00 000534_2023-04-17_21-25-10.758.PM~226.png lsl
exp_2023_04_17_13 leopard 140 534 rest_state 1681766699.8270802 2023-04-17T21:24:59.827080+00:00 000535_2023-04-17_21-25-11.015.PM~257.png lsl
exp_2023_04_17_13 leopard 140 535 rest_state 1681766700.0593982 2023-04-17T21:25:00.059398+00:00 000536_2023-04-17_21-25-11.268.PM~253.png lsl
exp_2023_04_17_13 leopard 140 536 rest_state 1681766700.2917159 2023-04-17T21:25:00.291716+00:00 000537_2023-04-17_21-25-11.522.PM~254.png lsl
exp_2023_04_17_13 leopard 140 537 rest_state 1681766700.5240335 2023-04-17T21:25:00.524034+00:00 000538_2023-04-17_21-25-11.759.PM~237.png lsl
exp_2023_04_17_13 leopard 140 538 rest_state 1681766700.7563512 2023-04-17T21:25:00.756351+00:00 000539_2023-04-17_21-25-12.000.PM~241.png lsl
exp_2023_04_17_13 leopard 140 539 rest_state 1681766700.988669 2023-04-17T21:25:00.988669+00:00 000540_2023-04-17_21-25-12.255.PM~255.png lsl
exp_2023_04_17_13 leopard 140 540 rest_state 1681766701.2209868 2023-04-17T21:25:01.220987+00:00 000541_2023-04-17_21-25-12.505.PM~250.png lsl
exp_2023_04_17_13 leopard 140 541 rest_state 1681766701.4533045 2023-04-17T21:25:01.453305+00:00 000542_2023-04-17_21-25-12.738.PM~233.png lsl
exp_2023_04_17_13 leopard 140 542 rest_state 1681766701.6856222 2023-04-17T21:25:01.685622+00:00 000543_2023-04-17_21-25-12.972.PM~234.png lsl
exp_2023_04_17_13 leopard 140 543 rest_state 1681766701.91794 2023-04-17T21:25:01.917940+00:00 000544_2023-04-17_21-25-13.205.PM~233.png lsl
exp_2023_04_17_13 leopard 140 544 rest_state 1681766702.1502576 2023-04-17T21:25:02.150258+00:00 000545_2023-04-17_21-25-13.442.PM~237.png lsl
exp_2023_04_17_13 leopard 140 545 rest_state 1681766702.3825755 2023-04-17T21:25:02.382576+00:00 000546_2023-04-17_21-25-13.678.PM~236.png lsl
exp_2023_04_17_13 leopard 140 546 rest_state 1681766702.6148932 2023-04-17T21:25:02.614893+00:00 000547_2023-04-17_21-25-13.914.PM~236.png lsl
exp_2023_04_17_13 leopard 140 547 rest_state 1681766702.847211 2023-04-17T21:25:02.847211+00:00 000548_2023-04-17_21-25-14.145.PM~231.png lsl
exp_2023_04_17_13 leopard 140 548 rest_state 1681766703.0795286 2023-04-17T21:25:03.079529+00:00 000549_2023-04-17_21-25-14.395.PM~250.png lsl
exp_2023_04_17_13 leopard 140 549 rest_state 1681766703.3118463 2023-04-17T21:25:03.311846+00:00 000550_2023-04-17_21-25-14.615.PM~220.png lsl
exp_2023_04_17_13 leopard 140 550 rest_state 1681766703.544164 2023-04-17T21:25:03.544164+00:00 000551_2023-04-17_21-25-14.848.PM~233.png lsl
exp_2023_04_17_13 leopard 140 551 rest_state 1681766703.7764819 2023-04-17T21:25:03.776482+00:00 000552_2023-04-17_21-25-15.080.PM~232.png lsl
exp_2023_04_17_13 leopard 140 552 rest_state 1681766704.0087996 2023-04-17T21:25:04.008800+00:00 000553_2023-04-17_21-25-15.301.PM~221.png lsl
exp_2023_04_17_13 leopard 140 553 rest_state 1681766704.2411172 2023-04-17T21:25:04.241117+00:00 000554_2023-04-17_21-25-15.545.PM~244.png lsl
exp_2023_04_17_13 leopard 140 554 rest_state 1681766704.473435 2023-04-17T21:25:04.473435+00:00 000555_2023-04-17_21-25-15.769.PM~224.png lsl
exp_2023_04_17_13 leopard 140 555 rest_state 1681766704.7057526 2023-04-17T21:25:04.705753+00:00 000556_2023-04-17_21-25-15.998.PM~229.png lsl
exp_2023_04_17_13 leopard 140 556 rest_state 1681766704.9380705 2023-04-17T21:25:04.938071+00:00 000557_2023-04-17_21-25-16.230.PM~232.png lsl
exp_2023_04_17_13 leopard 140 557 rest_state 1681766705.1703882 2023-04-17T21:25:05.170388+00:00 000558_2023-04-17_21-25-16.461.PM~231.png lsl
exp_2023_04_17_13 leopard 140 558 rest_state 1681766705.402706 2023-04-17T21:25:05.402706+00:00 000559_2023-04-17_21-25-16.684.PM~223.png lsl
exp_2023_04_17_13 leopard 140 559 rest_state 1681766705.6350236 2023-04-17T21:25:05.635024+00:00 000560_2023-04-17_21-25-16.908.PM~224.png lsl
exp_2023_04_17_13 leopard 140 560 rest_state 1681766705.8673413 2023-04-17T21:25:05.867341+00:00 000561_2023-04-17_21-25-17.132.PM~224.png lsl
exp_2023_04_17_13 leopard 140 561 rest_state 1681766706.0996592 2023-04-17T21:25:06.099659+00:00 000562_2023-04-17_21-25-17.369.PM~237.png lsl
exp_2023_04_17_13 leopard 140 562 rest_state 1681766706.331977 2023-04-17T21:25:06.331977+00:00 000563_2023-04-17_21-25-17.609.PM~240.png lsl
exp_2023_04_17_13 leopard 140 563 rest_state 1681766706.5642946 2023-04-17T21:25:06.564295+00:00 000564_2023-04-17_21-25-17.835.PM~226.png lsl
exp_2023_04_17_13 leopard 140 564 rest_state 1681766706.7966123 2023-04-17T21:25:06.796612+00:00 000565_2023-04-17_21-25-18.067.PM~232.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]);