Column descriptions

where group_session = "exp_2023_04_27_14"

- remove filter - group_session timestamp_unix timestamp_iso8601 event_type countdown_timer lion_spacebar_pressed tiger_spacebar_pressed leopard_spacebar_pressed

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

- column - group_session timestamp_unix timestamp_iso8601 event_type countdown_timer lion_spacebar_pressed tiger_spacebar_pressed leopard_spacebar_pressed

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

Sort... Sort by group_session Sort by timestamp_unix Sort by timestamp_iso8601 Sort by event_type Sort by countdown_timer Sort by lion_spacebar_pressed Sort by tiger_spacebar_pressed Sort by leopard_spacebar_pressed

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: event_type, countdown_timer, lion_spacebar_pressed, tiger_spacebar_pressed, leopard_spacebar_pressed, timestamp_iso8601 (date)

Next page

CREATE TABLE "finger_tapping_task_observation" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [event_type] TEXT,
   [countdown_timer] INTEGER,
   [lion_spacebar_pressed] INTEGER,
   [tiger_spacebar_pressed] INTEGER,
   [leopard_spacebar_pressed] INTEGER,
   PRIMARY KEY ([group_session], [timestamp_unix])
);
CREATE INDEX [idx_finger_tapping_task_observation_group_session]
    ON [finger_tapping_task_observation] ([group_session]);