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_27_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_27_14 leopard 161 342 rest_state 1682633098.459419 2023-04-27T22:04:58.459419+00:00 000343_2023-04-27_22-05-03.342.PM~223.png lsl
exp_2023_04_27_14 leopard 161 343 rest_state 1682633098.68259 2023-04-27T22:04:58.682590+00:00 000344_2023-04-27_22-05-03.562.PM~220.png lsl
exp_2023_04_27_14 leopard 161 344 rest_state 1682633098.9057612 2023-04-27T22:04:58.905761+00:00 000345_2023-04-27_22-05-03.776.PM~214.png lsl
exp_2023_04_27_14 leopard 161 345 rest_state 1682633099.1289322 2023-04-27T22:04:59.128932+00:00 000346_2023-04-27_22-05-03.990.PM~214.png lsl
exp_2023_04_27_14 leopard 161 346 rest_state 1682633099.3521035 2023-04-27T22:04:59.352103+00:00 000347_2023-04-27_22-05-04.215.PM~225.png lsl
exp_2023_04_27_14 leopard 161 347 rest_state 1682633099.5752745 2023-04-27T22:04:59.575274+00:00 000348_2023-04-27_22-05-04.428.PM~213.png lsl
exp_2023_04_27_14 leopard 161 348 rest_state 1682633099.7984457 2023-04-27T22:04:59.798446+00:00 000349_2023-04-27_22-05-04.645.PM~217.png lsl
exp_2023_04_27_14 leopard 161 349 rest_state 1682633100.021617 2023-04-27T22:05:00.021617+00:00 000350_2023-04-27_22-05-04.862.PM~217.png lsl
exp_2023_04_27_14 leopard 161 350 rest_state 1682633100.244788 2023-04-27T22:05:00.244788+00:00 000351_2023-04-27_22-05-05.089.PM~227.png lsl
exp_2023_04_27_14 leopard 161 351 rest_state 1682633100.4679592 2023-04-27T22:05:00.467959+00:00 000352_2023-04-27_22-05-05.301.PM~212.png lsl
exp_2023_04_27_14 leopard 161 352 rest_state 1682633100.6911302 2023-04-27T22:05:00.691130+00:00 000353_2023-04-27_22-05-05.512.PM~211.png lsl
exp_2023_04_27_14 leopard 161 353 rest_state 1682633100.9143014 2023-04-27T22:05:00.914301+00:00 000354_2023-04-27_22-05-05.739.PM~227.png lsl
exp_2023_04_27_14 leopard 161 354 rest_state 1682633101.1374724 2023-04-27T22:05:01.137472+00:00 000355_2023-04-27_22-05-05.945.PM~206.png lsl
exp_2023_04_27_14 leopard 161 355 rest_state 1682633101.3606436 2023-04-27T22:05:01.360644+00:00 000356_2023-04-27_22-05-06.149.PM~204.png lsl
exp_2023_04_27_14 leopard 161 356 rest_state 1682633101.5838149 2023-04-27T22:05:01.583815+00:00 000357_2023-04-27_22-05-06.357.PM~208.png lsl
exp_2023_04_27_14 leopard 161 357 rest_state 1682633101.8069859 2023-04-27T22:05:01.806986+00:00 000358_2023-04-27_22-05-06.599.PM~242.png lsl
exp_2023_04_27_14 leopard 161 358 rest_state 1682633102.030157 2023-04-27T22:05:02.030157+00:00 000359_2023-04-27_22-05-06.811.PM~212.png lsl
exp_2023_04_27_14 leopard 161 359 rest_state 1682633102.253328 2023-04-27T22:05:02.253328+00:00 000360_2023-04-27_22-05-07.022.PM~211.png lsl
exp_2023_04_27_14 leopard 161 360 rest_state 1682633102.4764993 2023-04-27T22:05:02.476499+00:00 000361_2023-04-27_22-05-07.232.PM~210.png lsl
exp_2023_04_27_14 leopard 161 361 rest_state 1682633102.6996703 2023-04-27T22:05:02.699670+00:00 000362_2023-04-27_22-05-07.441.PM~209.png lsl
exp_2023_04_27_14 leopard 161 362 rest_state 1682633102.9228415 2023-04-27T22:05:02.922842+00:00 000363_2023-04-27_22-05-07.665.PM~224.png lsl
exp_2023_04_27_14 leopard 161 363 rest_state 1682633103.1460125 2023-04-27T22:05:03.146013+00:00 000364_2023-04-27_22-05-07.868.PM~203.png lsl
exp_2023_04_27_14 leopard 161 364 rest_state 1682633103.3691838 2023-04-27T22:05:03.369184+00:00 000365_2023-04-27_22-05-08.080.PM~212.png lsl
exp_2023_04_27_14 leopard 161 365 rest_state 1682633103.592355 2023-04-27T22:05:03.592355+00:00 000366_2023-04-27_22-05-08.285.PM~205.png lsl
exp_2023_04_27_14 leopard 161 366 rest_state 1682633103.815526 2023-04-27T22:05:03.815526+00:00 000367_2023-04-27_22-05-08.511.PM~226.png lsl
exp_2023_04_27_14 leopard 161 367 rest_state 1682633104.0386972 2023-04-27T22:05:04.038697+00:00 000368_2023-04-27_22-05-08.720.PM~209.png lsl
exp_2023_04_27_14 leopard 161 368 rest_state 1682633104.2618682 2023-04-27T22:05:04.261868+00:00 000369_2023-04-27_22-05-08.939.PM~219.png lsl
exp_2023_04_27_14 leopard 161 369 rest_state 1682633104.4850395 2023-04-27T22:05:04.485039+00:00 000370_2023-04-27_22-05-09.157.PM~218.png lsl
exp_2023_04_27_14 leopard 161 370 rest_state 1682633104.7082105 2023-04-27T22:05:04.708210+00:00 000371_2023-04-27_22-05-09.372.PM~215.png lsl
exp_2023_04_27_14 leopard 161 371 rest_state 1682633104.9313817 2023-04-27T22:05:04.931382+00:00 000372_2023-04-27_22-05-09.589.PM~217.png lsl
exp_2023_04_27_14 leopard 161 372 rest_state 1682633105.154553 2023-04-27T22:05:05.154553+00:00 000373_2023-04-27_22-05-09.809.PM~220.png lsl
exp_2023_04_27_14 leopard 161 373 rest_state 1682633105.377724 2023-04-27T22:05:05.377724+00:00 000374_2023-04-27_22-05-10.013.PM~204.png lsl
exp_2023_04_27_14 leopard 161 374 rest_state 1682633105.6008952 2023-04-27T22:05:05.600895+00:00 000375_2023-04-27_22-05-10.219.PM~206.png lsl
exp_2023_04_27_14 leopard 161 375 rest_state 1682633105.8240662 2023-04-27T22:05:05.824066+00:00 000376_2023-04-27_22-05-10.440.PM~221.png lsl
exp_2023_04_27_14 leopard 161 376 rest_state 1682633106.0472374 2023-04-27T22:05:06.047237+00:00 000377_2023-04-27_22-05-10.645.PM~205.png lsl
exp_2023_04_27_14 leopard 161 377 rest_state 1682633106.2704084 2023-04-27T22:05:06.270408+00:00 000378_2023-04-27_22-05-10.862.PM~217.png lsl
exp_2023_04_27_14 leopard 161 378 rest_state 1682633106.4935796 2023-04-27T22:05:06.493580+00:00 000379_2023-04-27_22-05-11.088.PM~226.png lsl
exp_2023_04_27_14 leopard 161 379 rest_state 1682633106.7167509 2023-04-27T22:05:06.716751+00:00 000380_2023-04-27_22-05-11.305.PM~217.png lsl
exp_2023_04_27_14 leopard 161 380 rest_state 1682633106.9399219 2023-04-27T22:05:06.939922+00:00 000381_2023-04-27_22-05-11.514.PM~209.png lsl
exp_2023_04_27_14 leopard 161 381 rest_state 1682633107.163093 2023-04-27T22:05:07.163093+00:00 000382_2023-04-27_22-05-11.727.PM~213.png lsl
exp_2023_04_27_14 leopard 161 382 rest_state 1682633107.386264 2023-04-27T22:05:07.386264+00:00 000383_2023-04-27_22-05-11.949.PM~222.png lsl
exp_2023_04_27_14 leopard 161 383 rest_state 1682633107.6094353 2023-04-27T22:05:07.609435+00:00 000384_2023-04-27_22-05-12.169.PM~220.png lsl
exp_2023_04_27_14 leopard 161 384 rest_state 1682633107.8326063 2023-04-27T22:05:07.832606+00:00 000385_2023-04-27_22-05-12.389.PM~220.png lsl
exp_2023_04_27_14 leopard 161 385 rest_state 1682633108.0557775 2023-04-27T22:05:08.055778+00:00 000386_2023-04-27_22-05-12.597.PM~208.png lsl
exp_2023_04_27_14 leopard 161 386 rest_state 1682633108.2789485 2023-04-27T22:05:08.278949+00:00 000387_2023-04-27_22-05-12.808.PM~211.png lsl
exp_2023_04_27_14 leopard 161 387 rest_state 1682633108.5021198 2023-04-27T22:05:08.502120+00:00 000388_2023-04-27_22-05-13.020.PM~212.png lsl
exp_2023_04_27_14 leopard 161 388 rest_state 1682633108.725291 2023-04-27T22:05:08.725291+00:00 000389_2023-04-27_22-05-13.236.PM~216.png lsl
exp_2023_04_27_14 leopard 161 389 rest_state 1682633108.948462 2023-04-27T22:05:08.948462+00:00 000390_2023-04-27_22-05-13.454.PM~218.png lsl
exp_2023_04_27_14 leopard 161 390 rest_state 1682633109.1716332 2023-04-27T22:05:09.171633+00:00 000391_2023-04-27_22-05-13.669.PM~215.png lsl
exp_2023_04_27_14 leopard 161 391 rest_state 1682633109.3948042 2023-04-27T22:05:09.394804+00:00 000392_2023-04-27_22-05-13.875.PM~206.png lsl
exp_2023_04_27_14 leopard 161 392 rest_state 1682633109.6179755 2023-04-27T22:05:09.617975+00:00 000393_2023-04-27_22-05-14.098.PM~223.png lsl
exp_2023_04_27_14 leopard 161 393 rest_state 1682633109.8411465 2023-04-27T22:05:09.841146+00:00 000394_2023-04-27_22-05-14.312.PM~214.png lsl
exp_2023_04_27_14 leopard 161 394 rest_state 1682633110.0643177 2023-04-27T22:05:10.064318+00:00 000395_2023-04-27_22-05-14.533.PM~221.png lsl
exp_2023_04_27_14 leopard 161 395 rest_state 1682633110.287489 2023-04-27T22:05:10.287489+00:00 000396_2023-04-27_22-05-14.739.PM~206.png lsl
exp_2023_04_27_14 leopard 161 396 rest_state 1682633110.51066 2023-04-27T22:05:10.510660+00:00 000397_2023-04-27_22-05-14.951.PM~212.png lsl
exp_2023_04_27_14 leopard 161 397 rest_state 1682633110.7338312 2023-04-27T22:05:10.733831+00:00 000398_2023-04-27_22-05-15.160.PM~209.png lsl
exp_2023_04_27_14 leopard 161 398 rest_state 1682633110.9570022 2023-04-27T22:05:10.957002+00:00 000399_2023-04-27_22-05-15.371.PM~211.png lsl
exp_2023_04_27_14 leopard 161 399 rest_state 1682633111.1801734 2023-04-27T22:05:11.180173+00:00 000400_2023-04-27_22-05-15.576.PM~205.png lsl
exp_2023_04_27_14 leopard 161 400 rest_state 1682633111.4033444 2023-04-27T22:05:11.403344+00:00 000401_2023-04-27_22-05-15.791.PM~215.png lsl
exp_2023_04_27_14 leopard 161 401 rest_state 1682633111.6265156 2023-04-27T22:05:11.626516+00:00 000402_2023-04-27_22-05-16.011.PM~220.png lsl
exp_2023_04_27_14 leopard 161 402 rest_state 1682633111.8496869 2023-04-27T22:05:11.849687+00:00 000403_2023-04-27_22-05-16.217.PM~206.png lsl
exp_2023_04_27_14 leopard 161 403 rest_state 1682633112.0728579 2023-04-27T22:05:12.072858+00:00 000404_2023-04-27_22-05-16.425.PM~208.png lsl
exp_2023_04_27_14 leopard 161 404 rest_state 1682633112.296029 2023-04-27T22:05:12.296029+00:00 000405_2023-04-27_22-05-16.673.PM~248.png lsl
exp_2023_04_27_14 leopard 161 405 rest_state 1682633112.5192 2023-04-27T22:05:12.519200+00:00 000406_2023-04-27_22-05-16.909.PM~236.png lsl
exp_2023_04_27_14 leopard 161 406 rest_state 1682633112.7423713 2023-04-27T22:05:12.742371+00:00 000407_2023-04-27_22-05-17.130.PM~221.png lsl
exp_2023_04_27_14 leopard 161 407 rest_state 1682633112.9655423 2023-04-27T22:05:12.965542+00:00 000408_2023-04-27_22-05-17.339.PM~209.png lsl
exp_2023_04_27_14 leopard 161 408 rest_state 1682633113.1887136 2023-04-27T22:05:13.188714+00:00 000409_2023-04-27_22-05-17.554.PM~215.png lsl
exp_2023_04_27_14 leopard 161 409 rest_state 1682633113.4118848 2023-04-27T22:05:13.411885+00:00 000410_2023-04-27_22-05-17.773.PM~219.png lsl
exp_2023_04_27_14 leopard 161 410 rest_state 1682633113.6350558 2023-04-27T22:05:13.635056+00:00 000411_2023-04-27_22-05-17.979.PM~206.png lsl
exp_2023_04_27_14 leopard 161 411 rest_state 1682633113.858227 2023-04-27T22:05:13.858227+00:00 000412_2023-04-27_22-05-18.190.PM~211.png lsl
exp_2023_04_27_14 leopard 161 412 rest_state 1682633114.081398 2023-04-27T22:05:14.081398+00:00 000413_2023-04-27_22-05-18.404.PM~214.png lsl
exp_2023_04_27_14 leopard 161 413 rest_state 1682633114.3045692 2023-04-27T22:05:14.304569+00:00 000414_2023-04-27_22-05-18.616.PM~212.png lsl
exp_2023_04_27_14 leopard 161 414 rest_state 1682633114.5277402 2023-04-27T22:05:14.527740+00:00 000415_2023-04-27_22-05-18.834.PM~218.png lsl
exp_2023_04_27_14 leopard 161 415 rest_state 1682633114.7509115 2023-04-27T22:05:14.750911+00:00 000416_2023-04-27_22-05-19.051.PM~217.png lsl
exp_2023_04_27_14 leopard 161 416 rest_state 1682633114.9740825 2023-04-27T22:05:14.974082+00:00 000417_2023-04-27_22-05-19.267.PM~216.png lsl
exp_2023_04_27_14 leopard 161 417 rest_state 1682633115.1972537 2023-04-27T22:05:15.197254+00:00 000418_2023-04-27_22-05-19.475.PM~208.png lsl
exp_2023_04_27_14 leopard 161 418 rest_state 1682633115.420425 2023-04-27T22:05:15.420425+00:00 000419_2023-04-27_22-05-19.708.PM~233.png lsl
exp_2023_04_27_14 leopard 161 419 rest_state 1682633115.643596 2023-04-27T22:05:15.643596+00:00 000420_2023-04-27_22-05-19.928.PM~220.png lsl
exp_2023_04_27_14 leopard 161 420 rest_state 1682633115.8667672 2023-04-27T22:05:15.866767+00:00 000421_2023-04-27_22-05-20.137.PM~209.png lsl
exp_2023_04_27_14 leopard 161 421 rest_state 1682633116.0899382 2023-04-27T22:05:16.089938+00:00 000422_2023-04-27_22-05-20.344.PM~207.png lsl
exp_2023_04_27_14 leopard 161 422 rest_state 1682633116.3131094 2023-04-27T22:05:16.313109+00:00 000423_2023-04-27_22-05-20.561.PM~217.png lsl
exp_2023_04_27_14 leopard 161 423 rest_state 1682633116.5362804 2023-04-27T22:05:16.536280+00:00 000424_2023-04-27_22-05-20.775.PM~214.png lsl
exp_2023_04_27_14 leopard 161 424 rest_state 1682633116.7594516 2023-04-27T22:05:16.759452+00:00 000425_2023-04-27_22-05-20.980.PM~205.png lsl
exp_2023_04_27_14 leopard 161 425 rest_state 1682633116.9826229 2023-04-27T22:05:16.982623+00:00 000426_2023-04-27_22-05-21.191.PM~211.png lsl
exp_2023_04_27_14 leopard 161 426 rest_state 1682633117.2057939 2023-04-27T22:05:17.205794+00:00 000427_2023-04-27_22-05-21.408.PM~217.png lsl
exp_2023_04_27_14 leopard 161 427 rest_state 1682633117.428965 2023-04-27T22:05:17.428965+00:00 000428_2023-04-27_22-05-21.631.PM~223.png lsl
exp_2023_04_27_14 leopard 161 428 rest_state 1682633117.652136 2023-04-27T22:05:17.652136+00:00 000429_2023-04-27_22-05-21.847.PM~216.png lsl
exp_2023_04_27_14 leopard 161 429 rest_state 1682633117.8753073 2023-04-27T22:05:17.875307+00:00 000430_2023-04-27_22-05-22.057.PM~210.png lsl
exp_2023_04_27_14 leopard 161 430 rest_state 1682633118.0984783 2023-04-27T22:05:18.098478+00:00 000431_2023-04-27_22-05-22.272.PM~215.png lsl
exp_2023_04_27_14 leopard 161 431 rest_state 1682633118.3216496 2023-04-27T22:05:18.321650+00:00 000432_2023-04-27_22-05-22.484.PM~212.png lsl
exp_2023_04_27_14 leopard 161 432 rest_state 1682633118.5448208 2023-04-27T22:05:18.544821+00:00 000433_2023-04-27_22-05-22.690.PM~206.png lsl
exp_2023_04_27_14 leopard 161 433 rest_state 1682633118.7679918 2023-04-27T22:05:18.767992+00:00 000434_2023-04-27_22-05-22.906.PM~216.png lsl
exp_2023_04_27_14 leopard 161 434 rest_state 1682633118.991163 2023-04-27T22:05:18.991163+00:00 000435_2023-04-27_22-05-23.125.PM~219.png lsl
exp_2023_04_27_14 leopard 161 435 rest_state 1682633119.214334 2023-04-27T22:05:19.214334+00:00 000436_2023-04-27_22-05-23.335.PM~210.png lsl
exp_2023_04_27_14 leopard 161 436 rest_state 1682633119.4375052 2023-04-27T22:05:19.437505+00:00 000437_2023-04-27_22-05-23.553.PM~218.png lsl
exp_2023_04_27_14 leopard 161 437 rest_state 1682633119.6606762 2023-04-27T22:05:19.660676+00:00 000438_2023-04-27_22-05-23.779.PM~226.png lsl
exp_2023_04_27_14 leopard 161 438 rest_state 1682633119.8838475 2023-04-27T22:05:19.883847+00:00 000439_2023-04-27_22-05-23.988.PM~209.png lsl
exp_2023_04_27_14 leopard 161 439 rest_state 1682633120.1070185 2023-04-27T22:05:20.107018+00:00 000440_2023-04-27_22-05-24.204.PM~216.png lsl
exp_2023_04_27_14 leopard 161 440 rest_state 1682633120.3301897 2023-04-27T22:05:20.330190+00:00 000441_2023-04-27_22-05-24.434.PM~230.png lsl
exp_2023_04_27_14 leopard 161 441 rest_state 1682633120.553361 2023-04-27T22:05:20.553361+00:00 000442_2023-04-27_22-05-24.654.PM~220.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]);