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 group_session = "exp_2023_01_31_14"

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_01_31_14 200 leopard 0 1675205833.7892847 2023-01-31T22:57:13.789285+00:00 653014.0
exp_2023_01_31_14 200 leopard 1 1675205833.7942848 2023-01-31T22:57:13.794285+00:00 653110.0
exp_2023_01_31_14 200 leopard 2 1675205833.7992847 2023-01-31T22:57:13.799285+00:00 653199.0
exp_2023_01_31_14 200 leopard 3 1675205833.8042848 2023-01-31T22:57:13.804285+00:00 653281.0
exp_2023_01_31_14 200 leopard 4 1675205833.8092847 2023-01-31T22:57:13.809285+00:00 653355.0
exp_2023_01_31_14 200 leopard 5 1675205833.8142848 2023-01-31T22:57:13.814285+00:00 653422.0
exp_2023_01_31_14 200 leopard 6 1675205833.8192847 2023-01-31T22:57:13.819285+00:00 653485.0
exp_2023_01_31_14 200 leopard 7 1675205833.8242848 2023-01-31T22:57:13.824285+00:00 653542.0
exp_2023_01_31_14 200 leopard 8 1675205833.8292847 2023-01-31T22:57:13.829285+00:00 653593.0
exp_2023_01_31_14 200 leopard 9 1675205833.8342848 2023-01-31T22:57:13.834285+00:00 653640.0
exp_2023_01_31_14 200 leopard 10 1675205833.8392847 2023-01-31T22:57:13.839285+00:00 653684.0
exp_2023_01_31_14 200 leopard 11 1675205833.8442848 2023-01-31T22:57:13.844285+00:00 653726.0
exp_2023_01_31_14 200 leopard 12 1675205833.8492846 2023-01-31T22:57:13.849285+00:00 653764.0
exp_2023_01_31_14 200 leopard 13 1675205833.8542848 2023-01-31T22:57:13.854285+00:00 653800.0
exp_2023_01_31_14 200 leopard 14 1675205833.8592846 2023-01-31T22:57:13.859285+00:00 653836.0
exp_2023_01_31_14 200 leopard 15 1675205833.8642848 2023-01-31T22:57:13.864285+00:00 653872.0
exp_2023_01_31_14 200 leopard 16 1675205833.8692846 2023-01-31T22:57:13.869285+00:00 653906.0
exp_2023_01_31_14 200 leopard 17 1675205833.8742847 2023-01-31T22:57:13.874285+00:00 653940.0
exp_2023_01_31_14 200 leopard 18 1675205833.8792846 2023-01-31T22:57:13.879285+00:00 653977.0
exp_2023_01_31_14 200 leopard 19 1675205833.8842847 2023-01-31T22:57:13.884285+00:00 654016.0
exp_2023_01_31_14 200 leopard 20 1675205833.8892846 2023-01-31T22:57:13.889285+00:00 654054.0
exp_2023_01_31_14 200 leopard 21 1675205833.8942847 2023-01-31T22:57:13.894285+00:00 654095.0
exp_2023_01_31_14 200 leopard 22 1675205833.8992846 2023-01-31T22:57:13.899285+00:00 654140.0
exp_2023_01_31_14 200 leopard 23 1675205833.9042847 2023-01-31T22:57:13.904285+00:00 654187.0
exp_2023_01_31_14 200 leopard 24 1675205833.9092846 2023-01-31T22:57:13.909285+00:00 654237.0
exp_2023_01_31_14 200 leopard 25 1675205833.9142847 2023-01-31T22:57:13.914285+00:00 654290.0
exp_2023_01_31_14 200 leopard 26 1675205833.9192848 2023-01-31T22:57:13.919285+00:00 654348.0
exp_2023_01_31_14 200 leopard 27 1675205833.9242847 2023-01-31T22:57:13.924285+00:00 654410.0
exp_2023_01_31_14 200 leopard 28 1675205833.9292848 2023-01-31T22:57:13.929285+00:00 654475.0
exp_2023_01_31_14 200 leopard 29 1675205833.9342847 2023-01-31T22:57:13.934285+00:00 654545.0
exp_2023_01_31_14 200 leopard 30 1675205833.9392848 2023-01-31T22:57:13.939285+00:00 654620.0
exp_2023_01_31_14 200 leopard 31 1675205833.9442847 2023-01-31T22:57:13.944285+00:00 654701.0
exp_2023_01_31_14 200 leopard 32 1675205833.9492848 2023-01-31T22:57:13.949285+00:00 654784.0
exp_2023_01_31_14 200 leopard 33 1675205833.9542847 2023-01-31T22:57:13.954285+00:00 654873.0
exp_2023_01_31_14 200 leopard 34 1675205833.9592848 2023-01-31T22:57:13.959285+00:00 654968.0
exp_2023_01_31_14 200 leopard 35 1675205833.9642847 2023-01-31T22:57:13.964285+00:00 655069.0
exp_2023_01_31_14 200 leopard 36 1675205833.9692848 2023-01-31T22:57:13.969285+00:00 655173.0
exp_2023_01_31_14 200 leopard 37 1675205833.9742846 2023-01-31T22:57:13.974285+00:00 655283.0
exp_2023_01_31_14 200 leopard 38 1675205833.9792848 2023-01-31T22:57:13.979285+00:00 655401.0
exp_2023_01_31_14 200 leopard 39 1675205833.9842846 2023-01-31T22:57:13.984285+00:00 655524.0
exp_2023_01_31_14 200 leopard 40 1675205833.9892848 2023-01-31T22:57:13.989285+00:00 655651.0
exp_2023_01_31_14 200 leopard 41 1675205833.9942846 2023-01-31T22:57:13.994285+00:00 655785.0
exp_2023_01_31_14 200 leopard 42 1675205833.9992847 2023-01-31T22:57:13.999285+00:00 655927.0
exp_2023_01_31_14 200 leopard 43 1675205834.0042846 2023-01-31T22:57:14.004285+00:00 656075.0
exp_2023_01_31_14 200 leopard 44 1675205834.0092847 2023-01-31T22:57:14.009285+00:00 656228.0
exp_2023_01_31_14 200 leopard 45 1675205834.0142846 2023-01-31T22:57:14.014285+00:00 656388.0
exp_2023_01_31_14 200 leopard 46 1675205834.0192847 2023-01-31T22:57:14.019285+00:00 656557.0
exp_2023_01_31_14 200 leopard 47 1675205834.0242846 2023-01-31T22:57:14.024285+00:00 656732.0
exp_2023_01_31_14 200 leopard 48 1675205834.0292847 2023-01-31T22:57:14.029285+00:00 656914.0
exp_2023_01_31_14 200 leopard 49 1675205834.0342846 2023-01-31T22:57:14.034285+00:00 657104.0
exp_2023_01_31_14 200 leopard 50 1675205834.0392847 2023-01-31T22:57:14.039285+00:00 657303.0
exp_2023_01_31_14 200 leopard 51 1675205834.0442848 2023-01-31T22:57:14.044285+00:00 657510.0
exp_2023_01_31_14 200 leopard 52 1675205834.0492847 2023-01-31T22:57:14.049285+00:00 657724.0
exp_2023_01_31_14 200 leopard 53 1675205834.0542848 2023-01-31T22:57:14.054285+00:00 657946.0
exp_2023_01_31_14 200 leopard 54 1675205834.0592847 2023-01-31T22:57:14.059285+00:00 658178.0
exp_2023_01_31_14 200 leopard 55 1675205834.0642848 2023-01-31T22:57:14.064285+00:00 658420.0
exp_2023_01_31_14 200 leopard 56 1675205834.0692847 2023-01-31T22:57:14.069285+00:00 658668.0
exp_2023_01_31_14 200 leopard 57 1675205834.0742848 2023-01-31T22:57:14.074285+00:00 658925.0
exp_2023_01_31_14 200 leopard 58 1675205834.0792847 2023-01-31T22:57:14.079285+00:00 659192.0
exp_2023_01_31_14 200 leopard 59 1675205834.0842848 2023-01-31T22:57:14.084285+00:00 659468.0
exp_2023_01_31_14 200 leopard 60 1675205834.0892847 2023-01-31T22:57:14.089285+00:00 659752.0
exp_2023_01_31_14 200 leopard 61 1675205834.0942848 2023-01-31T22:57:14.094285+00:00 660044.0
exp_2023_01_31_14 200 leopard 62 1675205834.0992846 2023-01-31T22:57:14.099285+00:00 660346.0
exp_2023_01_31_14 200 leopard 63 1675205834.1042848 2023-01-31T22:57:14.104285+00:00 660656.0
exp_2023_01_31_14 200 leopard 64 1675205834.1092846 2023-01-31T22:57:14.109285+00:00 660972.0
exp_2023_01_31_14 200 leopard 65 1675205834.1142848 2023-01-31T22:57:14.114285+00:00 661296.0
exp_2023_01_31_14 200 leopard 66 1675205834.1192846 2023-01-31T22:57:14.119285+00:00 661628.0
exp_2023_01_31_14 200 leopard 67 1675205834.1242847 2023-01-31T22:57:14.124285+00:00 661968.0
exp_2023_01_31_14 200 leopard 68 1675205834.1292846 2023-01-31T22:57:14.129285+00:00 662311.0
exp_2023_01_31_14 200 leopard 69 1675205834.1342847 2023-01-31T22:57:14.134285+00:00 662661.0
exp_2023_01_31_14 200 leopard 70 1675205834.1392846 2023-01-31T22:57:14.139285+00:00 663018.0
exp_2023_01_31_14 200 leopard 71 1675205834.1442847 2023-01-31T22:57:14.144285+00:00 663378.0
exp_2023_01_31_14 200 leopard 72 1675205834.1492846 2023-01-31T22:57:14.149285+00:00 663741.0
exp_2023_01_31_14 200 leopard 73 1675205834.1542847 2023-01-31T22:57:14.154285+00:00 664107.0
exp_2023_01_31_14 200 leopard 74 1675205834.1592846 2023-01-31T22:57:14.159285+00:00 664476.0
exp_2023_01_31_14 200 leopard 75 1675205834.1642847 2023-01-31T22:57:14.164285+00:00 664848.0
exp_2023_01_31_14 200 leopard 76 1675205834.1692848 2023-01-31T22:57:14.169285+00:00 665218.0
exp_2023_01_31_14 200 leopard 77 1675205834.1742847 2023-01-31T22:57:14.174285+00:00 665588.0
exp_2023_01_31_14 200 leopard 78 1675205834.1792848 2023-01-31T22:57:14.179285+00:00 665959.0
exp_2023_01_31_14 200 leopard 79 1675205834.1842847 2023-01-31T22:57:14.184285+00:00 666328.0
exp_2023_01_31_14 200 leopard 80 1675205834.1892848 2023-01-31T22:57:14.189285+00:00 666693.0
exp_2023_01_31_14 200 leopard 81 1675205834.1942847 2023-01-31T22:57:14.194285+00:00 667054.0
exp_2023_01_31_14 200 leopard 82 1675205834.1992848 2023-01-31T22:57:14.199285+00:00 667413.0
exp_2023_01_31_14 200 leopard 83 1675205834.2042847 2023-01-31T22:57:14.204285+00:00 667767.0
exp_2023_01_31_14 200 leopard 84 1675205834.2092848 2023-01-31T22:57:14.209285+00:00 668113.0
exp_2023_01_31_14 200 leopard 85 1675205834.2142847 2023-01-31T22:57:14.214285+00:00 668453.0
exp_2023_01_31_14 200 leopard 86 1675205834.2192848 2023-01-31T22:57:14.219285+00:00 668787.0
exp_2023_01_31_14 200 leopard 87 1675205834.2242846 2023-01-31T22:57:14.224285+00:00 669113.0
exp_2023_01_31_14 200 leopard 88 1675205834.2292848 2023-01-31T22:57:14.229285+00:00 669428.0
exp_2023_01_31_14 200 leopard 89 1675205834.2342846 2023-01-31T22:57:14.234285+00:00 669735.0
exp_2023_01_31_14 200 leopard 90 1675205834.2392848 2023-01-31T22:57:14.239285+00:00 670032.0
exp_2023_01_31_14 200 leopard 91 1675205834.2442846 2023-01-31T22:57:14.244285+00:00 670319.0
exp_2023_01_31_14 200 leopard 92 1675205834.2492847 2023-01-31T22:57:14.249285+00:00 670593.0
exp_2023_01_31_14 200 leopard 93 1675205834.2542846 2023-01-31T22:57:14.254285+00:00 670856.0
exp_2023_01_31_14 200 leopard 94 1675205834.2592847 2023-01-31T22:57:14.259285+00:00 671108.0
exp_2023_01_31_14 200 leopard 95 1675205834.2642846 2023-01-31T22:57:14.264285+00:00 671346.0
exp_2023_01_31_14 200 leopard 96 1675205834.2692847 2023-01-31T22:57:14.269285+00:00 671571.0
exp_2023_01_31_14 200 leopard 97 1675205834.2742846 2023-01-31T22:57:14.274285+00:00 671781.0
exp_2023_01_31_14 200 leopard 98 1675205834.2792847 2023-01-31T22:57:14.279285+00:00 671980.0
exp_2023_01_31_14 200 leopard 99 1675205834.2842846 2023-01-31T22:57:14.284285+00:00 672165.0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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