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

View and edit SQL

Suggested facets: station, timestamp_iso8601 (date)

Link group_session station participant id task timestamp_unix timestamp_iso8601 filename url timestamp_origin
exp_2023_02_21_14 leopard 119 713 rest_state 1677017432.84432 2023-02-21T22:10:32.844320+00:00 2023-02-21T22_10_32.844320160Z.png creation
exp_2023_02_21_14 leopard 119 714 rest_state 1677017432.948324 2023-02-21T22:10:32.948324+00:00 2023-02-21T22_10_32.948324367Z.png creation
exp_2023_02_21_14 leopard 119 715 rest_state 1677017433.060328 2023-02-21T22:10:33.060328+00:00 2023-02-21T22_10_33.060328900Z.png creation
exp_2023_02_21_14 leopard 119 716 rest_state 1677017433.148332 2023-02-21T22:10:33.148332+00:00 2023-02-21T22_10_33.148332460Z.png creation
exp_2023_02_21_14 leopard 119 717 rest_state 1677017433.244336 2023-02-21T22:10:33.244336+00:00 2023-02-21T22_10_33.244336344Z.png creation
exp_2023_02_21_14 leopard 119 718 rest_state 1677017433.372341 2023-02-21T22:10:33.372341+00:00 2023-02-21T22_10_33.372341523Z.png creation
exp_2023_02_21_14 leopard 119 719 rest_state 1677017433.440344 2023-02-21T22:10:33.440344+00:00 2023-02-21T22_10_33.440344275Z.png creation
exp_2023_02_21_14 leopard 119 720 rest_state 1677017433.544348 2023-02-21T22:10:33.544348+00:00 2023-02-21T22_10_33.544348483Z.png creation
exp_2023_02_21_14 leopard 119 721 rest_state 1677017433.640352 2023-02-21T22:10:33.640352+00:00 2023-02-21T22_10_33.640352368Z.png creation
exp_2023_02_21_14 leopard 119 722 rest_state 1677017433.748356 2023-02-21T22:10:33.748356+00:00 2023-02-21T22_10_33.748356737Z.png creation
exp_2023_02_21_14 leopard 119 723 rest_state 1677017433.84436 2023-02-21T22:10:33.844360+00:00 2023-02-21T22_10_33.844360622Z.png creation
exp_2023_02_21_14 leopard 119 724 rest_state 1677017433.940364 2023-02-21T22:10:33.940364+00:00 2023-02-21T22_10_33.940364506Z.png creation
exp_2023_02_21_14 leopard 119 725 rest_state 1677017434.036368 2023-02-21T22:10:34.036368+00:00 2023-02-21T22_10_34.036368387Z.png creation
exp_2023_02_21_14 leopard 119 726 rest_state 1677017434.144372 2023-02-21T22:10:34.144372+00:00 2023-02-21T22_10_34.144372760Z.png creation
exp_2023_02_21_14 leopard 119 727 rest_state 1677017434.244376 2023-02-21T22:10:34.244376+00:00 2023-02-21T22_10_34.244376806Z.png creation
exp_2023_02_21_14 leopard 119 728 rest_state 1677017434.348381 2023-02-21T22:10:34.348381+00:00 2023-02-21T22_10_34.348381014Z.png creation
exp_2023_02_21_14 leopard 119 729 rest_state 1677017434.448385 2023-02-21T22:10:34.448385+00:00 2023-02-21T22_10_34.448385060Z.png creation
exp_2023_02_21_14 leopard 119 730 rest_state 1677017434.57639 2023-02-21T22:10:34.576390+00:00 2023-02-21T22_10_34.576390239Z.png creation
exp_2023_02_21_14 leopard 119 731 rest_state 1677017434.660393 2023-02-21T22:10:34.660393+00:00 2023-02-21T22_10_34.660393638Z.png creation
exp_2023_02_21_14 leopard 119 732 rest_state 1677017434.772398 2023-02-21T22:10:34.772398+00:00 2023-02-21T22_10_34.772398167Z.png creation
exp_2023_02_21_14 leopard 119 733 rest_state 1677017434.852401 2023-02-21T22:10:34.852401+00:00 2023-02-21T22_10_34.852401407Z.png creation
exp_2023_02_21_14 leopard 119 734 rest_state 1677017434.976406 2023-02-21T22:10:34.976406+00:00 2023-02-21T22_10_34.976406424Z.png creation
exp_2023_02_21_14 leopard 119 735 rest_state 1677017435.096411 2023-02-21T22:10:35.096411+00:00 2023-02-21T22_10_35.096411278Z.png creation
exp_2023_02_21_14 leopard 119 736 rest_state 1677017435.176414 2023-02-21T22:10:35.176414+00:00 2023-02-21T22_10_35.176414513Z.png creation
exp_2023_02_21_14 leopard 119 737 rest_state 1677017435.256417 2023-02-21T22:10:35.256417+00:00 2023-02-21T22_10_35.256417753Z.png creation
exp_2023_02_21_14 leopard 119 738 rest_state 1677017435.372422 2023-02-21T22:10:35.372422+00:00 2023-02-21T22_10_35.372422446Z.png creation
exp_2023_02_21_14 leopard 119 739 rest_state 1677017435.456425 2023-02-21T22:10:35.456425+00:00 2023-02-21T22_10_35.456425842Z.png creation
exp_2023_02_21_14 leopard 119 740 rest_state 1677017435.56443 2023-02-21T22:10:35.564430+00:00 2023-02-21T22_10_35.564430215Z.png creation
exp_2023_02_21_14 leopard 119 741 rest_state 1677017435.688435 2023-02-21T22:10:35.688435+00:00 2023-02-21T22_10_35.688435232Z.png creation
exp_2023_02_21_14 leopard 119 742 rest_state 1677017435.776438 2023-02-21T22:10:35.776438+00:00 2023-02-21T22_10_35.776438792Z.png creation
exp_2023_02_21_14 leopard 119 743 rest_state 1677017435.900443 2023-02-21T22:10:35.900443+00:00 2023-02-21T22_10_35.900443809Z.png creation
exp_2023_02_21_14 leopard 119 744 rest_state 1677017435.980447 2023-02-21T22:10:35.980447+00:00 2023-02-21T22_10_35.980447046Z.png creation
exp_2023_02_21_14 leopard 119 745 rest_state 1677017436.052449 2023-02-21T22:10:36.052449+00:00 2023-02-21T22_10_36.052449959Z.png creation
exp_2023_02_21_14 leopard 119 746 rest_state 1677017436.172454 2023-02-21T22:10:36.172454+00:00 2023-02-21T22_10_36.172454815Z.png creation
exp_2023_02_21_14 leopard 119 747 rest_state 1677017436.284459 2023-02-21T22:10:36.284459+00:00 2023-02-21T22_10_36.284459346Z.png creation
exp_2023_02_21_14 leopard 119 748 rest_state 1677017436.364462 2023-02-21T22:10:36.364462+00:00 2023-02-21T22_10_36.364462583Z.png creation
exp_2023_02_21_14 leopard 119 749 rest_state 1677017436.476467 2023-02-21T22:10:36.476467+00:00 2023-02-21T22_10_36.476467115Z.png creation
exp_2023_02_21_14 leopard 119 750 rest_state 1677017436.54847 2023-02-21T22:10:36.548470+00:00 2023-02-21T22_10_36.548470029Z.png creation
exp_2023_02_21_14 leopard 119 751 rest_state 1677017436.672475 2023-02-21T22:10:36.672475+00:00 2023-02-21T22_10_36.672475043Z.png creation
exp_2023_02_21_14 leopard 119 752 rest_state 1677017436.780479 2023-02-21T22:10:36.780479+00:00 2023-02-21T22_10_36.780479416Z.png creation
exp_2023_02_21_14 leopard 119 753 rest_state 1677017436.868482 2023-02-21T22:10:36.868482+00:00 2023-02-21T22_10_36.868482975Z.png creation
exp_2023_02_21_14 leopard 119 754 rest_state 1677017436.972487 2023-02-21T22:10:36.972487+00:00 2023-02-21T22_10_36.972487183Z.png creation
exp_2023_02_21_14 leopard 119 755 rest_state 1677017437.05649 2023-02-21T22:10:37.056490+00:00 2023-02-21T22_10_37.056490583Z.png creation
exp_2023_02_21_14 leopard 119 756 rest_state 1677017437.168495 2023-02-21T22:10:37.168495+00:00 2023-02-21T22_10_37.168495114Z.png creation
exp_2023_02_21_14 leopard 119 757 rest_state 1677017437.284499 2023-02-21T22:10:37.284499+00:00 2023-02-21T22_10_37.284499808Z.png creation
exp_2023_02_21_14 leopard 119 758 rest_state 1677017437.352502 2023-02-21T22:10:37.352502+00:00 2023-02-21T22_10_37.352502558Z.png creation
exp_2023_02_21_14 leopard 119 759 rest_state 1677017437.468507 2023-02-21T22:10:37.468507+00:00 2023-02-21T22_10_37.468507252Z.png creation
exp_2023_02_21_14 leopard 119 760 rest_state 1677017437.576511 2023-02-21T22:10:37.576511+00:00 2023-02-21T22_10_37.576511622Z.png creation
exp_2023_02_21_14 leopard 119 761 rest_state 1677017437.648514 2023-02-21T22:10:37.648514+00:00 2023-02-21T22_10_37.648514535Z.png creation
exp_2023_02_21_14 leopard 119 762 rest_state 1677017437.776519 2023-02-21T22:10:37.776519+00:00 2023-02-21T22_10_37.776519714Z.png creation
exp_2023_02_21_14 leopard 119 763 rest_state 1677017437.880523 2023-02-21T22:10:37.880523+00:00 2023-02-21T22_10_37.880523922Z.png creation
exp_2023_02_21_14 leopard 119 764 rest_state 1677017437.964527 2023-02-21T22:10:37.964527+00:00 2023-02-21T22_10_37.964527318Z.png creation
exp_2023_02_21_14 leopard 119 765 rest_state 1677017438.080532 2023-02-21T22:10:38.080532+00:00 2023-02-21T22_10_38.080532014Z.png creation
exp_2023_02_21_14 leopard 119 766 rest_state 1677017438.200536 2023-02-21T22:10:38.200536+00:00 2023-02-21T22_10_38.200536870Z.png creation
exp_2023_02_21_14 leopard 119 767 rest_state 1677017438.276539 2023-02-21T22:10:38.276539+00:00 2023-02-21T22_10_38.276539945Z.png creation
exp_2023_02_21_14 leopard 119 768 rest_state 1677017438.352543 2023-02-21T22:10:38.352543+00:00 2023-02-21T22_10_38.352543020Z.png creation
exp_2023_02_21_14 leopard 119 769 rest_state 1677017438.468547 2023-02-21T22:10:38.468547+00:00 2023-02-21T22_10_38.468547713Z.png creation
exp_2023_02_21_14 leopard 119 770 rest_state 1677017438.588552 2023-02-21T22:10:38.588552+00:00 2023-02-21T22_10_38.588552568Z.png creation
exp_2023_02_21_14 leopard 119 771 rest_state 1677017438.668555 2023-02-21T22:10:38.668555+00:00 2023-02-21T22_10_38.668555805Z.png creation
exp_2023_02_21_14 leopard 119 772 rest_state 1677017438.78456 2023-02-21T22:10:38.784560+00:00 2023-02-21T22_10_38.784560499Z.png creation
exp_2023_02_21_14 leopard 119 773 rest_state 1677017438.856563 2023-02-21T22:10:38.856563+00:00 2023-02-21T22_10_38.856563413Z.png creation
exp_2023_02_21_14 leopard 119 774 rest_state 1677017438.976568 2023-02-21T22:10:38.976568+00:00 2023-02-21T22_10_38.976568267Z.png creation
exp_2023_02_21_14 leopard 119 775 rest_state 1677017439.092572 2023-02-21T22:10:39.092572+00:00 2023-02-21T22_10_39.092572961Z.png creation
exp_2023_02_21_14 leopard 119 776 rest_state 1677017439.168576 2023-02-21T22:10:39.168576+00:00 2023-02-21T22_10_39.168576036Z.png creation
exp_2023_02_21_14 leopard 119 777 rest_state 1677017439.28858 2023-02-21T22:10:39.288580+00:00 2023-02-21T22_10_39.288580892Z.png creation
exp_2023_02_21_14 leopard 119 778 rest_state 1677017439.368584 2023-02-21T22:10:39.368584+00:00 2023-02-21T22_10_39.368584129Z.png creation
exp_2023_02_21_14 leopard 119 779 rest_state 1677017439.484588 2023-02-21T22:10:39.484588+00:00 2023-02-21T22_10_39.484588821Z.png creation
exp_2023_02_21_14 leopard 119 780 rest_state 1677017439.560591 2023-02-21T22:10:39.560591+00:00 2023-02-21T22_10_39.560591896Z.png creation
exp_2023_02_21_14 leopard 119 781 rest_state 1677017439.672596 2023-02-21T22:10:39.672596+00:00 2023-02-21T22_10_39.672596429Z.png creation
exp_2023_02_21_14 leopard 119 782 rest_state 1677017439.7806 2023-02-21T22:10:39.780600+00:00 2023-02-21T22_10_39.780600798Z.png creation
exp_2023_02_21_14 leopard 119 783 rest_state 1677017439.892605 2023-02-21T22:10:39.892605+00:00 2023-02-21T22_10_39.892605329Z.png creation
exp_2023_02_21_14 leopard 119 784 rest_state 1677017439.968608 2023-02-21T22:10:39.968608+00:00 2023-02-21T22_10_39.968608404Z.png creation
exp_2023_02_21_14 leopard 119 785 rest_state 1677017440.076612 2023-02-21T22:10:40.076612+00:00 2023-02-21T22_10_40.076612775Z.png creation
exp_2023_02_21_14 leopard 119 786 rest_state 1677017440.196617 2023-02-21T22:10:40.196617+00:00 2023-02-21T22_10_40.196617629Z.png creation
exp_2023_02_21_14 leopard 119 787 rest_state 1677017440.26862 2023-02-21T22:10:40.268620+00:00 2023-02-21T22_10_40.268620543Z.png creation
exp_2023_02_21_14 leopard 119 788 rest_state 1677017440.380625 2023-02-21T22:10:40.380625+00:00 2023-02-21T22_10_40.380625072Z.png creation
exp_2023_02_21_14 leopard 119 789 rest_state 1677017440.492629 2023-02-21T22:10:40.492629+00:00 2023-02-21T22_10_40.492629606Z.png creation
exp_2023_02_21_14 leopard 119 790 rest_state 1677017440.568632 2023-02-21T22:10:40.568632+00:00 2023-02-21T22_10_40.568632681Z.png creation
exp_2023_02_21_14 leopard 119 791 rest_state 1677017440.688637 2023-02-21T22:10:40.688637+00:00 2023-02-21T22_10_40.688637537Z.png creation
exp_2023_02_21_14 leopard 119 792 rest_state 1677017440.776641 2023-02-21T22:10:40.776641+00:00 2023-02-21T22_10_40.776641097Z.png creation
exp_2023_02_21_14 leopard 119 793 rest_state 1677017440.884645 2023-02-21T22:10:40.884645+00:00 2023-02-21T22_10_40.884645466Z.png creation
exp_2023_02_21_14 leopard 119 794 rest_state 1677017440.964648 2023-02-21T22:10:40.964648+00:00 2023-02-21T22_10_40.964648701Z.png creation
exp_2023_02_21_14 leopard 119 795 rest_state 1677017441.080653 2023-02-21T22:10:41.080653+00:00 2023-02-21T22_10_41.080653397Z.png creation
exp_2023_02_21_14 leopard 119 796 rest_state 1677017441.160656 2023-02-21T22:10:41.160656+00:00 2023-02-21T22_10_41.160656633Z.png creation
exp_2023_02_21_14 leopard 119 797 rest_state 1677017441.276661 2023-02-21T22:10:41.276661+00:00 2023-02-21T22_10_41.276661328Z.png creation
exp_2023_02_21_14 leopard 119 798 rest_state 1677017441.352664 2023-02-21T22:10:41.352664+00:00 2023-02-21T22_10_41.352664403Z.png creation
exp_2023_02_21_14 leopard 119 799 rest_state 1677017441.464668 2023-02-21T22:10:41.464668+00:00 2023-02-21T22_10_41.464668934Z.png creation
exp_2023_02_21_14 leopard 119 800 rest_state 1677017441.580673 2023-02-21T22:10:41.580673+00:00 2023-02-21T22_10_41.580673628Z.png creation
exp_2023_02_21_14 leopard 119 801 rest_state 1677017441.664677 2023-02-21T22:10:41.664677+00:00 2023-02-21T22_10_41.664677026Z.png creation
exp_2023_02_21_14 leopard 119 802 rest_state 1677017441.772681 2023-02-21T22:10:41.772681+00:00 2023-02-21T22_10_41.772681395Z.png creation
exp_2023_02_21_14 leopard 119 803 rest_state 1677017441.896686 2023-02-21T22:10:41.896686+00:00 2023-02-21T22_10_41.896686413Z.png creation
exp_2023_02_21_14 leopard 119 804 rest_state 1677017441.964689 2023-02-21T22:10:41.964689+00:00 2023-02-21T22_10_41.964689165Z.png creation
exp_2023_02_21_14 leopard 119 805 rest_state 1677017442.088694 2023-02-21T22:10:42.088694+00:00 2023-02-21T22_10_42.088694182Z.png creation
exp_2023_02_21_14 leopard 119 806 rest_state 1677017442.204698 2023-02-21T22:10:42.204698+00:00 2023-02-21T22_10_42.204698874Z.png creation
exp_2023_02_21_14 leopard 119 807 rest_state 1677017442.292702 2023-02-21T22:10:42.292702+00:00 2023-02-21T22_10_42.292702436Z.png creation
exp_2023_02_21_14 leopard 119 808 rest_state 1677017442.368705 2023-02-21T22:10:42.368705+00:00 2023-02-21T22_10_42.368705511Z.png creation
exp_2023_02_21_14 leopard 119 809 rest_state 1677017442.48471 2023-02-21T22:10:42.484710+00:00 2023-02-21T22_10_42.484710203Z.png creation
exp_2023_02_21_14 leopard 119 810 rest_state 1677017442.556713 2023-02-21T22:10:42.556713+00:00 2023-02-21T22_10_42.556713117Z.png creation
exp_2023_02_21_14 leopard 119 811 rest_state 1677017442.672717 2023-02-21T22:10:42.672717+00:00 2023-02-21T22_10_42.672717808Z.png creation
exp_2023_02_21_14 leopard 119 812 rest_state 1677017442.780722 2023-02-21T22:10:42.780722+00:00 2023-02-21T22_10_42.780722180Z.png creation

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