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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_11_07_10 200 leopard 0 1667844782.7819762 2022-11-07T18:13:02.781976+00:00 148615.0
exp_2022_11_07_10 200 leopard 1 1667844782.7869763 2022-11-07T18:13:02.786976+00:00 148609.0
exp_2022_11_07_10 200 leopard 2 1667844782.7919762 2022-11-07T18:13:02.791976+00:00 148603.0
exp_2022_11_07_10 200 leopard 3 1667844782.7969763 2022-11-07T18:13:02.796976+00:00 148597.0
exp_2022_11_07_10 200 leopard 4 1667844782.8019762 2022-11-07T18:13:02.801976+00:00 148591.0
exp_2022_11_07_10 200 leopard 5 1667844782.8069763 2022-11-07T18:13:02.806976+00:00 148585.0
exp_2022_11_07_10 200 leopard 6 1667844782.8119762 2022-11-07T18:13:02.811976+00:00 148579.0
exp_2022_11_07_10 200 leopard 7 1667844782.8169763 2022-11-07T18:13:02.816976+00:00 148573.0
exp_2022_11_07_10 200 leopard 8 1667844782.8219762 2022-11-07T18:13:02.821976+00:00 148567.0
exp_2022_11_07_10 200 leopard 9 1667844782.8269763 2022-11-07T18:13:02.826976+00:00 148561.0
exp_2022_11_07_10 200 leopard 10 1667844782.8319762 2022-11-07T18:13:02.831976+00:00 148554.0
exp_2022_11_07_10 200 leopard 11 1667844782.8369763 2022-11-07T18:13:02.836976+00:00 148548.0
exp_2022_11_07_10 200 leopard 12 1667844782.8419762 2022-11-07T18:13:02.841976+00:00 148542.0
exp_2022_11_07_10 200 leopard 13 1667844782.8469763 2022-11-07T18:13:02.846976+00:00 148536.0
exp_2022_11_07_10 200 leopard 14 1667844782.8519762 2022-11-07T18:13:02.851976+00:00 148529.0
exp_2022_11_07_10 200 leopard 15 1667844782.8569763 2022-11-07T18:13:02.856976+00:00 148523.0
exp_2022_11_07_10 200 leopard 16 1667844782.8619761 2022-11-07T18:13:02.861976+00:00 148517.0
exp_2022_11_07_10 200 leopard 17 1667844782.8669763 2022-11-07T18:13:02.866976+00:00 148510.0
exp_2022_11_07_10 200 leopard 18 1667844782.8719761 2022-11-07T18:13:02.871976+00:00 148504.0
exp_2022_11_07_10 200 leopard 19 1667844782.8769763 2022-11-07T18:13:02.876976+00:00 148497.0
exp_2022_11_07_10 200 leopard 20 1667844782.8819761 2022-11-07T18:13:02.881976+00:00 148491.0
exp_2022_11_07_10 200 leopard 21 1667844782.8869762 2022-11-07T18:13:02.886976+00:00 148484.0
exp_2022_11_07_10 200 leopard 22 1667844782.891976 2022-11-07T18:13:02.891976+00:00 148478.0
exp_2022_11_07_10 200 leopard 23 1667844782.8969762 2022-11-07T18:13:02.896976+00:00 148472.0
exp_2022_11_07_10 200 leopard 24 1667844782.901976 2022-11-07T18:13:02.901976+00:00 148465.0
exp_2022_11_07_10 200 leopard 25 1667844782.9069762 2022-11-07T18:13:02.906976+00:00 148459.0
exp_2022_11_07_10 200 leopard 26 1667844782.9119763 2022-11-07T18:13:02.911976+00:00 148452.0
exp_2022_11_07_10 200 leopard 27 1667844782.9169762 2022-11-07T18:13:02.916976+00:00 148446.0
exp_2022_11_07_10 200 leopard 28 1667844782.9219763 2022-11-07T18:13:02.921976+00:00 148440.0
exp_2022_11_07_10 200 leopard 29 1667844782.9269762 2022-11-07T18:13:02.926976+00:00 148433.0
exp_2022_11_07_10 200 leopard 30 1667844782.9319763 2022-11-07T18:13:02.931976+00:00 148427.0
exp_2022_11_07_10 200 leopard 31 1667844782.9369762 2022-11-07T18:13:02.936976+00:00 148421.0
exp_2022_11_07_10 200 leopard 32 1667844782.9419763 2022-11-07T18:13:02.941976+00:00 148414.0
exp_2022_11_07_10 200 leopard 33 1667844782.9469762 2022-11-07T18:13:02.946976+00:00 148408.0
exp_2022_11_07_10 200 leopard 34 1667844782.9519763 2022-11-07T18:13:02.951976+00:00 148402.0
exp_2022_11_07_10 200 leopard 35 1667844782.9569762 2022-11-07T18:13:02.956976+00:00 148396.0
exp_2022_11_07_10 200 leopard 36 1667844782.9619763 2022-11-07T18:13:02.961976+00:00 148389.0
exp_2022_11_07_10 200 leopard 37 1667844782.9669762 2022-11-07T18:13:02.966976+00:00 148383.0
exp_2022_11_07_10 200 leopard 38 1667844782.9719763 2022-11-07T18:13:02.971976+00:00 148377.0
exp_2022_11_07_10 200 leopard 39 1667844782.9769762 2022-11-07T18:13:02.976976+00:00 148371.0
exp_2022_11_07_10 200 leopard 40 1667844782.9819763 2022-11-07T18:13:02.981976+00:00 148365.0
exp_2022_11_07_10 200 leopard 41 1667844782.9869761 2022-11-07T18:13:02.986976+00:00 148359.0
exp_2022_11_07_10 200 leopard 42 1667844782.9919763 2022-11-07T18:13:02.991976+00:00 148353.0
exp_2022_11_07_10 200 leopard 43 1667844782.9969761 2022-11-07T18:13:02.996976+00:00 148347.0
exp_2022_11_07_10 200 leopard 44 1667844783.0019763 2022-11-07T18:13:03.001976+00:00 148341.0
exp_2022_11_07_10 200 leopard 45 1667844783.0069761 2022-11-07T18:13:03.006976+00:00 148335.0
exp_2022_11_07_10 200 leopard 46 1667844783.0119762 2022-11-07T18:13:03.011976+00:00 148329.0
exp_2022_11_07_10 200 leopard 47 1667844783.016976 2022-11-07T18:13:03.016976+00:00 148324.0
exp_2022_11_07_10 200 leopard 48 1667844783.0219762 2022-11-07T18:13:03.021976+00:00 148318.0
exp_2022_11_07_10 200 leopard 49 1667844783.026976 2022-11-07T18:13:03.026976+00:00 148312.0
exp_2022_11_07_10 200 leopard 50 1667844783.0319762 2022-11-07T18:13:03.031976+00:00 148306.0
exp_2022_11_07_10 200 leopard 51 1667844783.0369763 2022-11-07T18:13:03.036976+00:00 148301.0
exp_2022_11_07_10 200 leopard 52 1667844783.0419762 2022-11-07T18:13:03.041976+00:00 148295.0
exp_2022_11_07_10 200 leopard 53 1667844783.0469763 2022-11-07T18:13:03.046976+00:00 148289.0
exp_2022_11_07_10 200 leopard 54 1667844783.0519762 2022-11-07T18:13:03.051976+00:00 148283.0
exp_2022_11_07_10 200 leopard 55 1667844783.0569763 2022-11-07T18:13:03.056976+00:00 148278.0
exp_2022_11_07_10 200 leopard 56 1667844783.0619762 2022-11-07T18:13:03.061976+00:00 148272.0
exp_2022_11_07_10 200 leopard 57 1667844783.0669763 2022-11-07T18:13:03.066976+00:00 148267.0
exp_2022_11_07_10 200 leopard 58 1667844783.0719762 2022-11-07T18:13:03.071976+00:00 148261.0
exp_2022_11_07_10 200 leopard 59 1667844783.0769763 2022-11-07T18:13:03.076976+00:00 148256.0
exp_2022_11_07_10 200 leopard 60 1667844783.0819762 2022-11-07T18:13:03.081976+00:00 148250.0
exp_2022_11_07_10 200 leopard 61 1667844783.0869763 2022-11-07T18:13:03.086976+00:00 148244.0
exp_2022_11_07_10 200 leopard 62 1667844783.0919762 2022-11-07T18:13:03.091976+00:00 148239.0
exp_2022_11_07_10 200 leopard 63 1667844783.0969763 2022-11-07T18:13:03.096976+00:00 148234.0
exp_2022_11_07_10 200 leopard 64 1667844783.1019762 2022-11-07T18:13:03.101976+00:00 148228.0
exp_2022_11_07_10 200 leopard 65 1667844783.1069763 2022-11-07T18:13:03.106976+00:00 148223.0
exp_2022_11_07_10 200 leopard 66 1667844783.1119761 2022-11-07T18:13:03.111976+00:00 148217.0
exp_2022_11_07_10 200 leopard 67 1667844783.1169763 2022-11-07T18:13:03.116976+00:00 148212.0
exp_2022_11_07_10 200 leopard 68 1667844783.1219761 2022-11-07T18:13:03.121976+00:00 148206.0
exp_2022_11_07_10 200 leopard 69 1667844783.1269763 2022-11-07T18:13:03.126976+00:00 148201.0
exp_2022_11_07_10 200 leopard 70 1667844783.1319761 2022-11-07T18:13:03.131976+00:00 148195.0
exp_2022_11_07_10 200 leopard 71 1667844783.1369762 2022-11-07T18:13:03.136976+00:00 148190.0
exp_2022_11_07_10 200 leopard 72 1667844783.141976 2022-11-07T18:13:03.141976+00:00 148185.0
exp_2022_11_07_10 200 leopard 73 1667844783.1469762 2022-11-07T18:13:03.146976+00:00 148179.0
exp_2022_11_07_10 200 leopard 74 1667844783.151976 2022-11-07T18:13:03.151976+00:00 148174.0
exp_2022_11_07_10 200 leopard 75 1667844783.1569762 2022-11-07T18:13:03.156976+00:00 148168.0
exp_2022_11_07_10 200 leopard 76 1667844783.1619763 2022-11-07T18:13:03.161976+00:00 148163.0
exp_2022_11_07_10 200 leopard 77 1667844783.1669762 2022-11-07T18:13:03.166976+00:00 148157.0
exp_2022_11_07_10 200 leopard 78 1667844783.1719763 2022-11-07T18:13:03.171976+00:00 148152.0
exp_2022_11_07_10 200 leopard 79 1667844783.1769762 2022-11-07T18:13:03.176976+00:00 148147.0
exp_2022_11_07_10 200 leopard 80 1667844783.1819763 2022-11-07T18:13:03.181976+00:00 148141.0
exp_2022_11_07_10 200 leopard 81 1667844783.1869762 2022-11-07T18:13:03.186976+00:00 148135.0
exp_2022_11_07_10 200 leopard 82 1667844783.1919763 2022-11-07T18:13:03.191976+00:00 148130.0
exp_2022_11_07_10 200 leopard 83 1667844783.1969762 2022-11-07T18:13:03.196976+00:00 148125.0
exp_2022_11_07_10 200 leopard 84 1667844783.2019763 2022-11-07T18:13:03.201976+00:00 148119.0
exp_2022_11_07_10 200 leopard 85 1667844783.2069762 2022-11-07T18:13:03.206976+00:00 148113.0
exp_2022_11_07_10 200 leopard 86 1667844783.2119763 2022-11-07T18:13:03.211976+00:00 148108.0
exp_2022_11_07_10 200 leopard 87 1667844783.2169762 2022-11-07T18:13:03.216976+00:00 148102.0
exp_2022_11_07_10 200 leopard 88 1667844783.2219763 2022-11-07T18:13:03.221976+00:00 148097.0
exp_2022_11_07_10 200 leopard 89 1667844783.2269762 2022-11-07T18:13:03.226976+00:00 148091.0
exp_2022_11_07_10 200 leopard 90 1667844783.2319763 2022-11-07T18:13:03.231976+00:00 148085.0
exp_2022_11_07_10 200 leopard 91 1667844783.2369761 2022-11-07T18:13:03.236976+00:00 148080.0
exp_2022_11_07_10 200 leopard 92 1667844783.2419763 2022-11-07T18:13:03.241976+00:00 148074.0
exp_2022_11_07_10 200 leopard 93 1667844783.2469761 2022-11-07T18:13:03.246976+00:00 148069.0
exp_2022_11_07_10 200 leopard 94 1667844783.2519763 2022-11-07T18:13:03.251976+00:00 148063.0
exp_2022_11_07_10 200 leopard 95 1667844783.2569761 2022-11-07T18:13:03.256976+00:00 148057.0
exp_2022_11_07_10 200 leopard 96 1667844783.2619762 2022-11-07T18:13:03.261976+00:00 148052.0
exp_2022_11_07_10 200 leopard 97 1667844783.266976 2022-11-07T18:13:03.266976+00:00 148046.0
exp_2022_11_07_10 200 leopard 98 1667844783.2719762 2022-11-07T18:13:03.271976+00:00 148040.0
exp_2022_11_07_10 200 leopard 99 1667844783.276976 2022-11-07T18:13:03.276976+00:00 148034.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]);