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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_04_17_13 200 leopard 0 1681766623.6410549 2023-04-17T21:23:43.641055+00:00 474599.0
exp_2023_04_17_13 200 leopard 1 1681766623.646055 2023-04-17T21:23:43.646055+00:00 474606.0
exp_2023_04_17_13 200 leopard 2 1681766623.6510549 2023-04-17T21:23:43.651055+00:00 474613.0
exp_2023_04_17_13 200 leopard 3 1681766623.656055 2023-04-17T21:23:43.656055+00:00 474620.0
exp_2023_04_17_13 200 leopard 4 1681766623.6610548 2023-04-17T21:23:43.661055+00:00 474627.0
exp_2023_04_17_13 200 leopard 5 1681766623.666055 2023-04-17T21:23:43.666055+00:00 474634.0
exp_2023_04_17_13 200 leopard 6 1681766623.6710548 2023-04-17T21:23:43.671055+00:00 474642.0
exp_2023_04_17_13 200 leopard 7 1681766623.676055 2023-04-17T21:23:43.676055+00:00 474650.0
exp_2023_04_17_13 200 leopard 8 1681766623.6810548 2023-04-17T21:23:43.681055+00:00 474659.0
exp_2023_04_17_13 200 leopard 9 1681766623.686055 2023-04-17T21:23:43.686055+00:00 474669.0
exp_2023_04_17_13 200 leopard 10 1681766623.6910548 2023-04-17T21:23:43.691055+00:00 474679.0
exp_2023_04_17_13 200 leopard 11 1681766623.696055 2023-04-17T21:23:43.696055+00:00 474691.0
exp_2023_04_17_13 200 leopard 12 1681766623.7010548 2023-04-17T21:23:43.701055+00:00 474703.0
exp_2023_04_17_13 200 leopard 13 1681766623.706055 2023-04-17T21:23:43.706055+00:00 474717.0
exp_2023_04_17_13 200 leopard 14 1681766623.7110548 2023-04-17T21:23:43.711055+00:00 474732.0
exp_2023_04_17_13 200 leopard 15 1681766623.716055 2023-04-17T21:23:43.716055+00:00 474748.0
exp_2023_04_17_13 200 leopard 16 1681766623.7210548 2023-04-17T21:23:43.721055+00:00 474766.0
exp_2023_04_17_13 200 leopard 17 1681766623.726055 2023-04-17T21:23:43.726055+00:00 474785.0
exp_2023_04_17_13 200 leopard 18 1681766623.7310548 2023-04-17T21:23:43.731055+00:00 474805.0
exp_2023_04_17_13 200 leopard 19 1681766623.736055 2023-04-17T21:23:43.736055+00:00 474827.0
exp_2023_04_17_13 200 leopard 20 1681766623.7410548 2023-04-17T21:23:43.741055+00:00 474850.0
exp_2023_04_17_13 200 leopard 21 1681766623.746055 2023-04-17T21:23:43.746055+00:00 474875.0
exp_2023_04_17_13 200 leopard 22 1681766623.7510548 2023-04-17T21:23:43.751055+00:00 474901.0
exp_2023_04_17_13 200 leopard 23 1681766623.7560549 2023-04-17T21:23:43.756055+00:00 474929.0
exp_2023_04_17_13 200 leopard 24 1681766623.7610548 2023-04-17T21:23:43.761055+00:00 474958.0
exp_2023_04_17_13 200 leopard 25 1681766623.7660549 2023-04-17T21:23:43.766055+00:00 474988.0
exp_2023_04_17_13 200 leopard 26 1681766623.771055 2023-04-17T21:23:43.771055+00:00 475020.0
exp_2023_04_17_13 200 leopard 27 1681766623.7760549 2023-04-17T21:23:43.776055+00:00 475052.0
exp_2023_04_17_13 200 leopard 28 1681766623.781055 2023-04-17T21:23:43.781055+00:00 475086.0
exp_2023_04_17_13 200 leopard 29 1681766623.7860548 2023-04-17T21:23:43.786055+00:00 475120.0
exp_2023_04_17_13 200 leopard 30 1681766623.791055 2023-04-17T21:23:43.791055+00:00 475156.0
exp_2023_04_17_13 200 leopard 31 1681766623.7960548 2023-04-17T21:23:43.796055+00:00 475192.0
exp_2023_04_17_13 200 leopard 32 1681766623.801055 2023-04-17T21:23:43.801055+00:00 475229.0
exp_2023_04_17_13 200 leopard 33 1681766623.8060548 2023-04-17T21:23:43.806055+00:00 475267.0
exp_2023_04_17_13 200 leopard 34 1681766623.811055 2023-04-17T21:23:43.811055+00:00 475305.0
exp_2023_04_17_13 200 leopard 35 1681766623.8160548 2023-04-17T21:23:43.816055+00:00 475343.0
exp_2023_04_17_13 200 leopard 36 1681766623.821055 2023-04-17T21:23:43.821055+00:00 475382.0
exp_2023_04_17_13 200 leopard 37 1681766623.8260548 2023-04-17T21:23:43.826055+00:00 475421.0
exp_2023_04_17_13 200 leopard 38 1681766623.831055 2023-04-17T21:23:43.831055+00:00 475459.0
exp_2023_04_17_13 200 leopard 39 1681766623.8360548 2023-04-17T21:23:43.836055+00:00 475498.0
exp_2023_04_17_13 200 leopard 40 1681766623.841055 2023-04-17T21:23:43.841055+00:00 475536.0
exp_2023_04_17_13 200 leopard 41 1681766623.8460548 2023-04-17T21:23:43.846055+00:00 475574.0
exp_2023_04_17_13 200 leopard 42 1681766623.851055 2023-04-17T21:23:43.851055+00:00 475611.0
exp_2023_04_17_13 200 leopard 43 1681766623.8560548 2023-04-17T21:23:43.856055+00:00 475648.0
exp_2023_04_17_13 200 leopard 44 1681766623.861055 2023-04-17T21:23:43.861055+00:00 475684.0
exp_2023_04_17_13 200 leopard 45 1681766623.8660548 2023-04-17T21:23:43.866055+00:00 475720.0
exp_2023_04_17_13 200 leopard 46 1681766623.871055 2023-04-17T21:23:43.871055+00:00 475754.0
exp_2023_04_17_13 200 leopard 47 1681766623.8760548 2023-04-17T21:23:43.876055+00:00 475788.0
exp_2023_04_17_13 200 leopard 48 1681766623.8810549 2023-04-17T21:23:43.881055+00:00 475821.0
exp_2023_04_17_13 200 leopard 49 1681766623.8860548 2023-04-17T21:23:43.886055+00:00 475853.0
exp_2023_04_17_13 200 leopard 50 1681766623.8910549 2023-04-17T21:23:43.891055+00:00 475884.0
exp_2023_04_17_13 200 leopard 51 1681766623.896055 2023-04-17T21:23:43.896055+00:00 475914.0
exp_2023_04_17_13 200 leopard 52 1681766623.9010549 2023-04-17T21:23:43.901055+00:00 475943.0
exp_2023_04_17_13 200 leopard 53 1681766623.906055 2023-04-17T21:23:43.906055+00:00 475971.0
exp_2023_04_17_13 200 leopard 54 1681766623.9110548 2023-04-17T21:23:43.911055+00:00 475998.0
exp_2023_04_17_13 200 leopard 55 1681766623.916055 2023-04-17T21:23:43.916055+00:00 476024.0
exp_2023_04_17_13 200 leopard 56 1681766623.9210548 2023-04-17T21:23:43.921055+00:00 476049.0
exp_2023_04_17_13 200 leopard 57 1681766623.926055 2023-04-17T21:23:43.926055+00:00 476073.0
exp_2023_04_17_13 200 leopard 58 1681766623.9310548 2023-04-17T21:23:43.931055+00:00 476096.0
exp_2023_04_17_13 200 leopard 59 1681766623.936055 2023-04-17T21:23:43.936055+00:00 476119.0
exp_2023_04_17_13 200 leopard 60 1681766623.9410548 2023-04-17T21:23:43.941055+00:00 476140.0
exp_2023_04_17_13 200 leopard 61 1681766623.946055 2023-04-17T21:23:43.946055+00:00 476161.0
exp_2023_04_17_13 200 leopard 62 1681766623.9510548 2023-04-17T21:23:43.951055+00:00 476182.0
exp_2023_04_17_13 200 leopard 63 1681766623.956055 2023-04-17T21:23:43.956055+00:00 476201.0
exp_2023_04_17_13 200 leopard 64 1681766623.9610548 2023-04-17T21:23:43.961055+00:00 476221.0
exp_2023_04_17_13 200 leopard 65 1681766623.966055 2023-04-17T21:23:43.966055+00:00 476239.0
exp_2023_04_17_13 200 leopard 66 1681766623.9710548 2023-04-17T21:23:43.971055+00:00 476258.0
exp_2023_04_17_13 200 leopard 67 1681766623.976055 2023-04-17T21:23:43.976055+00:00 476276.0
exp_2023_04_17_13 200 leopard 68 1681766623.9810548 2023-04-17T21:23:43.981055+00:00 476294.0
exp_2023_04_17_13 200 leopard 69 1681766623.986055 2023-04-17T21:23:43.986055+00:00 476313.0
exp_2023_04_17_13 200 leopard 70 1681766623.9910548 2023-04-17T21:23:43.991055+00:00 476331.0
exp_2023_04_17_13 200 leopard 71 1681766623.996055 2023-04-17T21:23:43.996055+00:00 476349.0
exp_2023_04_17_13 200 leopard 72 1681766624.0010548 2023-04-17T21:23:44.001055+00:00 476368.0
exp_2023_04_17_13 200 leopard 73 1681766624.0060549 2023-04-17T21:23:44.006055+00:00 476386.0
exp_2023_04_17_13 200 leopard 74 1681766624.0110548 2023-04-17T21:23:44.011055+00:00 476405.0
exp_2023_04_17_13 200 leopard 75 1681766624.0160549 2023-04-17T21:23:44.016055+00:00 476425.0
exp_2023_04_17_13 200 leopard 76 1681766624.021055 2023-04-17T21:23:44.021055+00:00 476445.0
exp_2023_04_17_13 200 leopard 77 1681766624.0260549 2023-04-17T21:23:44.026055+00:00 476466.0
exp_2023_04_17_13 200 leopard 78 1681766624.031055 2023-04-17T21:23:44.031055+00:00 476487.0
exp_2023_04_17_13 200 leopard 79 1681766624.0360548 2023-04-17T21:23:44.036055+00:00 476509.0
exp_2023_04_17_13 200 leopard 80 1681766624.041055 2023-04-17T21:23:44.041055+00:00 476531.0
exp_2023_04_17_13 200 leopard 81 1681766624.0460548 2023-04-17T21:23:44.046055+00:00 476554.0
exp_2023_04_17_13 200 leopard 82 1681766624.051055 2023-04-17T21:23:44.051055+00:00 476578.0
exp_2023_04_17_13 200 leopard 83 1681766624.0560548 2023-04-17T21:23:44.056055+00:00 476603.0
exp_2023_04_17_13 200 leopard 84 1681766624.061055 2023-04-17T21:23:44.061055+00:00 476629.0
exp_2023_04_17_13 200 leopard 85 1681766624.0660548 2023-04-17T21:23:44.066055+00:00 476655.0
exp_2023_04_17_13 200 leopard 86 1681766624.071055 2023-04-17T21:23:44.071055+00:00 476682.0
exp_2023_04_17_13 200 leopard 87 1681766624.0760548 2023-04-17T21:23:44.076055+00:00 476710.0
exp_2023_04_17_13 200 leopard 88 1681766624.081055 2023-04-17T21:23:44.081055+00:00 476738.0
exp_2023_04_17_13 200 leopard 89 1681766624.0860548 2023-04-17T21:23:44.086055+00:00 476767.0
exp_2023_04_17_13 200 leopard 90 1681766624.091055 2023-04-17T21:23:44.091055+00:00 476797.0
exp_2023_04_17_13 200 leopard 91 1681766624.0960548 2023-04-17T21:23:44.096055+00:00 476827.0
exp_2023_04_17_13 200 leopard 92 1681766624.101055 2023-04-17T21:23:44.101055+00:00 476858.0
exp_2023_04_17_13 200 leopard 93 1681766624.1060548 2023-04-17T21:23:44.106055+00:00 476889.0
exp_2023_04_17_13 200 leopard 94 1681766624.111055 2023-04-17T21:23:44.111055+00:00 476921.0
exp_2023_04_17_13 200 leopard 95 1681766624.1160548 2023-04-17T21:23:44.116055+00:00 476953.0
exp_2023_04_17_13 200 leopard 96 1681766624.121055 2023-04-17T21:23:44.121055+00:00 476985.0
exp_2023_04_17_13 200 leopard 97 1681766624.1260548 2023-04-17T21:23:44.126055+00:00 477017.0
exp_2023_04_17_13 200 leopard 98 1681766624.1310549 2023-04-17T21:23:44.131055+00:00 477049.0
exp_2023_04_17_13 200 leopard 99 1681766624.1360548 2023-04-17T21:23:44.136055+00:00 477081.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]);