Column descriptions

group_session

Group session ID

frequency

Frequency of the samples (main clock frequency).

station

The iMac that the participant was stationed at.

timestamp_unix

The Unix timestamp of the event.

timestamp_iso8601

The ISO-8601 timestamp of the event.

aux_gsr

value of the gsr channel.

where station = "cheetah"

- remove filter - group_session frequency station id timestamp_unix timestamp_iso8601 gsr

= != 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 frequency station id timestamp_unix timestamp_iso8601 gsr

= != 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 frequency Sort by station Sort by id Sort by timestamp_unix Sort by timestamp_iso8601 Sort by gsr

descending

✎ View and edit SQL

This data as json, copyable

0 records

CREATE TABLE "gsr_sync" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [frequency] INTEGER,
   [station] TEXT REFERENCES [station]([id]),
   [id] INTEGER,
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [gsr] FLOAT,
   PRIMARY KEY ([group_session], [frequency], [station], [id])
);
CREATE INDEX [idx_gsr_sync_station]
    ON [gsr_sync] ([station]);
CREATE INDEX [idx_gsr_sync_group_session]
    ON [gsr_sync] ([group_session]);